Mendix
Mendix
This page outlines the steps to connect Mendix to your CData Connect Cloud account.
Prerequisites
Before you connect, you must first do the following:
- Connect a data source to your CData Connect Cloud account. See Connections for more information.
- Configure your OData tables and columns from your data sources.
- Generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.
- Download the OData metadata file according to the steps below.
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/service/$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/service 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 Non-Production for the environment type.
-
Click Done! to create your connection.
You can now use your connection in Mendix Studio Pro.