MS SQL DB

To securely connect Explorazor to your MS SQL DB database and retrieve data -

  1. Click on Datasets and select Add New from top right

  2. Under Database Connections, click on Connect MS SQL DB

  3. Connect to your MS SQL DB database by entering the requested information in the field. Should you want to enable Live Connection, select the True option

  4. Once all the fields are filled, you can choose the tables you want to transfer onto Explorazor by clicking on Select Tables

  5. Check the boxes next to the desired tables and click on Select Columns

  6. Select the individual columns you want to include, or simply Select All. Select Confirm

  7. Data retrieved from your MS SQL DB database will get stored as a dataset in Explorazor with the relevant timestamp reflecting the date and time of upload and refresh