Adding a data source

Add a data source that contains raw data that you want to process in the Pentaho Data Mastering application.

You must have admin privileges to add a data source.

Perform the following steps to add a data source:

1. On the left navigation menu, click Master Data. The Master Data page opens.

2. In the Resources card, click Add Data Source.

   The Create Data Source page opens.

3. In the Data Source Name box, specify the name of the data source.

4. In the Database Type list, select the database that you want to source data from.

5. Update the input fields for the selected database.

   For reference, review the following examples of input fields for different databases:

Field	Description
Data source name*	Name of the data source.
Database type*	Type of the database.
Driver provided	Not required for Oracle databases.
Configuration method*	Method of configuration. Supported values are: URI Credentials SSL The configuration method that you select determines whether some fields on the page are shown.
Database name*	Name of the database.
Username*	Name of the database user.
Password*	Password to access the database.
Service URI*	Service URI details. The Service URI field is visible only when you select URI as the configuration method. For example: db://username:[email protected]:1234/root
Host*	Host name of the server. The Host field is visible only when you select Credentials as the configuration method. For example: localhost
Port*	Port number to be used for connection. The Port field is visible only when you select Credentials as the configuration method. For example: 5432
SSL Type	Type of SSL to use. The SSL Type field is visible only when SSL is selected as the configuration method. Supported SSL types are: Encryption Only Encryption with Server and Client Authentication The following fields are displayed for both SSL types: Trust Source Type* - Type of trust source Trust Source Location* - Location of trust source Trust Source Password*- Password of trust source Cipher Suite* - Cipher suite details Server’s Distinguished Name* - Distinguished name of server The following fields are displayed only when you select the Encryption with Server and Client Authentication SSL type: Key Store Type* - Type of key store. Key Store Location* - Location of key store. Key Store Password* - Password of key store.
Description	Description of the data source.
* Mandatory

Field	Description
Data source name*	Name of the data source.
Database type*	Type of database.
Driver provided	Not required for PostgreSQL databases.
Configuration method*	Method of configuration. Supported values are: URI Credentials The configuration method that you select determines whether some fields on the page are displayed.
Database name*	Name of the database.
Username*	Name of the database user.
Password*	Password to access the database.
Service URI*	Service URI details. The Service URI field is visible only when you select URI as the configuration method. For example: db://username:[email protected]:1234/root
Host*	Host name of the server. The Host field is visible only when you select Credentials as the configuration method. For example: localhost
Port*	Port number to be used for connection. The Port field is visible only when you select Credentials as the configuration method. For example: 5432
Description	Description of the data source.
* Mandatory

Field	Description
Data source name*	Name of the data source.
Database type*	Type of database.
Configuration method*	Method of configuration. Credentials is the only configuration method that is supported for Snowflake.
Database name*	Name of the database.
Username*	Name of the database user.
Password*	Password to access the database.
Host*	Host name of the server. For example: localhost
Port*	Port number to be used for connection. For example: 5432
Description	Description of the data source.
* Mandatory

Field	Description
Data source name*	Name of the data source.
Database type*	Type of database.
Connection Type	Connection type for the database.
Configuration method*	Method of configuration. Supported values are:- URI Credentials The configuration method that you select determines whether some fields on the page are displayed.
Database name*	Name of the database.
Username*	Name of the database user.
Password*	Password to access the database.
Service URI*	Service URI details. The Service URI field is visible only when you select URI as the configuration method. For example: db://username:[email protected]:1234/root
Host*	Host name of the server. The Host field is visible only when you select Credentials as the configuration method. For example: localhost
Port*	Port number to be used for connection. The Port field is visible only when you select Credentials as the configuration method. For example: 5432
Description	Description of the data source.
* Mandatory

Field	Description
Data source name*	Name of the data source.
Database type*	Type of database.
Configuration method*	Method of configuration. Credentials is the only configuration method that is supported for MySQL.
Database name*	Name of the database.
Username*	Name of the database user.
Password*	Password to access the database.
Host*	Host name of the server. The Host field is visible only when you select Credentials as the configuration method. For example: localhost
Port*	Port number to be used for connection. The Port field is visible only when you select Credentials as the configuration method. For example: 5432
Description	Description of the data source.
* Mandatory

6. Click Test Connection to test the database connectivity. If the data source connection information that you entered is valid, a confirmation message is displayed. If the data source connection information is not valid, an error notification is displayed. A data source is created only when the database connectivity test is successful.

1. (Optional) Specify the description of the data source in the Description box.

2. Click Create Data Source.

   A confirmation message is displayed at the top of the page and the new data source is added in the data source table.

   Tip: To add multiple data sources at one time, see Adding data sources in bulk.