You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 3 Next »
The RDB via Snapshot Connector can be configured using the Aspire Admin UI. It requires the following entities to be created:
Bellow are the examples of how to create the Credential, Connection and the Seed. For the Connector please check this page.
Note: we are not going to use this credential, we will use SA instead, creating this because credential is required in connection config)
JDBC Url - jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId={DATABASE};OAuthServiceAcctEmail=ex-223163-prd-mktplcinteg@prd-223163-mkplace-bd-de4f8262.iam.gserviceaccount.com;OAuthType=0;OAuthPvtKeyPath=/home/dliu/projects/dmp/bigquery-lib/GCP_BQ_SA.json
Note - {DATABASE} value will be read from seed "Database name" field.
JDBC Driver Jar /home/dliu/projects/dmp/baseline/assets/aspire-distribution-archetype-5.0.4-distribution/drivers/GoogleBigQueryJDBC42.jar
Specify Classpath /home/dliu/projects/dmp/bigquery-lib
The description of all "connection" fields can be found here.
Note: The JDBC driver class can be found in attachments
For the creation of the Connector object using the Admin UI check this page
The description of all "seed" fields can be found here.