CData Software - Knowledge Base
Recent Articles
-
How to create an RPA flow for Zoho Books Data in UiPath Studio
Use the Zoho Books ODBC Driver to create workflows that access real-time Zoho Books without any coding.
-
Seamlessly Bring Bullhorn CRM Data into Retool Using CData Connect AI
Integrate Bullhorn CRM data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Certinia Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Certinia replication to delimited files (CSV/TSV).
-
Automated Continuous Vault CRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable Vault CRM replication to Snowflake.
-
Create Power BI Reports on Real-Time Short.io Data
Use the CData ODBC Driver for Short.io to visualize Short.io in Power BI Desktop.
-
Building Dynamic Web Pages with Facebook Ads Data Using AngularJS
Create single-page applications with live connectivity to Facebook Ads using the CData API Server.
-
Connect to and Visualize Live Zoho CRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zoho CRM.
-
Connecting Pipedream with Salesforce Pardot 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 Salesforce Pardot data in real time.
-
Use the CData Software ODBC Driver for Hive in MicroStrategy Desktop
Connect to Apache Hive in MicroStrategy Desktop using the CData Software ODBC Driver for Hive.
-
Connect to Live Acumatica Data in MicroStrategy through CData Connect AI
Create a live connection to Acumatica Data in CData Connect AI and connect to your Acumatica ERP from MicroStrategy.
-
A PostgreSQL Interface for Paymo Data (MySQL Remoting via JDBC)
Use the Remoting features of the Paymo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Reports with Acumatica Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Acumatica ERP.
-
Connect Redis to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Redis using the CData Python MCP Server.
-
Access Greenplum Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Pivotal GreenPlum from HeidiSQL.
-
Use Claude to Talk to Your Odoo 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 Odoo ERP for you.
-
Explore Geographical Relationships in MariaDB Data with Power Map
Create data visualizations with MariaDB in Power Map.
-
Automated Continuous OneNote Replication to Databricks
Use CData Sync for automated, continuous, customizable OneNote replication to Databricks.
-
Connect to Google Ads from Asprova with CData Software ODBC Driver for Google Ads
This article shows how to connect faster to Google Ads data from Asprova.
-
Access Live EnterpriseDB Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live EnterpriseDB data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Presto Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Presto to connect to Presto and execute queries in PowerBuilder.
-
Getting Started with the CData Excel Add-In for Sage 200
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Sage 200.
-
Feed Zoom Data into FineReport
How to set Zoom as a JDBC data source in FineReport.
-
Analyze PayPal Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of PayPal and visualize live PayPal in Infragistics Reveal.
-
Build a Singer.io Tap for CapsuleCRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live CapsuleCRM data using
-
How to Build an ETL App for Front Data in Python with CData
Create ETL applications and real-time data pipelines for Front in Python with petl.
-
Automated Continuous Everhour Replication to MySQL
Use CData Sync for automated, continuous, customizable Everhour replication to MySQL.
-
Provide OData Services of Freshdesk Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Freshdesk by developing a WCF Service Application.
-
Visualize Live Microsoft Exchange Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Exchange and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Migrating data from FreeAgent to Snowflake using CData SSIS Components.
Easily push FreeAgent to Snowflake using the CData SSIS Tasks for FreeAgent and Snowflake.
-
Connect Elorus Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Elorus using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to ClickTime Data in HULFT Integrate
Connect to ClickTime as a JDBC data source in HULFT Integrate
-
Seamlessly Bring Databricks Data into Retool Using CData Connect AI
Integrate Databricks data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating Antigravity CLI with SAS XPORT via CData CLI
Connect SAS XPORT to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Sybase-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Sybase and build web apps with connectivity to live Sybase.
-
How to Build an ETL App for MongoDB Data in Python with CData
Create ETL applications and real-time data pipelines for MongoDB in Python with petl.
-
Access Live BigQuery Data in Coginiti Pro
Connect to and query live Google BigQuery from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Lakebase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Lakebase from HeidiSQL.
-
Integrate Zoho CRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zoho CRM with External Services.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Apache Phoenix to Power BI dashboards. Simply drag and drop Apache Phoenix into data visuals on the Power BI canvas.
-
Use Manus AI to Talk to Your Authorize.Net 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 Authorize.Net.
-
Automated Continuous Avro Replication to SQLite
Use CData Sync for automated, continuous, customizable Avro replication to SQLite.
-
How to Visualize Zoho CRM 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 Zoho CRM in Python.
-
Easily Integrate Elasticsearch Data in Lazarus Pascal IDE
Learn how to easily integrate live Elasticsearch in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to import Teradata Data into Apache Solr
Use the CData Software JDBC Driver for Teradata in Data Import Handler and create an automated import of Teradata to Apache Solr Enterprise Search platform.
-
Build Apps with Live Avalara AvaTax in Adalo using CData Connect AI
Use CData Connect AI to integrate live Avalara AvaTax into the Adalo platform and build custom mobile and web applications with real-time Avalara AvaTax.
-
Easily Build Angular2 Database Apps
Use the API Server and Angular 2 to Build Dynamic Web Apps with Live Database Data.
-
How to Easily Query Zoho Projects Data in OpenOffice Base
Connect to Zoho Projects data in OpenOffice Base using the CData ODBC Driver for Zoho Projects and generate reports with live data insights.
-
Getting Started with the CData Python Connector for CircleCI
Learn to install and license the CData Python Connector
-
Visualize Live JSON Services in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live JSON into custom reports in Power BI.
-
Prepare, Blend, and Analyze eBay Analytics Data in Alteryx Designer (ODBC)
Build workflows to access live eBay Analytics for self-service data analytics.
-
Edit and Search HubDB External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of HubDB to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create HubDB objects that you can access from apps and the dashboard.
-
Access Live Teamwork Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Teamwork into the statistical analysis tools available in SAS JMP. This article shows how to use Teamwork in the Graph Builder and Query Builder.
-
Connect to Hugging Face 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 Hugging Face and work with Hugging Face in your FileMaker application.
-
Build Apps with Live Shortcut Data Using the Low-Code Development Platform of Mendix
Connect Shortcut with Mendix to build apps using the CData API Driver for JDBC.
-
Process & Analyze Instagram Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Instagram Data.
-
Connect to SAP ByDesign Data in DBArtisan
Use wizards in DBArtisan to configure SAP Business ByDesign as a data source.
-
Build Dashboards with Rootly Data in DBxtra
Create dynamic dashboards and perform analytics based on Rootly in DBxtra.
-
Access Live Dynamics 365 Business Central Data in AWS Lambda
Connect to live Dynamics 365 Business Central in AWS Lambda using the CData JDBC Driver.
-
Connect to SharePoint Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft SharePoint in the Denodo Virtual DataPort Administrator.
-
Create Informatica Mappings From/To a JDBC Data Source for Todoist
Create Todoist data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automate Paylocity Data Replication to Couchbase
Use CData Sync to Customize and automate Paylocity replication to Couchbase.
-
Integrating LlamaIndex with CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Apache CouchDB in real time.
-
Gmail Reporting in OBIEE with the Gmail JDBC Driver
Deploy the Gmail JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Adobe Commerce Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Amazon S3.
-
Model, Search, and Visualize Live SAP Ariba Source Data in ThoughtSpot
Use CData Connect AI to connect to live SAP Ariba Source for modeling, searching, and visualizing.
-
How to Create Power BI Visual Reports with Real-Time Quaderno Data
Use CData Power BI Connectors to visualize Quaderno in Power BI.
-
Deploy the ADO.NET Provider for eBay on an SSRS Report Server
Connect to eBay 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.
-
How to Seamlessly Import Bitbucket Data into IBM SPSS Modeler
Integrate Bitbucket data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Neo4J from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Neo4J, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Back Up Stripe to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Stripe. In this article, we will employ an SSIS workflow to populate a database with Stripe data.
-
Build Outreach.io-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Outreach.io and build Outreach.io-connected web apps with Axios.
-
Integrating Antigravity CLI with PDFMonkey via CData CLI
Connect PDFMonkey to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate with Sugar CRM Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sugar CRM to a JSON file on disk.
-
Automated Continuous Paymo Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Paymo replication to OneLake in Microsoft Fabric.
-
How to Work with SAP Ariba Source Data in ETL Validator JDBC
Connect to SAP Ariba Source from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP Business One
Create an ODBC connection to SAP Business One in Informatica and browse and transfer SAP Business One.
-
How to Seamlessly Import Toggl Data into IBM SPSS Modeler
Integrate Toggl data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Natively Connect to Splunk Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Splunk. Leverage the native support for ODBC in PHP.
-
Connect to CapsuleCRM Data in DBeaver
Use the CData ODBC Driver to connect to CapsuleCRM in DBeaver.
-
Salesforce Marketing Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Salesforce Marketing Cloud through CData Connect AI using different applications and tools.
-
Integrating GitHub Copilot CLI with LaunchDarkly 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 Data from Snapchat Ads into Google Sheets
Import Snapchat Ads into a Google spreadsheet that is automatically refreshed.
-
Automated Continuous LDAP Replication to Vertica
Use CData Sync for automated, continuous, customizable LDAP replication to Vertica.
-
Connect to SAP Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP ERP/NetWeaver using standard SQL.
-
Automated Continuous YouTube Analytics Replication to MySQL
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to MySQL.
-
Build Timely-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Timely.
-
Use Databricks Agent Bricks to Talk to Your LinkedIn Ads Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your LinkedIn Ads for you.
-
Visualize Live Snapchat Ads Data in the Power BI Service
Use CData Connect AI to connect to live Snapchat Ads and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous eBay Analytics Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable eBay Analytics replication to OneLake in Microsoft Fabric.
-
Integrating Kiro CLI with Procore 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 connect PolyBase to Oracle Eloqua Reporting
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle Eloqua Reporting.
-
Building Dynamic Web Pages with MariaDB Data Using AngularJS
Create single-page applications with live connectivity to MariaDB using the CData API Server.
-
Automated Continuous Mailgun Replication to Snowflake
Use CData Sync for automated, continuous, customizable Mailgun replication to Snowflake.
-
How to connect to Pipedrive Data in DBVisualizer
Integrate Pipedrive with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Freshservice Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Freshservice and build visualizations in Tableau.
-
Create Informatica Mappings From/To an ODBC Data Source for Raisers Edge NXT
Create an ODBC connection to Raisers Edge NXT in Informatica and browse and transfer Raisers Edge NXT.
-
How to connect to Dotmailer Data from Spring Boot
Connect to Dotmailer in a Spring Boot Application using the CData API Driver for JDBC
-
Excel Spreadsheet Automation on Sage 300 Data with the QUERY Formula
Pull data from Sage 300, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData Excel Add-In for Freshdesk
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Freshdesk.
-
Build Visualizations of Azure Data Catalog Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Azure Data Catalog in Birst.