CData Connect Cloud supports powerful features that advanced users and organizations rely on for their workflows. This page outlines some of these features.
CData Connect Cloud 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
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.
CData Connect Cloud 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 Cloud 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 Cloud login credentials.
CData Connect Cloud supports the following SSO providers:
- OpenID Connect
- Google Workspace
- Microsoft Azure AD
- Active Directory Federation Services (ADFS)
- Active Directory/LDAP
- Ping Federate
To enable SSO for your account, contact the CData sales team at email@example.com.
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 modal 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.
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.