Informix

TapData Cloud offers you cloud services that are suitable for scenarios requiring rapid deployment and low initial investment, helping you focus more on business development rather than infrastructure management. Free trial with TapData Cloud.TapData Community is an open-source data integration platform that provides basic data synchronization and transformation capabilities. This helps you quickly explore and implement data integration projects. As your project or business grows, you can seamlessly upgrade to TapData Cloud or TapData Enterprise to access more advanced features and service support.

Informix is a product family within IBM's Information Management division that is centered on several relational database management system and Multi-model database offerings.

This article describes how to connect to Informix data sources on TapData Cloud.

Connect to Informix

1. Log in to TapData Platform.

2. In the left navigation panel, click Connections.

3. On the right side of the page, click Create.

4. In the pop-up dialog, select Informix.

5. Fill in the connection information for Informix on the redirected page, following the instructions provided below.

   • Connection name: Fill in a unique name that has business significance.
   • Connection type: Supports Informix as a source or target database.
   • Host: Fill in the database connection address.
   • Port: Fill in the service port of database.
   • Server: Fill in the Server info
   • Database: Fill in the database name.
   • Password: The database password.
   • Connection Parameter String: Additional connection parameters, default empty.
   • Timezone: By default, TapData Cloud utilizes the time zone used by the database. However, you also have the flexibility to manually specify the time zone based on your business requirements.
   • Agent settings: Defaults to Platform automatic allocation, you can also manually specify an agent.
   • Model load time: If there are less than 10,000 models in the data source, their information will be updated every hour. But if the number of models exceeds 10,000, the refresh will take place daily at the time you have specified.

6. Click Test Connection, and when passed, click Save.

   tip

   If the connection test fails, follow the prompts on the page to fix it.