CData Software - Knowledge Base
Recent Articles
-
Automated Continuous PostgreSQL Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Google BigQuery.
-
Build Automated Microsoft Teams-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft Teams and build automated workflows in Zapier.
-
Connect to Dynamics CRM Data in Google Apps Script via Connect AI
Use CData Connect AI to access Microsoft Dynamics CRM in Google Apps Script.
-
Connect to Cloudflare Data from a Connection Pool in JBoss
Integrate Cloudflare into Java servlets: Use the Management Console in JBoss to install the Cloudflare JDBC Driver.
-
How to Import Data from Oracle Eloqua Reporting into Google Sheets
Import Oracle Eloqua Reporting into a Google spreadsheet that is automatically refreshed.
-
Load CampaignMonitor Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load CampaignMonitor to a database.
-
How to create an RPA flow for TaxJar Data in UiPath Studio
Use the TaxJar ODBC Driver to create workflows that access real-time TaxJar without any coding.
-
Moving Data from ADP to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ADP data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access REST Data from MySQL in PHP
Connect to REST through the standard MySQL libraries in PHP.
-
How to Connect to MailerSend Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MailerSend. Leverage the pyodbc module for ODBC in Python.
-
Analyze Azure DevOps Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Azure DevOps and visualize live Azure DevOps in Infragistics Reveal.
-
Working with Gong Data in LINQPad
Execute LINQ queries to Gong in LINQPad.
-
How to Access Live Salesforce Marketing Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Salesforce Marketing enables you to integrate Salesforce Marketing Cloud into workflows built using Microsoft Power Automate Desktop.
-
Automate SAP Ariba Source Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP Ariba Source and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automated Continuous Odoo Replication to SQLite
Use CData Sync for automated, continuous, customizable Odoo replication to SQLite.
-
Create Bitly Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Bitly data access from reports, embedded analytics, and more.
-
View Reports on Real-Time Jira Data in Power BI Report Server
Use the CData ODBC Driver for Jira to visualize Atlassian Jira in Power BI Desktop and then publish them to Power BI Report Server.
-
Create WordPress-Connected Business Apps in AppSheet
Connect to WordPress Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to WordPress.
-
Build WooCommerce-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live WooCommerce.
-
Easily Integrate Okta Data in Lazarus Pascal IDE
Learn how to easily integrate live Okta in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Feed ServiceDesk Plus Data into FineReport
How to set ServiceDesk Plus as a JDBC data source in FineReport.
-
Connect to ShipStation Data in ACL Analytics
Connect to ShipStation via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to ShipStation.
-
Connect to Redshift Data in Google Apps Script via Connect AI
Use CData Connect AI to access Amazon Redshift in Google Apps Script.
-
Getting Started with the CData ODBC Driver for Pinterest
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Pinterest.
-
Visualize Delighted Data in TIBCO Spotfire through ADO.NET
Integrate Delighted into dashboards in TIBCO Spotfire.
-
Query Oracle Eloqua Reporting Data in ColdFusion
Write standard ColdFusion data access code to connect to Oracle Eloqua Reporting.
-
How to Connect to Live Trello Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Trello for you.
-
Consume Asana OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Asana feeds that reflect any changes in SAP Lumira.
-
How to connect to Monday.com Data from IntelliJ
Integrate connectivity to Monday.com with wizards in IntelliJ.
-
How to create an RPA flow for Act CRM Data in UiPath Studio
Use the Act CRM ODBC Driver to create workflows that access real-time Act CRM without any coding.
-
Integrating Codex CLI with Procore 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 Acumatica Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Acumatica ERP.
-
Publish Crystal Reports on Hubstaff Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Hubstaff.
-
Process & Analyze Ontraport Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Ontraport Data.
-
Integrate Live Square Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Square from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Square.
-
How to connect to Workday Data in DBVisualizer
Integrate Workday with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to BenchmarkEmail Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for BenchmarkEmail and the SQL Gateway to access BenchmarkEmail from Google Apps Script.
-
Build Acumatica-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Acumatica ERP and build web apps with connectivity to live Acumatica ERP.
-
How to Work with Parquet Data in ETL Validator JDBC
Connect to Parquet from ETL Validator jobs using the CData Software JDBC Driver.
-
Access SAP Tables and SAP Queries using CData SAP Providers
In this article we explain how our SAP products obtain table information and provide a free helper utility to add additional table schemas to our SAP Providers.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Front
Provide connectivity to Front through an SAP BusinessObjects universe.
-
Visualize Zuora Data in TIBCO Spotfire through ADO.NET
Integrate Zuora into dashboards in TIBCO Spotfire.
-
How to Query Live Mistral AI Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Mistral AI data in natural language using Python.
-
Connect to MariaDB 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 MariaDB.
-
Bind Live Oracle Eloqua Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Eloqua data
-
Build a PostgreSQL Interface for Zoom Data using the CData JDBC Driver
Use the Remoting features of the Zoom JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Live DB2 Data in Visual Studio Code via Cline
Run CData MCP Server for DB2 on Windows Subsytem for Linux (WSL) and connect to live IBM DB2 from the Cline extension in Visual Studio Code.
-
Connect to Redis Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Redis.
-
Use the CData ODBC Driver for LionDesk in Microsoft Power Query
You can use the CData LionDesk ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import LionDesk into Microsoft Power Query.
-
Consume Freshdesk OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Freshdesk feeds that reflect any changes in SAP Lumira.
-
Build Apps with Live Okta in Adalo using CData Connect AI
Use CData Connect AI to integrate live Okta into the Adalo platform and build custom mobile and web applications with real-time Okta.
-
Connect to Freshsales Data in JRuby
Create a simple JRuby app with access to live Freshsales.
-
Integrating Codex CLI with Sage 300 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 to Live Redshift Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Amazon Redshift for you.
-
Connect to Todoist Data in NetBeans
Connect to Todoist in NetBeans with the data source configuration wizard.
-
Automated Continuous SAP Ariba Source Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to MongoDB.
-
Getting Started with the CData ADO.NET Provider for Cohere
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Email Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Email.
-
Automated Continuous Jira Assets Replication to Oracle
Use CData Sync for automated, continuous, customizable Jira Assets replication to Oracle.
-
Automate Placid Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Placid from PowerShell? This article demonstrates how to utilize the Placid Cmdlets for tasks like connecting to Placid, automating operations, downloading data, and more.
-
Automated Continuous Couchbase Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Couchbase replication to AlloyDB.
-
Automated Continuous SAP BusinessObjects BI Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to SQL Server.
-
Create Microsoft Ads-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Microsoft Ads Data from Klipfolio and build custom visualizations using live Microsoft Ads.
-
Access IBM Cloud Object Storage Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access IBM Cloud Object Storage from your Oracle system.
-
How to Connect to Live Google Drive 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 Drive through natural language.
-
Build a PostgreSQL Interface for Zuora Data using the CData JDBC Driver
Use the Remoting features of the Zuora JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Automated Azure Synapse-Connected Workflows in Zapier
Use CData Connect AI to connect to live Azure Synapse and build automated workflows in Zapier.
-
Integrate Zoho Recruit with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zoho Recruit with External Services.
-
Analyze SAP Hybris C4C Data in Cognos Analytics
Use CData Connect AI to connect to SAP Hybris C4C Data from Cognos Analytics and analyze live SAP Hybris C4C.
-
Analyze ShipStation Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ShipStation and visualize ShipStation in SAP Analytics Cloud.
-
Query Live Authorize.Net 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 Authorize.Net directly from the development environment.
-
Integrate Campaigner with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Campaigner with External Services.
-
Use the CData Software JDBC Driver for Mouseflow in MicroStrategy
Connect to Mouseflow in MicroStrategy Developer using the CData Software JDBC Driver for Mouseflow.
-
How to Query Twitter Ads Data in MySQL Workbench
Execute MySQL queries against live Twitter Ads from MySQL Workbench.
-
Stream Humanity Data into Apache Kafka Topics
Access and stream Humanity in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Twilio from Asprova with CData Software ODBC Driver for Twilio
This article shows how to connect faster to Twilio data from Asprova.
-
Create Dashboards and Visualize Live QuickBooks Online Data in Geckoboard
Use CData Connect AI to connect to live QuickBooks Online and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Replicate Multiple Outreach.io Accounts via the CData Sync CLI
Replicate multiple Outreach.io accounts to one or many databases.
-
Build Odoo-Connected Apps in Choreo
Use CData Connect AI to connect to Odoo Data from Choreo and build custom apps using live Odoo ERP.
-
Validate SAP SuccessFactors Data with QuerySurge
Access and validate SAP SuccessFactors in QuerySurge using the CData JDBC Driver.
-
How to Connect to & Open ServiceDesk Plus Data in Microsoft Excel
This article uses the CData ODBC driver for ServiceDesk Plus to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Extend Google Sheets with Facebook Data
Make calls to Facebook from Google Apps Script via the API Server.
-
Integrate Cline with Live YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live YouTube Analytics from within your IDE.
-
How to Connect to Live CockroachDB 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 CockroachDB for you.
-
Integrating Unbounce Data in Talend Cloud Data Management Platform
Connect Unbounce Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to integrate SharePoint with Apache Airflow
Access and process Microsoft SharePoint in Apache Airflow using the CData JDBC Driver.
-
Using the CData Software ODBC Driver for Cassandra in PyCharm
Connect to Cassandra as an ODBC data source in PyCharm using the CData Software ODBC Driver for Cassandra.
-
Connect to Google Tasks Data in DBArtisan
Use wizards in DBArtisan to configure Google Tasks as a data source.
-
Integrate Cursor with Live Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Facebook Ads from within the editor.
-
Integrate SAP Ariba Source Data in the Pentaho Report Designer
Publish reports based on SAP Ariba Source in the Pentaho BI tool.
-
Connect SharePoint to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SharePoint with IBM WebSphere for seamless data integration and connectivity.
-
Connect to eBay Data from PowerBuilder via ADO.NET
This article demonstrates how to access eBay from Appeon PowerBuilder using the CData ADO.NET Provider for eBay.
-
Visualize Google Sheets Data in Tableau
The CData ODBC driver for Google Sheets enables you integrate Google Sheets data into Tableau dashboards.
-
How to connect to Dynamics CRM Data with Squirrel SQL client
Connect to Microsoft Dynamics CRM and execute queries in the Squirrel SQL Client.
-
Using the CData Software ODBC Driver for Webflow in PyCharm
Connect to Webflow as an ODBC data source in PyCharm using the CData Software ODBC Driver for Webflow.
-
Explore Geographical Relationships in Sage 300 Data with Power Map
Create data visualizations with Sage 300 in Power Map.
-
Connect to EnterpriseDB in SpagoBI
Create reports featuring live EnterpriseDB in SpagoBI Studio. Host EnterpriseDB reports on SpagoBI Server.
-
Create Informatica Mappings From/To an ODBC Data Source for Everhour
Create an ODBC connection to Everhour in Informatica and browse and transfer Everhour.
-
Replicate Multiple SAP HANA Accounts via the CData Sync CLI
Replicate multiple SAP HANA accounts to one or many databases.
-
Integrating OpenCode Terminal with Dynamics NAV 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.