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 →Integrate Cvent Data into Automated Tasks with Power Automate
Use CData Connect Server to create a virtual SQL Server database for Cvent data and integrate live Cvent data into your Power Automate (Microsoft Flow) tasks.
Power Automate (Microsoft Flow) is an online service that automates events (known as workflows) across the most common apps and services. When paired with CData Connect Server, you get instant, cloud-to-cloud access to Cvent data for visualizations, dashboards, and more. This article shows how to connect to Connect Server from Power Automate and integrate live Cvent data into your workflows and tasks.
CData Connect Server provides a pure SQL interface for Cvent, allowing you to easily integrate with live Cvent data in Power Automate — without replicating the data. CData Connect Server looks exactly like a SQL Server database to Power Automate and uses optimized data processing out of the box to push all supported SQL operations (filters, JOINs, etc) directly to Cvent, leveraging server-side processing to quickly return Cvent data.
Create a Virtual SQL Database for Cvent Data
CData Connect Server uses a straightforward, point-and-click interface to connect to data sources and generate APIs.
- Login to Connect Server and click Connections.
- Select "Cvent" from Available Data Sources.
-
Enter the necessary authentication properties to connect to Cvent.
Before you can authenticate to Cvent, you must create a workspace and an OAuth application.
Creating a Workspace
To create a workspace:
- Sign into Cvent and navigate to App Switcher (the blue button in the upper right corner of the page) >> Admin.
- In the Admin menu, navigate to Integrations >> REST API.
- A new tab launches for Developer Management. Click on Manage API Access in the new tab.
- Create a Workspace and name it. Select the scopes you would like your developers to have access to. Scopes control what data domains the developer can access.
- Choose All to allow developers to choose any scope, and any future scopes added to the REST API.
- Choose Custom to limit the scopes developers can choose for their OAuth apps to selected scopes. To access all tables exposed by the driver, you need to set the following scopes:
event/attendees:read event/attendees:write event/contacts:read event/contacts:write event/custom-fields:read event/custom-fields:write event/events:read event/events:write event/sessions:delete event/sessions:read event/sessions:write event/speakers:delete event/speakers:read event/speakers:write budget/budget-items:read budget/budget-items:write exhibitor/exhibitors:read exhibitor/exhibitors:write survey/surveys:read survey/surveys:write
Creating an OAuth Application
After you have set up a Workspace and invited them, developers can sign up and create a custom OAuth app. See the Creating a Custom OAuth Application section in the Help documentation for more information.
Connecting to Cvent
After creating an OAuth application, set the following connection properties to connect to Cvent:
- InitiateOAuth: GETANDREFRESH. Used to automatically get and refresh the OAuthAccessToken.
- OAuthClientId: The Client ID associated with the OAuth application. You can find this on the Applications page in the Cvent Developer Portal.
- OAuthClientSecret: The Client secret associated with the OAuth application. You can find this on the Applications page in the Cvent Developer Portal.
- Click Save Changes
- Click Privileges -> Add and add the new user (or an existing user) with the appropriate permissions.
Connecting to CData Connect Server
To use Connect Server to integrate Cvent data into your Power Automate tasks, you need a new SQL Server connection:
- Log in to Power Automate
- Click Data -> Connections -> New connection
- Select SQL Server
- In the connection wizard:
- Set Authentication Type to "SQL Server Authentication"
- Set SQL server name to the address of your Connect Server instance (connect_server_url)
- Set SQL database name to the name of the virtual Cvent database you created earlier (like cventdb)
- Set the Username and Password and click Create
Integrating Cvent Data into Power Automate Tasks
With the connection to Connect Server configured, you are ready to integrate live Cvent data into your Power Automate tasks.
- Log in to Power Automate
- Click My flows -> New and choose to create the flow from blank or template
- Add (or configure) a SQL Server action (like Get rows) and configure the action to connect to your Connect Server connection
- Select a Table to work with (from the drop-down menu) and configure any advanced options (like filters, orders, etc)
- Configure any actions to follow and test, then save the flow
SQL Access to Cvent Data from Applications
Now you have a direct connection to live Cvent data from Power Automate tasks. You can create more connections and workflows to drive business — all without replicating Cvent data.
To get SQL data access to 200+ SaaS, Big Data, and NoSQL sources directly from your applications, see the CData Connect Server.
Related Power Automate Articles
This article walks through using CData Connect Server with Power Automate (Online). Check out our other articles for more ways to work with Power Automate Desktop: