CA Plex Database Options

[Legacy User]

G'day All,

 

I'm looking at what the various options are for database generation with CA Plex.

 

The marketing material suggests that IBM i DB2, MS SQL and Oracle are the only database options.

 

Can I use any JDBC compliant database for Java based applications? For instance is Apache Cassandra supported - which is a free and open source database?

 

Regards,

 

Darryl

[Anon Anon]

Hi Darryl -

 

You should be able to run any JDBC compliant database with Plex Java. In order to generate/build the the tables/views/indexes you will need an ODBC driver for the DB. As of my knowledge there are ODBC drivers for Cassandra, but I am not sure if they are free.

 

Best regards

Lorenz

[Niels Sorensen]

Hi Darryl,

 

We have successfully used the following databases with JDBC connections:

- IBM DB2 (IBM i/Windows)

- PostgreSQL (Linux/Windows)

- MySQL (Linux/Windows)

- MariaDB (Windows)

- MS SQL

- HSQLDB

 

Did some work in order to migrate tables/views to the different databases but not a big task!

 

So I see no reason that the JDBC driver for Cassandra should not work with Plex. Personally my next en devour will be Neo4J.

 

-Niels P.

Websydian

[Legacy User]

Neo looks interesting

[Legacy User]

Hi Darryl

let me add DB2 UDB on Linux (Ubuntu & Red Hat) with Java variant at least until Plex 6.1, MS SQL Server with JEE (server layer for Webclient apps) with Plex 6.1. Old times (Plex 3 to 5), Sybase with ODBC variants, and sometime, long ago, writing to a flat text file by using MS ODBC text driver.

Jorge Ubeda