Microsoft SQL Server¶
To use the Microsoft SQL Server API to perform bulk data loads, first you need to follow these steps:
Install the Microsoft Command Line Utilities for SQL Server on the host where the Virtual DataPort server runs:
Edit the JDBC data source and click the tab Read & Write. Then, select Use bulk data load APIs and in the Bcp executable location box, enter the path to the file
On Windows: enter
c:\Program Files\Microsoft SQL Server\bcp.exe.
On Linux: enter
Make sure the file path you enter exists; on your system, “bcp” may be installed on a different path.
The process is the same regardless of if you selected a jTDS adapter or a Microsoft adapter.