Target Connection

Use TargetConnectionEnabled to stop user from changing target connection properties via interface.

MS SQL Server specific parameter

MS SQL Server specific parameter

MS SQL Server specific parameter

Only relevant to MySql connection.

Use TargetDatabase to specify database name for MS Sql Server, PostgreSQL, MySql or Interbase.

MS SQL Server specific parameter

MS SQL Server specific parameter

MS SQL Server specific parameter

0 = ocaNormal
1 = ocaSYSDBA
2 = ocaSYSOPER

Use TargetPassword to specify Password for target connection.

Note:

Leave it blank if you want to use ODBC connection string

Use TargetPort to specify tcp/ip port for PostgreSQL or MySql.

When Target type is 
Oracle - TNS NANE
MS Sql Server – server name
ODBC – ODBC Dsn or connection string
Ole DB – Ole DB connection string

Example:

DEWizadAX1. TargetType = dtOracle;

DEWizadAX1.TargetServer=”ORCL”;
DEWizadAX1.TargetDatabase=”;
DEWizadAX1.TargetUserName=”scott”;
DEWizadAX1.TargetPassword=”tiger”; 

Example using ODBC Connection string:

DEWizadAX1. TargetType = dtODBC
DEWizadAX1.TargetServer=’uid=sa;pwd=;driver={SQL Server};server=(local);database=demo;’
DEWizadAX1.TargetDatabase=”;
DEWizadAX1.TargetUserName=”; -- must be blank when using odbc connection string
DEWizadAX1.TargetPassword=”;  -- must be blank

Works only with PostgreSQL and MySQL

Works only with PostgreSQL and MySQL

Works only with PostgreSQL and MySQL

Use TargetTable to specify table to load data into.

Ole DB connection time out

Use to specify type of target database

0  = dtNone
2  = dtODBC
6  = dtSqlServer
7  = dtOracle
9  = dtMySql
10 = dtPostgreSQL
11 = dtInterbase
12 = dtOleDB
16 = dtSqLite
16 = dtSqlServerCE

Oracle direct path loading

Use TargetUseName to specify user name for target connection.

Leave it blank if you want to use ODBC connection string

Use SourceUseUnicode enable Unicode for MySQL, PostgreSQL and Sqlite connections

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • dewizardx/properties/targetconnection.txt
  • Last modified: 17/09/2018 09:44
  • by admin