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.
Easy Heading Free | ||||
---|---|---|---|---|
|
Note: we are not going to use this credential, we will use SA instead, creating this because credential is required in connection config)
Image Added
Image Removed
An RDBMS "URL" is needed to tell the connector application what database to crawl. The exact form of this URL is dictated by the JDBC driver and therefore the database vendor, but will be of the form
jdbc:<vendor>://<server>:<port>/{DATABASE}
For example: jdbc:mysql://192.168.40.27/{DATABASE} - the marker {DATABASE} will be replaced with the value of Database name field (see Create Seed section on this page)
See your database vendor's documentation for more information on JDBC URLs.
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
etc.The description of all "connection" fields can be found here.
Image Removed
Image Added
The description of all "seed" fields can be found here.