Microsoft SQL Server

Configure MS SQL Server with Zing

Microsoft SQL Server is one of the most widely used databases for enterprise deployments, developed by Microsoft. MS SQL is scalable and includes ETL (Extract, Transform and Load) tools and reporting services. It is evolving rapidly in the cloud and on hybrid platforms.

You can connect Zing to your MS SQL database from the Zing web console.

You’ll need:

  • Hostname, which is the URL or IP address of your database
  • Database Name, which is the name on your hostname IP / URL, your database is referenced by
  • Username, which is your username. Best practice is to create a read only user
  • Password, which is your password. Once you enter this, Zing will automatically encrypt this.

Web Console

Add a MS SQL database from the web:

  1. Go to your Zing Data Web Console and ensure you are logged in

  2. Tap the ‘Data Sources’ tab

  3. Enter your MS SQL credentials, as outlined above.

  4. If your SQL Server / Azure database is behind a firewall (which it typically will be), you’ll need to allow connections from Zing’s IP address:

  5. Tap ‘Check Connection’

  6. Zing will verify that it can connect to your data source and if successful, add it as a source. If Zing cannot connect to your data source, you'll see a message asking your to check your credentials and retry. If even after checking your credentials and retrying you still experience issues, reach out to Zing support here
  7. Choose the tables you want to include and tap ‘Save’.

  8. The data source you just added will be available to everybody in your organization.