Custom connector for IBM Informix utilizes an ODBC connection for executing custom queries and retrieves metadata using specific queries tailored to this data source.
ODBC Driver
Before importing, using the custom connector requires the installation and configuration of the ODBC driver.
We have tested the import using the official IBM ODBC driver available here Informix Client.
IBM ODBC driver configuration manual: Configuration manual
ODBC Driver Configuration
The provided configuration instructions are for version 4.50.FC8 of IBM Informix ODBC Driver Setup Utility.
Install the Informix ODBC Driver.
Open ODBC Data Source Administrator (64-bit) in Windows.
Choose either User DSN or System DSN, then click the Add... button.
In the IBM Informix ODBC Driver Setup window:
- Go to the General tab and provide a Data Source Name.
- Switch to the Connection tab:
- Select informix from the Server Name dropdown.
- Enter the IP address or hostname of the Informix database in the Host Name field.
- Provide the port number in the Service field.
- Select onsoctcp from the Protocol dropdown.
- Leave the Options field empty if not needed.
- Enter the User Name and Password.
- Select the Database Name from the Database dropdown.
Click Apply and then test the connection by clicking Test Connection.
If the test connection is successful:
- Go to the Environment tab. Refer to the screenshot below for settings that worked during our test import.
- Proceed to the Advanced tab. Again, refer to the screenshot below for settings that worked during our test import.
Click Apply to save the new data source.
The new data source will now be available for selection in the Dataedo import process.
Connector features
Data Catalog
Dataedo will document following objects from IBM Informix:
- Tables,
- Views
- Procedures,
- Functions
How to connect
To connect to IBM Informix create new documentation by clicking Add and choosing New connection.
On the connection screen choose IBM Informix (Local Custom Connector) or IBM Informix (Shared Custom Connector)
Choose ODBC driver configured earlier
Click Connect
Connector specification
Imported objects
| Object | Imported as |
|---|---|
| Table | Table |
| View | View |
| Function | Function |
| Procedure | Procedure |
Tables metadata
| Metadata | Imported as |
|---|---|
| Name | Name |
| Comment | Description |
| Columns | Table columns |
| Name | Name |
| Data type | Data type |
| Null/Not null | Nullable |
| Comment | Description |
| Foreign Keys | Relationships |
| Constraint table | FK Table |
| Referenced table | PK Table |
| Name | Relationship name |
| Primary/Unique keys | Unique keys |
| Name | Key name |
| Columns | Columns |
| Triggers | Triggers |
| Definition | Script |
| Name | Name |
| Action | When |
Views metadata
| Metadata | Imported as |
|---|---|
| Name | Name |
| Comment | Description |
| Columns | View columns |
| Name | Name |
| Data type | Data type |
| Null/Not null | Nullable |
| Comment | Description |
Procedures metadata
| Metadata | Imported as |
|---|---|
| Name | Name |
| Comment | Description |
| Parameters | Function parameters |
| Name | Name |
| Data type | Data type |
| Mode | Mode |
Functions metadata
| Metadata | Imported as |
|---|---|
| Name | Name |
| Comment | Description |
| Parameters | Function parameters |
| Name | Name |
| Data type | Data type |
| Mode | Mode |