CData Software - Knowledge Base
Recent Articles
-
Integrate Cursor with Live Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Twitter Ads from within the editor.
-
Using the CData Software ODBC Driver for Certinia in PyCharm
Connect to Certinia as an ODBC data source in PyCharm using the CData Software ODBC Driver for Certinia.
-
Use Agno to Talk to Your Dynamics CRM 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 Microsoft Dynamics CRM for you.
-
Connect to Certinia Data from PowerBuilder via ADO.NET
This article demonstrates how to access Certinia from Appeon PowerBuilder using the CData ADO.NET Provider for Certinia.
-
Add Azure DevOps Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Azure DevOps with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Build an ETL App for Shopify Data in Python with CData Connect AI
Build ETL pipelines that read and write live Shopify in Python with petl and the CData Connect AI Python SDK.
-
Build Omnisend-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Omnisend and build web apps with connectivity to live Omnisend.
-
Visualize Live FTP Data in the Power BI Service
Use CData Connect AI to connect to live FTP Servers and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Data Flows from SQL Server to Azure Table through SSIS
Easily push SQL Server data to Azure Table using the CData SSIS Tasks for Azure Table.
-
Access Cassandra Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Apache Cassandra from HeidiSQL.
-
Design BIRT Reports on xBase Data
Provide current xBase to your embedded analytics.
-
Access Shopify Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Shopify from your Oracle system.
-
Visualize Freshdesk Data in TIBCO Spotfire through ADO.NET
Integrate Freshdesk into dashboards in TIBCO Spotfire.
-
Build Data Flows from Neo4J to SQL Server using SSIS
Easily back up Neo4J to SQL Server using the SSIS components for Neo4J.
-
Automated Continuous ZarMoney Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ZarMoney replication to Google Cloud SQL.
-
Connect to Copper Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Copper in the Denodo Virtual DataPort Administrator.
-
Query IBM Cloud Object Storage Data from Node.js
Use the OData endpoint of the CData API Server to connect to your IBM Cloud Object Storage and perform CRUD operations on IBM Cloud Object Storage from Node.js.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Zoho Creator actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect to SAP BusinessObjects BI Data in RapidMiner
Integrate SAP BusinessObjects BI with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Create Power BI Visual Reports with Real-Time Jira Data
Use CData Power BI Connectors to visualize Atlassian Jira in Power BI.
-
Visualize Okta Data in Tableau
The CData ODBC driver for Okta enables you integrate Okta into Tableau dashboards.
-
Integrating Cursor CLI with Databricks 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.
-
Integrate Outreach.io Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Outreach.io and integrate live Outreach.io into your Power Automate tasks.
-
ETL VWO in Oracle Data Integrator
This article shows how to transfer VWO into a data warehouse using Oracle Data Integrator.
-
Integrate Open WebUI with Live ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live ADP from within the chat interface.
-
Replicate Brex Data from PowerShell
Write a quick PowerShell script to query Brex. Use connectivity to the live data to replicate Brex to SQL Server.
-
Integrate with live ShipStation Data in Jitterbit
Use CData Connect AI to connect to and integrate live ShipStation in Jitterbit.
-
Natively Connect to AlloyDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google AlloyDB. Leverage the native support for ODBC in PHP.
-
How to Easily Query GraphQL Data in OpenOffice Base
Connect to GraphQL data in OpenOffice Base using the CData ODBC Driver for GraphQL and generate reports with live data insights.
-
How to Connect the Power BI Service to Amplitude: Complete Guide
Connect to the CData Software Power BI Connector for Amplitude from PowerBI.com to provide real-time Amplitude across the organization.
-
Analyze MessageBird Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MessageBird in Microsoft R Open.
-
Visualize Databricks Data in TIBCO Spotfire through OData
Integrate Databricks into dashboards in TIBCO Spotfire.
-
Query Live SAS xpt 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 SAS XPORT directly from the development environment.
-
Use the CData Software JDBC Driver for Oracle in MicroStrategy Web
Connect to Oracle Database in MicroStrategy Web using the CData Software JDBC Driver for Oracle.
-
Create Informatica Mappings From/To an ODBC Data Source for Sage 200
Create an ODBC connection to Sage 200 in Informatica and browse and transfer Sage 200.
-
Bind Live FTP Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live FTP data
-
Integrating Antigravity CLI with Email via CData CLI
Connect Email to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect to SAP Netweaver Gateway Data from Spring Boot
Connect to SAP Netweaver Gateway in a Spring Boot Application using the CData JDBC Driver for SAP Netweaver Gateway
-
Viewing Gong Data in RAD Studio Data Explorer
How to view Gong in RAD Studio Data Explorer using the CData ODBC Driver for Gong.
-
Connect to Smartsheet Data in NetBeans
Connect to Smartsheet in NetBeans with the data source configuration wizard.
-
Automated Continuous HCL Domino Replication to Oracle
Use CData Sync for automated, continuous, customizable HCL Domino replication to Oracle.
-
Use Dash to Build to Web Apps on Oracle Financials Cloud Data
Create Python applications that use pandas and Dash to build Oracle Financials Cloud-connected web apps.
-
How to publish and share Shortcut Data dashboards with Tableau Server
The CData ODBC driver for Shortcut enables you integrate Shortcut into Tableau dashboards.
-
Automated Continuous HCL Domino Replication to Vertica
Use CData Sync for automated, continuous, customizable HCL Domino replication to Vertica.
-
Build Semantic Layer Views for Reckon Accounts Hosted Data in APOS Live Data Gateway
Use the CData Connector for Reckon Accounts Hosted in APOS Live Data Gateway to build Semantic Layer Views for Reckon Accounts Hosted.
-
Integrate Live Jira Assets Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Analyze Exact Online Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Exact Online from Power Pivot. You will use the Table Import Wizard to load Exact Online. You can visually build the import query or use any SQL supported by the driver.
-
How to connect to Snapchat Ads Data from Spring Boot
Connect to Snapchat Ads in a Spring Boot Application using the CData JDBC Driver for Snapchat Ads
-
Extract, Transform, and Load DocuSign Data in Informatica PowerCenter
Create a simple Workflow for DocuSign in Informatica PowerCenter.
-
Create Outreach.io Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Outreach.io from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create MarkLogic Dataflows on PowerBI.com
Connect to the CData Power BI Connector for MarkLogic from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query Copper Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Copper from Node.js.
-
Load RSS Feeds to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load RSS Feeds to a database.
-
Query ADP Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume ADP entities in PHP by modeling them as objects.
-
How to Connect DBeaver to Zoom via a JDBC Driver
Manage Zoom with visual tools in DBeaver like the query browser.
-
ConvertKit Reporting in OBIEE with the ConvertKit JDBC Driver
Deploy the ConvertKit JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Import and Visualize Sage 200 Data in Power View
Create data visualizations based on Sage 200 in Excel.
-
Connect to Hubstaff Data in RazorSQL
Connect to Hubstaff from wizards and query Hubstaff from the GUI in the RazorSQL database management tool.
-
Integrating Boomi Agentstudio with PostgreSQL Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to PostgreSQL, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Validate Coda Data with QuerySurge
Access and validate Coda in QuerySurge using the CData JDBC Driver.
-
Connecting Pipedream with MYOB AccountRight Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on MYOB AccountRight data in real time.
-
Connect to Delighted Data from PowerBuilder via JDBC
This article demonstrates how to access Delighted from PowerBuilder using the Delighted JDBC Driver.
-
Use the CData ODBC Driver for Couchbase in Microsoft Power Query
You can use the CData Couchbase ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Couchbase into Microsoft Power Query.
-
Working with Google Drive Data in LINQPad
Execute LINQ queries to Google Drive in LINQPad.
-
Build SendGrid Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SendGrid and build visualizations in Tableau Cloud.
-
Bridge FormSite Connectivity with Apache NiFi
Access and process FormSite in Apache NiFi using the CData JDBC Driver.
-
Integrate Goose with Live Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Jira Assets from within the local AI agent.
-
Connect to Cvent Data in ACL Analytics
Connect to Cvent via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Cvent.
-
Import Real-Time ServiceDesk Plus Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ServiceDesk Plus in ColdFusion.
-
Working with QuickBooks Time Data in LINQPad
Execute LINQ queries to QuickBooks Time in LINQPad.
-
Create Quickbase-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Quickbase Data from Klipfolio and build custom visualizations using live Quickbase.
-
How to connect to MailerLite Data from Spring Boot
Connect to MailerLite in a Spring Boot Application using the CData API Driver for JDBC
-
Build Dashboards with Act CRM Data in DBxtra
Create dynamic dashboards and perform analytics based on Act CRM in DBxtra.
-
How to publish and share SAP Fieldglass Data dashboards with Tableau Server
The CData ODBC driver for SAP Fieldglass enables you integrate SAP Fieldglass into Tableau dashboards.
-
Import and Visualize Sage Intacct Data in Power View
Create data visualizations based on Sage Intacct in Excel.
-
Visualize Google Tasks Data in Sisense
Create an ElastiCube in Sisense app with access to Google Tasks.
-
Visualize Live JSON Services in the Power BI Service
Use CData Connect AI to connect to live JSON and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Dashboards with Coda Data in DBxtra
Create dynamic dashboards and perform analytics based on Coda in DBxtra.
-
Use the CData API Server to Access eBay Analytics Data in Microsoft PowerPivot
Use the CData API Server to connect to live eBay Analytics in the Power Pivot business intelligence tool.
-
How to Measure Claude Token Reduction with CData Connect AI
Reproduce the published CData Connect AI token-reduction benchmark on your own data, or use it as a starting point to measure your own AI workloads.
-
Connecting Mastra with Sugar CRM 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 Sugar CRM, no replication required.
-
How to Connect the Power BI Service to Dynamics 365: Complete Guide
Connect to the CData Software Power BI Connector for Dynamics 365 from PowerBI.com to provide real-time Microsoft Dynamics 365 across the organization.
-
Create Reports from Freshservice Data in Looker Studio
Use CData Connect AI to gain access to live Freshservice and create custom reports in Looker Studio.
-
Integrating Kiro CLI with Monday.com 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 Datasets from LDAP in Domo Workbench and Build Visualizations of LDAP Objects in Domo
Use the CData Software ODBC Driver for LDAP to create datasets from LDAP in Domo Workbench and then build visualizations in the Domo service.
-
Build Charts with SurveyMonkey Data in Clear Analytics
Create dynamic charts and perform analytics based on SurveyMonkey in Clear Analytics.
-
Connect to Oracle HCM Cloud Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle HCM Cloud.
-
Automated Continuous Marketo Replication to MySQL
Use CData Sync for automated, continuous, customizable Marketo replication to MySQL.
-
Automated Continuous Jira Replication to Snowflake
Use CData Sync for automated, continuous, customizable Jira replication to Snowflake.
-
Integrating LlamaIndex with Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle HCM Cloud in real time.
-
ETL Google Calendar in Oracle Data Integrator
This article shows how to transfer Google Calendar into a data warehouse using Oracle Data Integrator.
-
DataBind Controls to Freshteam Data in Delphi
DataBind to Freshteam in Delphi with standard data access components and controls.
-
Build Semantic Layer Views for Acumatica Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Acumatica ERP.
-
Integrate Mode with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Mode with External Services.
-
A PostgreSQL Interface for Blackbaud FE NXT Data using the CData ODBC Driver
Use the SQL Gateway and Blackbaud FE NXT ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access SAS xpt Data from MySQL in PHP
Connect to SAS xpt through the standard MySQL libraries in PHP.
-
Connect to Access Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Access and the Script function in FileMaker Pro to connect to Access and work with Microsoft Access in your FileMaker application.
-
DataBind Charts to Teradata Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Teradata from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Use Claude to Talk to Your Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Google Spanner for you.
-
Connect to Jodoo Data in RapidMiner
Integrate Jodoo with standard components and data source configuration wizards in RapidMiner Studio.