Setting Up a SQL Linked Server

Overview

Here are the instructions for setting up a Linked Server from Microsoft SQL Server to our QQube SQLAnywhere Database.

You will have access to the following views prefixed by QQubeFinancials. and QQubeUser:

• vf_   - FACT tables
• vd_  - DIMENSIONS (e.g. lists)
• vdf_ - Transaction Dimensions e.g. Geography, Document Attributes, Line Attributes
• vl_   - LOOKUPS   These are designed only for looking up a list of values.  These are used in our Company Setup data models.

Setting the Server Provider

You should see the SQL Anywhere OLE DB Provider in the list of SQL Server Providers:

If you do NOT, then please do the following:

1. Open up a DOS Window (Run as Administrator)
2. Navigate to the proper directory: C:\Program Files (x86)\CLEARIFY\QQube Tool\SQL Anywhere 17\BIN64
3. Run regsvr32 on:
   1. dboledb17.dll
   2. dboledba17.dll

Right click on the SAOLEDB.17 Provider to bring up the following screen and check Allow inprocess:

Click OK when done.

Create the Linked Server

Right click on the Linked Servers folder and click New Linked Server:

For the General portion of the setup:

• Linked server - QQUBE
• Provider - SQL Anywhere OLE DB Provider 17
• Product name - SQL Anywhere
• Data source - QQubeFinancials (cannot change this name)

Next click on the Security option:

Click OK when done.

Your new linked server will have a tree similar to the following.  Go to the Views and expand as you will not have permission for any of the tables (and some views) as explained in the top of this guide.