CData Software - Knowledge Base
Recent Articles
-
Connecting GenSpark with NetSuite Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to NetSuite CRM & ERP without any replication or custom integration required.
-
Automate ChargeOver Data Replication to Azure Synapse
Use CData Sync to customize and automate ChargeOver replication to Azure Synapse.
-
Create Data Visualizations Based On Google Ads Data in Mode
Use CData Connect AI to connect to Google Ads Data from Mode and build visualizations using live
-
Creating CSV-Connected Applications in Unqork
You can use CData Connect AI to feed CSV/TSV Files to Unqork and build custom business apps.
-
Integrate Procore Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Procore from Informatica Cloud.
-
Create Data Visualizations Based On SAP Ariba Source Data in Mode
Use CData Connect AI to connect to SAP Ariba Source Data from Mode and build visualizations using live
-
Visualize Live Google Ad Manager Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Google Ad Manager into custom reports in Power BI.
-
Replicate Zoho Books Data in Heroku for Use in Salesforce Connect
Replicate Zoho Books to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build a Simple VCL Application for Flowlu Data
How to build a simple VCL Application to view Flowlu in RAD Studio using the CData ODBC Driver for Flowlu.
-
Query SAS Data Sets Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAS Data Sets and perform CRUD operations on SAS Data Sets from Node.js.
-
Bridge Telegram Connectivity with Apache NiFi
Access and process Telegram in Apache NiFi using the CData JDBC Driver.
-
Viewing Timely Data in RAD Studio Data Explorer
How to view Timely in RAD Studio Data Explorer using the CData ODBC Driver for Timely.
-
Build Power BI XMLA-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Power BI XMLA and build Power BI XMLA-connected web apps with Axios.
-
Connect to SAP Business One from Asprova with CData Software ODBC Driver for SAP Business One
This article shows how to connect faster to SAP Business One data from Asprova.
-
Use Azure AI Foundry to Talk to Your Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Microsoft Ads for you.
-
How to Work with OnePageCrm Data in AWS Glue Jobs Using JDBC
Connect to OnePageCrm from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Dashboards with Onfleet Data in Dundas BI
Create dynamic dashboards and perform analytics based on Onfleet in Dundas BI.
-
Query Datadog Data in ColdFusion
Write standard ColdFusion data access code to connect to Datadog.
-
How to Work with Hubstaff Data in AWS Glue Jobs Using JDBC
Connect to Hubstaff from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
ZohoExpense Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ZohoExpense facts in real time.
-
Build Delighted-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Delighted.
-
Analyze DB2 Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of IBM DB2 and visualize IBM DB2 in SAP Analytics Cloud.
-
Create Data Visualizations Based On MariaDB Data in Mode
Use CData Connect AI to connect to MariaDB Data from Mode and build visualizations using live
-
Build Voice Agents in ElevenLabs with access to Live Active Directory Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Active Directory.
-
Natively Connect to Pipeliner CRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Pipeliner CRM. Leverage the native support for ODBC in PHP.
-
Build SAP HANA XS Advanced-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SAP HANA XS Advanced to explore live SAP HANA XS Advanced Data in Claude Code to assist with building SAP HANA XS Advanced-powered applications.
-
Integrate with Zuora Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Zuora in SnapLogic.
-
Connect to Egnyte Data in RazorSQL
Connect to Egnyte from wizards and query Egnyte from the GUI in the RazorSQL database management tool.
-
Connect to Eventbrite Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Eventbrite and the SQL Gateway to access Eventbrite from Google Apps Script.
-
Analyze Auth0 Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Auth0 in Microsoft R Open.
-
Automated Continuous MailerLite Replication to Amazon S3
Use CData Sync for automated, continuous, customizable MailerLite replication to Amazon S3.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP Concur
Create SAP Concur data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft OneNote to Power BI dashboards. Simply drag and drop Microsoft OneNote into data visuals on the Power BI canvas.
-
Connect to Exa Data in CloverDX (formerly CloverETL)
Transfer Exa using the visual workflow in the CloverDX data integration tool.
-
Integrating Mocean Data in Talend Cloud Data Management Platform
Connect Mocean Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automate Google Directory Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Directory replication to Azure Data Lake.
-
Automated Continuous Wave Financial Replication to SingleStore
Use CData Sync for automated, continuous, customizable Wave Financial replication to SingleStore.
-
Build Data Flows from SQL Server to Blackbaud FE NXT through SSIS
Easily push SQL Server data to Blackbaud FE NXT using the CData SSIS Tasks for Blackbaud FE NXT.
-
How to Query Live Elasticsearch Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Elasticsearch data in natural language using Python.
-
Stream Dynamics 365 Business Central Data into Apache Kafka Topics
Access and stream Dynamics 365 Business Central in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build a Simple VCL Application for Toggl Data
How to build a simple VCL Application to view Toggl in RAD Studio using the CData ODBC Driver for Toggl.
-
Visualize Humanity Data in TIBCO Spotfire through ADO.NET
Integrate Humanity into dashboards in TIBCO Spotfire.
-
Easily Integrate Snapchat Ads Data in Lazarus Pascal IDE
Learn how to easily integrate live Snapchat Ads in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Establish a Live Connection with BambooHR Data using Tableau Bridge
The CData ODBC Driver for BambooHR enables you to integrate live BambooHR into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to BigCommerce from a Connection Pool in WebLogic
Use the CData JDBC Driver for BigCommerce to connect to BigCommerce from Web applications running on WebLogic.
-
Create Apps from Spark Data in Qlik Sense Cloud
Use CData Connect AI to connect to Spark Data and build apps from live Apache Spark SQL in Qlik Sense Cloud.
-
Replicate Dynamics NAV Data to Multiple Databases
Replicate Microsoft Dynamics NAV to disparate databases with a point-and-click configuration.
-
View Reports on Real-Time xBase Data in Power BI Report Server
Use the CData ODBC Driver for xBase to visualize xBase in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Reports with Google Spanner Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Spanner.
-
Connect to Gorgias Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Gorgias and work with Gorgias in your FileMaker applications.
-
Build Dashboards with Reckon Accounts Hosted Data in Dundas BI
Create dynamic dashboards and perform analytics based on Reckon Accounts Hosted in Dundas BI.
-
Create Azure Synapse-Connected Dashboards in Grafana
Connect to Azure Synapse Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Azure Synapse.
-
Getting Started with the CData ODBC Driver for Epicor Kinetic
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Epicor Kinetic.
-
Integrate with Live Jira Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Jira from the MuleSoft Anypoint Platform to integrate live Atlassian Jira into custom reports and dashboards.
-
Stream Bright Data Data into Apache Kafka Topics
Access and stream Bright Data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Migrating data from Rootly to Google BigQuery using CData SSIS Components.
Easily push Rootly to Google BigQuery using the CData SSIS Tasks for Rootly and Google BigQuery.
-
Choosing the Best Method to Connect Retently to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Retently from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Replicate Tavily Data from PowerShell
Write a quick PowerShell script to query Tavily. Use connectivity to the live data to replicate Tavily to SQL Server.
-
Build Dashboards with Greenplum Data in Dundas BI
Create dynamic dashboards and perform analytics based on Pivotal GreenPlum in Dundas BI.
-
Build an OLAP Cube in SSAS from Jira Assets Data
Establish a connection to Jira Assets data from SQL Server Analysis Services, and use the Jira Assets Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software ODBC Driver for Clio in MicroStrategy Web
Connect to Clio in MicroStrategy Web using the CData Software ODBC Driver for Clio.
-
Connect to Omnisend Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Omnisend in the Denodo Virtual DataPort Administrator.
-
Visualize Amazon S3 Data in Sisense
Create an ElastiCube in Sisense app with access to Amazon S3.
-
Automated Continuous Typeform Replication to Vertica
Use CData Sync for automated, continuous, customizable Typeform replication to Vertica.
-
Automated Continuous Google Tasks Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Tasks replication to Google BigQuery.
-
Use Biml to Build SSIS Tasks to Replicate CockroachDB Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate CockroachDB to SQL Server.
-
Create Informatica Mappings From/To a JDBC Data Source for NetSuite
Create NetSuite data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Prepare, Blend, and Analyze PolarTeamPro Data in Alteryx Designer (ODBC)
Build workflows to access live PolarTeamPro for self-service data analytics.
-
Provide OData Services of Power BI XMLA Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Power BI XMLA by developing a WCF Service Application.
-
Access Live Raisers Edge NXT Data in TIBCO Data Virtualization
Use the Raisers Edge NXT Tibco DV Adapter to create a Raisers Edge NXT data source in TIBCO Data Virtualization Studio and gain access to live Raisers Edge NXT from your TDV Server.
-
Configure the CData JDBC Driver for Strava in a Connection Pool in Tomcat
Connect to Strava from a connection pool in Tomcat.
-
How to Visualize SendInBlue Data in Python with pandas
Use pandas and other modules to analyze and visualize live SendInBlue in Python.
-
Access Live Cosmos DB Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Cosmos DB from your Google Sheets.
-
Replicate Microsoft Ads Data from PowerShell
Write a quick PowerShell script to query Microsoft Ads. Use connectivity to the live data to replicate Microsoft Ads to SQL Server.
-
Integrating GitHub Copilot CLI with Spotify 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.
-
Access Perplexity Data from MySQL in Amazon QuickSight
Connect to Perplexity and build visualizations of Perplexity using a MySQL Connection in Amazon QuickSight.
-
Access Pingdom Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Pingdom.
-
Bridge Azure Data Lake Storage Connectivity with Apache NiFi
Access and process Azure Data Lake Storage in Apache NiFi using the CData JDBC Driver.
-
Excel Spreadsheet Automation on Sendwithus Data with the QUERY Formula
Pull data from Sendwithus, automate spreadsheets, and more with the QUERY formula.
-
Feed Customer.io Data into FineReport
How to set Customer.io as a JDBC data source in FineReport.
-
Build MarkLogic-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live MarkLogic.
-
Back Up iContact to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with iContact data.
-
Replicate BambooHR Data in Heroku for Use in Salesforce Connect
Replicate BambooHR to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect PolyBase to Azure DevOps
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Azure DevOps.
-
Bidirectional Access to HCL Domino Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate HCL Domino in Filemaker Pro for Mac or Windows.
-
Edit and Search External DocuSign Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of DocuSign to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create DocuSign Data objects that you can access from apps and the dashboard.
-
Use JayDeBeApi to access OneNote Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft OneNote.
-
Provide OData Services of Instantly Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Instantly by developing a WCF Service Application.
-
DataBind Bannerbear Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Bannerbear to a chart.
-
Visualize Foursquare 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 Foursquare into TIBCO Spotfire.
-
Publish Reports with OData Services in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date OData.
-
Manage Elorus Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Elorus.
-
Replicate Nethunt Data to Multiple Databases
Replicate Nethunt to disparate databases with a point-and-click configuration.
-
Manage Copper Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Copper.
-
Create Data Visualizations in Cognos BI with ConvertAPI Data
Access ConvertAPI as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Apps with Live Sage Cloud Accounting Data Using the Low-Code Development Platform of Mendix
Connect Sage Business Cloud Accounting with Mendix to build apps using the CData JDBC Driver for Sage Cloud Accounting.
-
Connect Power BI XMLA to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Power BI XMLA with IBM WebSphere for seamless data integration and connectivity.
-
How to Build an ETL App for SendPulse Data in Python with CData
Create ETL applications and real-time data pipelines for SendPulse in Python with petl.
-
Integrating OpenCode Terminal with Act CRM 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.
-
Working with Raisers Edge NXT Data in LINQPad
Execute LINQ queries to Raisers Edge NXT in LINQPad.