CData Software - Knowledge Base
Recent Articles
-
Exact Online Reporting in OBIEE with the Exact Online JDBC Driver
Deploy the Exact Online JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Extend Google Sheets with SAP Concur Data
Make calls to SAP Concur from Google Apps Script via the API Server.
-
Automated Continuous Humanity Replication to Snowflake
Use CData Sync for automated, continuous, customizable Humanity replication to Snowflake.
-
Build Semantic Layer Views for DocuSign Data in APOS Live Data Gateway
Use the CData Connector for DocuSign in APOS Live Data Gateway to build Semantic Layer Views for DocuSign.
-
How to Connect to Jira Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Atlassian Jira. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Airtable Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Airtable replication to Amazon S3.
-
How to create Customer.io federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Customer.io in MySQL .
-
Create Reports from Oracle Service Cloud Data in Looker Studio
Use CData Connect AI to gain access to live Oracle Service Cloud and create custom reports in Looker Studio.
-
Migrating data from SAP SuccessFactors LMS to Snowflake using CData SSIS Components.
Easily push SAP SuccessFactors LMS to Snowflake using the CData SSIS Tasks for SAP SuccessFactors LMS and Snowflake.
-
Connect to Paylocity Data in JRuby
Create a simple JRuby app with access to live Paylocity.
-
Automate FreshBooks Data Replication to SAP HANA
Use CData Sync to customize and automate FreshBooks replication to SAP HANA.
-
Using the CData Software ODBC Driver for GraphQL in PyCharm
Connect to GraphQL as an ODBC data source in PyCharm using the CData Software ODBC Driver for GraphQL.
-
Query SpaceX Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SpaceX from Node.js.
-
Automated Continuous SingleStore Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SingleStore replication to delimited files (CSV/TSV).
-
Integrate with GetResponse Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy GetResponse to a JSON file on disk.
-
Build Voice Agents in ElevenLabs with access to Live Google Contacts Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Contacts.
-
Integrate Live SAP Hybris C4C Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Automated Azure Data Catalog Data Replication to Teradata
Use CData Sync to Customize and automate Azure Data Catalog replication to Teradata.
-
Explore Geographical Relationships in Tickspot Data with Power Map
Create data visualizations with Tickspot in Power Map.
-
Replicate SharePoint Excel Services Data to Multiple Databases via the CData Sync CLI
Replicate SharePoint Excel Services to disparate databases with a single configuration.
-
Create Reports with Oracle Eloqua Reporting Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Eloqua Reporting.
-
Analyze Twilio Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Twilio in Microsoft R Open.
-
Automate Oracle Sales Data Replication to SAP HANA
Use CData Sync to customize and automate Oracle Sales replication to SAP HANA.
-
Visualize Google Analytics Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Analytics.
-
Use the CData Software JDBC Driver for SAP SuccessFactors in MicroStrategy
Connect to SAP SuccessFactors in MicroStrategy Developer using the CData Software JDBC Driver for SAP SuccessFactors.
-
Validate Optimizely Data with QuerySurge
Access and validate Optimizely in QuerySurge using the CData JDBC Driver.
-
Getting Started with the CData Python Connector for PingOne
Learn to install and license the CData Python Connector
-
DataBind Controls to Anaplan Data in C++Builder
DataBind to Anaplan in C++Builder with standard components and controls.
-
Integrate with Zoom Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Zoom in SnapLogic.
-
Build a Singer.io Tap for SAP ByDesign With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP ByDesign data using
-
Publish Reports with Rebilly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Rebilly.
-
Getting Started with the CData Python Connector for SpaceX
Learn to install and license the CData Python Connector
-
Connect to Google Calendar Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Simplesat Data in DBArtisan
Use wizards in DBArtisan to configure Simplesat as a data source.
-
Automated Continuous Billsby Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Billsby replication to delimited files (CSV/TSV).
-
Automated Continuous Stripe Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Stripe replication to Google BigQuery.
-
How to work with FHIR Data in Apache Spark using SQL
Access and process FHIR Data in Apache Spark using the CData Software JDBC Driver.
-
Access Outlook Data from MySQL in Amazon QuickSight
Connect to Outlook and build visualizations of Outlook using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous EmailOctopus Replication to SQLite
Use CData Sync for automated, continuous, customizable EmailOctopus replication to SQLite.
-
Visualize Wave Financial Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Wave Financial.
-
Design BIRT Reports on Coda Data
Provide current Coda to your embedded analytics.
-
Connect to MYOB AccountRight Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for MYOB AccountRight to connect to MYOB AccountRight and execute queries in PowerBuilder.
-
Access Live Bitbucket Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Bitbucket data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Data Visualizations in Cognos BI with HubDB Data
Access HubDB as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate with Oracle Eloqua Data in JReport Designer
Create charts and reports based on Oracle Eloqua in JReport Designer.
-
Create Apps from SendGrid Data in Qlik Sense Cloud
Use CData Connect AI to connect to SendGrid Data and build apps from live SendGrid in Qlik Sense Cloud.
-
Access Shortcut Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Shortcut from HeidiSQL.
-
Integrating Claude Code with MongoDB Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on MongoDB within assisted coding and automated development workflows.
-
Integrate with IBM Cloud Object Storage Data in SnapLogic
Use CData Connect AI to connect to and integrate with live IBM Cloud Object Storage in SnapLogic.
-
Explore Geographical Relationships in Egnyte Data with Power Map
Create data visualizations with Egnyte in Power Map.
-
View Reports on Real-Time Reckon Accounts Hosted Data in Power BI Report Server
Use the CData ODBC Driver for Reckon Accounts Hosted to visualize Reckon Accounts Hosted in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software JDBC Driver for Deel in MicroStrategy Desktop
Connect to Deel in MicroStrategy Desktop using the CData Software JDBC Driver for Deel.
-
Work with Zendesk Data in FoxPro
Load Zendesk into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Amazon Athena Data into Power Automate Desktop using CData Connect
CData Connect for Amazon Athena Data enables you to integrate Amazon Athena into workflows built using Microsoft Power Automate Desktop.
-
How to create an RPA flow for Shippo Data in UiPath Studio
Use the Shippo ODBC Driver to create workflows that access real-time Shippo without any coding.
-
Integrate Live Trello Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to Datadog Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Datadog as an External Source in Dremio.
-
How to connect to Salesforce Data in DBVisualizer
Integrate Salesforce & Force.com with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Apps with Live WooCommerce Data Using the Low-Code Development Platform of Mendix
Connect WooCommerce with Mendix to build apps using the CData JDBC Driver for WooCommerce.
-
Use the CData Software ODBC Driver for Salesforce Data 360 in SAS for Real-Time Reporting and Analytics
Connect to real-time Salesforce Data 360 in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Salesforce Data 360.
-
Integrating OpenCode Terminal with Grafana 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 Access Live Sugar CRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Sugar CRM enables you to integrate Sugar CRM into workflows built using Microsoft Power Automate Desktop.
-
View Reports on Real-Time Printful Data in Power BI Report Server
Use the CData ODBC Driver for Printful to visualize Printful in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Dashboards with Twitter Ads Data in DBxtra
Create dynamic dashboards and perform analytics based on Twitter Ads in DBxtra.
-
Provide OData Services of Microsoft OneDrive Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft OneDrive by developing a WCF Service Application.
-
Integrating Cursor CLI with Bannerbear 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 Informatica Mappings From/To a JDBC Data Source for Codat
Create Codat data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Connect Flowise AI Agents to Live Salesforce Pardot Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Salesforce Pardot without replication.
-
Replicate Cloudant Data from PowerShell
Write a quick PowerShell script to query IBM Cloudant. Use connectivity to the live data to replicate IBM Cloudant to SQL Server.
-
How to create an RPA flow for Mocean Data in UiPath Studio
Use the Mocean ODBC Driver to create workflows that access real-time Mocean without any coding.
-
Use ChatGPT to Talk to Your HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Apache HBase for you.
-
Natively Connect to MySQL Data in PHP
The CData ODBC driver for MySQL enables you to create PHP applications with connectivity to MySQL. Leverage the native support for ODBC in PHP.
-
ETL ClickUp in Oracle Data Integrator
This article shows how to transfer ClickUp into a data warehouse using Oracle Data Integrator.
-
How to Use a Microsoft Access Database to Update Greenplum Data in Real Time
Update Greenplum data by creating a linked table in Microsoft Access with the CData Greenplum ODBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Forms
Provide connectivity to Google Forms through an SAP BusinessObjects universe.
-
How to create an RPA flow for Beeminder Data in UiPath Studio
Use the Beeminder ODBC Driver to create workflows that access real-time Beeminder without any coding.
-
Publish Postmark-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Postmark.
-
Integrate Google Calendar Data in the Pentaho Report Designer
Publish reports based on Google Calendar in the Pentaho BI tool.
-
Manage Simplesat Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Simplesat.
-
Access Live Trello 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 Trello through MCP integration.
-
Natively Connect to Microsoft Ads Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Ads. Leverage the native support for ODBC in PHP.
-
Integrating LlamaIndex with Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Microsoft Teams in real time.
-
How to Access OData Services Using Entity Framework
This article shows how to access OData using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Rapidly Develop Bitly-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 Bitly.
-
Publish WordPress-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live WordPress.
-
Access Live SAP Fieldglass Data in Excel 365 Online (Excel for the web)
Connect to SAP Fieldglass from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Semantic Layer Views for Outreach.io Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Outreach.io.
-
Replicate Multiple Bullhorn CRM Accounts
Replicate multiple Bullhorn CRM accounts to one or many databases.
-
Replicate Helpscout Data to Multiple Databases
Replicate Helpscout to disparate databases with a point-and-click configuration.
-
Back Up Google Contacts to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Contacts. In this article, we will employ an SSIS workflow to populate a database with Google Contacts data.
-
Getting Started with the CData Power BI Connector for SingleStore
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SingleStore.
-
Connecting Moonlit Workflow with Oracle Service Cloud 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 Oracle Service Cloud in real time.
-
Integrate with SAP Netweaver Gateway Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Netweaver Gateway to a JSON file on disk.
-
Build Visualizations of ShipStation Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ShipStation in Birst.
-
Rapidly Develop Yelp-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 Yelp.
-
Replicate Multiple Adobe Commerce Accounts
Replicate multiple Adobe Commerce accounts to one or many databases.
-
Publish Templated-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Templated.
-
Build Data Flows from SAP Business One to SQL Server using SSIS
Easily back up SAP Business One to SQL Server using the SSIS components for SAP Business One.
-
Connect to Toggl Data in HULFT Integrate
Connect to Toggl as a JDBC data source in HULFT Integrate
-
How to Connect Gong Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Gong data in real time using natural language.