CData Software - Knowledge Base
Recent Articles
-
Build Airtable Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Airtable and build visualizations in Tableau.
-
Model GitHub Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and GitHub, enabling the direct import of real-time GitHub.
-
Integrate Real-Time Access to MongoDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to MongoDB in real time.
-
Use the CData API Server to Access TaxJar in Microsoft PowerPivot
Use the CData API Server to connect to live TaxJar in the Power Pivot business intelligence tool.
-
Manage Amazon Marketplace in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Amazon Marketplace.
-
How to Query Live Redshift in Perplexity MacOS Desktop
Connect to and query live Redshift in Perplexity Desktop using the CData MCP Server.
-
Access Live SAP HANA Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SAP HANA data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Wave Financial in Google Apps Script via SQL Gateway
Use the ODBC Driver for Wave Financial and the SQL Gateway to access Wave Financial from Google Apps Script.
-
Automated Continuous BigCommerce Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable BigCommerce replication to Amazon Redshift.
-
Visualize Live SharePoint in the Power BI Service
Use CData Connect AI to connect to live Microsoft SharePoint and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Instagram from PowerBuilder via JDBC
This article demonstrates how to access Instagram from PowerBuilder using the Instagram JDBC Driver.
-
Integrate with Act CRM in JReport Designer
Create charts and reports based on Act CRM in JReport Designer.
-
How to use SQLAlchemy ORM to access Google Directory in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Directory.
-
How to Connect to Live Microsoft Exchange from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Microsoft Exchange for you.
-
Connect to eBay Analytics in SpagoBI
Create reports featuring live eBay Analytics in SpagoBI Studio. Host eBay Analytics reports on SpagoBI Server.
-
Build an OLAP Cube in SSAS from SAS Data Sets
Establish a connection to SAS Data Sets data from SQL Server Analysis Services, and use the SAS Data Sets Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query Outreach.io in DataGrip
Create a Data Source for Outreach.io in DataGrip and use SQL to query live Outreach.io.
-
Analyze SQL Server in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft SQL Server and visualize Microsoft SQL Server in SAP Analytics Cloud.
-
Extract, Transform, and Load Square in Informatica PowerCenter
Create a simple Workflow for Square in Informatica PowerCenter.
-
Work with Live MailChimp in Power Query
Use CData Connect AI to connect to MailChimp and work with live MailChimp in Microsoft Power Query.
-
How to integrate Okta with Apache Airflow
Access and process Okta in Apache Airflow using the CData JDBC Driver.
-
Connect to Klaviyo from a Connection Pool in JBoss
Integrate Klaviyo into Java servlets: Use the Management Console in JBoss to install the Klaviyo JDBC Driver.
-
Bidirectional Access to Harvest from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Harvest in Filemaker Pro for Mac or Windows.
-
Use the CData Software ODBC Driver for Procore in SAS for Real-Time Reporting and Analytics
Connect to real-time Procore in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Procore.
-
How to Connect the Power BI Service to Redis: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Access Salesloft as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Salesloft from your Oracle system.
-
Automated Continuous Freshdesk Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Freshdesk replication to Amazon Redshift.
-
Query Authorize.Net from Node.js
Use the OData endpoint of the CData API Server to connect to your Authorize.Net and perform CRUD operations on Authorize.Net from Node.js.
-
Connect to Pinterest in Jaspersoft Studio
Execute SQL to remote Pinterest in Jaspersoft Studio.
-
Operational Reporting on Azure Table from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Azure Table Storage.
-
Prepare, Blend, and Analyze Facebook Ads in Alteryx Designer (Connect AI)
Build workflows to access live Facebook Ads for self-service data analytics.
-
Create Paylocity-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Paylocity from OutSystems and build custom enterprise apps using live Paylocity.
-
Access Live Oracle Sales Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Sales data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Query Google Data Catalog from Node.js
Use the OData endpoint of the CData API Server to connect to your Google Data Catalog and perform CRUD operations on Google Data Catalog from Node.js.
-
Validate Azure Analysis Services with QuerySurge
Access and validate Azure Analysis Services in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Azure Data Lake Storage Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Azure SQL Database.
-
Build Visualizations of PostgreSQL in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PostgreSQL in Birst.
-
DataBind Charts to Lakebase
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Lakebase from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Access Live Zoho Books in TIBCO Data Virtualization
-