CData Software - Knowledge Base
Recent Articles
-
Use JayDeBeApi to access SAP SuccessFactors LMS Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP SuccessFactors LMS.
-
Analyze Notion Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Notion in Microsoft R Open.
-
Publish Okta-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Okta.
-
Build Agents in Relevance AI with Access to Live Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Oracle HCM Cloud within intelligent agent workflows.
-
Validate SuiteCRM Data with QuerySurge
Access and validate SuiteCRM in QuerySurge using the CData JDBC Driver.
-
Integrate AlloyDB Data into Power Automate Desktop using CData Connect
CData Connect for AlloyDB Data enables you to integrate Google AlloyDB into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Azure Data Catalog Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Google Cloud SQL.
-
Connect to Real-Time MailChimp Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for MailChimp and Dataflow to import and use MailChimp in Power Apps.
-
Build Voice Agents in ElevenLabs with access to Live SAP Ariba Source Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP Ariba Source.
-
Build Automated Couchbase-Connected Workflows in Zapier
Use CData Connect AI to connect to live Couchbase and build automated workflows in Zapier.
-
How to connect to ZeroBounce Data from Spring Boot
Connect to ZeroBounce in a Spring Boot Application using the CData API Driver for JDBC
-
How to Work with SuiteCRM Data in AWS Glue Jobs Using JDBC
Connect to SuiteCRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
A PostgreSQL Interface for DB2 Data (MySQL Remoting via JDBC)
Use the Remoting features of the DB2 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Tableau Connector for Acumatica
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Acumatica.
-
Integrating GitHub Copilot CLI with Adobe Experience Manager 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.
-
Connect to Zoho Recruit Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Zoho Recruit as an External Source in Dremio.
-
Visualize Live Jira Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Atlassian Jira.
-
Use JayDeBeApi to access Act-On Data in Python
Use standard Python scripting and the development environment of your choice to access live Act-On.
-
Create Apps from SQL Analysis Services Data in Qlik Sense Cloud
Use CData Connect AI to connect to SQL Analysis Services Data and build apps from live SQL Analysis Services in Qlik Sense Cloud.
-
Design BIRT Reports on Landbot Data
Provide current Landbot to your embedded analytics.
-
Connect to Certinia from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Certinia, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Epicor Kinetic Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Google Cloud SQL.
-
Import Real-Time Clari Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Clari in ColdFusion.
-
Connect to SendGrid Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SendGrid to connect to SendGrid and execute queries in PowerBuilder.
-
How to Access SAP HANA XS Advanced Data Using Entity Framework
This article shows how to access SAP HANA XS Advanced using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze Sendwithus Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sendwithus from Power Pivot. You will use the Table Import Wizard to load Sendwithus. You can visually build the import query or use any SQL supported by the driver.
-
Query SAP SuccessFactors LMS Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP SuccessFactors LMS entities in PHP by modeling them as objects.
-
Connect to Trello Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Trello Data and connect to Trello in Akorbi Digital RunMyProcess.
-
Create Power BI Reports on Real-Time Quickbase Data
Use the CData ODBC Driver for Quickbase to visualize Quickbase in Power BI Desktop.
-
Integrating Claude Code CLI with ChartMogul 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.
-
Integrate Live Todoist Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Todoist to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Extract, Transform, and Load LaunchDarkly Data in Informatica PowerCenter
Create a simple Workflow for LaunchDarkly in Informatica PowerCenter.
-
Use the CData Software ODBC Driver for Confluence in MicroStrategy
Connect to Atlassian Confluence in MicroStrategy Developer using the CData Software ODBC Driver for Confluence.
-
Build Apps with Live Coda Data Using the Low-Code Development Platform of Mendix
Connect Coda with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Oracle Financials Cloud Replication to Oracle
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Oracle.
-
Provide OData Services of Twitter Ads Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Twitter Ads by developing a WCF Service Application.
-
Access Live Microsoft Planner Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Planner from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Analyze Google Calendar Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Calendar and visualize live Google Calendar in Infragistics Reveal.
-
Integrate LinkedIn Ads Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live LinkedIn Ads from Informatica Cloud.
-
Integrate with Live Avalara AvaTax Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Avalara AvaTax from the MuleSoft Anypoint Platform to integrate live Avalara AvaTax into custom reports and dashboards.
-
Query Postmark Data in DataGrip
Create a Data Source for Postmark in DataGrip and use SQL to query live Postmark.
-
Build Dynamics CRM-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Dynamics CRM to explore live Dynamics CRM Data in Cursor to assist with building Dynamics CRM-powered applications.
-
Connect to Instantly Data from PowerBuilder via ADO.NET
This article demonstrates how to access Instantly from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Getting Started with the CData Connect AI Python SDK for Bullhorn CRM
Install the CData Connect AI Python SDK to read and write live Bullhorn CRM with standard DB-API 2.0 Python code.
-
Build CockroachDB-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for CockroachDB to explore live CockroachDB Data in Gemini Code Assist to assist with building CockroachDB-powered applications.
-
How to connect to Azure DevOps Data from IntelliJ
Integrate connectivity to Azure DevOps with wizards in IntelliJ.
-
Integrating Kiro CLI with RabbitMQ 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.
-
Integrating Antigravity CLI with SurveyMonkey via CData CLI
Connect SurveyMonkey to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access Google Cloud Storage Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Cloud Storage from your Oracle system.
-
Create a Data Access Object for MariaDB Data using JDBI
A brief overview of creating a SQL Object API for MariaDB in JDBI.
-
Explore Geographical Relationships in Adobe Target Data with Power Map
Create data visualizations with Adobe Target in Power Map.
-
Build Dashboards with Microsoft OneDrive Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft OneDrive in Dundas BI.
-
Prepare, Blend, and Analyze Amazon Athena Data in Alteryx Designer (Connect AI)
Build workflows to access live Amazon Athena for self-service data analytics.
-
Connect to Act-On Data in HULFT Integrate
Connect to Act-On as a JDBC data source in HULFT Integrate
-
Analyze Authorize.Net Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Authorize.Net and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Use the CData Software JDBC Driver for ServiceNow in MicroStrategy Desktop
Connect to ServiceNow in MicroStrategy Desktop using the CData Software JDBC Driver for ServiceNow.
-
Create Apollo-Connected Business Apps in AppSheet
Connect to Apollo Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Apollo.
-
Load Optimizely Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Optimizely to a database.
-
Getting Started with the CData Excel Add-In for Oracle Service Cloud
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle Service Cloud.
-
Access Live Billsby Data in AWS Lambda
Connect to live Billsby in AWS Lambda using the CData JDBC Driver.
-
Use Dash to Build to Web Apps on Shippo Data
Create Python applications that use pandas and Dash to build Shippo-connected web apps.
-
Query Dynamics 365 Data in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft Dynamics 365.
-
DataBind Charts to Microsoft Teams Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Teams 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.
-
Process & Analyze Typeform Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Typeform Data.
-
Build Dynamics CRM-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Dynamics CRM to explore live Dynamics CRM Data in GitHub Copilot to assist with building Dynamics CRM-powered applications.
-
Access Live DocuSign Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate DocuSign into the statistical analysis tools available in SAS JMP. This article shows how to use DocuSign in the Graph Builder and Query Builder.
-
Connect to Microsoft OneDrive Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Microsoft OneDrive as an External Source in Dremio.
-
Everhour Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Everhour facts in real time.
-
Analyze CSV Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of CSV/TSV Files and visualize live CSV/TSV Files in Infragistics Reveal.
-
Integrate SingleStore Data into Power Automate Desktop using CData Connect
CData Connect for SingleStore Data enables you to integrate SingleStore into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for Reckon Accounts Hosted in SAS for Real-Time Reporting and Analytics
Connect to real-time Reckon Accounts Hosted in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Reckon Accounts Hosted.
-
Build MongoDB-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for MongoDB to explore live MongoDB Data in GitHub Copilot to assist with building MongoDB-powered applications.
-
Access XML Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live XML Files from HeidiSQL.
-
Integrating Kiro CLI with Accelo 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.
-
Object-Relational Mapping (ORM) with Contentful Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Contentful into a Java-based ORM framework, Hibernate.
-
Access Live Twilio Data in Coginiti Pro
Connect to and query live Twilio from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Visualize MarkLogic Data in Python with pandas
Use pandas and other modules to analyze and visualize live MarkLogic in Python.
-
Use the CData Software ODBC Driver for CapsuleCRM in MicroStrategy Desktop
Connect to CapsuleCRM in MicroStrategy Desktop using the CData Software ODBC Driver for CapsuleCRM.
-
Connect to RabbitMQ Data in JRuby
Create a simple JRuby app with access to live RabbitMQ.
-
Migrating data from GraphQL to Snowflake using CData SSIS Components.
Easily push GraphQL to Snowflake using the CData SSIS Tasks for GraphQL and Snowflake.
-
Enable the Stripe JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Stripe.
-
Query Instagram Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Instagram and perform CRUD operations on Instagram from Node.js.
-
Provide OData Services of LeadDesk Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for LeadDesk by developing a WCF Service Application.
-
Access ZohoSubscriptions Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ZohoSubscriptions from HeidiSQL.
-
LINQ to IBM Informix Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the IBM Informix Data Provider.
-
Integrate with Live IBM Informix Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to IBM Informix from the MuleSoft Anypoint Platform to integrate live IBM Informix into custom reports and dashboards.
-
Integrating Dataiku with Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Azure Data Lake Storage.
-
Automated Continuous Printify Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Printify replication to Azure SQL Database.
-
Integrate Goose with Live Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Epicor Kinetic from within the local AI agent.
-
Build Pipelines with Live Snowflake Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Snowflake from Google Cloud Data Fusion, enabling the integration of live Snowflake into the building and management of effective data pipelines.
-
Bridge Oracle Service Cloud Connectivity with Apache NiFi
Access and process Oracle Service Cloud in Apache NiFi using the CData JDBC Driver.
-
Build an OLAP Cube in SSAS from Bugsnag Data
Establish a connection to Bugsnag data from SQL Server Analysis Services, and use the Bugsnag Data Provider to build OLAP cubes for use in analytics and reporting.
-
DataBind Charts to Pingdom Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Pingdom 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.
-
Visualize Dynamics CRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Dynamics CRM.
-
How to create Zoho Projects federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoho Projects in MySQL .
-
Manage LeadDesk Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for LeadDesk.
-
Automated Continuous Invoiced Replication to SQL Server
Use CData Sync for automated, continuous, customizable Invoiced replication to SQL Server.
-
Visualize LeadDesk Data in TIBCO Spotfire through ADO.NET
Integrate LeadDesk into dashboards in TIBCO Spotfire.
-
Create Reports with SurveyMonkey Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SurveyMonkey.
-
Getting Started with the CData Python Connector for SharePoint
Learn to install and license the CData Python Connector