We are proud to share our inclusion in the 2024 Gartner Magic Quadrant for Data Integration Tools. We believe this recognition reflects the differentiated business outcomes CData delivers to our customers.
Get the Report →Build AlloyDB-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for AlloyDB Data and create custom apps in Mendix.
Mendix is a high-productivity app platform that allows you to build and maintain both mobile and web applications at-scale. When paired with CData Connect Cloud, Mendix provides instant, cloud-to-cloud access to AlloyDB data for applications. This article demonstrates how to connect to a CData Connect Cloud data source from within Mendix.
CData Connect Cloud provides a pure cloud-to-cloud interface for AlloyDB, allowing you to import data from live AlloyDB data in Mendix — without replicating the data to a natively supported database. As you build web and mobile applications from within Mendix, CData Connect Cloud pushes all supported SQL operations (filters, JOINs, etc.) directly to AlloyDB, leveraging server-side processing to return the requested AlloyDB data quickly.
Configure AlloyDB Connectivity for Mendix
Connectivity to AlloyDB from Mendix is made possible through CData Connect Cloud. To work with AlloyDB data from Mendix, we start by creating and configuring a AlloyDB connection.
- Log into Connect Cloud, click Connections and click Add Connection
- Select "AlloyDB" from the Add Connection panel
-
Enter the necessary authentication properties to connect to AlloyDB.
The following connection properties are usually required in order to connect to AlloyDB.
- Server: The host name or IP of the server hosting the AlloyDB database.
- User: The user which will be used to authenticate with the AlloyDB server.
- Password: The password which will be used to authenticate with the AlloyDB server.
You can also optionally set the following:
- Database: The database to connect to when connecting to the AlloyDB Server. If this is not set, the user's default database will be used.
- Port: The port of the server hosting the AlloyDB database. This property is set to 5432 by default.
Authenticating with Standard Authentication
Standard authentication (using the user/password combination supplied earlier) is the default form of authentication.
No further action is required to leverage Standard Authentication to connect.
Authenticating with pg_hba.conf Auth Schemes
There are additional methods of authentication available which must be enabled in the pg_hba.conf file on the AlloyDB server.
Find instructions about authentication setup on the AlloyDB Server here.
Authenticating with MD5 Authentication
This authentication method must be enabled by setting the auth-method in the pg_hba.conf file to md5.
Authenticating with SASL Authentication
This authentication method must be enabled by setting the auth-method in the pg_hba.conf file to scram-sha-256.
Authenticating with Kerberos
The authentication with Kerberos is initiated by AlloyDB Server when the ∏ is trying to connect to it. You should set up Kerberos on the AlloyDB Server to activate this authentication method. Once you have Kerberos authentication set up on the AlloyDB Server, see the Kerberos section of the help documentation for details on how to authenticate with Kerberos.
- Click Create & Test
-
Navigate to the Permissions tab in the Add AlloyDB Connection page and update the User-based permissions.


Configure AlloyDB Endpoints for Mendix
After connecting to AlloyDB, create a workspace and virtual dataset for your desired table(s).
- Navigate to the Virtual Datasets page and click Add to create a new Workspace (or select an existing workspace).
- Click Add to add new assets to the Workspace.
- Select the AlloyDB connection (e.g. AlloyDB1) and click Next.
- Select the table(s) you wish to work with and click Confirm.
- Make note of the OData Service URL for your workspace, e.g. https://cloud.cdata.com/api/odata/{workspace_name}
With the connection and Workspace configured, you are ready to connect to AlloyDB data from Mendix.
Build a AlloyDB-Connected App
With the Workspace added to Connect Cloud, you can build an app in Mendix with live access to AlloyDB data.
Downloading the OData Metadata File
When creating a connection in Mendix, the connection flow requires a Data Source Contract File. Follow these steps to download the OData metadata file for CData Connect Cloud using curl, a command line tool:
- Open a command-line window for your operating system. On Windows, open the start menu, type cmd, and press the Enter key to open a command prompt. On macOS and Linux, open a Terminal window.
- To check if curl is installed on your system, type curl -help and press the enter key. If it is not installed, install it from the curl website.
-
Issue the following curl command, replacing USER with your CData Connect Cloud
username and PAT with the PAT you generated above:
curl -u USER:PAT https://cloud.cdata.com/api/odata/{workspace_name}/$metadata -o metadata.xml
- Locate the metadata.xml file that the curl command created and move it to an accessible location.
Connecting to CData Connect Cloud in Mendix
Follow these steps to establish a connection from Mendix to CData Connect Cloud:
- Login to Mendix and open the Data Hub page.
- In the Register a Data Source section, select OData.
- Upload the metadata.xml file from the steps above and click Next.
- Enter your desired values for Data Source Name and Data Source Version. In the Data Source Relative Path field, enter /api/odata/{workspace_name} and click Next.
- On the Application information page, click Register a new application.
- Enter a name in Application Name and select a technical owner (by default, this is the user who is currently logged in).
- Click Next. In the Environment Name field, enter a desired name (for example, CData Connect Cloud). In the Environment Location field, enter https://cloud.cdata.com and select the appropriate Environment Type (e.g. Production), depending on what is needed.
- Click Done! to create your connection.








You can now use your connection in Mendix Studio Pro to easily create applications with access to live AlloyDB data.
Get CData Connect Cloud
To get live data access to 100+ SaaS, Big Data, and NoSQL sources directly from your cloud applications, try CData Connect Cloud today!