database movement

[Alchemist17]

I don't know if anyone could offer any advice. We have an instance of cache that runs our electronic prescribing system, we have no access to the back end of the system as this is prohibited by the vendors, however we are able to run reports based on the the SQL tables that have been set up by the vendor for that purpose. Formulating these reports into a web portal has provided numerous benefits to medical staff and we are even able to link biochemistry to prescribed medicines by combining the lab data and the SQL derived queries. However what we would like to be able to do within the portal is to provide intelligence to the medical staff around the medicines that they have prescribed and to do this I would like to link to a portion of the presribing system that is updated once a month by a third party supplier. However this information is not in one of the pre-built SQL tables. The once monthly update is in the form of a cache.dat file and I was wondering if it would be possible to host the cache.dat in a separate cache installation and extract the data I need in a more relational type format. I have tried to do this but hit errors (created a namespace and database and pointed at the cache.dat). I have never used cache before and so don't know if this is at all possible?  Could anyone help.

many thanks

[Edward Clark]

This mailing list is mostly for sharing information about using the MultiValue features of Caché. You might get more/better responses on the general Caché Community. There is a list of Intersystems's communities at http://www.intersystems.com/community.

 

Have you talked to your application vendor or the 3rd party provider of the updated cache.dat? Start there if you haven't.

 

In general, you can connect a cache.dat to a different cache instance. What kind if errors are you getting?

---

From: InterSy...@googlegroups.com [mailto:InterSy...@googlegroups.com] On Behalf Of Alchemist17
Sent: Monday, May 13, 2013 9:54 AM
To: InterSy...@googlegroups.com
Subject: [InterSystems-MV] database movement

I don't know if anyone could offer any advice. We have an instance of cache that runs our electronic prescribing system, we have no access to the back end of the system as this is prohibited by the vendors, however we are able to run reports based on the the SQL tables that have been set up by the vendor for that purpose. Formulating these reports into a web portal has provided numerous benefits to medical staff and we are even able to link biochemistry to prescribed medicines by combining the lab data and the SQL derived queries. However what we would like to be able to do within the portal is to provide intelligence to the medical staff around the medicines that they have prescribed and to do this I would like to link to a portion of the presribing system that is updated once a month by a third party supplier. However this information is not in one of the pre-built SQL tables. The once monthly update is in the form of a cache.dat file and I was wondering if it would be possible to host the cache.dat in a separate cache installation and extract the data I need in a more relational type format. I have tried to do this but hit errors (created a namespace and database and pointed at the cache.dat). I have never used cache before and so don't know if this is at all possible?  Could anyone help.

many thanks

--
You received this message because you are subscribed to the Google Groups "InterSystems: MV Community" group.
To post to this group, send email to Cac...@googlegroups.com
To unsubscribe from this group, send email to CacheMV-u...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/CacheMV?hl=en
---
You received this message because you are subscribed to the Google Groups "InterSystems: MV Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to InterSystems-...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.