Adding a new database type

Talend Data Preparation allows a direct connection to various types of databases. You can use them as source to create new datasets.

You can manually enrich the list of databases from which you can import data.

The list of available database types for dataset creation actually depends on the JDBC drivers that you have stored in the <components_catalog_path>/.m2 folder.

Let's say that you have some customer data stored on an Oracle database, and you want to import it in Talend Data Preparation to perform cleansing operations. You will add a JDBC driver .jar file specific to Oracle databases to the Components Catalog folder structure to add this new source of data in the Talend Data Preparation interface.

Procedure

Download the latest Oracle JDBC driver called ojdbc8-19.19.0.0.jar from MVN repository website.
Create the <components_catalog_path>/.m2/com/oracle/database/jdbc/ojdbc8/19.19.0.0/ folder.
Copy the ojdbc8-19.19.0.0.jar in the newly created folder.
Update the <components_catalog_path>/config/jdbc_config.json file by adding the following lines:
```
{
		"id" : "ORACLE",
		"class" : "oracle.jdbc.OracleDriver",
		"url" : "jdbc:oracle:thin:@//<server ip>:<server port>/<database>",
		"paths" :
		[
			{"path" : "mvn:com.oracle.database.jdbc/ojdbc8/19.19.0.0"}
		]

	}
```
Where:
- id is the value that will be displayed in the Talend Data Preparation interface as Database type.
- class is the driver class used to communicate with the database.
- url is the URL template to access a database.
- path is the path of your database, it is identical to the path mentioned in step 2.

Results

The Oracle database is now available in the database type drop-down list in the import form.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here