MS SQL DB

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

  1. Click on Data and select New Data Connections from the left navigation bar

  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 Phrazor 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 Phrazor with the relevant timestamp reflecting the date and time of upload and refresh