CData Connect supports powerful features that advanced users and organizations rely on for their workflows. This page outlines some of these features.

Derived Views

CData Connect supports derived views, which are saved queries that dynamically populate data when you use them. After you create a derived view in Data Explorer, you can query it from your choice of Client as though it were any other connection. When querying a derived view, the syntax follows the format CData.DerivedViews.derivedViewName.

When a derived view is saved in an account, it appears in the derived views list for all users. However, users who issue queries to derived views must have appropriate permissions for each data source that the derived view queries. If a user lacks appropriate permissions, they will receive an error when issuing a query.

Example Derived View

If you wanted to create a derived view to return all of the accounts in your Salesforce connection that were marked as deleted, your derived view might contain the following query:

SELECT * FROM [Salesforce1].[Salesforce].[Accounts] WHERE Deleted = 'true'

If you saved this derived view as DeletedAccounts, you could issue the following query from a Client to return all of the deleted accounts:

SELECT * FROM [CData].[DerivedViews].[DeletedAccounts]

This derived view provides a convenient, consistent way to access an up-to-date list of deleted accounts without the need to re-enter the query parameters every time.

Query Federation

CData Connect enables you to write queries that combine data from different sources directly, on-demand.

In many ad hoc scenarios, it is impractical to build pipelines to consolidate data. With query federation, you can bypass the need for custom pipelines by creating queries across data sources from the reporting tool of your choice.

See SQL Federated Queries for more information.

Single Sign-On (SSO)

CData Connect supports Single Sign-On (SSO). When SSO is enabled for your account, users sign in through your chosen SSO provider instead of using CData Connect login credentials.

CData Connect supports the following SSO providers:

  • SAML
  • OpenID Connect
  • Google Workspace
  • Microsoft Azure AD
  • Active Directory Federation Services (ADFS)
  • Active Directory/LDAP
  • Ping Federate
  • Okta Workforce Identity Cloud

To enable SSO for your account, contact the CData sales team at sales@cdata.com.

User Credentials

By default, all users on an account can access data from a data source through the same login credentials. For example, if you have a connection to Salesforce, all user accounts can access the data from the Salesforce account created for that Salesforce connection. Query permissions can be customized per-user to restrict available operations, but all users access the same data under these restrictions.

Certain data sources support the ability to force each user on an account to log into a connection with their own login credentials. This feature ensures that users can only access the data from accounts that they need to access. Furthermore, when a connection is configured in this way, it only counts as a single connection slot toward your account maximum.

If a data source supports User Credentials, a Data Credentials label appears in the Authentication section of the connection settings. Clicking the setting next to this label opens a dialog that allows you to set the desired mode for the connection.

Note: The following restrictions apply to this feature:

  • This feature is only available for the following data sources. If this feature is desired for a data source that is not listed, please contact our support team to request it.

    • Salesforce
    • Snowflake
    • Workday
  • Only administrator users can toggle a data source between Shared Credentials and User Credentials, but users of all roles can log into a User Credentials connection with their own credentials.

  • User Credentials are not supported when using the OData API. To connect a data source to the OData API, you must use Shared Credentials.

Virtual Datasets

The virtual datasets feature at its core is an organization scheme that creates a data catalog from connected data sources in CData Connect. Virtual datasets make it possible to bundle related data items separately in a simple and scalable way, while reducing data silos and promoting synergy across teams.

These virtual datasets can include tables, views, and derived views. All of these are exposed directly without transformations, so the column names and other properties remain the same. Any table, view, or derived view can be added to any number of workspaces. They can be referenced by a unique alias. Tables that are virtual datasets support full CRUD capabilities.