Healthcare Cache ODBC Driver / Connector

Question

Question

Andrew Turner · Dec 27, 2019

Hello All

Could someone help me in the details of the ODBC connection I need to connect to the Healthshare Cache databases for the CMC application?

Much appreciated in advance

Andrew

Discussion (4)0

Log in or sign up to continue

Eduard Lebedyuk Dec 27, 2019 to Andrew Turner

To connect you'll need a create a new Cache connection (as the driver seems to be installed) and specify these params:

Host/Port (Copy from existing connection)
User/pass
Namespace - you need to choose a namespace with the data you need.

0 0

score 0 · Answer 1 · 2019-12-27T09:59:52-05:00

Eduard Lebedyuk · Dec 27, 2019

Can you explain the issue you're having?

0 0

score 0 · Answer 2 · 2019-12-27T10:11:40-05:00

Hi Eduard

I am trying to connect to our Healthshare cache database using Alteryx. SO I am not familiar with how to connect to to this at all. Do I need to download a specific ODBC driver, and do I need a specific username and password to attach to that driver? If I go into Alteryx and choose a 32-bit ODBC connector, I get a "Cache 2012 (System)" connector that has preconfigured properties and when testing that connection it works, but there is nothing available from that connection.

Any ideas? I could attach what the connection properties look like if that helps?

Kind regards

Andrew

score 0 · Answer 3 · 2019-12-30T03:39:34-05:00

Andrew Turner Dec 30, 2019 to Eduard Lebedyuk

Hi Eduard

Many thanks for your help, much appreciated.

Kind regards

Andrew

0 0