CardExchange Solutions Documentation
Producer Help - Using Databases
- Craig Bechelli (Deactivated)
- Paul Metcalf (Deactivated)
Starting at the Premium edition, CardExchange® Producer offers database connections. Database connections and the stability of these connections has always been one the key factors for developing connections.
Besides the variety of offered connections, all the major database connections are created based on direct (native) connections. Therefore for all the major database systems, we have their native connectors embedded. That will ensure 100% stable and secure connections.
CardExchange® Producer does not only offer these type of connections, it also offers multiple database connections with true Push-Pull technology. Sometimes there is some confusion about the push and pull, but CardExchange® Producer does not use internal database structures to transport data from one database to the other database. That ensures that with CardExchange® Producer you never have to worry about the privacy of the information because it this information stays were it should be... in your database!
The different type of database connections offered are available per edition as shown below:
| Edition | Supported Database Connections |
|---|---|
GO | Internal MS Access Database |
| Premium | MS Excel (all formats), CSV, and TXT files, MS Access (all formats), Paradox |
| Professional | MS Excel (all formats), CSV, and TXT files, MS Access (all formats), Paradox, MS SQL, MySQL, Oracle, DB2, PostgreSQL, Ingris, SQLite, ODBC, Multiple Databases |
| Business | MS Excel (all formats), CSV, and TXT files, MS Access (all formats), Paradox, MS SQL, MySQL, Oracle, DB2, PostgreSQL, Ingris, SQLite, ODBC, Multiple Databases |
With CardExchange® Producer your data is secured processed with 128 bit encrypted connections.