This article explains using the Sql2Xink tool to pull employee data from a SQL database into your Xink account. This is especially useful if your Active Directory isn't updated and your HR data is managed in platforms like Workday or Dynamics 365.
Sql2Xink automates this data pull when scheduled as a task or executed via Command Prompt.
Install Sql2Xink
Download the installer and run Sql2XinkSetup.msi to install.
Launch "Configure Xink Sql2Xink" from the Start menu to open the tool.
Connect to Your SQL Database
Click Connect to the database. Enter your connection string and click Test to verify it.
Example Connection Strings
SQL On-Premises:
Provider=sqloledb;Data Source=SERVERNAME;Initial Catalog=eMailSignature;User Id=eMailSignature_Superuser;Password=changemenow;SQL Azure:
Provider=SQLOLEDB;Data Source=sqlserver.database.windows.net;Initial Catalog=eMailSignature;Authentication=ActiveDirectoryPassword;User ID=eMailSignature_Superuser;Password=changemenow;Use Encryption for Data=true;
Connect to Xink Cloud
Click Connect to Xink Cloud and log in with your Xink API user. Learn how to create an API user.
Map Fields from SQL to Xink
Click Map fields to align SQL fields with Xink fields. Enter your SQL SELECT statement and click Refresh fields. If field names match, the tool will auto-map them.
Test the Configuration
Open Command Prompt and run:
Sql2Xink.exe updateDefault install path:
C:\Program Files (x86)\Xink Sql2XinkSchedule the Sync
Use Windows Task Scheduler to run:
Sql2Xink.exe updateRemove Departed Employees
To remove users from Xink who no longer exist in SQL:
Sql2Xink.exe update --removeSql2Xink.exe update -rHelp command:
Sql2Xink.exe help updatePreserve Manual Edits
Sql2Xink respects manual edits when "Do not update fields that were set or changed manually" is enabled in Xink. Learn more: Preserve Manual Edits Feature.
