Alooma can replicate tables from your IBM Db2 server to your target data warehouse in near real time.
This enables you to, for example, enrich your analytics data coming from your mobile devices with user attributes stored in your IBM Db2 database.
Alooma uses incremental replication for Db2 databases.
Integrating your IBM Db2 database with Alooma is easy:
How do you want to connect to Alooma? If it's via an SSH server, check out how to connect via SSH. Otherwise, you'll need to whitelist access to Alooma's IP addresses:
From the Plumbing screen, click Add new input. Select IBM Db2 from the list of inputs.
Name your IBM Db2 input.
Select the destination schema. This is the schema where you’d like Alooma to create the tables for this input in your data warehouse.
Enter the following information:
Hostname of the IBM Db2 server (default port is 50000)
Username and password
If your IBM Db2 server is behind an SSH server you can connect to it via SSH.
Click Connect to continue.
Select the tables you want to replicate. For each table, specify the Update Indicator Column and Primary Key. You can add as many tables as you need.
You should also index the indicator columns. Follow the instructions for creating an index here: https://www.ibm.com/support/knowledgecenter/SSCRJT_6.0.0/com.ibm.swg.im.bigsql.commsql.doc/doc/r0000919.html
Q: What happens to data already replicated when a user removes a table from the list of tables to replicate?
A: Nothing. The data remains in the data warehouse.
Q: What happens when user adds a table to the list of tables to replicate?
A: Alooma will start replicating it, including its historical data.
Keep the mapping mode to the default of OneClick if you'd like Alooma to automatically map all IBM Db2 tables exactly to your target data warehouse. Otherwise, they'll have to be mapped manually from the Mapper screen.
Alooma maintains three tables in your target database per each table in IBM Db2.
That's it! You're done integrating IBM Db2 and Alooma.