CData Software - Knowledge Base
Recent Articles
-
Connect to Asana Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Asana Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Link ShipEngine with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ShipEngine data in Filemaker Pro for Mac or Windows.
-
Automated Continuous Invoiced Replication to SingleStore
Use CData Sync for automated, continuous, customizable Invoiced replication to SingleStore.
-
Build HDFS-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for HDFS Data and create custom apps in Mendix.
-
Replicate Telegram Data in Heroku for Use in Salesforce Connect
Replicate Telegram data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Model, Search, and Visualize Live Gmail Data in ThoughtSpot
Use CData Connect AI to connect to live Gmail data for modeling, searching, and visualizing.
-
Integrate with live Microsoft Entra ID Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Entra ID data in Jitterbit.
-
How to connect to Coda Data in DBVisualizer
Integrate Coda data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Reports from AfterShip Data in Looker Studio
Use CData Connect AI to gain access to live AfterShip data and create custom reports in Looker Studio.
-
Connect to Printful Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Printful as an External Source in Dremio.
-
Build a PostgreSQL Interface for Impala Data using the CData JDBC Driver
Use the Remoting features of the Impala JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for DB2 in MicroStrategy
Connect to DB2 data in MicroStrategy Developer using the CData Software ODBC Driver for DB2.
-
Import Real-Time PDFMonkey Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use PDFMonkey data in ColdFusion.
-
Integrate Live Google Directory Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Directory data to Blue Prism using the CData ODBC Driver for Google Directory to create automated workflows for repetitive business tasks.
-
Migrating data from PayPal to Snowflake using CData SSIS Components.
Easily push PayPal data to Snowflake using the CData SSIS Tasks for PayPal and Snowflake.
-
Publish Float-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Float data.
-
Integrate Cline with Live QuickBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live QuickBooks data from within your IDE.
-
Visualize eBay Analytics Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load eBay Analytics data into TIBCO Spotfire.
-
Integrate with live Cloudflare Data in Jitterbit
Use CData Connect AI to connect to and integrate live Cloudflare data in Jitterbit.
-
Automated Continuous Qualaroo Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Qualaroo replication to Azure SQL Database.
-
Use the CData ODBC Driver for Pipedrive from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Pipedrive to connect to Pipedrive data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Pipedrive data in Excel.
-
Use the CData Software ODBC Driver for Vault CRM in MicroStrategy Desktop
Connect to Vault CRM data in MicroStrategy Desktop using the CData Software ODBC Driver for Vault CRM.
-
Connect Freshteam to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Freshteam with IBM WebSphere for seamless data integration and connectivity.
-
Access Live MarkLogic Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate MarkLogic data into the statistical analysis tools available in SAS JMP. This article shows how to use MarkLogic data in the Graph Builder and Query Builder.
-
Connect to Avaza Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Avaza and the SQL Gateway to access Avaza data from Google Apps Script.
-
Visualize ScrapingBee Data in Sisense
Create an ElastiCube in Sisense app with access to ScrapingBee data.
-
How to create Campaigner federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Campaigner data in MySQL .
-
Connect to XML Data from a Connection Pool in JBoss
Integrate XML data into Java servlets: Use the Management Console in JBoss to install the XML JDBC Driver.
-
Migrating data from HubSpot to Databricks using CData SSIS Components.
Easily push HubSpot data to Databricks using the CData SSIS Tasks for HubSpot and Databricks.
-
Work with Salesforce Pardot Data in FoxPro
Load Salesforce Pardot data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Data Flows from Azure Synapse to SQL Server using SSIS
Easily back up Azure Synapse data to SQL Server using the SSIS components for Azure Synapse.
-
Replicate SAP HANA Data to Multiple Databases
Replicate SAP HANA data to disparate databases with a point-and-click configuration.
-
Getting Started with the CData Connect AI Python SDK for Google Sheets
Install the CData Connect AI Python SDK to read and write live Google Sheets data with standard DB-API 2.0 Python code.
-
Automate QuickBooks Online Data Replication to SAP HANA
Use CData Sync to customize and automate QuickBooks Online data replication to SAP HANA.
-
Use CData Connect AI to Access Testmonitor Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Testmonitor data in the Power Pivot business intelligence tool.
-
Bridge eBay Analytics Connectivity with Apache NiFi
Access and process eBay Analytics data in Apache NiFi using the CData JDBC Driver.
-
Build Tickspot-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Tickspot data and build web apps with connectivity to live Tickspot data.
-
Access Live Cloudant Data in Coginiti Pro
Connect to and query live Cloudant data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating Gumloop with HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on HBase data within automated workflows.
-
Visualize Live Access Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Access data.
-
Access Live Sage Intacct Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Sage Intacct data from your Excel spreadsheets.
-
Create Apps from Couchbase Data in Qlik Sense Cloud
Use CData Connect AI to connect to Couchbase Data and build apps from live Couchbase data in Qlik Sense Cloud.
-
Integrate Live Salesloft Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Salesloft from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Salesloft data.
-
Connect to HubDB Data in Claris FileMaker Pro
Use the CData ODBC Driver for HubDB in FileMaker Pro to connect to HubDB and work with HubDB data in your FileMaker applications.
-
Integrating Dataiku with Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Adobe Commerce data.
-
Building Dynamic Web Pages with Excel Online Data Using AngularJS
Create single-page applications with live connectivity to Excel Online using the CData API Server.
-
Model Cassandra Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Cassandra, enabling the direct import of real-time Cassandra data.
-
How to Connect to & Open Sybase IQ Data in Microsoft Excel
This article uses the CData ODBC driver for Sybase IQ to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Live Google Analytics Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Analytics data.
-
Moving Data from Twilio to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Twilio data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Datasets from Opsgenie in Domo Workbench and Build Visualizations of Opsgenie Data in Domo
Use the CData Software ODBC Driver for Opsgenie to create datasets from Opsgenie data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Live Microsoft Teams Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Microsoft Teams in CData Connect AI and connect to your Microsoft Teams data from PostgreSQL.
-
Replicate Freshdesk Data to Multiple Databases via the CData Sync CLI
Replicate Freshdesk data to disparate databases with a single configuration.
-
Access Slack Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Slack data from HeidiSQL.
-
Prepare, Blend, and Analyze SuiteCRM Data in Alteryx Designer (Connect AI)
Build workflows to access live SuiteCRM data for self-service data analytics.
-
Access Zoom Data from MySQL in PHP
Connect to Zoom through the standard MySQL libraries in PHP.
-
Object-Relational Mapping (ORM) with REST 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 REST data into a Java-based ORM framework, Hibernate.
-
Build MVC Applications with Connectivity to Google Forms Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Forms from an ASP.NET MVC application.
-
Connect to Clio Data from PowerBuilder via ADO.NET
This article demonstrates how to access Clio data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Analyze ServiceDesk Plus Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ServiceDesk Plus data and visualize ServiceDesk Plus data in SAP Analytics Cloud.
-
Access Live SAP HANA XS Advanced Data in Coginiti Pro
Connect to and query live SAP HANA XS Advanced data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating LangGraph with Mode Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Mode data within automated workflows.
-
Load Jumpseller Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Jumpseller data to a database.
-
Build a Singer.io Tap for Oracle Financials Cloud With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Oracle Financials Cloud data using the CData Python Connector.
-
Use Agno to Talk to Your Apify 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 Apify data for you.
-
Automate Airtable Data Replication to Azure Synapse
Use CData Sync to customize and automate Airtable data replication to Azure Synapse.
-
Visualize Databricks Data in Tableau
The CData ODBC driver for Databricks enables you integrate Databricks data into Tableau dashboards.
-
Integrate with Pipeline CRM Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Pipeline CRM data to a JSON file on disk.
-
Object-Relational Mapping (ORM) with TigerGraph 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 TigerGraph data into a Java-based ORM framework, Hibernate.
-
Connect to and Query Reply.io Data in QlikView over ODBC
Create data visualizations with Reply.io data in QlikView.
-
Integrate Zendesk with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zendesk with External Services.
-
How to update SAP Netweaver Gateway from Excel
This article explains how to transfer data from Excel to SAP Netweaver Gateway using the Excel Add-In for SAP Netweaver Gateway.
-
Use Azure AI Foundry to Talk to Your Microsoft OneDrive 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 Microsoft OneDrive data for you.
-
DataBind Controls to Ontraport Data in Delphi
DataBind to Ontraport data in Delphi with standard data access components and controls.
-
Integrate Live Jira Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Jira data and integrate live Jira data into apps built in Microsoft Power Apps.
-
Build Dashboards with Azure Analysis Services Data in Dundas BI
Create dynamic dashboards and perform analytics based on Azure Analysis Services data in Dundas BI.
-
Use the CData Software JDBC Driver for Shippo in MicroStrategy
Connect to Shippo data in MicroStrategy Developer using the CData Software JDBC Driver for Shippo.
-
Automated Continuous Azure Synapse Replication to SQLite
Use CData Sync for automated, continuous, customizable Azure Synapse replication to SQLite.
-
Integrate Goose with Live Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Jira data from within the local AI agent.
-
Use the CData Software ODBC Driver for Paylocity in MicroStrategy Web
Connect to Paylocity data in MicroStrategy Web using the CData Software ODBC Driver for Paylocity.
-
Create Informatica Mappings From/To an ODBC Data Source for Clockify
Create an ODBC connection to Clockify in Informatica and browse and transfer Clockify data.
-
Build AI Agents with Klaviyo Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Klaviyo data through CData Connect AI.
-
Connect to Live Adobe Commerce Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Adobe Commerce in CData Connect AI and connect to your Adobe Commerce data from PostgreSQL.
-
Build a Singer.io Tap for eBay With the CData Python Connector
Learn how to easily build a Singer.io Tap for live eBay data using the CData Python Connector.
-
Use the CData ODBC Driver for HBase from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for HBase to connect to HBase data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring HBase data in Excel.
-
Connect to IBM Informix Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for IBM Informix to connect to IBM Informix data and execute queries in PowerBuilder.
-
Seamlessly Bring SAP HANA Data into Retool Using CData Connect AI
Integrate SAP HANA data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
A PostgreSQL Interface for Zoho Recruit Data using the CData ODBC Driver
Use the SQL Gateway and Zoho Recruit ODBC Driver to create a PostgreSQL entry-point for data access.
-
Model Microsoft Teams Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Microsoft Teams, enabling the direct import of real-time Microsoft Teams data.
-
How to Create Power BI Visual Reports with Real-Time SAP SuccessFactors Data
Use CData Power BI Connectors to visualize SAP SuccessFactors data in Power BI.
-
View Reports on Real-Time Amazon Marketplace Data in Power BI Report Server
Use the CData ODBC Driver for Amazon Marketplace to visualize Amazon Marketplace data in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Dashboards and Visualize Live Vault CRM Data in Geckoboard
Use CData Connect AI to connect to live Vault CRM data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Bugsnag Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Bugsnag replication to PostgreSQL.
-
Query Live MariaDB Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live MariaDB data directly from the development environment.
-
Query Toggl Data as a MySQL Database in Node.js
Execute MySQL queries against Toggl data from Node.js.
-
Seamlessly Bring Campaigner Data into Retool Using CData Connect AI
Integrate Campaigner data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connecting Moonlit Workflow with Sage Intacct Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Sage Intacct data in real time.
-
Use the CData Software ODBC Driver for Codat in SAS for Real-Time Reporting and Analytics
Connect to real-time Codat data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Codat.
-
Rapidly Develop ZendeskSell-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 ZendeskSell.
-
Create SSAS Tabular Models from Retently Data
How to build a SQL Server Analysis Service Tabular Model from Retently data using CData drivers.