Infrastructure at your Service

All Posts By

Cesare Cervini

Cesare Cervini

Installing the cdata ODBC drivers for Excel

By | Database Administration & Monitoring | No Comments

This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, HSQLDB, MongoDB, and MariaDB. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). Like MongoDB, Excel is not a relational data source, but the ODBC API will allow…

Read More
Cesare Cervini

Installing the ODBC drivers for MongoDB

By | Database Administration & Monitoring, Development & Performance | No Comments

This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, HSQLDB, Excel, and MariaDB. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). MongoDB is a noSQL database but the ODBC API will hide this fact and allow…

Read More
Cesare Cervini

Installing the ODBC drivers for Microsoft SQLServer for Linux

By | Database Administration & Monitoring, Development & Performance | No Comments

This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, HSQLDB, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). As root, follow the documentation here to get and install sqlserver express for Linux. Here are the…

Read More
Cesare Cervini

Installing the ODBC drivers for HSQLDB

By | Database Administration & Monitoring | No Comments

This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). As user debian, follow the documentation here and here to get and install hsqldb for…

Read More
Cesare Cervini

Installing the ODBC drivers for Oracle RDBMS

By | Application integration & Middleware, Database Administration & Monitoring | No Comments

This article is part of a series that includes SQLite, Postgresql, Firebird, MongoDB, Microsoft SQL Server, HSQLDB, Excel, and MariaDB. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). As we already have a running Oracle remote instance, we don’t need to set one up…

Read More
Cesare Cervini

Installing the ODBC drivers for MariaDB

By | Database Administration & Monitoring, Development & Performance | No Comments

This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, HSQLDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). The MariaDB ODBC drivers can be installed from the platform’s default package repositories. As it…

Read More
Cesare Cervini

Installing the ODBC drivers for Firebird

By | Database Administration & Monitoring, Development & Performance | No Comments

This article is part of a series that includes SQLite, Postgresql, Microsoft SQLServer, Oracle RDBMS, HSQLDB, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). As root, install the Firebird RDBMS and its ODBC drivers from the official repositories: # apt…

Read More
Cesare Cervini

Installing the ODBC drivers for PostgreSQL

By | Database Administration & Monitoring, Development & Performance | No Comments

This article is part of a series that includes SQLite, MariaDB, Firebird, Oracle RDBMS, Microsoft SQL Server, HSQLDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). The postgresql drivers can be installed from the platform’s default package repositories using the following…

Read More
Cesare Cervini

Installing the ODBC Driver Manager with SQLite on Linux

By | Database Administration & Monitoring, Development & Performance | No Comments

This article is part of a series that includes Firebird, Postgresql, Microsoft SQLServer, Oracle RDBMS, HSQLDB, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Excepting the present part which deals with the ODBC Driver manager’s installation which is a prerequisite, each part can be used independently from the others. The test system is a debian v11 (bullseye). Installation…

Read More
Cesare Cervini

Connecting to Repositories with the Same Name and/or ID

By | Enterprise content management | No Comments

A rare but recurrent issue that customers sometimes encounter is to how to connect to each one of distinct repositories with the same name or same docbase id, or even both if one repository is a clone of the other one. The present connection resolution technique based on the dfc.properties file does not support this and only lets one connect to the first matching repository found. Well knowing this limitation, why were they created with…

Read More