This guide shows you how to connect Yellowfin to an IBM Informix data source.
Yellowfin does not ship with the driver required for this connection due to licensing/paywall reasons. You will need to manually upload the driver through the Plugin Manager or Creating a Basic Data Source Connection. |
1. Click on the Create button and choose the data source option.
2. Select IBM Informix from the databases list.
3. When the New Connection popup appears, provide a name and description for your database.
4. Connection String: when selecting Connection String you have the same functionality as in Generic JDBC Data Source.
5. IBM Informix configuration fields.
6. Authentication Adapter: Specify an authentication method for the database adapter. More details Advanced Connection Editor.
7. Include Schema in SQL: Select this checkbox to add the schema name when addressing database tables in SQL queries.
8. Database Host: Enter the name or IP address of the server hosting the Informix database.
9. Database Port: Yellowfin will display the correct TCP/IP port number for this connection.
10. Database Name: Specify the name of the Informix database to connect to. If you don't provide a database name, a connection is made to the Informix database server.
11. Server Name: Use this optional parameter to specify the name of the database server.
12. JDBC Driver: The JDBC driver talks to your Informix database.
13. Username: Enter the user ID to connect to the database.
14. Password: Specify the password for the user ID provided above.
15. Toggle Advanced Settings to see more settings.
16. Once you have completed your connection information, you will have several options: