You can use Db2 Warehouse on Cloud Connector to securely read data from or write data to IBM Db2 Warehouse on Cloud.
The IBM Db2 Warehouse on Cloud is a fast, fully managed, data warehouse and analytics service provisioned on the Cloud.
You can create a connection of Db2 Warehouse on Cloud type in Data Integration and use the connection in mappings and mapping tasks to read from or write data to IBM Db2 Warehouse. Db2 Warehouse on Cloud sources and targets in mappings represent tables in IBM Db2 Warehouse on Cloud. Create a mapping task to process data based on the data flow logic defined in a mapping or integration template.
You can switch mappings to advanced mode to include transformations and functions that enable advanced functionality.
When you run a Db2 Warehouse on Cloud mapping task, the Secure Agent either reads or writes data to IBM Db2 Warehouse based on the defined data logic and the configured Db2 Warehouse on Cloud connection.
Example
You work as a data analyst in a retail corporation that has outlets across various countries. You want to assess your retain store performance across geographical distributions and produce a report that identifies the likelihood of future sales outcomes based on existing data. You want to use the built-in analytics, R predictive modeling, and business intelligence tools in IBM Db2 Warehouse on Cloud. The solution speeds up the process and helps you analyze your data and get precise insights quickly.
You design a mapping to read data from Salesforce and other transactional systems and aggregate the data. Use Db2 Warehouse on Cloud Connector to write aggregated data to IBM Db2 Warehouse and then use the predictive modeling algorithms to identify your potential stores across geographical locations, track your leads, and come up with a future course of action.