Skip to main content
Skip table of contents

SaaS Applications

CData Virtuality works with a number of SaaS applicationscloud-based software tools that deliver services over the internet, such as customer relationship management or marketing automation platforms. These applications typically store data externally, and CData Virtuality enables seamless access and integration with that data for analysis and reporting. CData Virtuality supports OAuth 2.0 and token-based authentication, as well as data model abstraction for ease of querying.

Drivers

Cloud applications, like Salesforce, are not databases but APIs. CData’s JDBC and ODBC drivers wrap cloud APIs into a virtual SQL layer. For less common applications that do not have a CData driver, CData Virtuality uses REST connectors. For example, the Salesforce JDBC driver translates SQL into Salesforce SOQL queries.

Metadata Discovery and Data Type Conversion

For cloud and SaaS applications, CData Virtuality reads metadata from APIs to build tables, columns, and data types. It scans JSON, XML, and custom API formats and identifies rows based on patterns within the documents. If the SaaS application does not have formal metadata APIs, CData Virtuality can analyze JSON keys and build a table schema with column names, data types, and nested paths.

If the default data model does not meet requirements, you can customize CData Virtuality’s settings for modeling the data.

CData Virtuality can map SaaS API types to SQL types, such as string to VARCHAR, arrays to JSON text or separate child tables, and dates to TIMESTAMP.

Supported SaaS Applications

The supported SaaS applications are the following:

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.