I am planning to implement Business Intelligence based on the data in my instances. What is the best way to set up my databases and environment to use DeepSee?
Last comment 11 April 2018
Databases
About this tag
InterSystems Caché database is a file where all the data, application scripts, and users, roles and security configurations are stored. Typically the name of the file is cache.dat
Subscribe to Databases content with RSS 
or email
or email The following post outlines an architectural design of intermediate complexity for DeepSee. As in the previous example, this implementation includes separate databases for storing the DeepSee cache, DeepSee implementation and settings. This post introduces two new databases: the first to store the globals needed for synchronization, the second to store fact tables and indices.
Last comment 11 April 2018
Databases, Namespace (Databases), Microsoft Windows Server (Databases), System Administration (Databases), Monitoring (Databases)
Hi
The message is received at all times.
cconsole.log
Last answer 3 April 2018 Last comment 3 April 2018
The following post is a guide to implement a basic architecture for DeepSee. This implementation includes a database for the DeepSee cache and a database for the DeepSee implementation and settings.
Is there something in Cache that is equivalent to partitioning a table in Oracle? I'm trying to break some big tables into groups so that the most frequently accessed data is faster to retrieve.
Last answer 28 April 2016 Last comment 23 March 2018
I am trying to read data from MySQL Server 2012 to a stream and I keep getting an error here is my code so far
ERROR
Last answer 16 March 2018 Last comment 19 March 2018
Is there a way to pull a user name and password from the Credentials list that is kept in Ensemble? Right now I have a LDAP user that I have hard coded into my ZAUTHENTICATE, which I would like to get away from.
Last answer 24 February 2018 Last comment 1 March 2018
We have noticed in the course of the last 18 days our CACHE.dat has grown by 20 GB. Is there a way we can break down the data in CACHE.dat to see what could be growing in size?
Last answer 30 January 2018
Hello,
I have a property which I need to move from one class definition to another as follows:
Old definition:
Last answer 29 January 2018 Last comment 30 January 2018
Some of our interfaces use globals for lookups, but we are currently looking at putting a groups of (document) interfaces in a separate production with a shared ‘Default Database for Routines’ to reduce code duplication.
Last answer 15 January 2018 Last comment 11 October 2017
Hello everyone,
i want an automatic unidirectional syncronization of multiple databases (some tables from .dat file, not the whole .dat file) .
Last answer 2 December 2017 Last comment 15 December 2017
Hi, community
i am defining a new role on my system , i want that this role has access only to my own data base , do you konw which roles can i add to this one ?
thank you
Last answer 11 December 2017 Last comment 12 December 2017
Hi community,
my database (HSAUDIT) is only on the read mode , how can i pass to the Read/Write mode?
thank's
Last answer 8 December 2017 Last comment 11 December 2017
I am trying to replace one of our SQL Integration Service jobs with Ensemble and I am running into an issue executing a query against a MS SQL database using JDBC drivers.
Last answer 5 November 2017 Last comment 3 November 2017
I have two databases, and both of them have a global ^Data with subscripts going from 1 to 10 000 000.
I want to get one database with global ^Data but with subscripts going from 1 to 20 000 000.
Since each db is around 100 Gb and they are on a different hosts, what's the best way to merge them?
Last answer 25 October 2017 Last comment 25 October 2017
It was my answer to the question appeared in GoogleGroups. And when I answered there I figured out that it might worth to post an article and to add some light on how Unicode is stored in Caché.
Last comment 17 October 2017
Recently, we scheduled two tasks (1008 and 1009) within Task Manager. Task ID 1008 is set to run after Purge Tasks (%SYS-ID:3), and Task 1009 is set to run at 7:00:00 each day.
Last answer 26 September 2017 Last comment 11 October 2017
Currently, we are utilizing batch jobs at the OS level to kick off routines that watch for files. We are trying to convert these processes to be performed by the Task Manager.
Last answer 21 September 2017 Last comment 21 September 2017
While creating namespaces, there is a provision for keeping the data, and code separately in database.
What I am looking for,
What are the benefit we can achieve by doing this?
Last answer 14 September 2017 Last comment 14 September 2017
In which global cache class codes are storing in cache DB?
For example, Routine codes are storing in ^ROUTINE global.
Last answer 10 September 2017 Last comment 14 September 2017
MonCaché — MongoDB API implementation based on InterSystems Caché
Last comment 13 September 2017
Hey, the question is simple!
Is possible one classe is not generated journal?
I would like a given class not to generate this data but on a configured basis to generate, is possible?
Last answer 31 August 2017 Last comment 31 August 2017
We are running Caché v2010.2 on OpenVMS and are receiving the message, 'Unable to start the database read test' in our CCONSOLE.LOG.
Last answer 5 July 2017 Last comment 28 August 2017
Does anyone know of a utility to compare two databases (i.e., CACHE.DAT files) and find globals/subscripts that are different between them?
Last answer 11 July 2017 Last comment 24 August 2017
Hi,
I use cache 5.0 and access cache through OpenVMS.
Last answer 8 August 2017 Last comment 11 August 2017
I'm trying to recreate a smaller copy of our DEV machine on a sandbox instance.
Last answer 14 July 2017
Greetings,
How do I organize a wildcard search with respect to a database search?
Example of what I am trying to do: s x=$o(^G("ABC","A*",x))
Last answer 13 July 2017