CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Connect AI Python SDK for Power BI XMLA
Install the CData Connect AI Python SDK to read live Power BI XMLA data with standard DB-API 2.0 Python code.
-
Connecting Mastra with Figshare Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Figshare data, no replication required.
-
FTP Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on FTP facts in real time.
-
Publish Reports with Landbot Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Landbot data.
-
Certinia Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Certinia data through CData Connect AI using different applications and tools.
-
Build Visualizations of Facebook Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Facebook data in Birst.
-
Search External ConstantContact Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ConstantContact data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ConstantContact Data objects that you can access from apps and the dashboard.
-
Query Live LinkedIn Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live LinkedIn data through a conversational interface.
-
Extract, Transform, and Load Printify Data in Informatica PowerCenter
Create a simple Workflow for Printify data in Informatica PowerCenter.
-
Connect to GraphQL Data from Crystal Reports
Use CData Connect AI to connect to and report on live GraphQL data from Crystal Reports.
-
Build Bright Data Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Bright Data data and build visualizations in Tableau Cloud.
-
Use CData Connect AI to Access Yelp Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Yelp data in the Power Pivot business intelligence tool.
-
Getting Started with the CData Python Connector for Jira Assets
Learn to install and license the CData Python Connector and configure a connection to live Jira Assets data.
-
Bridge Sendwithus Connectivity with Apache NiFi
Access and process Sendwithus data in Apache NiFi using the CData JDBC Driver.
-
Create Twitter Ads Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Twitter Ads data access from reports, embedded analytics, and more.
-
How to connect Amazon QuickSight to Marketo Data
Create a connection to Marketo data in CData Connect AI and insert Marketo data into Amazon QuickSight SPICE to build interactive dashboards.
-
Analyze Dynamics 365 Business Central Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Dynamics 365 Business Central data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Load OpenWeatherMap Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load OpenWeatherMap data to a database.
-
Connect to SAP HANA Data in Ruby
Connect to SAP HANA data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Splunk-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Splunk data and build web apps with connectivity to live Splunk data.
-
Create Dashboards and Visualize Live Oracle Eloqua Data in Geckoboard
Use CData Connect AI to connect to live Oracle Eloqua data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Access Moosend Data Using Entity Framework
This article shows how to access Moosend data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
A PostgreSQL Interface for SAP Netweaver Gateway Data using the CData ODBC Driver
Use the SQL Gateway and SAP Netweaver Gateway ODBC Driver to create a PostgreSQL entry-point for data access.
-
Stream Basecamp Data into Apache Kafka Topics
Access and stream Basecamp data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous PayPal Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable PayPal replication to delimited files (CSV/TSV).
-
Provide OData Services of Splunk Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Splunk data by developing a WCF Service Application.
-
Establish a Live Connection with Aweber Data using Tableau Bridge
The CData ODBC Driver for Aweber enables you to integrate live Aweber data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Theia IDE with Live AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live AlloyDB data from within the development environment.
-
Add Tavily Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Tavily with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create CouchDB-Connected Dashboards in Grafana
Connect to CouchDB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to CouchDB data.
-
Build Voice Agents in ElevenLabs with access to Live MySQL Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live MySQL data.
-
Automated Continuous Shippo Replication to Oracle
Use CData Sync for automated, continuous, customizable Shippo replication to Oracle.
-
Integrating OpenCode with Workday data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
DataBind Controls to Google Search Results in Delphi
DataBind to Google Search results in Delphi with standard data access components and controls.
-
Create Freshdesk-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Freshdesk Data from Klipfolio and build custom visualizations using live Freshdesk data.
-
How to Work with REST Data in ETL Validator JDBC
Connect to REST from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Devin with Live ClickUp Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live ClickUp data.
-
Model Sugar CRM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Sugar CRM, enabling the direct import of real-time Sugar CRM data.
-
Prepare, Blend, and Analyze AfterShip Data in Alteryx Designer (ODBC)
Build workflows to access live AfterShip data for self-service data analytics.
-
Use the CData Software ODBC Driver for Couchbase in MicroStrategy Desktop
Connect to Couchbase data in MicroStrategy Desktop using the CData Software ODBC Driver for Couchbase.
-
Automated Continuous Cloudflare Replication to Databricks
Use CData Sync for automated, continuous, customizable Cloudflare replication to Databricks.
-
Integrate Elasticsearch Data in the Pentaho Report Designer
Publish reports based on Elasticsearch data in the Pentaho BI tool.
-
Connect to SAP Business One Data from PowerBuilder via JDBC
This article demonstrates how to access SAP Business One data from PowerBuilder using the SAP Business One JDBC Driver.
-
Connect to Dynamics 365 Data in ACL Analytics
Connect to Dynamics 365 data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Dynamics 365 data.
-
Create Apps from Aweber Data in Qlik Sense Cloud
Use CData Connect AI to connect to Aweber Data and build apps from live Aweber data in Qlik Sense Cloud.
-
Use the CData Software ODBC Driver for SAP Business One in MicroStrategy Desktop
Connect to SAP Business One data in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Business One.
-
Integrate Cohere Data in Pentaho Data Integration
Build ETL pipelines based on Cohere data in the Pentaho Data Integration tool.
-
Build Azure Data Lake Storage-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Azure Data Lake Storage Data and create custom apps in Bubble.
-
Integrate Adobe Experience Manager with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Adobe Experience Manager with External Services.
-
Build Data Flows from SQL Server to Dropbox through SSIS
Easily push SQL Server data to Dropbox using the CData SSIS Tasks for Dropbox.
-
Build Adobe Experience Manager-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Adobe Experience Manager Data and create custom apps in Mendix.
-
Getting Started with the CData Tableau Connector for Egnyte
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
DataBind Controls to QuickBooks Time Data in Delphi
DataBind to QuickBooks Time data in Delphi with standard data access components and controls.
-
How to Create Power BI Visual Reports with Real-Time Adobe Experience Manager Data
Use CData Power BI Connectors to visualize Adobe Experience Manager data in Power BI.
-
SAP HANA XS Advanced Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP HANA XS Advanced facts in real time.
-
Analyze Freshservice Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Freshservice data and visualize live Freshservice data in Infragistics Reveal.
-
Use the CData Software ODBC Driver for NASA in SAS for Real-Time Reporting and Analytics
Connect to real-time NASA data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for NASA.
-
Integrate Google Drive Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Drive data from Informatica Cloud.
-
How to create Hacker News federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Hacker News data in MySQL .
-
Connect to Oracle SCM Data from Crystal Reports
Use CData Connect AI to connect to and report on live Oracle SCM data from Crystal Reports.
-
Connect to Microsoft Entra ID from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Entra ID data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
DataBind Charts to Apollo Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apollo data 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.
-
Automated Continuous IBM Informix Replication to Vertica
Use CData Sync for automated, continuous, customizable IBM Informix replication to Vertica.
-
Query, Visualize, and Share live eBay Data in Redash
Use CData Connect AI to connect to live eBay data in Redash for querying, visualizing, and sharing.
-
Choosing the Best Method to Connect Shortcut to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Shortcut data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Google's Vertex AI Agent with Live Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Zoho Books data within intelligent workflows.
-
Connect to Live Excel Online Data in MicroStrategy through CData Connect AI
Create a live connection to Excel Online Data in CData Connect AI and connect to your Excel Online data from MicroStrategy.
-
Getting Started with the CData JDBC Driver for Dynamics 365
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dynamics 365.
-
Validate Eventbrite Data with QuerySurge
Access and validate Eventbrite data in QuerySurge using the CData JDBC Driver.
-
Use Grok to Talk to Your Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Google Directory data for you.
-
Visualize CouchDB Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to CouchDB data.
-
Access Live JSON Services in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate JSON services into the statistical analysis tools available in SAS JMP. This article shows how to use JSON services in the Graph Builder and Query Builder.
-
Automated Continuous CSV Replication to SQLite
Use CData Sync for automated, continuous, customizable CSV replication to SQLite.
-
Create QuickBooks Online-Connected Business Apps in AppSheet
Connect to QuickBooks Online Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to QuickBooks Online data.
-
CockroachDB Reporting in OBIEE with the CockroachDB JDBC Driver
Deploy the CockroachDB JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Google Forms Data from MySQL in PHP
Connect to Google Forms through the standard MySQL libraries in PHP.
-
Access Smartsheet Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Smartsheet data from your Oracle system.
-
Connect to Real-Time Onfleet Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Onfleet data in Power Apps.
-
Migrating data from Perigon to Databricks using CData SSIS Components.
Easily push Perigon data to Databricks using the CData SSIS Tasks for Perigon and Databricks.
-
Connect to Xero Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Xero data from Filemaker Pro on Mac.
-
Automated Continuous NetSuite SuiteAnalytics Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to PostgreSQL.
-
Automated Continuous Perplexity Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Perplexity replication to IBM DB2.
-
Connect to Live Oracle Financials Cloud Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Oracle Financials Cloud in CData Connect AI and connect to your Oracle Financials Cloud data from PostgreSQL.
-
How to integrate Harvest with Apache Airflow
Access and process Harvest data in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData SSIS Components for Airtable
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Airtable.
-
Configure the CData JDBC Driver for Microsoft Dataverse in a Connection Pool in Tomcat
Connect to Microsoft Dataverse data from a connection pool in Tomcat.
-
Connect to Invoiced Data from PowerBuilder via JDBC
This article demonstrates how to access Invoiced data from PowerBuilder using the Invoiced JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for Parquet
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Parquet.
-
ETL GraphQL in Oracle Data Integrator
This article shows how to transfer GraphQL data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Exact Online Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Exact Online replication to AlloyDB.
-
Create Data Visualizations in Cognos BI with Cloudant Data
Access Cloudant data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query Neo4J Data in ColdFusion
Write standard ColdFusion data access code to connect to Neo4J data.
-
How to Connect to Live Sybase IQ Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Sybase IQ data securely in real time.
-
Design BIRT Reports on ServiceDesk Plus Data
Provide current ServiceDesk Plus data to your embedded analytics.
-
Using the CData Software ODBC Driver for Azure Data Catalog in PyCharm
Connect to Azure Data Catalog as an ODBC data source in PyCharm using the CData Software ODBC Driver for Azure Data Catalog.
-
Access SAS Data Sets Data from MySQL in PHP
Connect to SAS Data Sets through the standard MySQL libraries in PHP.
-
ETL Templated in Oracle Data Integrator
This article shows how to transfer Templated data into a data warehouse using Oracle Data Integrator.
-
Model ActiveCampaign Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ActiveCampaign, enabling the direct import of real-time ActiveCampaign data.
-
Prepare, Blend, and Analyze ZohoSubscriptions Data in Alteryx Designer (Connect AI)
Build workflows to access live ZohoSubscriptions data for self-service data analytics.
-
How to Connect to Live Sage Cloud Accounting Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Sage Cloud Accounting data for you.