Setting up Apache Ignite with DBImport

You can start Ignite within the DBImport process using the following procedure.

1. Copy the Ignite JARs to the TAFJ_HOME/ext directory. For more information, see Required Ignite JARs.
2. In tafj.properties, set the following parameters:
   • temn.tafj.runtime.use.external.caching=true
   • temn.cache.external.caching.provider=org.apache.ignite.IgniteProvider
3. In caching.properties, set the IP to your IP.

   temn.cache.ignite.allowed.ips = (Your_IP)

4. Create the TAFJ_CACHE_KS_INIT table with default encryption value.

   CREATE TABLE TAFJ_CACHE_KS_INIT ( RECID VARCHAR2(255));
   INSERT INTO TAFJ_CACHE_KS_INIT VALUES ('Waz7G611E%+6291Tqz');
   commit;

5. Configure the cachestore.keystore file located in TAFJCache.jar for your database and update it to TAFJCache.jar.

   tKeyStore -keystoretype JCEKS -keystorepassword 3jyh?=%%_baT -key temn.tafj.jdbc.password –value T24 -JCEKS -file C:\TAFJ\lib\cachestore.keystore
   tKeyStore -keystoretype JCEKS -keystorepassword 3jyh?=%%_baT -key temn.tafj.jdbc.username –value T24 -JCEKS -file C:\TAFJ\lib\cachestore.keystore
   tKeyStore -keystoretype JCEKS -keystorepassword 3jyh?=%%_baT -key temn.tafj.jdbc.url –value jdbc:sqlserver://localhost:1433;databaseName=TESTDB;integratedSecurity=false -JCEKS -file C:\TAFJ\lib\cachestore.keystore
   tKeyStore -keystoretype JCEKS -keystorepassword 3jyh?=%%_baT -key temn.tafj.jdbc.driver –value com.microsoft.sqlserver.jdbc.SQLServerDriver -JCEKS -file C:\TAFJ\lib\cachestore.keystore

6. Start Ignite with the default password (3jyh?=%_baT). This verifies the correct configuration.
7. Configure DBImport.default for big tables. Here, you are testing only two files.

   CacheTables    = FBNK.STMT.ENTRY,FBNK.CATEG.ENTRY
   CacheName    = DBImportXMLWriteBehind
   File           = FBNK.STMT.ENTRY,FBNK.CATEG.ENTRY

8. Start DBImport. You should see Ignite startup within the DBImport process.