Microsoft SQL Server
You can create a Microsoft SQL Server Source Connector to write to a Microsoft SQL table by using your username and password.
The schema for this Source Connector is defined by the Microsoft SQL table schema.
- SQL Server URL (Optional)
Step 1: Click New Connector.
Step 2: Under the System prompt, click Microsoft SQL Server.
Step 3: Provide a Connector Name.
Step 4: Select Source Connector.
Step 5: Provide the Host Name.
Step 6: Provide the Port Number.
Step 7: Provide your Username.
Step 8: Provide your Password.
Step 9: Provide the name of the Database that contains the table from which data should be read.
Step 10: Note, this field is optional and in most cases is best avoided. If your server instance is specifically configured, you may provide the SQL Server URL used to connect to your instance of Microsoft SQL Server, contact support for further details.
Step 11: Provide the name of the Table where data should be written.