This discussion allows you to configure a Connector for a specific remote Data Store. This Connector Configuration will then be available in the Data Library for setting up Data Sources for import and export. The common configuration parameters for all Connectors are described below. For Connector–specific configuration parameters, mouse over the fields in the form.
Important: for any optional fields that you leave blank here, be aware that settings applied at the Data Source or Session level take precedence. If you return later to this form and update an optional field that you initially left blank, the settings you apply here will not override the settings already saved at the Data Source or Session level for this connector.
Allows you to connect to a JDBC source for Data Library imports. The following fields are used to define the connection parameters.
Name and Description: the name and description users will see for this
JDBC URL: the JDBC connection string. The schema name can be included in the
You can control the database, schemas, and tables that are shown to users when
they browse a data source during import. For databases, schemas, and tables,
you can choose to:
only" which returns only the databases, schemas or tables that you
which hides the databases, schemas and tables that you specify here.
all" which is the default setting to display everything in the data
When you select the "Show only" or "Hide" options, a field
is provided for specifying the databases, schemas or tables on which you want
the option enforced.
Important: These settings are not enforced when users query against the data
source; query results still return a complete list of matches. For example, if
you choose to "hide" a specific database, the query results will
still include that database in the returned results. However, that database
will not be displayed to users when they browse the data source.
Query Prefetch Size for queries: The batch size used (in rows) when prefetching
data on import.
Max Column Size: The maximum size in Unicode characters allowed in a cell when
importing or exporting data.
Pre-import SQL: SQL statement to execute before beginning import, after the
table’s schema is determined.
Post-import SQL: SQL statement to execute after import completes.
Export Batch Size: the batch size used when exporting data.
Max VARCHAR Size: the maximum size allowed for a VARCHAR column allowed on
export. Columns greater than this size will be created as CLOB columns in the
Automatically create table: create a new table automatically on export.
- If checked, and no table exists - a new table will be created and the data will be populated
- If unchecked, and the table exists - the records in the existing table will be left intact, and the new records will be added
- If checked and a table exists - the table is dropped, recreated, and the records will be added to the table
- If unchecked and there is no table - you will get an error
You have to decide if you want to build a table or not (and make sure the account used in the credentials has the rights to create table, or that specific privilege.
Now - if you want to retain some of the records or the structure, then I would suggest running the pre-export & post-export SQL. Pre-export would delete what you want to remove, but retain the database structure. A post command can be issued as a follow up to do activities like rebuild an index or things of that manner.
Pre-export SQL: SQL statement to execute before beginning export, after the
table is created if auto-create is enabled.
Post-export SQL: SQL statement to execute after export completes.
The user authentication can be done through a Shared Account or an Individual
Account. If you chose to authenticate with an individual account, the user will
be prompted to enter a username and password to access this Data Source. If you
choose to authenticate with a Shared Account, the following fields are
User: the username for a shared account used to authenticate to the database.
Password: the password for a shared account used to authenticate to the
Role: if roles have been implemented for this database, authenticated users
with this user role can perform queries after authentication.