Connect SQL using Scribe Insight

Connect SQL using Scribe Insight

If you have any doubt in the post please post comments. I will try to solve your problem.

Using ODBC adapter we can create SQL server connection and load tables in the configure steps/source. 

• You can simply select single table.
• You can even write complex custom query to execute.
•  You can also execute store procedure.

1. Open the scribe click configure steps

2. Add connection. Expand ODBC and double click "Add/Modify Datasource"

3. ODBC data source window will pop up. Click "Add" button in the user DSN tab.

4. Select "SQL Server" and click "Finish" button.

5. Give sql server name in the server input field and give name of your datasource.

6. If logged in windows login user name and PWD are same to connect the SQL server click                   "Windows NT authentication"

    Other click SQL server authentication using login id and pwd and give username and pwd.

7. Check change default datasource and choose you database in the SQL server and click next button.

8. Click finish button.

9. Click testdatasource button,Your database added in the ODBC datasource and click OK button.

10. Choose your datasource in the configure steps connection lookup.

11. Now your tables are loaded. You can click tables and click. If you want write custom query you can do it. You can also execute store procedure.