Generic JDBC (Oracle, MySQL, Teradata, etc.)

Generic JDBC transforms Aginity into a universal tool for working with data platforms that support the JDBC API. When using Generic JDBC, you have the ability to establish a connection to a database, review database objects in the tree, generate and send queries using SQL statements, and process the results.

Aginity provides an easy data connectivity solution, without complicated manipulations and additional maintenance. To establish a connection with the data source, you just need

  1. A platform specific JDBC driver to mediate between JDBC technology and the target database
  2. A connection URL that your JDBC driver will use to retrieve a connection to a database.

Here is how to make a generic JDBC connection in Aginity to a few popular database platforms:

How to connect to MySQL platform using Generic JDBC

🔎 NOTE: The manual with reference material for MySQL Connector/J:
https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference.html

🔎 NOTE: JDBC Type 4 driver for MySQL in the Maven repository:
https://mvnrepository.com/artifact/mysql/mysql-connector-java

1. Add Generic driver:
1.1. Navigate to the ‘Drivers’ screen and select ‘Generic’ item from the ‘Add’ dropdown:
mceclip0.png

1.2. Specify Class name value, download driver files and click the ‘Create driver’ button:

mceclip1.png

🔎 NOTE: Please use the JDBC reference manual from your platform vendor to find the name of the class:

https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-driver-name.html

🔎 NOTE: Get the necessary JDBC drivers from your DB vendor or from the public Maven repository:

https://mvnrepository.com/artifact/mysql/mysql-connector-java

2. Add Generic connection:
2.1. Navigate to the ‘Connections’ screen and select ‘Generic’ item from the ‘Add’ dropdown:

mceclip2.png

2.2. Fill in the ‘JDBC URL’ field and populate the other connection properties:

mceclip3.png

🔎 NOTE: Connection URL syntax can be found in the JDBC reference manual from your platform vendor:
https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-jdbc-url-format.html

🔎 NOTE: If you want to define additional configuration properties, set them as a JDBC URL parameter in the URL as key=value pairs. Pay attention to the symbols that precede the parameters and separate them.

3. Create database objects and review them in the ‘Database Explorer’ and ‘Discovery’ panels:

mceclip4.png

How to connect to Oracle platform using Generic JDBC

🔎 NOTE: Oracle JDBC Developer's Guide and Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/21/jjdbc/index.html
https://docs.oracle.com/en/database/oracle/oracle-database/21/jajdb/

🔎 NOTE: Oracle Database JDBC in the Maven repository:
https://mvnrepository.com/artifact/com.oracle.database.jdbc

1. Add Generic driver:
1.1. Navigate to the ‘Drivers’ screen and select ‘Generic’ item from the ‘Add’ dropdown:

mceclip5.png

1.2. Specify Class name value, download driver files and click the ‘Create driver’ button:

mceclip6.png

🔎 NOTE: Please use the JDBC reference manual from your platform vendor to find the name of the class:

https://docs.oracle.com/en/database/oracle/oracle-database/21/jajdb/oracle/jdbc/OracleDriver.html

🔎 NOTE: Get the necessary JDBC drivers from your DB vendor or from the public Maven repository:

https://mvnrepository.com/artifact/com.oracle.database.jdbc

 

2. Add Generic connection:

2.1. Navigate to the ‘Connections’ screen and select ‘Generic’ item from the ‘Add’ dropdown:

mceclip7.png

2.2. Fill in the ‘JDBC URL’ field and populate the other connection properties:

mceclip8.png

🔎 NOTE: Connection URL syntax can be found in the JDBC reference manual from your platform vendor:
https://docs.oracle.com/en/database/oracle/oracle-database/21/jjdbc/data-sources-and-URLs.html#GUID-C4F2CA86-0F68-400C-95DA-30171C9FB8F0

🔎 NOTE: If you want to define additional configuration properties, set them as a JDBC URL parameter in the URL as name=value pairs. Pay attention to the symbols that precede the parameters and separate them.

3. Create database objects and review them in the ‘Database Explorer’ and ‘Discovery’ panels:

mceclip9.png

How to connect to Teradata platform using Generic JDBC

🔎 NOTE: Teradata JDBC Driver Reference:
https://teradata-docs.s3.amazonaws.com/doc/connectivity/jdbc/reference/current/frameset.html

🔎 NOTE: Teradata JDBC Driver:
https://downloads.teradata.com/download/connectivity/jdbc-driver

1. Add Generic driver:
1.1. Navigate to the ‘Drivers’ screen and select ‘Generic’ item from the ‘Add’ dropdown:
mceclip10.png


1.2. Specify Class name value, download driver files and click the ‘Create driver’ button:

mceclip11.png

🔎NOTE: Please use the JDBC reference manual from your platform vendor to find the name of the class:

https://teradata-docs.s3.amazonaws.com/doc/connectivity/jdbc/reference/current/frameset.html

🔎 NOTE: Get the necessary JDBC drivers from your DB vendor or from the public Maven repository:

https://downloads.teradata.com/download/connectivity/jdbc-driver

2. Add Generic connection:
2.1. Navigate to the ‘Connections’ screen and select ‘Generic’ item from the ‘Add’ dropdown:

mceclip12.png

2.2. Fill in the ‘JDBC URL’ field and populate the other connection properties:

mceclip13.png

🔎 NOTE: Connection URL syntax can be found in the JDBC reference manual from your platform vendor:
https://teradata-docs.s3.amazonaws.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html

🔎 NOTE: If you want to define additional configuration properties, set them as a JDBC URL parameter in the URL as ParameterName=Value pairs. Pay attention to the symbols that precede the parameters and separate them.

Create database objects and review them in the ‘Database Explorer’ and ‘Discovery’ panels:

mceclip14.png

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request