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.
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
Revisit the Getting Started page for a refresher.
Read more about the API Builder here.