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 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

Hi Eduard

Many thanks for your help, much appreciated.

Kind regards

Andrew

0 0