CData Software - Knowledge Base
Recent Articles
-
Migrating data from Basecamp to Google BigQuery using CData SSIS Components.
Easily push Basecamp data to Google BigQuery using the CData SSIS Tasks for Basecamp and Google BigQuery.
-
Visualize Jodoo Data in Sisense
Create an ElastiCube in Sisense app with access to Jodoo data.
-
Integrating Cursor with Sage Cloud Accounting 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 Onfleet Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Onfleet data.
-
Create Egnyte-Connected Applications in Appsmith
Connect to Egnyte Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Egnyte data.
-
Connect Miro Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Miro data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Klipfolio Data into Power Automate Desktop using CData Connect
CData Connect for Klipfolio Data enables you to integrate Klipfolio data into workflows built using Microsoft Power Automate Desktop.
-
Replicate Certinia Data to Multiple Databases
Replicate Certinia data to disparate databases with a point-and-click configuration.
-
Visualize Live Mode Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Mode data into custom reports in Power BI.
-
How to Connect the Power BI Service to SAP Concur: Complete Guide
Connect to the CData Software Power BI Connector for SAP Concur from PowerBI.com to provide real-time SAP Concur data across the organization.
-
Analyze Salesforce CRM Analytics Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Salesforce CRM Analytics from Power Pivot. You will use the Table Import Wizard to load Salesforce CRM Analytics data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Live EmailOctopus Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live EmailOctopus data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Pipelines with Live PayPal Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to PayPal from Google Cloud Data Fusion, enabling the integration of live PayPal data into the building and management of effective data pipelines.
-
Build Semantic Layer Views for MongoDB Data in APOS Live Data Gateway
Use the CData Connector for MongoDB in APOS Live Data Gateway to build Semantic Layer Views for MongoDB data.
-
Connect to FTP Data in RazorSQL
Connect to FTP from wizards and query FTP data from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData Excel Add-In for Anaplan
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Anaplan.
-
Use the CData Software ODBC Driver for Email in MicroStrategy Desktop
Connect to Email data in MicroStrategy Desktop using the CData Software ODBC Driver for Email.
-
Connect to MessageBird Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for MessageBird data.
-
Visualize Vault CRM Data in TIBCO Spotfire through ADO.NET
Integrate Vault CRM data into dashboards in TIBCO Spotfire.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZendeskSell
Provide connectivity to ZendeskSell data through an SAP BusinessObjects universe.
-
Automated Continuous Zoho Creator Replication to Databricks
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Databricks.
-
Use Dash to Build to Web Apps on ADP Data
Create Python applications that use pandas and Dash to build ADP-connected web apps.
-
Edit and Search External SAP HANA Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP HANA data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP HANA Data objects that you can access from apps and the dashboard.
-
Use the CData Software JDBC Driver for Google Translate in MicroStrategy
Connect to Google Translate data in MicroStrategy Developer using the CData Software JDBC Driver for Google Translate.
-
Connect to Suadeo Data in Aqua Data Studio
Access Suadeo data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Configure the CData JDBC Driver for Tanda in a Connection Pool in Tomcat
Connect to Tanda data from a connection pool in Tomcat.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for GetResponse
Provide connectivity to GetResponse data through an SAP BusinessObjects universe.
-
A PostgreSQL Interface for Clio Data (MySQL Remoting via JDBC)
Use the Remoting features of the Clio JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Sage Intacct-Connected Apps in Choreo
Use CData Connect AI to connect to Sage Intacct Data from Choreo and build custom apps using live Sage Intacct data.
-
Link Simplesat with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Simplesat data in Filemaker Pro for Mac or Windows.
-
Use the CData Software JDBC Driver for Exact Online in MicroStrategy
Connect to Exact Online data in MicroStrategy Developer using the CData Software JDBC Driver for Exact Online.
-
Build a PostgreSQL Interface for OnePageCrm Data using the CData JDBC Driver
Use the Remoting features of the OnePageCrm JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Python Connector for Asana
Learn to install and license the CData Python Connector and configure a connection to live Asana data.
-
Build a Singer.io Tap for eBay Analytics With the CData Python Connector
Learn how to easily build a Singer.io Tap for live eBay Analytics data using the CData Python Connector.
-
Visualize Live Zoho Inventory Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Zoho Inventory data into custom reports in Power BI.
-
Easily Integrate Epicor Kinetic Data in Lazarus Pascal IDE
Learn how to easily integrate live Epicor Kinetic data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build OneNote Visualizations in Tableau Cloud
Use CData Connect AI to connect to live OneNote data and build visualizations in Tableau Cloud.
-
Connect to LeadDesk Data in RapidMiner
Integrate LeadDesk data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Browserless Data in Ruby
Connect to Browserless data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connecting Mastra with SAP Concur Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time SAP Concur data, no replication required.
-
Automated Continuous QuickBooks Online Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Google Cloud SQL.
-
Object-Relational Mapping (ORM) with Procore Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Procore data into a Java-based ORM framework, Hibernate.
-
Create Dynamic Invoiced Grids Using the Infragistics XamDataGrid
Learn how you can connect Invoiced to Infragistics XamDataGrid to build dynamic grids.
-
Build MVC Applications with Connectivity to Microsoft Ads Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Microsoft Ads from an ASP.NET MVC application.
-
Integrate MailerLite Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MailerLite data from Informatica Cloud.
-
Validate XML Data with QuerySurge
Access and validate XML data in QuerySurge using the CData JDBC Driver.
-
Build Mixpanel-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Mixpanel data and build web apps with connectivity to live Mixpanel data.
-
Connecting Mastra with FTP Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time FTP data, no replication required.
-
Getting Started with the CData Connect AI Python SDK for Cvent
Install the CData Connect AI Python SDK to read and write live Cvent data with standard DB-API 2.0 Python code.
-
Automate REST Data Replication to Azure Data Lake
Use CData Sync to customize and automate REST data replication to Azure Data Lake.
-
Getting Started with the CData Tableau Connector for Zoho Projects
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Zoho Projects.
-
Automated Continuous DocuSign Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable DocuSign replication to Amazon Redshift.
-
How to publish and share Oracle Sales Data dashboards with Tableau Server
The CData ODBC driver for Oracle Sales enables you integrate Oracle Sales data into Tableau dashboards.
-
Import Real-Time Reckon Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Reckon data in ColdFusion.
-
How to Connect to & Open Vercel Data in Microsoft Excel
This article uses the CData ODBC driver for Vercel to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Smartsheet Replication to SingleStore
Use CData Sync for automated, continuous, customizable Smartsheet replication to SingleStore.
-
Moving Data from Jumpseller to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Jumpseller data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect to & Open ADP Data in Microsoft Excel
This article uses the CData ODBC driver for ADP to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize CloudConvert Data in TIBCO Spotfire through ADO.NET
Integrate CloudConvert data into dashboards in TIBCO Spotfire.
-
Automated Continuous Kintone Replication to SQL Server
Use CData Sync for automated, continuous, customizable Kintone replication to SQL Server.
-
Query ServiceNow Data as a SQL Server Database in Node.js
Execute SQL Server queries against ServiceNow data from Node.js.
-
Import and Visualize Coda Data in Power View
Create data visualizations based on Coda data in Excel.
-
Create BigQuery-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to BigQuery Data from OutSystems and build custom enterprise apps using live BigQuery data.
-
Operational Reporting on Discourse Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Discourse data.
-
Automated Continuous Postmark Replication to SQL Server
Use CData Sync for automated, continuous, customizable Postmark replication to SQL Server.
-
Access Live Access Data in Coginiti Pro
Connect to and query live Access data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Apps from Oracle HCM Cloud Data in Qlik Sense Cloud
Use CData Connect AI to connect to Oracle HCM Cloud Data and build apps from live Oracle HCM Cloud data in Qlik Sense Cloud.
-
Automate Harvest Data Replication to SAP HANA
Use CData Sync to customize and automate Harvest data replication to SAP HANA.
-
Access Adobe Target Data from MySQL in PHP
Connect to Adobe Target through the standard MySQL libraries in PHP.
-
Connect to SurveyMonkey from a Connection Pool in WebLogic
Use the CData JDBC Driver for SurveyMonkey to connect to SurveyMonkey data from Web applications running on WebLogic.
-
Import DocuSign Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to DocuSign Data and provide access to live DocuSign data for custom reports in the Power BI Service.
-
Natively Connect to Simplesat Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Simplesat data. Leverage the native support for ODBC in PHP.
-
Build Okta-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Okta Data and create custom apps in Bubble.
-
Connect to Office 365 from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Office 365 data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Publish Crystal Reports on Datadog Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Datadog data.
-
Analyze Greenplum Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Greenplum data and visualize Greenplum data in SAP Analytics Cloud.
-
Analyze JotForm Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze JotForm data in Microsoft R Open.
-
Use the CData ODBC Driver for AdRoll in Microsoft Power Query
You can use the CData AdRoll ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import AdRoll data into Microsoft Power Query.
-
Integrate Trae with Live Airtable Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Airtable data from within the AI-powered IDE.
-
Build Charts with Adobe Commerce Data in Clear Analytics
Create dynamic charts and perform analytics based on Adobe Commerce data in Clear Analytics.
-
How to Visualize Splunk Data in Python with pandas
Use pandas and other modules to analyze and visualize live Splunk data in Python.
-
Use Azure AI Foundry to Talk to Your Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Odoo data for you.
-
Connect to Marketo Data from PowerBuilder via ADO.NET
This article demonstrates how to access Marketo data from Appeon PowerBuilder using the CData ADO.NET Provider for Marketo.
-
Access Live Active Directory Data in AWS Lambda
Connect to live Active Directory data in AWS Lambda using the CData JDBC Driver.
-
How to Connect to Live SparkPost 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 SparkPost data without replication.
-
Use the CData Software JDBC Driver for Templated in MicroStrategy Desktop
Connect to Templated data in MicroStrategy Desktop using the CData Software JDBC Driver for Templated.
-
Replicate Teamwork Data from PowerShell
Write a quick PowerShell script to query Teamwork data. Use connectivity to the live data to replicate Teamwork data to SQL Server.
-
Integrate Live Shippo Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Shippo from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Shippo data.
-
Build Apps with Live Sendwithus data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Sendwithus data into the Adalo platform and build custom mobile and web applications with real-time Sendwithus data.
-
Access Dropbox Data from MySQL in Amazon QuickSight
Connect to Dropbox and build visualizations of Dropbox data using a MySQL Connection in Amazon QuickSight.
-
Access Live ShipEngine Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ShipEngine data from your Excel spreadsheets.
-
How to Easily Query YouTube Analytics Data in OpenOffice Base
Connect to YouTube Analytics data in OpenOffice Base using the CData ODBC Driver for YouTube Analytics and generate reports with live data insights.
-
Publish Crystal Reports on SendPulse Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SendPulse data.
-
Access GitLab Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access GitLab data from your Oracle system.
-
How to integrate Google Campaign Manager 360 with Apache Airflow
Access and process Google Campaign Manager 360 data in Apache Airflow using the CData JDBC Driver.
-
Connect Foursquare to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Foursquare data using the CData Python MCP Server.
-
Create Dynamic Freshsales Grids Using the Infragistics XamDataGrid
Learn how you can connect Freshsales to Infragistics XamDataGrid to build dynamic grids.
-
Integrate with SendGrid Data in JReport Designer
Create charts and reports based on SendGrid data in JReport Designer.
-
Create Data Visualizations Based On GitHub Data in Mode
Use CData Connect AI to connect to GitHub Data from Mode and build visualizations using live GitHub data.
-
Integrate Live Oracle Sales Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Oracle Sales data from within the IDE.