The RDB via Tables Connector can be configured using the Aspire Admin UI. It requires the following entities to be created:
Credential
Connection
Connector
Seed
Bellow are the examples of how to create the Credential, Connection and the Seed. For the Connector please check this page.
Create Credential
On the Aspire Admin UI go to the credentials tab
All existing credential will be list. Click on the new button
Enter the new credential description.
Select Rdb-Tables from the Type list.
Enter User and Password. Note: The password will be automatically encrypted by Aspire.
Create Connection
On the Aspire Admin UI go to the connections tab
All existing connection will be list. Click on the new button
Enter the new connection description.
Select Rdb-Tables from the Type list.
In the "JDBC Url" field in the Properties section, enter the JDBC URL for the database to be crawled.
In the "JDBC Driver Jar:" field, enter the name of the JAR file containing the driver for your database.
In the "JDBC Driver Class" field, enter the Java class name for the driver (optional)
If your JDBC Driver jar does not contain all the necessary classes, you may add additional jar files in to the class path. To do this, select "Specify classpath" and enter the classpath to the jars containing the classes. The classpath may include jar files, directories or individual classes.
etc.
The description of all "connection" fields can be found here.
Create Connector
For the creation of the Connector object using the Admin UI check thispage
Create Seed
On the Aspire Admin UI go to the seeds tab
All existing seeds will be list. Click on the new button
Enter the new seed description.
Select Group Expansion from the Type list.
Scope: Include/exclude lists of the seeds its identities should be crawled. Default is all seeds
Custom mapping: Configure custom mapping for specific seeds:
Seed to apply the attribute mapping
Type local/external:
local:
The attribute to be used as the identity key
external:
The attribute to be used as the identity key
The external seed id for looking up the identity
The attribute used for lookup in external seeds identities
Connector: The id of the connector to be used with this seed. The connector type must match the seed type.
Connection: The id of the connection to be used with this seed. The connection type must match the seed type.
Workflow: The ids of the workflows that will be executed for the documents crawled.
Tag: The tags of the seed, these can be used to filter the seed.
Policies
Throttle Policy: Select the throttle policy that applies to this connection object.
Routing Policies: Select the routing policies that this connection will use.