Informix
Configure an Informix® datasource on your Guardium® system.
Supported Authentication Methods
| Authentication | Supported |
|---|---|
| Local user | Yes |
| LDAP | No |
| Kerberos | No |
| SSL | Yes Note: When Informix traffic is
sent with SSL, the Client IP is set to 0.0.0.0 in Guardium Data Protection reports
and other user interface elements. |
| Mutual SSL | No |
Parameters
| Field | Description |
|---|---|
| Host Name/IP | Required. The hostname or IP address of the datasource. |
| Port number | Required. Default value: 1526 |
| Informix server | The name of the Informix server. |
| Database | The name of the database. The default is sysmaster. When the database name is sysmaster, the db_locale that is specified in the connection property field is used to connect to the sysmaster database. For other databases, the db_locale in the sysdbslocale table is used. |
| Connection property | Properties that must be included in the JDBC URL to establish a JDBC connection with the datasource. The required format is property1=value;property2=value, where each property and value pair is separated by a semicolon. For examples, refer to the database vendor's JDBC documentation. For Informix Unicode databases, the connection property IFX_USE_STRENC=true might be required. Use the CLI command store set_informix_driver_property to set IFX_USE_STRENC=true on all Informix datasources. |
| Custom URL | The connection string to the datasource. When the custom URL is not provided, the datasource connection is made by using properties such as the hostname and port number. |
CAS (Configuration Auditing System) database instance
If you are a CAS user, configure the CAS database instance.
| Field | Description |
|---|---|
| Account | The name of the account owner.
Example: informix |
| Directory | The name of the installation directory. On UNIX®, the default is /opt/IBM/informix On Windows™, the default is C:\Program Files\IBM\Informix An environment variable INFORMIXDIR can be defined.The program servicename.cmd must be on the system path, where servicename is the name of the Informix server that is defined in the Datasource Definition GUI. |
When the database name is not sysmaster, 2 connections are made:
1) The first connection is made to the sysmaster database using BASE_URL_TEMPLATE (jdbc:informix-sqli://<HOST>:<PORT>/sysmaster:informixserver=<DBSERVER_NAME>). This connection returns the db_locale of the database from the sysdbslocals table.
2) The second connection is made to the database name that is specified. This connection replaces <locale> in the URL_TEMPLATE with the db_local that is returned from the first connection. (jdbc:informix-sqli://<HOST>:<PORT>/<DB_NAME>:informixserver=<DBSERVER_NAME>;DB_LOCALE=<LOCALE>).