Create a DSN in the odbc.ini file

A sample DSN named DEVART_POSTGRESQL is created during the driver installation. You can configure and adjust the DSN parameters as needed.

Modify the odbc.ini file

1. Open the odbc.ini file in a text editor, for example, nano.

Use the following command to edit the system-wide DSN.

sudo nano /Library/ODBC/odbc.ini

Use the following command to edit the user-specific DSN:

sudo vi ~/.odbc.ini

2. Add the configuration for your DSN in the odbc.ini file.

[DEVART_POSTGRESQL]
Driver=Devart ODBC Driver for PostgreSQL
Server=your_postgresql_server_name
Database=your_postgresql_database_name
User ID=your_postgresql_user_id 
Password=your_postgresql_password
Port=your_postgresql_port_number
Schema=your_postgresql_schema_name

The odbc.ini file opened in a text editor with entered DSN configuration details.

3. Save and close the file:

3.1. Press CTRL + O to save the file.

3.2. Press CTRL + X to exit the editor.

4. Optional: Test the DSN configuration with isql, a command-line tool for executing SQL interactively or in batches.

isql -v DEVART_POSTGRESQL

Once connected, you can run SQL queries to retrieve data from PostgreSQL.

Note

If the password isn’t saved in the DSN, you’ll be prompted to enter it at runtime when connecting to a data source. If the password is saved in the DSN, leave the User ID and Password fields empty.