Portal for Support Agents

IT Pro: How to read users from a SQL data source

This article explains how you can use the Sql2Xink tool to pull data from a SQL data source to Employees in Xink. This is often used if your Active Directory (AD) is not updated and your HR department maintains the data in an ERP system.

The Sql2Xink tool will pull the data automatically when you set it up as a scheduled task or run it from a cmd prompt.

The tool features a user interface where you can configure a connection string and a SQL SELECT statement to pull the data from your database.  

You will also be able to map fields from your SELECT statement to fields in your Xink account. 

We will walk you through the steps below.


Install Sql2Xink

Download the Sql2Xink installer and double-click the file Sql2XinkSetup.msi to install the tool.

First, you need to configure the tool. Click "Configure Xink Sql2Xink" from the Start menu which will start the main menu.


Connect to your SQL Server database

Click "Connect to the settings database" to connect the tool to your SQL Server. Enter the connection string and click "Test" to test the connection. Click "Save" to save the connection string.

Examples:

Provider=sqloledb;Data Source=SERVERNAME;Initial Catalog=eMailSignature;User Id=eMailSignature_Superuser;Password=changemenow;
Provider=sqloledb;Data Source=SERVERNAME;Initial Catalog=eMailSignature;Integrated Security=SSPI


Connect to Xink Cloud

Click the button "Connect to Xink Cloud" to connect the tool to Xink's API.  You need a Xink API user to connect.  Read the article on how to create an API user. The API user must have the "Employee control" permission set.

Enter the username and password for your API user and click "Test" to make sure that the API user login checks out ok. Click "Save" to keep your settings and dismiss the dialog.


Map fields from SQL to Xink

The final step is to tell Sql2Xink which fields from the SQL database goes where in Xink. Click "Map fields" to set the mapping.


Enter your SQL SELECT statement at the top and enter the email address of one of your existing Xink users. The email is necessary because the Xink API requires the email address of an existing user to work. 

Now click "Refresh fields".  Sql2Xink will now get the fields from your SQL statement, and it will contact the Xink API to retrieve all fields for your Xink account.  If the field names from your SQL statement match the Xink field names, the tool will automatically set up a mapping between the two.

Use the dropdowns to set where the SQL fields should go in Xink.

Click "Save" to save your mappings and dismiss the dialog.


Test the configuration

Now the time has come to test the export from your SQL database to Xink.  Start a cmd prompt and run Sql2Xink.exe from the cmd prompt. For a default installation, you will find Sql2Xink.exe in C:\Program Files (x86)\Xink Sql2Xink.  Check for any errors in the output.


Run Sql2Xink on a schedule

To always keep Xink updated from your SQL database, you should set up a scheduled task to run Sql2Xink.exe on a daily basis.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.