Jedox Cloud supports cloud-based relational databases such as PostgreSQL and MySQL. You can purchase the cloud-based relational databases as a Jedox service. These types of relational databases are fully maintained and supported by Jedox. There are currently 3 types of cloud-based relational databases:
- Relational Datastore S (2 vCores / 100GB)
- Relational Datastore M (4 vCores / 100GB)
- Relational Datastore L (8 vCore /100GB)
A Cloud Operations Engineer can create, configure and deploy the databases. Once configured and ready to use, you receive all the connection parameters (credentials, hostname, port). Customers with multiple instances (e.g. production, development, and testing) require a datastore license for each instance.
These databases can connect with different tools, depending on their type, for example, pgAdmin for PostgreSQL, MySQL Workbench for MySQL. These tools allow you to check the access to the relational databases.
The relational databases can be used for ODBC Queries. To add an ODBC connection, go to Administration > Connections and select Add a new connection. The Add Connection tab is displayed, allowing you to select the connection type.
The relational databases can also be used for Integrator connections.
Note: cloud-based relational databases backups are locally redundant and the retention period is 7 days.
You can then upgrade your relational database storage with additional 100GB packages. For upgrades and cost details, contact your Jedox Account Owner or Sales Manager. The upgrade process starts as soon as there is an official order from Jedox Order Management and takes no longer than 30 minutes to implement.
Updated July 8, 2024