In order for Yellowfin to retrieve results to populate reports a database connection must exist. This connection record provides Yellowfin with the location, user credentials, and logon method to be used in order to access your database.
There are two ways to Add a Data Source.
Add a Nickname, a Description (optional) and Drag & drop or browse the file to upload. Then, click Save.
NOTE: Only .jar and .yfp files are accepted.
Once the Driver is successfully installed, you will be redirected to the Database Settings.
Please refer to our JDBC Connections page to check specific information for your database.
Click on “Test Connection” to ensure a successful connection.
Once the connection is successful, the Test Connection button will turn green. Then, click Save.
If the connection fails, you will see a "Failed Connection Test" message.
To add a Cube data source:
Name | Description |
---|---|
Connection Nickname | Add a nickname to recognize your connection. |
Connection Description | Add a description for your connection (optional). |
Authentication Adapter | Choose between Standard Authentication, Pass-through Authentication, and Standard Authentication (No Pooling). |
XMLA URL | The URL for the XMLA data source. |
User Name | Enter or verify the Username for the database. |
Password | Enter or verify the Password for the User Name. |
Click on “Advanced” at the bottom of the Database settings screen and fill in all the required fields.
Name | Description |
---|---|
Min Connections | The minimum number of connections that can be opened simultaneously. |
Max Connections | The maximum number of connections to be opened simultaneously. |
Refresh Time | The number of minutes between connection resets. |
Timeout | The seconds a connection can remain open before it is closed. |
Name | Description |
---|---|
Time zone | Select a time zone for this data source connection. |
Broadcast | Specify if the content on the connection can be broadcasted or not. |
Subscribe | Specify if the content on the connection can be subscribed or not. |
3. Click on “Test Connection” to ensure a successful connection. Then, click Save.
Visit XMLA Data Source for more information.
To add a CSV data source:
Click on “Advanced” at the bottom of the Database settings screen and fill in all the required fields.
3. Click on "Prepare Data" to see the data table.
Visit CSV Data Imports for more information.
Remember the JNDI data source connection types is enabled by running the following SQL against your configuration database:
INSERT INTO Configuration(1, 'SYSTEM', 'JNDISOURCEENABLED', 'TRUE');
Visit Running Custom SQL for more information.
To add a JNDI data dource: