Infrastructure at your Service

Category Archives: Entreprise content management

Christophe Cosme

Pass Summit – dbi visit day 4 (2)

By | Business Intelligence, Entreprise content management | No Comments

Power BI 5 top custom visuals The development of Power BI itself is fast. But, the means to represent data is too. I mean there are constantly new Power BI custom visuals developed by the community and Microsoft. You can develop your own custom visuals and publish them on the marketplace for your organization or the whole community. Tips : check if the visuals are certified, meaning they have been tested on the different Power…

Read More
Cesare Cervini

A Graphical Overview of a Repository

By | Entreprise content management | No Comments

As the saying goes, “A Picture Is Worth A Thousands Words”. I’d add “And A Simple Graph Is Worth A Long, Abstruse List of Numbers”. And of words too, so let’s show off a little bit: Interested ? Then, please read on. It happens not so infrequently that we wish we could quickly plot a few numbers to have a look at their overall trend. The usual procedure is to output the numbers into a…

Read More
Cesare Cervini

A SQLite extension for gawk (part II)

By | Entreprise content management | No Comments

Welcome to part II of a three-part article on extending gawk with a SQLite binding. Part I is here. Part II is followed by Part III, which give some explanations for the code presented here and shows how to use the extension with a stress test. Here, I’ll list the source code of the extension and give instructions to compile and use it in gawk. Beware though that the code should be taken with several…

Read More
Cesare Cervini

An SQLite extension for gawk (part I)

By | Entreprise content management | No Comments

Quick: what is the most used database management system on our planet ? Oracle ? Wrong. SQL server ? Wrong again ! MySQL ? You’re almost there. It’s SQLite. Surprised ? I must confess that I was too. Actually, SQLite is special in that it is not the traditional 2-tiers client/server but one-tier and embedded, which means that it works as a library linked to an application. As such, it is used to fulfill the…

Read More
Cesare Cervini

Adding a timeout in monitoring probes

By | Entreprise content management | No Comments

A few months ago day, as I was writing the documentation for a monitoring probe, I suddenly realized that that probe, along with others I wrote during that time to monitor Documentum installations, had all a big, unexpected flaw. Indeed, it struck me that if it hang for some reason while running, it could stay there well after the next monitoring cycle had begun, which could too be affected by the same problem, and so…

Read More
Morgan Patou

Documentum – Checking warnings&errors from an xPlore full re-index

By | Application integration & Middleware, Entreprise content management | No Comments

When working with xPlore as a Full Text Server (indexing), there are a few ways to perform a full re-index. You can potentially do it from the IndexAgent UI, from the Dsearch UI, from the file system (with an ids.txt file for example, it is usually for a “small” number of r_object_id so that’s probably not an ideal way) or from the docbase (mass-queue, it’s not really a good way to do it either). Performing…

Read More
Cesare Cervini

Using a database trigger to request a rendition

By | Entreprise content management | No Comments

Some time ago, a colleague asked around if someone knew a way to automatically request a rendition right after a document was checked in. This looked like a trigger to me and TBOs are here for that, right ? Sure but there was an additional condition: it should be set up by an administrator from the idql command-line tool as no programming was possible at that time on that system. Given that this tool, along…

Read More
Morgan Patou

Documentum – Silent Install – xPlore IndexAgent

By | Application integration & Middleware, Entreprise content management | No Comments

In previous blogs, we installed in silent the Documentum binaries (CS), a docbroker (+licence(s) if needed), several repositories (here and here), D2 and finally the xPlore binaries & Dsearch. This blog will be the last one of this series related to silent installation on Documentum and it will be about how to install an xPlore IndexAgent on the existing docbase/repository created previously. So let’s start, as always, with the preparation of the properties file: [xplore@full_text_server_01…

Read More
Cesare Cervini

A SQLite extension for gawk (part III)

By | Entreprise content management | No Comments

Welcome to part III of a three-part article on extending gawk with a SQLite binding. Part I is here. Part II is here. In this final part, I’ll explain succinctly the code that was listed in part II. This part is best read while having Part II opened in another browser window. sqlite_gawk.c Line 48: All the operations on a database requires a handle that is initialized once the database is successfully opened. The handle…

Read More
Morgan Patou

Documentum – Silent Install – xPlore binaries & Dsearch

By | Application integration & Middleware, Entreprise content management | No Comments

In previous blogs, we installed in silent the Documentum binaries (CS), a docbroker (+licence(s) if needed), several repositories (here and here) and finally D2. I believe I only have 2 blogs left and they are both related to xPlore. In this one, we will see how to install the xPlore binaries as well as configure a first instance (Dsearch here) on it. Just like other Documentum components, you can find some silent installation files or…

Read More