Thanks @nogievetsky for providing this useful link.
Please note that in order for Xcalar to work with MS SQL Server, you will need to execute the following steps.
Step 1: Confirm Connection String Params
Talk to your DBA about the following connection string parameters.
- DB Name
- Password/Password Service
We recommend you use a password service, but if you do not have access to a password service, you can also use a password directly.
Step 2: Install Driver
Make sure MS SQL Server ODBC drivers are installed on each node of your Xcalar cluster. You typically need root permission to do this. An example Microsoft page (as of now) that gives more information about this is here:
Please check with your network software distribution admin on the guidelines for updating database vendor drivers including if there are any internal repositories from where these drivers are available to download.
Step 3: Confirm Installation
Once you have installed the drivers, you should have an entry in your:
file that looks like this:
[ODBC Driver 17 for SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Make sure the path to the Driver file is correct.
Step 4: Create Data Target
You are now ready to create the Data Target using the Database Connector Target in Xcalar Design.
In case you do not use the password service, the password argument field (psw_arguments) must be "plaintext" and the password provider field (psw_provider) must be the actual password, which is not displayed in clear text.
The auth_mode should be "none".
Step 5: Test Connectivity
Using Xcalar Design, you can select the Data Source Location and specify the MS SQL Server data target you created, and press Next. You will then be able to enter a test query. Let's say you wanted to show all the tables. You can run the following query to view the tables:
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'
This should return you a list of the tables in the database you are connected to, or you may see an error, where you can proceed to diagnose the error.