Connectors

Database

When creating a Connector to read or write data to or from a remote database there are a few items that are required. 

First, you must specify a valid Connection String to the database using the Java JDBC connection string conventions for the type of database you are connecting.  For example to connect to the sample SQL Server AdventureWorks database a valid connection string is as follows:

jdbc:microsoft:sqlserver://svr:1433;databaseName=AdventureWorks

The DB connection string includes the Server, Port and Database Name.  The username and password information for the DB Connection String must be provided in the Connection Username and Password fields.

In addition to the connection string, you must tell the Connector to which schema and table within the database you are going to read or write data.  In the case of an HR feed to AdventureWorks, the table might be Person.Person.

It is important that the table name include the schema name as in "schema.tablename."  Finally, often you only want to exchange certain records from the source table; to achieve this, you can specify a restriction clause (a SQL WHERE clause) in the Connector to filter the data.  For example, option1='Connector' specified in the Restriction Clause property would only export records from the Employees table where the value of the Option1 field is equal to "Connector."

Parameter	Description	Example
jdbcDriver	JDBC driver class. Optional.	{jdbcDriver:'sun.jdbc.odbc.JdbcOdbcDriver'}}
identifierTerminals	The pair of values to use for distinguishing between keywords and database object names.	{identifierTerminals:'[]'}