CData Software - Knowledge Base
Recent Articles
-
Build Visualizations of OnePageCrm Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of OnePageCrm data in Birst.
-
Build SAS xpt-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAS xpt data and build SAS xpt-connected web apps with Axios.
-
How to update Microsoft Ads from Excel
This article explains how to transfer data from Excel to Microsoft Ads using the Excel Add-In for Microsoft Ads.
-
Analyze VWO Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for VWO from Power Pivot. You will use the Table Import Wizard to load VWO data. You can visually build the import query or use any SQL supported by the driver.
-
Building Dynamic Web Pages with Reckon Data Using AngularJS
Create single-page applications with live connectivity to Reckon using the CData API Server.
-
Deploy the ADO.NET Provider for Amazon Marketplace on an SSRS Report Server
Connect to Amazon Marketplace data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect Aha! Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Aha! data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Work with Codat Data in AWS Glue Jobs Using JDBC
Connect to Codat from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Extract, Transform, and Load Oracle SCM Data in Informatica PowerCenter
Create a simple Workflow for Oracle SCM data in Informatica PowerCenter.
-
Easily Integrate Intercom Data in Lazarus Pascal IDE
Learn how to easily integrate live Intercom data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
View Reports on Real-Time SAP HANA XS Advanced Data in Power BI Report Server
Use the CData ODBC Driver for SAP HANA XS Advanced to visualize SAP HANA XS Advanced data in Power BI Desktop and then publish them to Power BI Report Server.
-
Lakebase Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Lakebase data through CData Connect AI using different applications and tools.
-
Automated Continuous Hubstaff Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Hubstaff replication to delimited files (CSV/TSV).
-
How to use SQLAlchemy ORM to access Exact Online Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Exact Online data.
-
Explore Geographical Relationships in AgileCRM Data with Power Map
Create data visualizations with AgileCRM data in Power Map.
-
Build a Simple VCL Application for Adobe Target Data
How to build a simple VCL Application to view Adobe Target data in RAD Studio using the CData ODBC Driver for Adobe Target.
-
Connect to Lakebase Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Lakebase data.
-
Load ZohoDesk Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZohoDesk data to a database.
-
Search External Coda Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Coda data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Coda Data objects that you can access from apps and the dashboard.
-
How to Create Power BI Visual Reports with Real-Time OData Services
Use CData Power BI Connectors to visualize OData services in Power BI.
-
Analyze Shippo Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Shippo data and visualize Shippo data in SAP Analytics Cloud.
-
Work with Chargebee Data in FoxPro
Load Chargebee data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Prepare, Blend, and Analyze ZendeskSell Data in Alteryx Designer (ODBC)
Build workflows to access live ZendeskSell data for self-service data analytics.
-
How to connect and process DB2 data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live DB2 data.
-
Prepare, Blend, and Analyze Excel Online Data in Alteryx Designer (ODBC)
Build workflows to access live Excel Online data for self-service data analytics.
-
Humanity Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Humanity facts in real time.
-
Access Live Short.io Data in AWS Lambda
Connect to live Short.io data in AWS Lambda using the CData JDBC Driver.
-
DataBind Controls to ChargeOver Data in Delphi
DataBind to ChargeOver data in Delphi with standard data access components and controls.
-
Connect to CloudConvert Data from a Connection Pool in JBoss
Integrate CloudConvert data into Java servlets: Use the Management Console in JBoss to install the CloudConvert JDBC Driver.
-
Import Real-Time IBM Informix Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use IBM Informix data in ColdFusion.
-
How to connect to Mixpanel Data from Spring Boot
Connect to Mixpanel in a Spring Boot Application using the CData API Driver for JDBC
-
Add Dynamics CRM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Dynamics CRM with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData Connect AI Python SDK for iContact
Install the CData Connect AI Python SDK to read live iContact data with standard DB-API 2.0 Python code.
-
Prepare, Blend, and Analyze Omnisend Data in Alteryx Designer (ODBC)
Build workflows to access live Omnisend data for self-service data analytics.
-
Design BIRT Reports on Oracle HCM Cloud Data
Provide current Oracle HCM Cloud data to your embedded analytics.
-
Automated Continuous LaunchDarkly Replication to AlloyDB
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to AlloyDB.
-
Automated Continuous SendInBlue Replication to Oracle
Use CData Sync for automated, continuous, customizable SendInBlue replication to Oracle.
-
Connecting Agentforce with WooCommerce Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your WooCommerce data for you.
-
Connect to Cohere Data in Ruby
Connect to Cohere data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Samanage Data in DBArtisan
Use wizards in DBArtisan to configure Samanage data as a data source.
-
Getting Started with the CData Connect AI Python SDK for AlloyDB
Install the CData Connect AI Python SDK to read and write live AlloyDB data with standard DB-API 2.0 Python code.
-
How to Connect to & Open JSON Services in Microsoft Excel
This article uses the CData ODBC driver for JSON to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to load Zoho Books data into Elasticsearch via Logstash
Introducing a simple method to load Zoho Books data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData ODBC Driver for QuickBooks Online
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for QuickBooks Online.
-
Connect to Pinterest Data in ACL Analytics
Connect to Pinterest data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Pinterest data.
-
Connect to Google Contacts Data from PowerBuilder via JDBC
This article demonstrates how to access Google Contacts data from PowerBuilder using the Google Contacts JDBC Driver.
-
How to Connect to Live LDAP Objects from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your LDAP objects for you.
-
Create Data Visualizations in Cognos BI with Opsgenie Data
Access Opsgenie data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Automated Workflows with Live Couchbase Data in Workato
Use CData Connect AI to connect to live Couchbase data and build automated workflows in Workato.
-
Build RSS-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live RSS feeds.
-
Analyze Adobe Experience Manager Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Adobe Experience Manager data in Microsoft R Open.
-
Access Live Azure Data Lake Storage Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Azure Data Lake Storage data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous Smartsheet Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Smartsheet replication to Azure SQL Database.
-
Connect to Epicor Kinetic Data in RapidMiner
Integrate Epicor Kinetic data with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze Elorus Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Elorus from Power Pivot. You will use the Table Import Wizard to load Elorus data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Aircall Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Aircall and work with Aircall data in your FileMaker application.
-
Build a Singer.io Tap for Pinterest With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Pinterest data using the CData Python Connector.
-
Visualize Live Sage Cloud Accounting Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Sage Cloud Accounting data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Claude Code with MailerLite Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on MailerLite data within assisted coding and automated development workflows.
-
Visualize Google Search Results from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Search results.
-
Trigger Zoho Inventory IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Zoho Inventory with standard wizards in Logic Apps.
-
Connect to Dotmailer Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Dotmailer data.
-
Automated Active Directory Data Replication to Teradata
Use CData Sync to Customize and automate Active Directory data replication to Teradata.
-
Getting Started with the CData Tableau Connector for ZarMoney
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
GetResponse Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to GetResponse data through CData Connect AI using different applications and tools.
-
Integrating GitHub Copilot with Sugar CRM 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.
-
Access Live IBM Informix Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to IBM Informix data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Hive Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Hive data from HeidiSQL.
-
Automated Continuous Act-On Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Act-On replication to Amazon Redshift.
-
Consume Epicor Kinetic OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Epicor Kinetic feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Insightly Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Insightly replication to Amazon Redshift.
-
How to Connect to Live Splunk Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Splunk data securely in real time.
-
Model, Search, and Visualize Live Google Ad Manager Data in ThoughtSpot
Use CData Connect AI to connect to live Google Ad Manager data for modeling, searching, and visualizing.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SuiteCRM
Provide connectivity to SuiteCRM data through an SAP BusinessObjects universe.
-
How to Connect to Live ServiceNow Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live ServiceNow data without replication.
-
How to import Neo4J Data into Apache Solr
Use the CData Software JDBC Driver for Neo4J in Data Import Handler and create an automated import of Neo4J data to Apache Solr Enterprise Search platform.
-
Work with Power BI XMLA Data in FoxPro
Load Power BI XMLA data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use Dash to Build Web Apps on Bullhorn CRM Data via CData Connect AI
Build interactive Dash web apps on live Bullhorn CRM data using pandas and the CData Connect AI Python SDK.
-
Automated Continuous FreshBooks Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable FreshBooks data replication to OneLake in Microsoft Fabric.
-
Add Dotmailer Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Dotmailer with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Snapchat Ads Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Snapchat Ads data using standard SQL.
-
Viewing Hubstaff Data in RAD Studio Data Explorer
How to view Hubstaff data in RAD Studio Data Explorer using the CData ODBC Driver for Hubstaff.
-
How to Visualize API 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 API data in Python.
-
Build Data Flows from SQL Server to Salesforce CRM Analytics through SSIS
Easily push SQL Server data to Salesforce CRM Analytics using the CData SSIS Tasks for Salesforce CRM Analytics.
-
Connect to ElevenLabs Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ElevenLabs and work with ElevenLabs data in your FileMaker applications.
-
Build Data Flows from Databricks to SQL Server using SSIS
Easily back up Databricks data to SQL Server using the SSIS components for Databricks.
-
Stream QuickBooks Time Data into Apache Kafka Topics
Access and stream QuickBooks Time data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create LightSpeedRetail Dataflows on PowerBI.com
Connect to the CData Power BI Connector for LightSpeedRetail from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Data Flows from ZeroBounce to SQL Server using SSIS
Easily back up ZeroBounce data to SQL Server using the SSIS components for ZeroBounce.
-
Analyze QuickBooks Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze QuickBooks data in Microsoft R Open.
-
Build MVC Applications with Connectivity to ScrapingBee Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ScrapingBee from an ASP.NET MVC application.
-
DataBind Charts to Shopify Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Shopify 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.
-
Query Live Salesforce Pardot 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 Salesforce Pardot data through a conversational interface.
-
Integrate with Amazon S3 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Amazon S3 data to a JSON file on disk.
-
Connecting Pipedream with SAP SuccessFactors LMS 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 SAP SuccessFactors LMS data in real time.
-
Automated Continuous Adobe Target Replication to Vertica
Use CData Sync for automated, continuous, customizable Adobe Target replication to Vertica.
-
Automated Continuous Google Translate Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Translate replication to MySQL.
-
Create Dynamic Simplesat Grids Using the Infragistics XamDataGrid
Learn how you can connect Simplesat to Infragistics XamDataGrid to build dynamic grids.
-
How to integrate Productboard with Apache Airflow
Access and process Productboard data in Apache Airflow using the CData JDBC Driver.
-
Replicate Close Data in Heroku for Use in Salesforce Connect
Replicate Close data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.