Connecting to the Optilogic Platform with Azure Data Studio

The following instructions show how to establish a local connection, using Azure Data Studio, to an Optiogic model that resides in the platform. These instructions will show you how to:

• Enable firewall access from your local machine
• Install PostGres plugin for Azure Data Studio
• Connect to the Cosmic Frog model within Azure Data Studio

Enable Firewall Access

To make a local connection you must first open a Firewall connection between your local IP address and the specific database you are trying to access. Right click the .frog model where you want to make the connection and select "Open in Cloud Storage."

Click the button to "Authorize Current IP Address."

Connection Paths to your Database

Selecting the "Show Connection Info" button will provide the details required to connect to your personal database. The connection strings and paths required to make a connection to this database are located on this screen. Each database has a unique connection string. We have connection information for the following:

• JSON
• POSTGRESQL
• PSQL
• JDBC
• LIBPQ
• ADO.NET
• PSYCOPG2
• SQLALCHEMY

For this example, we will copy and paste the strings for the ‘PSQL’ connection. The screen should look something like the following (with database names and passwords not blacked out):

Postgres Plugin for Azure Data Studio

Within Azure Data Studio click the "Extensions" button and type in "postgres" in the search box to find and install the PostgreSQL extension.

Connect to Cosmic Frog from Azure Data Studio

Add a new connection in Azure Data Studio, change the connection type to "PostgreSQL, "and enter the arguments for "PSQL" from the Cloud Storage page. NOTE: you will need to click "Advanced" to type in the Port and to change the SSL mode to "require."