CData Software - Knowledge Base
Recent Articles
-
Connect to Twilio Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Twilio.
-
Establish a Live Connection with ChargeOver Data using Tableau Bridge
The CData ODBC Driver for ChargeOver enables you to integrate live ChargeOver data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData ODBC Driver for Printful in Microsoft Power Query
You can use the CData Printful ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Printful data into Microsoft Power Query.
-
Migrating data from ZendeskSell to Google BigQuery using CData SSIS Components.
Easily push ZendeskSell data to Google BigQuery using the CData SSIS Tasks for ZendeskSell and Google BigQuery.
-
How to Visualize FTP Data in Python with pandas
Use pandas and other modules to analyze and visualize live FTP data in Python.
-
Use Biml to Build SSIS Tasks to Replicate Microsoft Planner Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Planner data to SQL Server.
-
Visualize Tavily 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 Tavily data into TIBCO Spotfire.
-
Analyze Snapchat Ads Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Snapchat Ads data and visualize Snapchat Ads data in SAP Analytics Cloud.
-
Use the CData Software ODBC Driver for Yelp in MicroStrategy Desktop
Connect to Yelp data in MicroStrategy Desktop using the CData Software ODBC Driver for Yelp.
-
Automated Continuous Reckon Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Reckon replication to Google BigQuery.
-
How to load Exact Online data into Elasticsearch via Logstash
Introducing a simple method to load Exact Online data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Azure Synapse Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Azure Synapse Data and connect to Azure Synapse data in Akorbi Digital RunMyProcess.
-
Analyze Perigon Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Perigon from Power Pivot. You will use the Table Import Wizard to load Perigon data. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Claude Code with Bannerbear Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Bannerbear data within assisted coding and automated development workflows.
-
Integrating Antigravity CLI with Jumpseller data via CData CLI
Connect Jumpseller data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Natively Connect to SharePoint Data in PHP
The CData ODBC driver for SharePoint enables you to create PHP applications with connectivity to SharePoint data. Leverage the native support for ODBC in PHP.
-
How to connect to Opsgenie Data in DBVisualizer
Integrate Opsgenie data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Beeminder Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Beeminder replication to Azure SQL Database.
-
Use the CData Software ODBC Driver for OnePageCrm in MicroStrategy Web
Connect to OnePageCrm data in MicroStrategy Web using the CData Software ODBC Driver for OnePageCrm.
-
Access Live GitLab Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to GitLab data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connecting Agentforce with MariaDB 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 MariaDB data for you.
-
Automated Continuous Azure Blob Storage Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Apache Kafka.
-
Connect to AgileCRM Data from a Connection Pool in Jetty
The AgileCRM JDBC Driver supports connection pooling: This article shows how to connect faster to AgileCRM data from Web apps in Jetty.
-
Connect to Xero Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Xero data.
-
Build Apps with Live BenchmarkEmail data in Adalo using CData Connect AI
Use CData Connect AI to integrate live BenchmarkEmail data into the Adalo platform and build custom mobile and web applications with real-time BenchmarkEmail data.
-
Connect to OData Services in CloverDX (formerly CloverETL)
Transfer OData services using the visual workflow in the CloverDX data integration tool.
-
Create a Data Access Object for Workable Data using JDBI
A brief overview of creating a SQL Object API for Workable data in JDBI.
-
Getting Started with the CData ADO.NET Provider for Dynamics 365
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Dynamics 365.
-
Access Live Phoenix Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Phoenix data from your Excel spreadsheets.
-
Automated Continuous Teamwork Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Teamwork replication to IBM DB2.
-
Dynamics NAV Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Dynamics NAV facts in real time.
-
Migrating data from CockroachDB to Databricks using CData SSIS Components.
Easily push CockroachDB data to Databricks using the CData SSIS Tasks for CockroachDB and Databricks.
-
Query Live CockroachDB 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 CockroachDB data directly from the development environment.
-
Build MVC Applications with Connectivity to Zoho Books Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoho Books from an ASP.NET MVC application.
-
Connect to Parallel Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Parallel and the SQL Gateway to access Parallel data from Google Apps Script.
-
Work with JobNimbus Data in FoxPro
Load JobNimbus data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use JayDeBeApi to access Dynamics NAV Data in Python
Use standard Python scripting and the development environment of your choice to access live Dynamics NAV data.
-
Replicate Multiple Cassandra Accounts via the CData Sync CLI
Replicate multiple Cassandra accounts to one or many databases.
-
Create Informatica Mappings From/To a JDBC Data Source for Neo4J
Create Neo4J data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Instantly 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 Instantly and work with Instantly data in your FileMaker application.
-
Getting Started with the CData SSIS Components for Shopify
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Shopify.
-
Build MVC Applications with Connectivity to ShipEngine Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ShipEngine from an ASP.NET MVC application.
-
Getting Started with the CData ADO.NET Provider for Google Translate
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Mouseflow
Provide connectivity to Mouseflow data through an SAP BusinessObjects universe.
-
Integrating Gumloop with Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Highrise data within automated workflows.
-
Operational Reporting on Figshare Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Figshare data.
-
Connect to Basecamp Data in JRuby
Create a simple JRuby app with access to live Basecamp data.
-
Query Ontraport Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Ontraport data from Node.js.
-
Connect to ShipEngine Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live ShipEngine data from Filemaker Pro on Mac.
-
Create Informatica Mappings From/To an ODBC Data Source for Yelp
Create an ODBC connection to Yelp in Informatica and browse and transfer Yelp data.
-
Automated Continuous SAP SuccessFactors Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Apache Kafka.
-
Build Semantic Layer Views for AdRoll Data in APOS Live Data Gateway
Use the CData Connector for AdRoll in APOS Live Data Gateway to build Semantic Layer Views for AdRoll data.
-
Create Reports with SAP HANA XS Advanced Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP HANA XS Advanced data.
-
Getting Started with the CData Tableau Connector for Bullhorn CRM
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Bullhorn CRM.
-
Oracle HCM Cloud Reporting in OBIEE with the Oracle HCM Cloud JDBC Driver
Deploy the Oracle HCM Cloud JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect Notion Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Notion data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to Live Google Spanner Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Google Spanner data through natural language.
-
How to connect and process Zendesk data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Zendesk data.
-
Work with MessageBird Data in FoxPro
Load MessageBird data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to connect to SingleStore Data from Spring Boot
Connect to SingleStore in a Spring Boot Application using the CData JDBC Driver for SingleStore
-
Build Apps with Live Sugar CRM data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Sugar CRM data into the Adalo platform and build custom mobile and web applications with real-time Sugar CRM data.
-
Connect to and Visualize Live Teradata Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Teradata data.
-
Connect to Mixpanel Data in DBeaver
Use the CData ODBC Driver to connect to Mixpanel data in DBeaver.
-
Automated Continuous MarkLogic Replication to Databricks
Use CData Sync for automated, continuous, customizable MarkLogic replication to Databricks.
-
Connect to Sage Intacct Data in ACL Analytics
Connect to Sage Intacct data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Sage Intacct data.
-
Automated Continuous Figshare Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Figshare replication to Amazon Redshift.
-
Integrate Open WebUI with Live ZohoExpense Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live ZohoExpense data from within the chat interface.
-
How to connect Amazon QuickSight to Google Calendar Data
Create a connection to Google Calendar data in CData Connect AI and insert Google Calendar data into Amazon QuickSight SPICE to build interactive dashboards.
-
Feed Coinbase Data into FineReport
How to set Coinbase data as a JDBC data source in FineReport.
-
Integrate Zoho Projects Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zoho Projects data from Informatica Cloud.
-
A PostgreSQL Interface for GraphQL Data using the CData ODBC Driver
Use the SQL Gateway and GraphQL ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Monday.com 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 Monday.com data without replication.
-
Use Dash to Build to Web Apps on FreeAgent Data
Create Python applications that use pandas and Dash to build FreeAgent-connected web apps.
-
Automated Continuous Dynamics CRM Replication to Oracle
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Oracle.
-
How to Connect to Live Dropbox Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Dropbox data for you.
-
Access Live QuickBooks Online 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 QuickBooks Online data through MCP integration.
-
Access Live Oracle Service Cloud Data in TIBCO Data Virtualization
Use the Oracle Service Cloud Tibco DV Adapter to create a Oracle Service Cloud data data source in TIBCO Data Virtualization Studio and gain access to live Oracle Service Cloud data from your TDV Server.
-
Integrating SAP Ariba Source Data in Talend Cloud Data Management Platform
Connect SAP Ariba Source Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP Ariba Source.
-
Analyze Google Analytics Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Analytics from Power Pivot. You will use the Table Import Wizard to load Google Analytics data. You can visually build the import query or use any SQL supported by the driver.
-
Access Datadog Data from MySQL in Amazon QuickSight
Connect to Datadog and build visualizations of Datadog data using a MySQL Connection in Amazon QuickSight.
-
Visualize SageHR Data in Sisense
Create an ElastiCube in Sisense app with access to SageHR data.
-
Automate CockroachDB Data Replication to Azure Synapse
Use CData Sync to customize and automate CockroachDB data replication to Azure Synapse.
-
Interact with Live Marketo Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Marketo data.
-
Build Apps with Live SFTP Data Using the Low-Code Development Platform of Mendix
Connect SFTP data with Mendix to build apps using the CData JDBC Driver for SFTP.
-
Connect to ZendeskSell Data in HULFT Integrate
Connect to ZendeskSell as a JDBC data source in HULFT Integrate
-
How to Connect to Live Oracle Financials Cloud 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 Oracle Financials Cloud data without replication.
-
Natively Connect to BigQuery Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to BigQuery data. Leverage the native support for ODBC in PHP.
-
Analyze Outreach.io Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Outreach.io data with the CData JDBC Driver for Outreach.io.
-
Extract, Transform, and Load XML Data in Informatica PowerCenter
Create a simple Workflow for XML data in Informatica PowerCenter.
-
Getting Started with the CData Connect AI Python SDK for ServiceDesk Plus
Install the CData Connect AI Python SDK to read live ServiceDesk Plus data with standard DB-API 2.0 Python code.
-
How to integrate Freshservice with Apache Airflow
Access and process Freshservice data in Apache Airflow using the CData JDBC Driver.
-
Integrating Claude Code with MYOB AccountRight Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on MYOB AccountRight data within assisted coding and automated development workflows.
-
Create a Data Access Object for Intercom Data using JDBI
A brief overview of creating a SQL Object API for Intercom data in JDBI.
-
Integrate Google's Vertex AI Agent with Live Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Klaviyo data within intelligent workflows.
-
Connect to NetSuite Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live NetSuite data.
-
Create Apps from SageHR Data in Qlik Sense Cloud
Use CData Connect AI to connect to SageHR Data and build apps from live SageHR data in Qlik Sense Cloud.
-
Visualize Live ZohoExpense Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ZohoExpense data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create SSAS Tabular Models from Jumpseller Data
How to build a SQL Server Analysis Service Tabular Model from Jumpseller data using CData drivers.
-
Connect to Real-Time Square Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Square and Dataflow to import and use Square data in Power Apps.
-
Connect to and Visualize Live VWO Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live VWO data.