SaaS Applications
CData Virtuality works with a number of SaaS applications—cloud-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:
Facebook Ads / Meta Marketing API
Xero / QuickBooks Online