BCP Ingestion

Following are the steps to perform ingestion on a SQL Server source using BCP fetch mechanism:

Navigate to the SQL Server source settings page.
Select the Fetch Data Using option as BCP.
Enter the other details and save the settings.

Once the metadata is crawled, navigate to the table configuration page and select the BCP character set. The options include Unicode Character and Character.

Advanced Configuration for SQL Server BCP Source

Multilines are supported in string columns for SQL Server BCP source (Source Type - SQL Server and Fetch Data Using - BCP). If the source table includes string columns with line breaks, perform the following:

Navigate to the source and click Configure on the required table.
Click the Advanced tab and click Add Configuration.
Set the key as ENABLE_QUOTENAME and value as true. The default value is false.
Click Save.

SQL Server Windows Based Authentication

The SQL Server driver supports SQL Server AD login. For details on setting Microsoft drivers for SQL Server AD login, see Connecting using Azure Active Directory authentication.

Last updated on