CData Software - Knowledge Base
Recent Articles
-
Use ChatGPT to Talk to Your Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Zoom for you.
-
Automated Continuous Aircall Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Aircall replication to Apache Cassandra.
-
How to integrate Outreach.io with Apache Airflow
Access and process Outreach.io in Apache Airflow using the CData JDBC Driver.
-
How to Work with Amazon Marketplace Data in AWS Glue Jobs Using JDBC
Connect to Amazon Marketplace from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Informatica Mappings From/To an ODBC Data Source for Salesforce
Create an ODBC connection to Salesforce in Informatica and browse and transfer Salesforce & Force.com.
-
How to Visualize Confluence Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Atlassian Confluence in Python.
-
Use the CData ODBC Driver for Opsgenie from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Opsgenie to connect to Opsgenie from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Opsgenie in Excel.
-
Automated Continuous Google Campaign Manager 360 Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Amazon S3.
-
Connect to QuickBooks Data in HULFT Integrate
Connect to QuickBooks as a JDBC data source in HULFT Integrate
-
Build an OLAP Cube in SSAS from SAP Data
Establish a connection to SAP ERP/NetWeaver data from SQL Server Analysis Services, and use the SAP Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Real-Time Contentful Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Contentful in Power Apps.
-
Connecting GenSpark with Stripe Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Stripe without any replication or custom integration required.
-
Validate Greenplum Data with QuerySurge
Access and validate Pivotal GreenPlum in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Freshsales Replication to Snowflake
Use CData Sync for automated, continuous, customizable Freshsales replication to Snowflake.
-
Automated Continuous ActiveCampaign Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to Apache Cassandra.
-
Moving Data from FreeAgent to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live FreeAgent data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect to Drip Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Drip. Leverage the pyodbc module for ODBC in Python.
-
How to Connect to Live Shopify Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Shopify for you.
-
Connect to Live Microsoft OneDrive Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Microsoft OneDrive in CData Connect AI and connect to your Microsoft OneDrive from PostgreSQL.
-
Use the CData Software JDBC Driver for WooCommerce in MicroStrategy Web
Connect to WooCommerce in MicroStrategy Web using the CData Software JDBC Driver for WooCommerce.
-
Getting Started with the CData Connect AI Python SDK for SQL Analysis Services
Install the CData Connect AI Python SDK to read and write live SQL Analysis Services with standard DB-API 2.0 Python code.
-
Access Live Notion Data in AWS Lambda
Connect to live Notion in AWS Lambda using the CData JDBC Driver.
-
Moving Data from Coda to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Coda data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Teamgate Data in CloverDX (formerly CloverETL)
Transfer Teamgate using the visual workflow in the CloverDX data integration tool.
-
Build Dynamics CRM-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Dynamics CRM Data and create custom apps in Bubble.
-
Create Apps from SAP Ariba Procurement Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP Ariba Procurement Data and build apps from live SAP Ariba Procurement in Qlik Sense Cloud.
-
How to integrate Metabase with Couchbase Data
Use CData Connect AI to connect to live Couchbase and create an interactive dashboard in Metabase from Couchbase.
-
Automated Continuous Instagram Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Instagram replication to AlloyDB.
-
Establish a Live Connection with Pipeliner CRM Data using Tableau Bridge
The CData ODBC Driver for Pipeliner CRM enables you to integrate live Pipeliner CRM into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to CSV Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live CSV/TSV Files from Filemaker Pro on Mac.
-
Connect to Cloudant Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live IBM Cloudant.
-
Working with SingleStore Data in LINQPad
Execute LINQ queries to SingleStore in LINQPad.
-
How to import QuickBooks Time Data into Apache Solr
Use the CData Software JDBC Driver for QuickBooks Time in Data Import Handler and create an automated import of QuickBooks Time to Apache Solr Enterprise Search platform.
-
Integrating OpenCode Terminal with Quaderno 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.
-
How to Work with Instantly Data in AWS Glue Jobs Using JDBC
Connect to Instantly from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query Spark Data in DataGrip
Create a Data Source for Spark in DataGrip and use SQL to query live Apache Spark SQL.
-
A PostgreSQL Interface for Sage Cloud Accounting Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sage Cloud Accounting JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous ZohoPeople Replication to MongoDB
Use CData Sync for automated, continuous, customizable ZohoPeople replication to MongoDB.
-
Connect to Retently Data in DBArtisan
Use wizards in DBArtisan to configure Retently as a data source.
-
CData Virtuality 4.10 Release Notes: Developer Preview of New Features and More
Read the release notes for CData Virtuality 4.10, including the developer preview of several mighty features and more.
-
Automated Continuous CSV Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable CSV replication to Apache Cassandra.
-
How to create an RPA flow for Quaderno Data in UiPath Studio
Use the Quaderno ODBC Driver to create workflows that access real-time Quaderno without any coding.
-
Bind Live Trello Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Trello data
-
Use Manus AI to Talk to Your Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Monday.com.
-
ETL Snapchat Ads in Oracle Data Integrator
This article shows how to transfer Snapchat Ads into a data warehouse using Oracle Data Integrator.
-
Feed Jira Assets Data into FineReport
How to set Jira Assets as a JDBC data source in FineReport.
-
DataBind Controls to SendPulse Data in C++Builder
DataBind to SendPulse in C++Builder with standard components and controls.
-
Getting Started with the CData ODBC Driver for WooCommerce
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for WooCommerce.
-
Publish Reports with Bitbucket Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bitbucket.
-
Bidirectional Access to Amazon Athena Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Amazon Athena in Filemaker Pro for Mac or Windows.
-
Connect to Act CRM Data in Google Apps Script via Connect AI
Use CData Connect AI to access Act CRM in Google Apps Script.
-
Access Live CloudConvert Data in AWS Lambda (with IntelliJ IDEA)
Connect to live CloudConvert in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Natively Connect to Dotmailer Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Dotmailer. Leverage the native support for ODBC in PHP.
-
Connect to Cosmos DB Data from Crystal Reports
Use CData Connect AI to connect to and report on live Azure Cosmos DB from Crystal Reports.
-
Create FTP-Connected Dashboards in Grafana
Connect to FTP Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to FTP Servers.
-
How to Access Zendesk Data Using Entity Framework
This article shows how to access Zendesk using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to import Zuora Data into Apache Solr
Use the CData Software JDBC Driver for Zuora in Data Import Handler and create an automated import of Zuora to Apache Solr Enterprise Search platform.
-
Automate eBay Analytics Data Replication to Azure Data Lake
Use CData Sync to customize and automate eBay Analytics replication to Azure Data Lake.
-
Connect to Insightly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Insightly using standard SQL.
-
Create Informatica Mappings From/To a JDBC Data Source for Oracle Financials Cloud
Create Oracle Financials Cloud data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData Software ODBC Driver for QuickBooks in MicroStrategy
Connect to QuickBooks Desktop in MicroStrategy Developer using the CData Software ODBC Driver for QuickBooks.
-
Connect to Live Couchbase Data in MicroStrategy through CData Connect AI
Create a live connection to Couchbase Data in CData Connect AI and connect to your Couchbase from MicroStrategy.
-
Visualize Live Coda Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Coda using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Bridge Mistral AI Connectivity with Apache NiFi
Access and process Mistral AI in Apache NiFi using the CData JDBC Driver.
-
Access Live TigerGraph Data in AWS Lambda (with IntelliJ IDEA)
Connect to live TigerGraph in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Access Hugging Face Data Using Entity Framework
This article shows how to access Hugging Face using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to use SQLAlchemy ORM to access Everhour Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Everhour.
-
Connect to Google Ads Data from AWS Glue
Use CData Connect AI to gain access to live Google Ads from your AWS Glue jobs.
-
Connect to Salesloft Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Salesloft to connect to Salesloft and execute queries in PowerBuilder.
-
How to connect to Certinia Data from Spring Boot
Connect to Certinia in a Spring Boot Application using the CData JDBC Driver for Certinia
-
Connect to Azure Synapse Data from a Connection Pool in JBoss
Integrate Azure Synapse into Java servlets: Use the Management Console in JBoss to install the Azure Synapse JDBC Driver.
-
Connect to Square Data in CloverDX (formerly CloverETL)
Transfer Square using the visual workflow in the CloverDX data integration tool.
-
How to Connect to LDAP Objects in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to LDAP. Leverage the pyodbc module for ODBC in Python.
-
Query Onfleet Data in DataGrip
Create a Data Source for Onfleet in DataGrip and use SQL to query live Onfleet.
-
Use Biml to Build SSIS Tasks to Replicate Close Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Close to SQL Server.
-
Integrate with Salesforce Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Salesforce & Force.com to a JSON file on disk.
-
Connect to Mistral AI Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Mistral AI and work with Mistral AI in your FileMaker applications.
-
How to connect to Twitter Ads Data from IntelliJ
Integrate connectivity to Twitter Ads with wizards in IntelliJ.
-
Connect to Real-Time iContact Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use iContact in Power Apps.
-
Connect to Google Cloud Storage Data in HULFT Integrate
Connect to Google Cloud Storage as a JDBC data source in HULFT Integrate
-
Connect to Quickbase Data in DBArtisan
Use wizards in DBArtisan to configure Quickbase as a data source.
-
Visualize IBM Informix Data in TIBCO Spotfire through ADO.NET
Integrate IBM Informix into dashboards in TIBCO Spotfire.
-
Integrating GitHub Copilot CLI with FHIR 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.
-
Access LinkedIn Ads Data from MySQL in PHP
Connect to LinkedIn Ads through the standard MySQL libraries in PHP.
-
Connect to Microsoft OneDrive from a Connection Pool in WebLogic
Use the CData JDBC Driver for Microsoft OneDrive to connect to Microsoft OneDrive from Web applications running on WebLogic.
-
Prepare, Blend, and Analyze Gong Data in Alteryx Designer (Connect AI)
Build workflows to access live Gong for self-service data analytics.
-
Query GraphQL Data from Node.js
Use the OData endpoint of the CData API Server to connect to your GraphQL and perform CRUD operations on GraphQL from Node.js.
-
Create Facebook Ads-Connected Nintex Workflows
Use CData Connect AI to connect to Facebook Ads Data from Nintex Workflow Cloud and build custom workflows using live Facebook Ads.
-
Integrate Azure DevOps Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Azure DevOps from Informatica Cloud.
-
Use Agno to Talk to Your Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Box for you.
-
Connect Active Directory to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Active Directory with IBM WebSphere for seamless data integration and connectivity.
-
Enable the SAP Fieldglass JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP Fieldglass.
-
Publish Shopify-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Shopify.
-
Access Perplexity Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Perplexity from your Oracle system.
-
Query CampaignMonitor Data in ColdFusion
Write standard ColdFusion data access code to connect to CampaignMonitor.
-
Access Live Oracle Financials Cloud Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Oracle Financials Cloud through MCP integration.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Translate
Provide connectivity to Google Translate through an SAP BusinessObjects universe.
-
Automated Continuous Tickspot Replication to MongoDB
Use CData Sync for automated, continuous, customizable Tickspot replication to MongoDB.
-
DataBind Controls to ShipEngine Data in C++Builder
DataBind to ShipEngine in C++Builder with standard components and controls.
-
Build MVC Applications with Connectivity to Microsoft Exchange Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Microsoft Exchange from an ASP.NET MVC application.