Microsoft SQL Server Read Connector (Legacy)

Prerequisites:

  • Access credentials
  • Data location on Microsoft SQL Server

Select MS SQL Server

Click the READ icon for MS SQL Server on the Connectors panel

Custom Code and PIP Install

Use the default code for the MS SQL Server Read Connector or modify as necessary. Specify any PIP packages to be installed.

Test Locally

The ability to test the code locally can be extremely helpful and expedite the connector development process.

๐Ÿ‘

MS SQL Server On Prem

Connectivity to Microsoft SQL Server on premise is supported.

811

Parsers & Schema

Data formats currently available are: Avro, Grok, JSON, Parquet and XSV. However, you can create your own parser functions or define a UDP (User Defined Parser) to process a file format.

For custom read connectors (e.g. SQL Server) you will need to create the schema with column names and data types as well as specifying default values etc.