Before performing a bulk data transformation (BDT) from a SQL Server to an Enterprise Database Server, ensure the following:
The DMSII Adapter is running on the MCP host.
The AIS Connection name is defined in the AIS Configuration Utility for each host of the target database.
Notes:
It is recommended that no updates are made to the transformation source database while the BDT is running.
It is recommended that the required tables in the transformation target are empty before starting a BDT for the first time. This avoids data duplication or transformation failure during the BDT.
To start a BDT
Click Manage.
The hosts associated with the deployed transformations appear in the Source Database Hosts pane.
In the Source Database Hosts pane, expand Windows Hosts, and then expand the required host to view the databases hosted on it.
Select the database from which you want to start the BDT.
Point to Start, and then click Bulk Data Transformation.
The Data Exchange Transformation Session Setup appears.
On the Transformations tab, select the transformation(s) you want to run, and click Next.
The General Settings tab appears.
On the General Settings tab, enter or change the following information, as appropriate:
The Agent Host box displays the name or IP address of the host on which the Data Exchange Agent for SQL Server is installed.
You must change the value of the Agent host if the Agent and the Administrative Service are not running on the same Windows host.
The Agent TCP Port box displays the default port number (9298) on which the Agent is listening. You must change the TCP port number only if you are not using the default port number.
The Runtime Service Host box displays the host name or IP address of the Windows partition where the Runtime Service is installed.
You must change the value of the Runtime Service host if both the Runtime Service and the Administrative Service are not running on the same Windows host.
The Runtime Service TCP Port box displays the TCP port number of the Runtime Service that was configured during installation.
If you require a secured connection, turn on Secure Connection. This enables you to configure a secure connection between the source database and the Runtime Service.
The Target Host displays the target MCP host name or IP address.
The DMSII Adapter TCP Port box displays the default port number (8299) on which the adapter is listening.
In the AIS Connection Name box, type the AIS Connection Name that you had defined using the AIS Configuration Utility.
If you require a secure connection from Runtime Service to the target database, enable secure connection in AIS, and then enter the corresponding Connection Name.
Click Next.
The Transformation Settings tab appears.
On the Transformation Settings tab, enter or change the following information, as appropriate:
From the Login Type drop-down list, select either Windows Authentication or SQL Server Authentication.
In the User Name and Password boxes, type the user ID and the password based on the selected login type.
From the Select Record drop-down list, select one of the following values:
With Update Lock: Select this option if you do not want data updates to the source tables during the BDT. This ensures data integrity. If you select this option, you need not specify the starting point for a changed data transformation.
With No Lock: Select this option if it is critical that the source tables be updated with the current data during the BDT. If you select this option, you must specify the starting point for a changed data transformation. It is possible that data integrity is compromised if you select this option.
In the Maximum Degree of Parallelization box, type the maximum number of threads that can run in parallel to perform the BDT. This value depends on the number of CPU cores and the available RAM of the machine where Runtime Service is running.
Note: To avoid performance issues, this value must not exceed the number of CPU cores of the machine where the Runtime Service resides.
Click Next.
The Start Transformations tab appears.
Verify all the details, and then click Start.
If the BDT fails to start, the error is displayed on the Bulk Data Transformation Status box. Click the icon in the Details column for more information on the cause and resolution of the error. The transformation starts after you have resolved all the errors.
Note: If SecuritySupport is configured in MCP, then Data Exchange calls the command LogonCheck while checking the format timestamp before performing a BDT. LogonCheck captures logon attempts for all MCP usercodes. For more information on LogonCheck, refer to the *SYMBOL/SECURITYSUPPORT file.
When the BDT starts, the status of the Bulk Data Transformation on the Summary tab changes to Running. Click Refresh on the Summary tab to view the updated status. Click Monitor on the Summary tab to see the statistical data corresponding to the BDT.