Connection

First, you would need to connect to both the source of your data (production environment tables) and the destination (non-production environment tables). The tool provides standard connection prompts for the OLE DB (when available) or ODBC (when OLE DB is not available) connections.

Choose the necessary SSIS version from the dropdown menu, before “Generation Package” button.

Select Source Connection (server with initial data)

Click on the source dropdown field.

Select «New Connect to Database» option.

In «Connection Window» select the type of the server. Based on the connection driver, you will be prompted for the required server connection information.

Types of connection:

MSSQL connection type

You can connect to the MSSQL database using either Windows Authentication or by entering your credentials.

Note: If you are using a custom port, please specify it in the "Server Name" field by using a comma (",") to separate the IP address and the port number.

Example: ‘127.0.0.1,1234’

Windows authentication

SQL Server authentication

After you have entered your data and pressed «Connect», you should see “Database” dropdown menu

After successful server connection, choose the database from the “Database” dropdown menu. It will contain the list of the databases accessible per provided login.

Click «Ok»

Now, select a Destination connection (Server for output from discovery tool)

Click on the Destination dropdown field.

In «Connection Window», select the type of server and enter your credentials. Once you have entered your passwords and clicked “CONNECT” your passwords will be saved and safely encrypted so that you do not have to re-enter your credentials once you leave the application.

MySQL connection type

You can also use windows authentication to connect via TCP to MySQL database or enter your credentials in order to connect.

Windows authentication

SQL Server authentication

After you have entered your data and pressed «Connect», you should see “Database” dropdown menu

After successful server connection, choose the database from the “Database” dropdown menu. It will contain the list of the databases accessible per provided login.

Click «Ok»

Now, select a Destination connection (Server for output from discovery tool)

Click on the Destination dropdown field.

In «Connection Window», select the type of server and enter your credentials. Once you have entered your passwords and clicked “CONNECT” your passwords will be saved and safely encrypted so that you do not have to re-enter your credentials once you leave the application.

Oracle connection type

Enter your credentials in order to connect.

After entering your data and pressing "Connect," if the connection is successful, click "OK."

Now, select a Destination connection (Server for output from discovery tool)

Click on the Destination dropdown field.

In «Connection Window», select the type of server and enter your credentials. Once you have entered your passwords and clicked “CONNECT” your passwords will be saved and safely encrypted so that you do not have to re-enter your credentials once you leave the application.

IBM DB2 connection type

Enter your credentials in order to connect.

After entering your data and pressing "Connect," if the connection is successful, click "OK."

Now, select a Destination connection (Server for output from discovery tool)

Click on the Destination dropdown field

In «Connection Window», select the type of server and enter your credentials. Once you have entered your passwords and clicked “CONNECT” your passwords will be saved and safely encrypted so that you do not have to re-enter your credentials once you leave the application.