- Access credentials
- Data location on Microsoft SQL Server
Click the READ icon for MS SQL Server on the Connectors panel
Use the default code for the MS SQL Server Read Connector or modify as necessary. Specify any PIP packages to be installed.
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.
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 over 2 years ago