Connector Setup

<< Click to Display Table of Contents >>

Raynet One Data Hub > 14.0 u1 > Connectors > Alphabetic Connector List > Microsoft SQL Server 

Connector Setup

 

 

MSSQLServer_Configuration_01

 

In the Configuration tab, either attach an .sql file from disk or manually write an SQL query in the SQL QUERY field. This is the query that will be executed on the target data source.

 

MSSQLServer_Configuration_02

 

 

In the Connection tab, enter the full connection string to the database into the CONNECTION STRING field.

oExample string for the connection to an SQL Server instance:
Server=myServerAddress\myInstanceName;
DataBase=myDataBase;UserId=myUsername;
Password=myPassword;

oExample string when using a trusted connection:
Server=myServerAddress;
Database=myDataBase;
Trusted_Connection=True;