Source Connection Parameters

FastTransfer requires connection information to access your source database where data will be extracted. This page covers all source connection-related parameters.

Source Connection Type

Specify the type of source database connection driver to use. This parameter determines how FastTransfer connects to your source database.

./FastTransfer \
...
 --sourceconnectiontype mssql \
...

Syntax:

• Short form: -c "connection_type"
• Long form: --sourceconnectiontype "connection_type"

Available Source Connection Types:

Connection Type	Description
clickhouse	ClickHouse
duckdb	DuckDB
duckdbstream	DuckDB using streaming (more memory efficient)
hana	SAP HANA (.net driver)
msoledbsql	SQL Server OleDB
mssql	SQL Server Native Client (.Net)
mysql	MySQL
nzcopy	Netezza copy (WIP)
nzoledb	Netezza OleDB
nzsql	Netezza Native (.net driver)
odbc	ODBC datasource (DSN must be configured)
oledb	Generic OleDB datasource
oraodp	Oracle ODP.Net
pgcopy	PostgreSQL Copy
pgsql	PostgreSQL Native (.Net)
teradata	Teradata (.Net)

Source DSN (Data Source Name)

If you have chosen an ODBC connection type for the source, you must define the DSN with the -n parameter, or alternatively define a connection string using --sourceconnectionstring.

./FastTransfer \
...
 --sourceconnectiontype odbc \
 --sourcedsn "MySourceODBCDataSource" \
...

Syntax:

• Short form: -n "DSN_name"
• Long form: --sourcedsn "DSN_name"

Source Provider

If you have chosen an OLEDB connection type for the source, you must define the OLEDB provider with the -p parameter.

./FastTransfer \
...
 --sourceconnectiontype oledb \
 --sourceprovider MSOLEDBSQL \
...

./FastTransfer \
...
 --sourceconnectiontype oledb \
 --sourceprovider NZOLEDB \
...

Syntax:

• Short form: -p "provider_name"
• Long form: --sourceprovider "provider_name"

Source Server

Except if you have defined a source connection string, you must define a source server (or could also be a TNS entry for Oracle).

Syntax:

• Short form: -s "server"
• Long form: --sourceserver "server"

Source Server Format Examples

The source server parameter accepts different formats depending on your database:

IP address or DNS name:

./FastTransfer \
...
 --sourceserver "mysourceserver.mydomain.com" \
...

IP address or DNS name with port number:

./FastTransfer \
...
 --sourceserver "mysourceserver.mydomain.com:2433" \
...

or

./FastTransfer \
...
 --sourceserver "mysourceserver.mydomain.com,2433" \
...

IP address or DNS name with named instance:

./FastTransfer \
...
 --sourceserver "mysourceserver.mydomain.com\myinstance" \
...

For Oracle - Easy Connect string:

./FastTransfer \
...
 --sourceserver "mysourceserver.mydomain.com:1521/myinstance" \
...

For Oracle - TNS entry:

./FastTransfer \
...
 --sourceserver "MYTNS" \
...

Source Connection String

Tips

You can use a connection string to define the connection to the source database. This connection string will override any other connection parameters and can be used if the other authentication modes are not enough for your case.

You can use the connection string for any source connection type. The connection string must be enclosed in double quotes.

Example:

./FastTransfer \
...
 --sourceconnectionstring "Server=myserver;Database=mydb;User ID=FastUser;Password=FastPassword;Encrypt=True;TrustServerCertificate=True"
...

Syntax:

• Short form: -g "connection_string"
• Long form: --sourceconnectionstring "connection_string"

Password Security in Logs

All passwords within the --sourceconnectionstring parameter are automatically hidden in all logs (Console, Files, and Database).

Source Database

Define the source database name.

Example:

./FastTransfer \
...
 --sourcedatabase "AdventureWorks" \
... 

Syntax:

• Short form: -d "database_name"
• Long form: --sourcedatabase "database_name"