Skip to content

Datasource with Azure Data Catalog

Azure Data Catalog is RDBMS (relational database management system), In AIV we are connecting Datasource with Azure Data Catlog JDBC drivers.

To add the Azure Data Catalog Datasource JDBC driver with AIV, follow the steps below:

  • To get the JDBC driver, Go the vendor’s end and download the (Catalog Data Catlog-connector-java.jar) Driver file.

  • Take the Azure Data Catalog -connector-java from vendor

  • After downloading the jar file, add it into the AIV.

  • To add Go to the library folder AIV\apache-tomcat-8.5.61\webapps\aiv\WEB-INF\lib folder and add the .jar file here.

Connecting Catalog Data Catlog Datasource with AIV

Go to the Master data section and click on Data Source, as shown in the figure below:

Image

Click on Create button from the bottom horizontal menu bar from Datasource section, as shown in the figure below:

Image

The Create Datasource window will open, as shown in the figure below:

Image

Search for Azure Data Catalog data source from Top-right search bar in Datasource section, as shown in the figure below:

Image

Click on Azure Data Catalog to create a data source using Azure Data Catalog.

Image

As you click on Azure Data Catalog take, the create dialog box will pop-up on screen, as shown in the figure below:

Image

Insert the following data in the Datasource connection Dialog box:

Enter Display Name: Azure Data Catalog [ Add name as per your requirements]

Enter Class: com.mysql.jdbc.Driver

Enter Connection: jdbc:azuredatacatalog

=GETANDREFRESH [Add Connection URL as per your Datasource connection]

Enter Username: [Provide the username of your Azure Data Catalog Datasource]

Enter Password: [Enter your respective Azure Data Catalog password]

Click on Test Connection Button to Check Database Connection, after Connection Successful.

Click on ok and save button to close the Dialog box.

Image

Select the Azure Data Catalog DataSource and click on Create Dataset, as shown in figure below:

Image

When you click on create Dataset the following screen will be display.

Image

Enter the Following details in Dataset.

Name: Azure Data Catalog (Add name as per your requirements)

Source: Azure Data Catalog (select the data source which you have created)

DataSource: JDBC