Option | Description |
---|---|
Name | Enter a unique name for the connection and click Continue. |
Server Host Name | Specifies the URL or IP address of the server that hosts Actian Ingres. This property is mandatory. |
Port | (Optional) Specifies the JDBC port number on which the JDBC connection can be established to the specified host/server. If the port number is not provided then the default port number is used. For example: II7. |
Database Name | (Optional) Specifies the database name to connect to. |
User Name | Specifies the user name for the specified database. This property is mandatory. |
Password | Specifies the password for the specified database. This property is mandatory. |
Additional Properties | (Optional) Specifies additional connection properties, in a comma separated format, that must be appended to the connection string. For example: rewriteBatchedStatements=true |
Test | Click to verify your connection, then click Save. |
Option | Description |
---|---|
Test Credentials | Click to verify your connection. A “Connection successful” message is returned when the connection is successful. An error message is returned when the connection attempt fails. |
Table Name | Select a table from which data will be read. This property is mandatory. |
Preview the first 20 records | Click to preview the first 20 records. Use this to verify that you’re connected to the correct table. Data for the selected source table is displayed in the source data preview pane. Click and enter a string to search for a particular record. |
Continue | Click when you have finished entering source definitions. The Rules page opens. If you are in the process of creating a Data Profile, proceed to Define Rules and Analyze Results. If you are in the process of creating connection, return to Creating a Connection. |