SQL Server 2019 BDC Bulk Loader

The destination writes data from record fields to table columns based on matching names. You can configure the destination to automatically handle data drift in SQL Server tables. The destination can create new SQL Server or external tables when new table references appear in records, and the destination can create new SQL Server columns when new field references appear in records. The destination cannot write data from record fields that store data in the Map, List, List_map, or File_ref data types.

When you configure the destination, specify connection information, including the database, schema, and table to write to, and the number of connections used. You can specify a row field that lists the fields to include in each row written to the table or you can have the destination write all rows except specified fields. You can also configure the destination to replace missing fields or fields containing invalid data types with specified default values, and to replace newline characters in string fields with a specified character.

Before you use the SQL Server 2019 BDC Bulk Loader destination, you must complete several prerequisite tasks. The destination is available in the SQL Server 2019 Big Data Cluster Enterprise stage library.install the SQL Server 2019 Big Data Cluster stage library and complete other prerequisite tasks. The SQL Server 2019 Big Data Cluster stage library is an Enterprise stage libraryEnterprise stage library. Releases of Enterprise stage libraries occur separately from Data Collector releases. For more information, see Enterprise Stage Libraries in the Data Collector documentation.