Page History
...
Table of Contents | ||
---|---|---|
|
Overview
Styleclass | ||
---|---|---|
| ||
When creating a new Once you have created a data source connection, you will need to first specify either the type of source you wish to connect to, or provide/select a third party connector to use.
This page will be dedicated to exploring parameters available when connecting to a database.
See Third Party Connectors for or CSV Data Imports for more information on other types of connection.
New Connection Window
Styleclass | ||
---|---|---|
| ||
This will include;
- Name
- Description
- Database Type (from the drivers you have available)
- Username
- Password
Once you have selected your database type, you will be prompted to complete options specific to your connection.
Next Steps
When the basic connection details are complete you will need to choose how you wish to proceed.
The following options may be available;
- Create View - this will allow you to continue onto the New View window. See Creating a View for more information.
- Advanced Connection Editor - this will take you to the advanced options available for your connection, otherwise accessed via the Admin Console.
- Test Connection - this will allow Yellowfin to test the connection information provided to ensure that the database can be reached.
- Save & Close - this will allow you to save your connection and return to the page you were previously on.
- Cancel - this will allow you to close the New Connection window without saving your connection.
Advanced Connection Editor
Styleclass | ||
---|---|---|
| ||
...
can view or modify its advanced connection parameters. This is done by accessing the Connection page in the Administration module.
To access this page, follow the steps:
- Navigate to Administration > Admin console, and expand the Data Sources tab.
- Click on a connection name to access the Connection page.
- From here you will have a range of options, split into the groups explored below.
Connection Description
This section allows you to define the basic metadata for your connection; Name, Description, and Tags. These items should be descriptive as users will need them in order to identify the connection when building content.
Section | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Connection Settings
These are the connection parameters that need to be defined in order for Yellowfin to know how to access your database.
You will be presented with a list of parameters that relates to the type of database you have chosen to connect to, as each database may require different options. However, the common parameters are explained below.
Section | |||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Connection Pool
The connection pool options allow section allows you to specify the number of database connections that can be open simultaneously, the refresh and timeout rates, and if a secondary connection pool can be used.
A connection pool is a collection of connections between Yellowfin and your database; each connection processes a single database query, so the limit set in the pool ensures how many queries will be processed simultaneously. This warrants too many queries from being processed and slowing down the system's performance.
Section | |||||
---|---|---|---|---|---|
|
...
|
...
Security
This section allows you to define who has access to this data source connection, and what they can do with it.
Section | |||||||
---|---|---|---|---|---|---|---|
|
...
|
...
Access Filters
This list allows you to add new, and manage existing, access filters.
...
See Restricting Data with Access Filters for more information.
...
Usage Parameters
This section allows you to define some general settings related to the use of this data source.
Section | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
|
...
|
Views & Content
This allows you to view a list of content that has been created based on this data source connection.
horizontalrule |
---|
Styleclass | ||
---|---|---|
| ||
...