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.
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.
Updated 7 months ago