CData Software - Knowledge Base
Recent Articles
-
Connect to Salesforce Data 360 Data from Crystal Reports
Use CData Connect AI to connect to and report on live Salesforce Data 360 data from Crystal Reports.
-
Automate ShipEngine Data Replication to SAP HANA
Use CData Sync to customize and automate ShipEngine data replication to SAP HANA.
-
Automated Continuous QuickBooks Online Replication to SQLite
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to SQLite.
-
Create Reports with Missive Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Missive data.
-
Build Semantic Layer Views for Paylocity Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Paylocity data.
-
Getting Started with the CData Excel Add-In for Testmonitor
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Testmonitor.
-
Build Semantic Layer Views for Azure Synapse Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure Synapse data.
-
Access Live NetSuite SuiteAnalytics Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live NetSuite SuiteAnalytics data through MCP integration.
-
How to connect to Beeminder Data with Squirrel SQL client
Connect to Beeminder data and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData SSIS Components for SAP Hybris C4C
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP Hybris C4C.
-
Connect and Visualize Live Freshteam Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Freshteam data into the Databricks platform and create visualization dashboards with real-time Freshteam data.
-
Automate Wistia Data Replication to Azure Synapse
Use CData Sync to customize and automate Wistia data replication to Azure Synapse.
-
Connect Clio to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Clio data using the CData Python MCP Server.
-
Load HelloSign Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load HelloSign data to a database.
-
How to Work with ConvertKit Data in ETL Validator JDBC
Connect to ConvertKit from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData ODBC Driver for Jira in Microsoft Power Query
You can use the CData Jira ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Jira data into Microsoft Power Query.
-
How to Connect the Power BI Service to SAP SuccessFactors: Complete Guide
Connect to the CData Software Power BI Connector for SAP SuccessFactors from PowerBI.com to provide real-time SAP SuccessFactors data across the organization.
-
Connect Salesforce Pardot to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Salesforce Pardot data using the CData Python MCP Server.
-
Import Real-Time Power BI XMLA Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Power BI XMLA data in ColdFusion.
-
Integrate Onfleet Data in the Pentaho Report Designer
Publish reports based on Onfleet data in the Pentaho BI tool.
-
Use Biml to Build SSIS Tasks to Replicate MySQL Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MySQL data to SQL Server.
-
SAP Fieldglass Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP Fieldglass data through CData Connect AI using different applications and tools.
-
Build BambooHR Visualizations in Tableau Cloud
Use CData Connect AI to connect to live BambooHR data and build visualizations in Tableau Cloud.
-
Integrating Contentful Data in Talend Cloud Data Management Platform
Connect Contentful Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Live SAP HANA 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 SAP HANA data through MCP integration.
-
Getting Started with the CData SSIS Components for Klaviyo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Klaviyo.
-
Rapidly Develop EnterpriseDB-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by EnterpriseDB.
-
Build Excel Online-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Excel Online data without replication.
-
Import CockroachDB Data Using Azure Data Factory
Use CData Connect AI to connect to CockroachDB Data from Azure Data Factory and import live CockroachDB data.
-
Build Freshdesk-Connected Apps in Choreo
Use CData Connect AI to connect to Freshdesk Data from Choreo and build custom apps using live Freshdesk data.
-
How to Work with SFTP Data in ETL Validator JDBC
Connect to SFTP from ETL Validator jobs using the CData Software JDBC Driver.
-
How to integrate Metabase with ADP Data
Use CData Connect AI to connect to live ADP data and create an interactive dashboard in Metabase from ADP data.
-
Connect to Excel Online Data in RazorSQL
Connect to Excel Online from wizards and query Excel Online data from the GUI in the RazorSQL database management tool.
-
Build a Singer.io Tap for Retently With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Retently data using the CData Python Connector.
-
Automated Continuous Paylocity Replication to SingleStore
Use CData Sync for automated, continuous, customizable Paylocity replication to SingleStore.
-
Analyze SAP HANA XS Advanced Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP HANA XS Advanced data and visualize SAP HANA XS Advanced data in SAP Analytics Cloud.
-
How to Build an ETL App for Eventbrite Data in Python with CData
Create ETL applications and real-time data pipelines for Eventbrite data in Python with petl.
-
How to Connect Freshservice Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Freshservice data in real time using natural language.
-
Integrating Typeform Data in Talend Cloud Data Management Platform
Connect Typeform Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to import Cvent Data into Apache Solr
Use the CData Software JDBC Driver for Cvent in Data Import Handler and create an automated import of Cvent data to Apache Solr Enterprise Search platform.
-
Build ServiceDesk Plus-Connected Apps in Choreo
Use CData Connect AI to connect to ServiceDesk Plus Data from Choreo and build custom apps using live ServiceDesk Plus data.
-
Automated Continuous Workday Replication to MySQL
Use CData Sync for automated, continuous, customizable Workday replication to MySQL.
-
DataBind Charts to Kafka Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Kafka 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.
-
Integrate with Freshdesk Data in JReport Designer
Create charts and reports based on Freshdesk data in JReport Designer.
-
Connect to Oracle Eloqua in SpagoBI
Create reports featuring live Oracle Eloqua data in SpagoBI Studio. Host Oracle Eloqua reports on SpagoBI Server.
-
FHIR Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on FHIR facts in real time.
-
Integrate Real-Time Access to REST in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to REST data in real time.
-
Model SAP Ariba Source Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP Ariba Source, enabling the direct import of real-time SAP Ariba Source data.
-
Automated Continuous CampaignMonitor Replication to MySQL
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to MySQL.
-
Getting Started with the CData Power BI Connector for FreshBooks
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create Informatica Mappings From/To an ODBC Data Source for Microsoft Entra ID
Create an ODBC connection to Microsoft Entra ID in Informatica and browse and transfer Microsoft Entra ID data.
-
Prepare, Blend, and Analyze Timely Data in Alteryx Designer (ODBC)
Build workflows to access live Timely data for self-service data analytics.
-
Automated Continuous Quaderno Replication to Databricks
Use CData Sync for automated, continuous, customizable Quaderno replication to Databricks.
-
Access Live Quickbase 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 Quickbase data through MCP integration.
-
DataBind Controls to Telegram Data in Delphi
DataBind to Telegram data in Delphi with standard data access components and controls.
-
Automated Continuous GetResponse Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable GetResponse replication to Google Cloud SQL.
-
Build Dashboards with ConvertAPI Data in Dundas BI
Create dynamic dashboards and perform analytics based on ConvertAPI data in Dundas BI.
-
Productboard Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Productboard facts in real time.
-
Build Automated Wistia-Connected Workflows in Zapier
Use CData Connect AI to connect to live Wistia data and build automated workflows in Zapier.
-
How to Visualize MariaDB 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 MariaDB data in Python.
-
Access Live Salesforce Marketing Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Salesforce Marketing data from your Excel spreadsheets.
-
Connect to Active Directory Data from a Connection Pool in JBoss
Integrate Active Directory data into Java servlets: Use the Management Console in JBoss to install the Active Directory JDBC Driver.
-
Easily Integrate ZarMoney Data in Lazarus Pascal IDE
Learn how to easily integrate live ZarMoney data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to CockroachDB Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for CockroachDB to connect to CockroachDB data and execute queries in PowerBuilder.
-
Automated Continuous Greenhouse Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Greenhouse replication to PostgreSQL.
-
Integrating Claude Code CLI with Facebook Ads 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 Codex with ElevenLabs 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 import Confluence Data into Apache Solr
Use the CData Software JDBC Driver for Confluence in Data Import Handler and create an automated import of Confluence data to Apache Solr Enterprise Search platform.
-
Use CData Connect AI to Access FreshBooks Data in Microsoft Power Pivot
Use CData Connect AI to connect to live FreshBooks data in the Power Pivot business intelligence tool.
-
Create Dashboards and Visualize Live SingleStore Data in Geckoboard
Use CData Connect AI to connect to live SingleStore data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Landbot Data from MySQL in Amazon QuickSight
Connect to Landbot and build visualizations of Landbot data using a MySQL Connection in Amazon QuickSight.
-
Stream Chargebee Data into Apache Kafka Topics
Access and stream Chargebee data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect Telegram Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Telegram data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect and Visualize Live Azure DevOps Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Azure DevOps data into the Databricks platform and create visualization dashboards with real-time Azure DevOps data.
-
Use the CData ODBC Driver for Google Cloud Storage in Microsoft Power Query
You can use the CData Google Cloud Storage ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Cloud Storage data into Microsoft Power Query.
-
Automated Continuous Google Analytics Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Analytics replication to SingleStore.
-
Getting Started with the CData Excel Add-In for Amplitude
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Amplitude.
-
Integrate Avro Data into Power Automate Desktop using CData Connect
CData Connect for Avro Data enables you to integrate Avro data into workflows built using Microsoft Power Automate Desktop.
-
Integrating GitHub Copilot with SendInBlue 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.
-
Create Reports with Campaigner Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Campaigner data.
-
Query Basecamp Data in DataGrip
Create a Data Source for Basecamp in DataGrip and use SQL to query live Basecamp data.
-
Connect to SFTP from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SFTP data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use Biml to Build SSIS Tasks to Replicate Flowlu Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Flowlu data to SQL Server.
-
Create Data Visualizations Based On Shopify Data in Mode
Use CData Connect AI to connect to Shopify Data from Mode and build visualizations using live Shopify data.
-
Automated Continuous ZeroBounce Replication to SingleStore
Use CData Sync for automated, continuous, customizable ZeroBounce replication to SingleStore.
-
Build Apps with Live Google Forms data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Forms data into the Adalo platform and build custom mobile and web applications with real-time Google Forms data.
-
How to Seamlessly Import RabbitMQ Data into IBM SPSS Modeler
Integrate RabbitMQ data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Query Live Sentry Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sentry data data in natural language using Python.
-
Visualize Wistia Data in Sisense
Create an ElastiCube in Sisense app with access to Wistia data.
-
Query, Visualize, and Share live Amazon Athena Data in Redash
Use CData Connect AI to connect to live Amazon Athena data in Redash for querying, visualizing, and sharing.
-
Bidirectional Access to MariaDB Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate MariaDB data in Filemaker Pro for Mac or Windows.
-
Build API-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for API Data and create custom apps in Bubble.
-
How to connect Amazon QuickSight to Splunk Data
Create a connection to Splunk data in CData Connect AI and insert Splunk data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Chargebee Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Chargebee data replication to OneLake in Microsoft Fabric.
-
Getting Started with the CData Connect AI Python SDK for Sybase IQ
Install the CData Connect AI Python SDK to read and write live Sybase IQ data with standard DB-API 2.0 Python code.
-
Integrate Devin with Live Slack 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 Slack data.
-
Connecting Pipedream with Figshare Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Figshare data in real time.
-
How to Work with Oracle HCM Cloud Data in AWS Glue Jobs Using JDBC
Connect to Oracle HCM Cloud from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous eBay Replication to MongoDB
Use CData Sync for automated, continuous, customizable eBay replication to MongoDB.
-
Viewing Paddle Data in RAD Studio Data Explorer
How to view Paddle data in RAD Studio Data Explorer using the CData ODBC Driver for Paddle.