Connection Editor

The connection string specifies the configuration values required to connect to the database. The content of the connection string depends on the database driver used.

To access the Connection Editor, click on the ... icon.

Note:
  • The Connection Editor helps build the connection string by offering a form that contains by default the most common connection properties for the selected connection type.
  • You are able to update the composition of this form by changing the default property names, or adding and deleting properties.
  • You can also paste a connection string into the Connection string property field before opening the Connection Editor. The form will then display the fields and values that are contained in the connection string.

A typical form looks like this:

<box-inline>Connection Editor</box-inline>

Once you have set up a connection to your database, you can create and execute your own SQL queries. Go here for details on SQL Editor.


Examples of connections

SQL Server

  • Not named, Windows authentication Data Source=serverAddress;Initial Catalog=databaseName;Integrated Security=True;

  • Named server, no Windows authentication Data Source=serverName\instanceName;Initial Catalog=databaseName;Integrated Security=;User ID=username;Password=password;

Example string:

Data Source=JOHNC\SQLSERVER2016;Initial Catalog=employees;Integrated Security=False;User ID=sa;Password=myexamplepwd123

Note:

When using an alias in your connection string and the DB server does not have a certificate, you have to add the TrustServerCertificate property and set it to 'True' to avoid errors.

TrustServerCertificate


Oracle

  • Using TNS-names entry Data Source=TNSname;User ID=username;Password=password;

  • Without using TNS-names entry Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=serverAddress)(PORT=port))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=serviceName)));User ID=username;Password=password;

OLE DB

  • Windows authentication Provider=sqloledb;Data Source=serverAddress;Initial Catalog=databaseName;Integrated Security=SSPI;

  • No Windows authentication Provider=sqloledb;Data Source=serverAddress;Initial Catalog=databaseName;Integrated Security=;User ID=username;Password=password;

ODBC

  • Microsoft Access database Driver={Microsoft Access Driver (*.mdb)};DBQ=databaseFilePath;

  • System Data Source Name, Windows authentication DSN=dataSourceName;Trusted_Connection=Yes;

  • System Data Source Name, no Windows authentication DSN=dataSourceName;Uid=username;Pwd=Password;


Examples of ODBC connections to databases on cloud servers

Note: The DSN property is not used when connecting to a database on a cloud server.

MySQL

Uid=root;Pwd= password;Driver={MySQL ODBC 8.0 ANSI Driver};Server=localhost;Database=myDatabase;

mySQL

PostgreSQL

Uid=postgres;Pwd=password;Driver={PostgreSQL ANSI(x64)};Server=localhost;Database=myDatabase;

postgres

SQLite

Driver={SQLite3 ODBC Driver};Database=F:\myDatabase.db;

SQLite


Connection strings

ODBC