Microsoft SQL Server

Overview

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. The schema cannot be changed after saving the Connector.

Prerequisites

Required information:
  • Host
  • Port
  • Username
  • Password
  • Database
  • SQL Server URL (Optional)
  • Table

Creating an MySQL Source Connector

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.
If you are trying to access a database that is behind a firewall, please ensure that the following Osmos IP addresses are allowed to access the database. Osmos uses these fixed IP addresses to access your sources and destinations.
  • 35.222.106.198/32
  • 35.232.180.174/32
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.
Note: the schema for this Source Connector is defined by the Microsoft SQL Server table schema. The schema cannot be changed after saving the Connector, so please confirm it is accurate before proceeding.
Note: for any fields that have primary key, foreign key or other constraints, you may either (1) ensure that the source data mapped to the field satisfies those constraints or (2) leave the field empty and ensure that your database is set up to auto populate those fields with appropriate constraint-satisfying data.
Copy link
On this page
Overview
Prerequisites
Creating an MySQL Source Connector