Access Sage across servers

[alexis]

Hi

My client is wanting to include Sage 50 Accounts data (Invoices) into the QlikView application that I am developing for them - we are using the CData ODBC driver in our attempt to access Sage.

The QlikView application is running on a different server to where Sage is running - we installed the CData ODBC driver on the QlikView server and proceeded to create an ODBC connector using  Part of the installation involves defining a URL, username and password.

The CData ODBC Help file walks you through a process of getting the URL definition from within our Sage installation (In Sage, Internet/Options, SData settings etc). We did this and Sage gave us the URL:

http://ncc2:5493/sdata/accounts50/GCRM/{6ECD1D13-580A-......‌‌.}

This URL is not taking into consideration (I don't think) that this data source may be accessed from another server and wonder how we need to enhance this URL definition further to take this into account - we have opened port 5493. This is uncharted territory for me and so any help will be massively appreciated.