Target Connection

Property TargetConnectionEnabled

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

Property TargetBatchSize

MS SQL Server specific parameter

Property TargetCheckConstraints

MS SQL Server specific parameter

Property TargetCommitData

MS SQL Server specific parameter

Property TargetCompress

Only relevant to MySql connection.

Property TargetDatabase

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

Property TargetFireTriggers

MS SQL Server specific parameter

Property TargetKeepIdentity

MS SQL Server specific parameter

Property TargetKeepNulls

MS SQL Server specific parameter

Property TargetOracleConnectAs

0 = ocaNormal 1 = ocaSYSDBA 2 = ocaSYSOPER

Property TargetPassword

Use TargetPassword to specify Password for target connection.

Leave it blank if you want to use ODBC connection string

Property TargetPort

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

Property TargetServerName

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:

VImpAX1. TargetType = dtOracle;
VImpAX1.TargetServer=”ORCL”;
VImpAX1.TargetDatabase=”;
VImpAX1.TargetUserName=”scott”;
VImpAX1.TargetPassword=”tiger”; 
Example using ODBC Connection string:

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

Property TargetSSLCACert

Works only with PostgreSQL and MySQL

Property TargetSSLCert

Works only with PostgreSQL and MySQL

Property TargetSSLKey

Works only with PostgreSQL and MySQL

Property TargetUseSSL

Works only with PostgreSQL and MySQL

Property TargetTable

Use TargetTable to specify table to load data into.

Property TargetTimeOut

Ole DB connection time out

Property TargetType

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\\ 
  18 = dtSqlServerCE\\ 
  35= dtBDE\\ 
  36 = dsApplication 

Property TargetUseDirectPathLoading

Oracle direct path loading

Property TargetUserName

Use TargetUseName to specify user name for target connection.

Leave it blank if you want to use ODBC connection string

Property TargetUseUnicode

Use SourceUseUnicode enable Unicode for MySQL, PostgreSQL and Sqlite connections

Property TransformationType

0 = ttADD
1 = ttADDONLY
2 = ttADDUPDATE
3 = ttUPDATE
4 = ttDELETE

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

  • vimpx/properties/targetconnection.txt
  • Last modified: 17/09/2018 10:30
  • by admin