Try our Interactive Data Client: a revolutionary, AI-Powered, custom data retrieval tool. Retrieve ANY data on ANY subject within seconds: Start Now!

Using Azure SQL with Interzoid

Connecting Interzoid to your Azure SQL Database is simple. This enables records in a database table can be sent to Interzoid APIs for data quality and data enrichment analysis and processing. All you need is a connection string that tells Interzoid how to reach your Azure SQL Server instance. You can copy and paste the format below and replace the placeholders with your own values.

Basic Connection String


  server={servername}.database.windows.net;user id={youruserid};password={yourpassword};port=1433;database=mysample;

Replace {servername}, {youruserid}, {yourpassword}, and mysample with your own server, database login, database password, and database name. This is all you need to get started.

Firewall Rules

If you want to create a Firewall rule to allow Interzoid's servers to hit your Azure SQL database, under "networking" on the Azure portal for your database server, create Firewall rules for the following two IP addresses (use the same for "start" and "end" IP addresses): 


  35.168.55.37
  44.209.66.205
This prevents setting up public access and allows our servers to read your table data for analysis and processing.

Advanced: Granting Read-Only Access

For additional security, we recommend creating a dedicated read-only user account.

  • Create a new SQL login or Azure AD user just for Interzoid (e.g., interzoid_app_ro).
  • Grant that user read-only permissions to the specific database or tables you want Interzoid to use. This will in most cases include providing SELECT access only to the account.
  • Use this new login in your connection string instead of a regular user.

Read-Only Connection String Example


  server=myserver.database.windows.net;user id=interzoid_app_ro;password=StrongPassword123;port=1433;database=interzoid_db;Application Intent=ReadOnly;

Adding Application Intent=ReadOnly tells Azure SQL that this connection is for read-only queries, which can help route traffic efficiently.

Key Notes

  • You stay in complete control of your Azure SQL environment.
  • You can revoke third party access at any time by disabling the read-only user or removing permissions.
  • Connection strings for your instance can also be found in the Azure Portal.

Questions? Contact support@interzoid.com.