Follow the instructions below to connect Yellowfin to an Actian Ingres database.
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. |
Click on the Create button and select Data Source.
Select Composite Information Server from the databases list.
Connection String: when selecting Connection String you have the same functionality as in Generic JDBC Data Source.
Composite Information Server configuration fields:
Authentication Adapter: Specify an authentication method for the database adapter. More details Advanced Connection Editor
Include Schema in SQL: Select this checkbox to add the schema name when addressing database tables in SQL queries.
Database Host: Enter the name or IP address of the server hosting the Composite database.
Database Port: The right TCP/IP port number for this database will automatically be provided by Yellowfin.
Domain: Specify the domain to be used for this database connection.
Database Name: Specify the name of the virtual database.
JDBC Driver: The JDBC driver talks to your Composite database.
Username: Enter the username of your database account.
Password: Provide the password of the above account.
Toggle Advanced Settings to see more settings.