Search

Home

Home

gravity.integration
gravity.integration
/gravity.integration ENG
gravity.integration ENG
/Technical Documentation
Technical Documentation
/GRAVITY.INTEGRATION Environment
GRAVITY.INTEGRATION Environment
/System Configuration
System Configuration
/Connections to sources/destinations
Connections to sources/destinations
/
New SQL Database Connection

New SQL Database Connection

To create a connection to a database server, select SQL database and click New….

image

In the connection creation form, you can select the Driver (the database driver).

image
icon
Depending on the selected driver, the form may contain different fields. However, the rules for creating a connection remain the same.

You can create the connection in two ways:

  • by entering the connection details such as Host, Port, Database name, User, and Password,
  • or by using the Custom connection string field, where you can provide your own connection string.
image

A connection string is always used when connecting to a database. If no value is provided in the Custom connection string field, the system will generate a default one based on the entered connection details (option 1). If you fill in the Custom connection string field, it takes precedence and will be used when creating the database connection (option 2). This allows you to create custom database connections—for example, if you want to connect to SQL Server using domain authentication, use a connection string such as:

Server=DESKTOP-YOUR_SERVER\SQLEXPRESS;Database=YOUR_DATABASE_NAME;Trusted_Connection=True;

icon
For more information on building connection strings, see: https://www.connectionstrings.com/sql-server/

After defining the connection details, it’s time to test the connection. To do this, use the Connection test button. When you see the message below, the connection has been configured correctly and you can save it using the Save button.

image