These settings enable you to define target connection settings and target table locations.
Target Connection Settings
Options | Description |
---|---|
Default Table Create DDL Template | The default Template used for generating DDL for new Tables created on targets of this connection. |
Default View Create DDL Template | The default Template used for generating DDL for new Views created on targets of this connection. |
Create procedures in same database as table | This setting enables you to specify if the procedures associated with new Tables created on Targets of this connection is created in the same database as the Table objects, or in the RED repository meta database. This option is not selected (OFF) by default for existing RED repositories, e.g. the Table's stored procedures are created in the RED repository meta database. If the Table is created in a different Target location (e.g. distinct schema/database in the same SQL Server instance), you can turn ON this option if you want the stored procedures to also be located in the same Target database as the Table object. Refer to Distributing Tables across Multiple SQL Server Databases for details. Note
|
Enable Automatic Creation of Indexes | This setting enables you to turn ON/OFF the automatic creation of metadata for indexes when creating new objects. Neither the RED metadata nor the physical index is created, if this setting is not enabled for objects. This option is selected (ON) by default. You can turn OFF this option for databases that do not have indexes, and if you do not require RED to automatically create metadata indexes for objects. Note
|
Default Pre-Load Action | The default Pre-Load Action to use for Load tables created on targets of this connection. Options include:
If Execute Pre-Load SQL is selected, then the SQL statement to execute before the load takes place must be entered—refer to Pre-Load Action in Database Link Load Properties Screen for details. |
Column Properties Configuration | Lists all the available Column Properties UI Configurations in the metadata. |
Target Table Location [For target enabled licenses]
Options | Description |
---|---|
Add new Target Location | This option enables you to add new database/schema locations for objects in this connection. For Greenplum, Netezza and PDW schema target locations setup, refer to Database source system - Local/Linked Servers or ODBC connection topics, depending on the connection type chosen for the database source.
|
Note
The database and schema names for Custom database connections are used as follows: <database>.<schema>.object name Leave database name blank if not required. Leave schema name blank to use the default schema.