In this tutorial, you will learn how to create a connection to a SQL Server database for the BookStore database.


You need to create a connection to your data source. For this tutorial, a connection to a SQL Server database will be created, which you will use on each Synatic flow that accesses and processes data for your API.

Synatic - Flow step - SQL Server

To create a connection:

Click the Add icon to add a new connection in the Solutions panel.

  • Server - Enter the SQL Server address or hostname where the database resides.

  • Username - Enter the username for the API to use when accessing the database.

  • Password - Enter the password for the API to use when accessing the database.

  • Database name - Enter the Database you want the API to connect to.
    📝 Defaults to the configured default database.


Watch the video below to learn how to add a new connection


Useful Tutorials

Revisit the Getting Started page for a refresher.

Read more about the API Builder here.


< Creating the Tag tab Info >

Did this answer your question?