CData Software - Knowledge Base
Recent Articles
-
Integrate Shippo with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Shippo with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Shippo.
-
Integrate Presto Data into Power Automate Desktop using CData Connect
CData Connect for Presto Data enables you to integrate Presto into workflows built using Microsoft Power Automate Desktop.
-
Connect to Trello Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Trello.
-
Build Calendly-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Calendly and build web apps with connectivity to live Calendly.
-
Connect to Drift Data in Ruby
Connect to Drift in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Qualaroo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Qualaroo data access from reports, embedded analytics, and more.
-
How to Build an ETL App for iContact Data in Python with CData
Create ETL applications and real-time data pipelines for iContact in Python with petl.
-
DataBind Controls to Adobe Experience Manager Data in Delphi
DataBind to Adobe Experience Manager in Delphi with standard data access components and controls.
-
Build Agents in Relevance AI with Access to Live Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Sugar CRM within intelligent agent workflows.
-
How to Connect the Power BI Service to ConvertAPI: Complete Guide
Connect to the CData Software Power BI Connector for ConvertAPI from PowerBI.com to provide real-time ConvertAPI across the organization.
-
Import Instagram Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Instagram Data and provide access to live Instagram for custom reports in the Power BI Service.
-
Build Data Flows from SQL Server to LinkedIn through SSIS
Easily push SQL Server data to LinkedIn using the CData SSIS Tasks for LinkedIn.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Power BI XMLA within intelligent workflows.
-
Visualize Live ConvertAPI Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ConvertAPI using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Excel Spreadsheet Automation on Amazon DynamoDB Data with the QUERY Formula
Pull data from Amazon DynamoDB, automate spreadsheets, and more with the QUERY formula.
-
Query Vault CRM Data as a SQL Server Database in Node.js
Execute SQL Server queries against Veeva Vault & Vault CRM from Node.js.
-
Access RSS Feeds from MySQL in Amazon QuickSight
Connect to RSS and build visualizations of RSS Feeds using a MySQL Connection in Amazon QuickSight.
-
Integrate Live FTP Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live FTP Servers to Blue Prism using the CData ODBC Driver for FTP to create automated workflows for repetitive business tasks.
-
Access Live LightSpeedRetail Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate LightSpeedRetail into the statistical analysis tools available in SAS JMP. This article shows how to use LightSpeedRetail in the Graph Builder and Query Builder.
-
Access Live Cosmos DB Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Azure Cosmos DB through MCP integration.
-
Pipeliner CRM Reporting in OBIEE with the Pipeliner CRM JDBC Driver
Deploy the Pipeliner CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
LINQ to Impala Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Impala Data Provider.
-
Connect to Unbounce Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Unbounce and work with Unbounce in your FileMaker applications.
-
How to connect SharePoint with SAP Business One Data through external lists
Provide SAP Business One to SharePoint users as an external list.
-
Write a Simple Go Application to work with Zoho CRM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoho CRM.
-
Analyze Zendesk Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Zendesk with the CData JDBC Driver for Zendesk.
-
Rapidly Develop Hugging Face-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 Hugging Face.
-
Import Oracle Sales Data Using Azure Data Factory
Use CData Connect AI to connect to Oracle Sales Data from Azure Data Factory and import live Oracle Sales.
-
Use the CData ODBC Driver for Tickspot from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Tickspot to connect to Tickspot from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Tickspot in Excel.
-
Connecting GenSpark with Asana Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Asana without any replication or custom integration required.
-
How to Connect to Copper Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Copper. Leverage the pyodbc module for ODBC in Python.
-
Integrate Live ServiceNow Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ServiceNow to Blue Prism using the CData ODBC Driver for ServiceNow to create automated workflows for repetitive business tasks.
-
Connect to LinkedIn Ads Data from Crystal Reports
Use CData Connect AI to connect to and report on live LinkedIn Ads from Crystal Reports.
-
Configure the CData JDBC Driver for Rootly in a Connection Pool in Tomcat
Connect to Rootly from a connection pool in Tomcat.
-
Automated Continuous OData Replication to Oracle
Use CData Sync for automated, continuous, customizable OData replication to Oracle.
-
Analyze Raisers Edge NXT Data in Cognos Analytics
Use CData Connect AI to connect to Raisers Edge NXT Data from Cognos Analytics and analyze live Raisers Edge NXT.
-
Getting Started with the CData Tableau Connector for Microsoft Ads
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Microsoft Ads.
-
Integrate ServiceNow Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ServiceNow from Informatica Cloud.
-
How to publish and share Pinterest Data dashboards with Tableau Server
The CData ODBC driver for Pinterest enables you integrate Pinterest into Tableau dashboards.
-
Build Presto-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Presto and build Presto-connected web apps with Axios.
-
Connect to SAP HANA Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP HANA from HeidiSQL.
-
Integrating Claude Code CLI with Miro 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.
-
Query Attio Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Attio from Node.js.
-
Connect and Visualize Live Zendesk Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Zendesk into the Databricks platform and create visualization dashboards with real-time Zendesk.
-
How to Connect to Live Pipedrive 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 Pipedrive for you.
-
Create ADP-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ADP Data from Klipfolio and build custom visualizations using live ADP.
-
Getting Started with the CData ADO.NET Provider for Instantly
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrating Claude Code CLI with ScrapingBee 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 ZohoSubscriptions
Create ZohoSubscriptions data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Edit and Search External SAP SuccessFactors Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP SuccessFactors to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP SuccessFactors Data objects that you can access from apps and the dashboard.
-
Build Elasticsearch-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Elasticsearch to explore live Elasticsearch Data in Claude Code to assist with building Elasticsearch-powered applications.
-
Using the CData Software ODBC Driver for CampaignMonitor in PyCharm
Connect to CampaignMonitor as an ODBC data source in PyCharm using the CData Software ODBC Driver for CampaignMonitor.
-
Create Datasets from Blackbaud FE NXT in Domo Workbench and Build Visualizations of Blackbaud FE NXT Data in Domo
Use the CData Software ODBC Driver for Blackbaud FE NXT to create datasets from Blackbaud FE NXT in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData SSIS Components for SAP Fieldglass
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP Fieldglass.
-
Getting Started with the CData ODBC Driver for Qualaroo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Qualaroo.
-
Integrate with Dynamics 365 Business Central Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Dynamics 365 Business Central to a JSON file on disk.
-
Replicate SAP HANA XS Advanced Data in Heroku for Use in Salesforce Connect
Replicate SAP HANA XS Advanced to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to and Query Blackbaud FE NXT Data in QlikView over ODBC
Create data visualizations with Blackbaud FE NXT in QlikView.
-
Visualize Workday 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 Workday into TIBCO Spotfire.
-
Build Charts with Attio Data in Clear Analytics
Create dynamic charts and perform analytics based on Attio in Clear Analytics.
-
How to connect and process XML Files from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live XML Files.
-
Operational Reporting on OnePageCrm Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote OnePageCrm.
-
Create Sybase IQ-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Sybase IQ Data from OutSystems and build custom enterprise apps using live Sybase IQ.
-
Provide OData Services of LinkedIn Ads Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for LinkedIn Ads by developing a WCF Service Application.
-
Use the CData ODBC Driver for Avro from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Avro to connect to Apache Avro from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache Avro in Excel.
-
Build MVC Applications with Connectivity to MYOB AccountRight Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access MYOB AccountRight from an ASP.NET MVC application.
-
DataBind Controls to MarkLogic Data in Delphi
DataBind to MarkLogic in Delphi with standard data access components and controls.
-
Import GraphQL Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access GraphQL. In this article, you will use the OData format to import GraphQL into Microsoft Power Query.
-
Connect to SQL Analysis Services Data in Google Apps Script via Connect AI
Use CData Connect AI to access SQL Analysis Services in Google Apps Script.
-
Connect to Recurly in SpagoBI
Create reports featuring live Recurly in SpagoBI Studio. Host Recurly reports on SpagoBI Server.
-
Build Dashboards with Coinbase Data in Dundas BI
Create dynamic dashboards and perform analytics based on Coinbase in Dundas BI.
-
Integrate with VWO Data in JReport Designer
Create charts and reports based on VWO in JReport Designer.
-
Create Reports with ZohoMarketingHub Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoMarketingHub.
-
Consume Azure Table OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Azure Table feeds that reflect any changes in SAP Lumira.
-
Use the CData ODBC Driver for Google Analytics from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Analytics to connect to Google Analytics from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Analytics in Excel.
-
Import Real-Time Splunk Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Splunk in ColdFusion.
-
Connect JSON to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live JSON using the CData Python MCP Server.
-
Connecting Agentforce with Act-On 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 Act-On for you.
-
Connect to LinkedIn Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live LinkedIn.
-
How to Connect Flowise AI Agents to Live Kintone 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 Kintone without replication.
-
Create Perplexity Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Perplexity from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating LangGraph with PayPal Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on PayPal within automated workflows.
-
Create Apps from SingleStore Data in Qlik Sense Cloud
Use CData Connect AI to connect to SingleStore Data and build apps from live SingleStore in Qlik Sense Cloud.
-
Use the CData Software JDBC Driver for SQL Server in MicroStrategy
Connect to Microsoft SQL Server in MicroStrategy Developer using the CData Software JDBC Driver for SQL Server.
-
Connect to Live Zoho Projects Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Zoho Projects in CData Connect AI and connect to your Zoho Projects from PostgreSQL.
-
Use the CData Software ODBC Driver for Missive in MicroStrategy Web
Connect to Missive in MicroStrategy Web using the CData Software ODBC Driver for Missive.
-
How to Connect to Live API Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live API securely in real time.
-
Build Salesloft-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Salesloft to explore live Salesloft Data in Claude Code to assist with building Salesloft-powered applications.
-
Connect Testmonitor Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Testmonitor using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Hive Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apache Hive from your Oracle system.
-
Automated Continuous Certinia Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Certinia replication to Apache Kafka.
-
Visualize SendGrid Data in Sisense
Create an ElastiCube in Sisense app with access to SendGrid.
-
Use the CData API Server to Access SFTP Data in Microsoft PowerPivot
Use the CData API Server to connect to live SFTP in the Power Pivot business intelligence tool.
-
Feed CouchDB Data into FineReport
How to set Apache CouchDB as a JDBC data source in FineReport.
-
Integrate Live Jira Assets Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Jira Assets to Blue Prism using the CData ODBC Driver for Jira Assets to create automated workflows for repetitive business tasks.
-
Use Grok to Talk to Your Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Amazon Redshift for you.
-
Design BIRT Reports on Microsoft Dataverse Data
Provide current Microsoft Dataverse (CDS) to your embedded analytics.
-
Connect to SingleStore Data in CloverDX (formerly CloverETL)
Transfer SingleStore using the visual workflow in the CloverDX data integration tool.
-
Stream Zoho Books Data into Apache Kafka Topics
Access and stream Zoho Books in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Parquet
Provide connectivity to Apache Parquet through an SAP BusinessObjects universe.