Date: Thu, 28 Mar 2024 14:55:19 -0600 (MDT) Message-ID: <1601056234.2589.1711659319958@confluence-external-wiki> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_2588_1005223226.1711659319957" ------=_Part_2588_1005223226.1711659319957 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Follow the instructions below to connect Yellowfin to an I= nterSystem Cache database.
Click on the Create button and then on Data Source.
<=
br>
Click on the Database icon.
When the New Connection popup appears, provide a name and desc= ription for your database.
From the Database Type drop down list, select InterSys=
tem Cache DB. New configuration fields will appear on doing so.&nb=
sp;
Select the Include Schema in SQL checkbox to =
add the schema name when addressing database tables in SQL queries.
<=
/p>
Next, enter the name of the server hosting the database.
The TCP/IP port number required for this database, will alread= y be displayed.
Specify the name of the database containing the data that you = require.
Yellowfin will automatically select the correct JDBC driver to=
talk to your InterSystem Cache database.
Enter the username and password of your InterSystem Cache data= base account.
Once you have completed your connection information, you will =
have several options:
Advanced Connection Editor: This will take you to the Data Source page in= the Admin Console and allow you to edit all the advanced options available= for your database.
Test Connection: This will validate the conne= ction parameters you provided to ensure it can connect to your database. If= the connection was successful, a message will appear.
Create View: This will save your connection a= nd get you started on creating a view based on it.
Save & Close: This will allow you to save= your connection and close the New Connection popup, returning you to the p= age you were on previously.
Cancel: This closes the New Connection popup = without saving your connection, returning you to the page you were on previ= ously.
We recommend testing the connection, and then saving it by usi= ng the Save & Close button.