Skip to main content

Powered by CData - Embedded Connectivity for Connect Cloud

  • 2 August 2024
  • 0 replies
  • 25 views

Powered by CData is a way for customers to integrate CData Connect Cloud live data access capabilities for their end users within their own applications.

Contact CData sales if you are interested in a Powered by CData account.

What is it?

Powered by CData is our OEM White label offering for Connect Cloud. It is an embedded solution for customer products and applications to enable their own users to create live data connections right inside their product. Behind the scenes, CData is building and running those data connections.​

Who is it for?

Powered by CData is for customers that are running and building their own products that need customer data onboarded or have to provide other embedded connectivity capabilities. Instead of building those features out themselves, customers can instead leverage CData's robust and wide selection of drivers and enable users to create those connections and add their credentials themselves.​

Why embedded connectivity?

A growing number of products require users to connect data to their systems. Instead of facilitating this connection, which can change depending on the system, embedded connectivity enables users to self-serve this connection and protect their data. Building this functionality in-house is expensive, time-consuming, and introduces scope creep from company's core engineering strengths.​

How is it installed and setup?

Powered by CData consists of two levels of accounts:

  • Parent Account—CData sales creates the parent account. The parent account is responsible for managing the child accounts and can create, view, and edit child accounts through the Powered by CData API. The parent account can monitor and troubleshoot child accounts.
     
  • Child Account—In the child account, each end user will have his/her own account. The end users can create, edit, and delete data sources. They can connect to data sources and query data.
     

The Powered by CData Accounts tab contains the child account names and Ids for reference.

AD_4nXcpYTRDSiuRTkVeZMnWZPCmRMbmsk-a8H3FDkPN8oKn2ADDMXbeJ1c0b5VPJEMgwiSikzR0_8DSflUPIJB-sfcAIv7zoy7YTZFix57bnj0w7UMvVP78BOEjceFepD5gt_1iG5Mp1OKNLTAnKSYg5ZFaVnhD?key=RLteAIB1n2n_3jA_yEnbjg

Click a child account to view the child account’s connections.

The Powered by CData Users tab displays the authorized users of the parent Powered by CData account.

AD_4nXe3j7HnaSSuSHi2UJL-b2utX12YaiKseQecq9DV-oByqbudaNV3yc6nNvllf5a8cUTjZNZ6-pIolJ5xe7GiT6SY7ZYJCbvTMO5JlwVJLnU9FjU19egT9N0fo7A137v4Pi5MEs0j_PiDhrtnBxEg1sECe4HY?key=RLteAIB1n2n_3jA_yEnbjg

Powered by CData Quickstart

The following is an overview of setting up Powered by CData. There are four main steps (links below navigate to the CData Connect Cloud Help documentation).

  1. Create a parent account.
  2. The administrator of the parent account creates a child account using the Powered by CData API.
  3. The end users of the child account configure connections that interact with Powered by CData and CData Connect Cloud.
  4. Query the connected data.

Creating a Parent Account

  1. The administrator of the Powered by CData parent account creates a JSON Web Token (JWT), which consists of a private key and a corresponding public key. The private key must be stored according to the security requirements of the product integrated with Powered by CData.
  2. The administrator provides the public key certificate in Privacy-Enhanced Mail (PEM) format to register in the management account. They can register the public key by opening a support ticket with CData Connect Cloud.

Creating a Child Account

Use Create Account in the Powered by CData API to create a child account. You must supply the JWT that you created in Create a Parent Account.

Configuring a Connection

An end user of the child account clicks Add Connection on your web page. On the backend, your web site calls the Create Connnection API, which generates a redirect URL to the Powered by CData web page. The end user can then configure a connection of a certain type, such as a Salesforce connection, and save and test the connection. When the end user is finished, he/she is then redirected back to your web page containing a list of connections. See Connection Flow for more details.

Querying the Data

Use one of the following CData Connect Cloud drivers to query the data:

In addition, CData Connect Cloud provides a full-featured REST API. You can query data directly with any REST-compatible application or client tool capable of creating HTTP requests.

Ready to get started? Take a tour or sign up for a free trial of Connect Cloud today!

Be the first to reply!

Reply