IBM Informix

Prev Next

Overview

Replicate Preview supports efficient data replication between IBM Informix and other supported systems, allowing it to operate as both a source and target endpoint. By configuring connections and selecting required datasets, users can establish replication pipelines that ensure controlled and consistent data delivery. The platform manages execution and resource handling, simplifying deployment across IBM Informix environments.

Note

IBM Informix is currently supported as both a source and target endpoint in Replicate Preview, limited to Snapshot (full load) replication mode, with Change Data Capture (CDC) and streaming replication not yet supported.

Prerequisites

The following steps must be completed before using the IBM Informix datastore as a source or target:

  • Ensure that the required users are assigned appropriate workspace roles and granted required item permissions. Refer to the User Permissions section below.

  • Create an IBM Informix datastore connection and assign Metadata Scanning and Cloud Replication usage types. Refer to Create a Connection and Connecting to IBM Informix for more information.

  • If you are using this connection as a source, run a scan to ingest metadata from this connection's objects into the SKP.

User Permissions

When setting up Refresh replications with IBM Informix as a source or target database, ensure the user ID used for establishing connections to the database has sufficient privileges to complete all required replication operations from Replicate Preview.

Authorize to Connect the Database

This permission must be granted already when the user is created. However, if the user is not authorized to establish a connection, you can use the command syntax.

grant connect to <user_id>;

Authorize to Select Catalog

This permission is required for the Metadata Scanner and allows you to display a list of tables and show fields in the table.

use <database_name>;
exec sp_addrolemember 'db_datareader', '<user_id>'

Authorize to Create Tables (Target Only)

This permission is required when using IBM Informix as a target endpoint and allows you to create target tables.

use <database_name>
grant alter on schema::<schema_name> to <user_id>;
grant create table to <user_id>;

Authorize to Insert, Update and Delete (Target Only)

This permission is required when using IBM Informix as a target endpoint and allows you to write records in target tables.

use <database_name>
grant select, insert, update, delete
on schema::<schema_name>
to <user_id>

Next Steps

In Replicate Preview, configure your workspace using this system datastore and start replicating data. Refer to Configure Workspace: Datastores for more information.