Manage Google Data Catalog Data in DBArtisan as a JDBC Source

The CData JDBC Driver for Google Data Catalog seamlessly integrates Google Data Catalog data into database management tools like DBArtisan by enabling you to access Google Data Catalog data as a database. This article shows how to create a JDBC source for Google Data Catalog in DBArtisan. You can then edit data visually and execute standard SQL.

Integrate Google Data Catalog Data into DBArtisan Projects

Follow the steps below to register Google Data Catalog data as a database instance in your project:

1. In DBArtisan, click Data Source -> Register Datasource.
2. Select Generic JDBC.
3. Click Manage.
4. In the resulting dialog, click New. Enter a name for the driver and click Add. In the resulting dialog, navigate to the driver JAR. The driver JAR is located in the lib subfolder of the installation directory.
5. In the Connection URL box, enter credentials and other required connection properties in the JDBC URL.

   Google Data Catalog uses the OAuth authentication standard. Authorize access to Google APIs on behalf on individual users or on behalf of users in a domain.

   Before connecting, specify the following to identify the organization and project you would like to connect to:

   • OrganizationId: The ID associated with the Google Cloud Platform organization resource you would like to connect to. Find this by navigating to the cloud console.

     Click the project selection drop-down, and select your organization from the list. Then, click More -> Settings. The organization ID is displayed on this page.

   • ProjectId: The ID associated with the Google Cloud Platform project resource you would like to connect to.

     Find this by navigating to the cloud console dashboard and selecting your project from the Select from drop-down. The project ID will be present in the Project info card.

   When you connect, the OAuth endpoint opens in your default browser. Log in and grant permissions to the application to completes the OAuth process. For more information, refer to the OAuth section in the Help documentation.

   Built-in Connection String Designer

   For assistance in constructing the JDBC URL, use the connection string designer built into the Google Data Catalog JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.

   java -jar cdata.jdbc.googledatacatalog.jar

   Fill in the connection properties and copy the connection string to the clipboard.

   Below is a typical connection string:

   jdbc:googledatacatalog:ProjectId=YourProjectId;InitiateOAuth=GETANDREFRESH
6. Finish the wizard to connect to Google Data Catalog data. Google Data Catalog entities are displayed in the Datasource Explorer.

You can now work with Google Data Catalog data as you work with any other database. See the driver help documentation for more information on the queries supported by the Google Data Catalog API.