This section describes how you create a new remote MS SQL Server.
Before you begin:
- You must install additional software to use the bulk copy program (BCP) utility for remote loading to the target:
- For Windows, download and install the “Microsoft Command Line Utilities” software package that includes the BCP utility. This software is not provided by the Connect CDC installation program. The “Microsoft Command Line Utilities” software package must be installed on the remote host machine that is applying the data to the remote MS SQL Server instance. See the Microsoft Command Line Utilities 11 for SQL Server website for more information.
- For Linux, download and install the SQL Server command-line mssql-tools. The software includes the BCP utility and the sqlcmd command-line query utility. This software is not provided by the Connect CDC installation program. The mssql-tools must be installed on the remote host machine that is applying the data to the remote SQL Server instance. After you install the utilities, append the BCP location to the PATH environment setting of the user running the kernel. To download the utilities, see the Install SQL Server tools webpage of the SQL Server on Linux Microsoft online documentation.
- The JDBC driver is required to access the remote instance of MS
SQL Server. This must be done even if MS SQL Server is not
installed on the remote host.
- For Windows, configure MS SQL Server to install the appropriate JDBC drivers for MS SQL Server on the remote host. Use the Connect CDC Installation wizard to install the appropriate JDBC drivers. See the Connect CDC Install Guide
- For Linux, the JDBC drivers are not installed with the CDC software. You must manually
download and install the latest JDBC drivers for MS SQL Server on Linux.
Note: SQL Server remote configurations (offbox) are supported on Windows and Linux machines.
On the Servers Properties dialog select Microsoft SQL Server from the dropdown list in the DBMS type section.
Check the checkbox, Remote Machine Name or IP. Specify the remote machine name or IP address of the remote server.
- Enter information for each field on the Server Properties dialog. Refer to Server properties dialog for MS SQL Server for field information.