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?
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.
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
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.
Neo looks interesting
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.