CData Software - Knowledge Base
Recent Articles
-
Faster Reporting using the CData Provider for Salesforce
The CData ADO.NET Provider for Salesforce features advanced caching capabilities. The Auto Cache feature of the Data Provider can be used to execute expensive queries against a local, automatically updated cache.
-
Use Databricks Agent Bricks to Talk to Your Snapchat Ads Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Snapchat Ads data for you.
-
Automated Continuous Tickspot Replication to SingleStore
Use CData Sync for automated, continuous, customizable Tickspot replication to SingleStore.
-
Connect to and Query Float Data in QlikView over ODBC
Create data visualizations with Float data in QlikView.
-
Use Biml to Build SSIS Tasks to Replicate Klaviyo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Klaviyo data to SQL Server.
-
Use Microsoft Copilot Studio to talk to your HubDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your HubDB data for you.
-
Use Dash to Build to Web Apps on Greenhouse Data
Create Python applications that use pandas and Dash to build Greenhouse-connected web apps.
-
DataBind Controls to Drip Data in C++Builder
DataBind to Drip data in C++Builder with standard components and controls.
-
Create a Data Access Object for Shippo Data using JDBI
A brief overview of creating a SQL Object API for Shippo data in JDBI.
-
Use the CData Software JDBC Driver for Cloudant in MicroStrategy Desktop
Connect to Cloudant data in MicroStrategy Desktop using the CData Software JDBC Driver for Cloudant.
-
Getting Started with the CData Excel Add-In for SparkPost
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SparkPost.
-
Work with Yelp Data in FoxPro
Load Yelp data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating GitHub Copilot with Attio 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 Goose with Live Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Twilio data from within the local AI agent.
-
Seamlessly Bring Oracle Financials Cloud Data into Retool Using CData Connect AI
Integrate Oracle Financials Cloud data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Migrating data from Oracle SCM to Databricks using CData SSIS Components.
Easily push Oracle SCM data to Databricks using the CData SSIS Tasks for Oracle SCM and Databricks.
-
Analyze Avaza Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Avaza data in Microsoft R Open.
-
Query Live ZohoMarketingHub 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 ZohoMarketingHub data through a conversational interface.
-
Visualize MessageBird Data in Tableau
The CData ODBC driver for MessageBird enables you integrate MessageBird data into Tableau dashboards.
-
Connect to Telegram Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Telegram as an External Source in Dremio.
-
Integrating Claude Code with Airtable Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Airtable data within assisted coding and automated development workflows.
-
Use Claude to Talk to Your Testmonitor Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Testmonitor data for you.
-
How to connect to Guru Data from IntelliJ
Integrate connectivity to Guru data with wizards in IntelliJ.
-
Connect to Printful Data in CloverDX (formerly CloverETL)
Transfer Printful data using the visual workflow in the CloverDX data integration tool.
-
Connect to Dotmailer Data from PowerBuilder via JDBC
This article demonstrates how to access Dotmailer data from PowerBuilder using the Dotmailer JDBC Driver.
-
Connect to BigCommerce Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to BigCommerce.
-
Prepare, Blend, and Analyze Oracle Data in Alteryx Designer (Connect AI)
Build workflows to access live Oracle data for self-service data analytics.
-
Load DB2 Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load DB2 data to a database.
-
Connect to Salesforce Marketing Data from AWS Glue
Use CData Connect AI to gain access to live Salesforce Marketing data from your AWS Glue jobs.
-
Build Agents in Relevance AI with Access to Live SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP Netweaver Gateway data within intelligent agent workflows.
-
Integrate Live Cloudflare Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Cloudflare data and integrate live Cloudflare data into apps built in Microsoft Power Apps.
-
Guru Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Guru facts in real time.
-
Validate MarkLogic Data with QuerySurge
Access and validate MarkLogic data in QuerySurge using the CData JDBC Driver.
-
Create Reports with SFTP Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SFTP data.
-
Connect to Paymo Data from a Connection Pool in Jetty
The Paymo JDBC Driver supports connection pooling: This article shows how to connect faster to Paymo data from Web apps in Jetty.
-
Use the CData ODBC Driver for Strava from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Strava to connect to Strava data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Strava data in Excel.
-
Excel Online Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Excel Online facts in real time.
-
Use Agno to Talk to Your Pipedrive 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 Pipedrive data for you.
-
Integrating Boomi Agentstudio with Bitly Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Bitly data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Visualize Live BenchmarkEmail Data in the Power BI Service
Use CData Connect AI to connect to live BenchmarkEmail data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Feed Apollo Data into FineReport
How to set Apollo data as a JDBC data source in FineReport.
-
Build Automated Wave Financial-Connected Workflows in Zapier
Use CData Connect AI to connect to live Wave Financial data and build automated workflows in Zapier.
-
Use the CData Software ODBC Driver for Clari in SAS for Real-Time Reporting and Analytics
Connect to real-time Clari data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Clari.
-
Automated Continuous DB2 Replication to Amazon S3
Use CData Sync for automated, continuous, customizable DB2 replication to Amazon S3.
-
How to import SAP HANA Data into Apache Solr
Use the CData Software JDBC Driver for SAP HANA in Data Import Handler and create an automated import of SAP HANA data to Apache Solr Enterprise Search platform.
-
LINQ to Microsoft OneDrive 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 Microsoft OneDrive Data Provider.
-
Connect to GetResponse Data in Google Apps Script via Connect AI
Use CData Connect AI to access GetResponse data in Google Apps Script.
-
How to Connect to Live Amazon Marketplace Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Amazon Marketplace data securely in real time.
-
Automated Continuous Microsoft Dataverse Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to PostgreSQL.
-
Automated Continuous Blackbaud FE NXT Replication to Vertica
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Vertica.
-
Create Power BI Reports on Real-Time Clockify Data
Use the CData ODBC Driver for Clockify to visualize Clockify data in Power BI Desktop.
-
Build BenchmarkEmail-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live BenchmarkEmail data and build BenchmarkEmail-connected web apps with Axios.
-
Connect to FreshBooks Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to FreshBooks.
-
How to load Amazon S3 data into Elasticsearch via Logstash
Introducing a simple method to load Amazon S3 data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software ODBC Driver for Front in MicroStrategy Web
Connect to Front data in MicroStrategy Web using the CData Software ODBC Driver for Front.
-
Connect to XML Data from a Connection Pool in Jetty
The XML JDBC Driver supports connection pooling: This article shows how to connect faster to XML data from Web apps in Jetty.
-
Work with LightSpeedRetail Data in FoxPro
Load LightSpeedRetail data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Enable the Microsoft Ads JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Ads data.
-
Feed Azure Analysis Services Data into FineReport
How to set Azure Analysis Services data as a JDBC data source in FineReport.
-
Process & Analyze EnterpriseDB Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live EnterpriseDB Data.
-
Build Visualizations of AgileCRM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of AgileCRM data in Birst.
-
Create Elasticsearch-Connected Dashboards in Grafana
Connect to Elasticsearch Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Elasticsearch data.
-
Integrating LangChain with Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Sybase IQ data within automated workflows.
-
Connect and Query Live Redshift Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Redshift data into Databricks and enable direct, live querying and analysis without replication.
-
Create Reports from WordPress Data in Looker Studio
Use CData Connect AI to gain access to live WordPress data and create custom reports in Looker Studio.
-
DataBind Controls to Insightly Data in Delphi
DataBind to Insightly data in Delphi with standard data access components and controls.
-
How to Connect to Jira Assets Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Jira Assets data. Leverage the pyodbc module for ODBC in Python.
-
Operational Reporting on Kafka Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Kafka data.
-
How to connect to Clari Data from IntelliJ
Integrate connectivity to Clari data with wizards in IntelliJ.
-
Connecting GenSpark with LDAP Objects via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to LDAP objects without any replication or custom integration required.
-
Create Shopify-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Shopify Data from Klipfolio and build custom visualizations using live Shopify data.
-
How to Easily Query Microsoft OneDrive Data in OpenOffice Base
Connect to Microsoft OneDrive data in OpenOffice Base using the CData ODBC Driver for Microsoft OneDrive and generate reports with live data insights.
-
How to Easily Query PostgreSQL Data in OpenOffice Base
Connect to PostgreSQL data in OpenOffice Base using the CData ODBC Driver for PostgreSQL and generate reports with live data insights.
-
How to Query Live SAP HANA Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP HANA data data in natural language using Python.
-
Link Klipfolio with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Klipfolio data in Filemaker Pro for Mac or Windows.
-
Integrating Boomi Agentstudio with Quickbase Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Quickbase data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build a Simple VCL Application for Aha! Data
How to build a simple VCL Application to view Aha! data in RAD Studio using the CData ODBC Driver for Aha!.
-
How to use SQLAlchemy ORM to access OData Services in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of OData services.
-
Migrating data from Microsoft Planner to Snowflake using CData SSIS Components.
Easily push Microsoft Planner data to Snowflake using the CData SSIS Tasks for Microsoft Planner and Snowflake.
-
Build Data Flows from Miro to SQL Server using SSIS
Easily back up Miro data to SQL Server using the SSIS components for Miro.
-
Integrate Devin with Live Adobe Target 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 Adobe Target data.
-
Create Informatica Mappings From/To a JDBC Data Source for Power BI XMLA
Create Power BI XMLA data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query Gorgias Data in ColdFusion
Write standard ColdFusion data access code to connect to Gorgias data.
-
Connect to ConvertAPI in SpagoBI
Create reports featuring live ConvertAPI data in SpagoBI Studio. Host ConvertAPI reports on SpagoBI Server.
-
Migrating data from Notion to Google BigQuery using CData SSIS Components.
Easily push Notion data to Google BigQuery using the CData SSIS Tasks for Notion and Google BigQuery.
-
Build a Simple VCL Application for Aircall Data
How to build a simple VCL Application to view Aircall data in RAD Studio using the CData ODBC Driver for Aircall.
-
Integrate Trae with Live ZohoSubscriptions Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ZohoSubscriptions data from within the AI-powered IDE.
-
Automated Continuous Dynamics NAV Replication to SQL Server
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to SQL Server.
-
Getting Started with the CData Tableau Connector for ServiceNow
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for ServiceNow.
-
Getting Started with the CData ADO.NET Provider for SparkPost
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate Apollo Data in the Pentaho Report Designer
Publish reports based on Apollo data in the Pentaho BI tool.
-
Access Live Oracle Service Cloud Data in Excel 365 Online (Excel for the web)
Connect to Oracle Service Cloud data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use Databricks Agent Bricks to Talk to Your Salesforce Marketing Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Salesforce Marketing data for you.
-
How to Connect to Live Amazon Marketplace 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 Amazon Marketplace data for you.
-
Replicate Multiple Couchbase Accounts
Replicate multiple Couchbase accounts to one or many databases.
-
Build Data Flows from RSS to SQL Server using SSIS
Easily back up RSS feeds to SQL Server using the SSIS components for RSS.
-
Excel Reporting in OBIEE with the Excel JDBC Driver
Deploy the Excel JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Live Sugar CRM Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Sugar CRM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Sugar CRM data.
-
Automated Continuous Gong Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Gong replication to Apache Cassandra.
-
How to connect to Sage 300 Data with Squirrel SQL client
Connect to Sage 300 data and execute queries in the Squirrel SQL Client.