ODBC Requests

A quick reference for when you're looking to submit an ODBC account creation request!

Updated over a week ago

***NOTE: All ODBC requests will require authorization from your agency's Security Officer. When possible, please have them submit the request on your behalf to have the request actioned faster!***

In this article:

Note: This article is for instructions on how to contact support for new ODBC connections and allowlisting for current ones. For the ODBC setup instructions once you have your credentials, please see our guide here.

The following template can be filled out by the Security Officer:

I, (Security Officer’s Name), am the Security Officer for (Agency Name) and am the individual with authority to grant access to our clients’ Protected Health Information. I authorize ODBC, SQL read-only access, to be set up for the following staff at the following static IP addresses:

Staff Member's Full Name:

Staff Member's Email:

Staff Member's Static IP Address:

Repeat the bottom 3 lines as necessary for each worker.

New ODBC Accounts

We will need the following items to create a new account for your agency:

  • The names of the worker(s) needed to be added

  • The emails of the worker(s), as we will need to send out the information to them directly

  • The static EXTERNAL IP for the worker

    • This can be found by Googling "What is my IP?". The result will look something like this:

    • Please also review our IP Requirements article to ensure your IP falls within these guidelines

***NOTE: Organizations can have a maximum number of ODBC accounts so the support team will first check if is within limit before reach out to Security Officer for authorization or changes. ***

How to find out if your IP is static:

Following these instructions to trace your IP address on Windows 10:

  1. Right-click on the “Start” button

  2. Type “Command Prompt” in the search bar and press enter

  3. Click “Command Prompt”

  4. Type “ipconfig/all” in the Command Prompt window and press “Enter”

  5. In the list of network information displayed, look for “DHCP Enabled”

If it says “Yes” next to “DHCP Enabled”, your system has a dynamic IP address. If it says “No”, your device has a static IP address.

To verify your IP address on macOS:

  1. Click the “System Preferences” icon in the Dock or choose Apple menu > System Preferences

  2. Select the “Network” option

  3. Go to Advanced > TCP/IP

If you see “Using DHCP” next to “Configure IPv4”, then your system uses a dynamic IP address. If the section says “Manually”, you have a static IP.

Alternatively, you can always contact your ISP to learn more about your network type and IP address.

IP Allowlisting

For an IP Allowlist, we need the IP as shown above, your ODBC username, your preferred email, and authorization from your Security Officer. Reach out to penelope@bonterratech.com for support.

Did this answer your question?