Skip to main content
Version: 1.0 (Latest)

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 \
...
--sourceconnectiontype

--sourceconnectiontype "connection_type"

Available Connection Types, grouped by database. The types marked ADBC use the Arpe.io ADBC drivers (bundled; Windows x64 and Linux x64): see ADBC Connections.

SQL Server
  • mssqlSQL Server Native Client (.Net)
  • msoledbsqlSQL Server OleDB
  • adbc_mssqlADBCSQL Server (ADBC)
PostgreSQL
  • pgsqlPostgreSQL Native (.Net)
  • pgcopyPostgreSQL Copy
  • adbc_pgsqlADBCPostgreSQL (ADBC)
Oracle
  • oraodpOracle ODP.Net
  • adbc_oracleADBCOracle (ADBC)
Teradata
  • teradataTeradata (.Net)
  • adbc_teradataADBCTeradata (ADBC)
IBM Netezza
  • nzsqlNetezza Native (.net driver)
  • nzoledbNetezza OleDB
  • adbc_netezzaADBCNetezza (ADBC)
IBM Db2
  • adbc_db2: Db2 for LUW (ADBC)
DuckDB
  • duckdbDuckDB
  • duckdbstreamDuckDB using streaming (more memory efficient)
MySQL
  • mysqlMySQL
SAP HANA
  • hanaSAP HANA (.net driver)
ClickHouse
  • clickhouseClickHouse
Generic drivers
  • odbcODBC datasource (DSN must be configured)
  • oledbGeneric OleDB datasource
note

An adbc_* source needs an adbc_* target. See ADBC Connections.

Source DSN (Data Source Name)​

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

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

--sourcedsn "DSN_name"

Source Provider​

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

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

--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).

--sourceserver

--sourceserver "server"

Source Server Format Examples​

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

IP address or DNS name
mysourceserver.mydomain.comHost
IP address or DNS name with port number
mysourceserver.mydomain.comHost: or ,2433Port
IP address or DNS name with named instance
mysourceserver.mydomain.comHost\myinstanceNamed instance
Oracle: Easy Connect string
mysourceserver.mydomain.comHost:1521Port/myinstanceInstance
Oracle: TNS entry
MYTNSTNS entry
The same formats in a command

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 \
...
--sourceconnectstring "Server=myserver;Database=mydb;User ID=FastUser;Password=FastPassword;Encrypt=True;TrustServerCertificate=True"
...
--sourceconnectstring

--sourceconnectstring "connection_string"

Password Security in Logs

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

Source Database​

Define the source database name.

Example:

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

--sourcedatabase "database_name"

Related
Copyright © 2026 Architecture & Performance.