CData Software - Knowledge Base
Recent Articles
-
Access Live Excel Data in Coginiti Pro
Connect to and query live Microsoft Excel from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Cursor with Live HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live HCL Domino from within the editor.
-
Integrate with Clari Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Clari to a JSON file on disk.
-
Build AI/ML Models with Live Azure Table Data using Dataiku
Connect Azure Table Data with Dataiku using the CData JDBC Driver for Azure.
-
Integrating Cursor CLI with Attio 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.
-
Replicate Avaza Data to Multiple Databases via the CData Sync CLI
Replicate Avaza to disparate databases with a single configuration.
-
Replicate Multiple Neo4J Accounts via the CData Sync CLI
Replicate multiple Neo4J accounts to one or many databases.
-
Access Live Microsoft Ads Data in Excel 365 Online (Excel for the web)
Connect to Microsoft Ads from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Adobe Commerce Data in HULFT Integrate
Connect to Adobe Commerce as a JDBC data source in HULFT Integrate
-
Use the CData ODBC Driver for ZohoExpense in Microsoft Power Query
You can use the CData ZohoExpense ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ZohoExpense into Microsoft Power Query.
-
Analyze Pushbullet Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Pushbullet and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Microsoft Dataverse Data in Aqua Data Studio
Access Microsoft Dataverse (CDS) from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Operational Reporting on IBM Cloud Object Storage Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote IBM Cloud Object Storage.
-
Automate SAP Netweaver Gateway Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Netweaver Gateway from PowerShell? This article demonstrates how to utilize the SAP Netweaver Gateway Cmdlets for tasks like connecting to SAP Netweaver Gateway, automating operations, downloading data, and more.
-
Automate Oracle Sales Data Replication to Azure Data Lake
Use CData Sync to customize and automate Oracle Sales replication to Azure Data Lake.
-
How to Build an ETL App for CampaignMonitor Data in Python with CData
Create ETL applications and real-time data pipelines for CampaignMonitor in Python with petl.
-
Extend Google Sheets with Slack Data
Make calls to Slack from Google Apps Script via the API Server.
-
Build Automated Workflows with Live Greenhouse Data in Workato
Use CData Connect AI to connect to live Greenhouse and build automated workflows in Workato.
-
Create Informatica Mappings From/To a JDBC Data Source for Snowflake
Create Snowflake data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Dataiku with Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Email.
-
Build FHIR-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for FHIR to explore live FHIR Data in Gemini Code Assist to assist with building FHIR-powered applications.
-
Build Visualizations of Dynamics 365 Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Dynamics 365 in Birst.
-
Integrating Cursor CLI with CouchDB 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.
-
Work with Live Google Ads Data in Power Query
Use CData Connect AI to connect to Google Ads and work with live Google Ads in Microsoft Power Query.
-
Connect to Pipeline CRM Data from PowerBuilder via JDBC
This article demonstrates how to access Pipeline CRM from PowerBuilder using the Pipeline CRM JDBC Driver.
-
How to Connect to Spark Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apache Spark SQL. Leverage the pyodbc module for ODBC in Python.
-
Import and Visualize Zoho Creator Data in Power View
Create data visualizations based on Zoho Creator in Excel.
-
Access Live Jira Assets Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Jira Assets from your Google Sheets.
-
How to connect to Hive Data from Spring Boot
Connect to Hive in a Spring Boot Application using the CData JDBC Driver for Apache Hive
-
Easily Integrate SAP Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP ERP/NetWeaver in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Bind Live Onfleet Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Onfleet data
-
Provide OData Services of Amazon S3 Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Amazon S3 by developing a WCF Service Application.
-
Create Informatica Mappings From/To an ODBC Data Source for BigQuery
Create an ODBC connection to BigQuery in Informatica and browse and transfer Google BigQuery.
-
Use the CData API Server to Access Mouseflow Data in Microsoft PowerPivot
Use the CData API Server to connect to live Mouseflow in the Power Pivot business intelligence tool.
-
Build Data Flows from SAP SuccessFactors LMS to SQL Server using SSIS
Easily back up SAP SuccessFactors LMS to SQL Server using the SSIS components for SAP SuccessFactors LMS.
-
Seamlessly Bring Adobe Analytics Data into Retool Using CData Connect AI
Integrate Adobe Analytics data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to connect to Vault CRM Data with Squirrel SQL client
Connect to Veeva Vault & Vault CRM and execute queries in the Squirrel SQL Client.
-
Automated Continuous Front Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Front replication to PostgreSQL.
-
Analyze Active Directory Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Active Directory and visualize Active Directory in SAP Analytics Cloud.
-
Automated Continuous Printful Replication to Oracle
Use CData Sync for automated, continuous, customizable Printful replication to Oracle.
-
Build Microsoft Ads Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Ads and build visualizations in Tableau.
-
Replicate Multiple Excel Accounts
Replicate multiple Excel accounts to one or many databases.
-
SAP Fieldglass Reporting in OBIEE with the SAP Fieldglass JDBC Driver
Deploy the SAP Fieldglass JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Excel Spreadsheet Automation on Telegram Data with the QUERY Formula
Pull data from Telegram, automate spreadsheets, and more with the QUERY formula.
-
Publish Crystal Reports on Clio Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Clio.
-
Use the CData Software ODBC Driver for Google Analytics in MicroStrategy Web
Connect to Google Analytics in MicroStrategy Web using the CData Software ODBC Driver for Google Analytics.
-
Access Live MailerLite Data in AWS Lambda (with IntelliJ IDEA)
Connect to live MailerLite in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software JDBC Driver for SAP Hybris C4C in MicroStrategy Desktop
Connect to SAP Hybris C4C in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Hybris C4C.
-
How to create Rebilly federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Rebilly in MySQL .
-
Write a Simple Go Application to work with SAP SuccessFactors Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP SuccessFactors.
-
Analyze Sage 200 Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Sage 200 and visualize live Sage 200 in Infragistics Reveal.
-
Connect Spotify Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Spotify using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData Software ODBC Driver for Demio in MicroStrategy Desktop
Connect to Demio in MicroStrategy Desktop using the CData Software ODBC Driver for Demio.
-
How to Connect to Live FTP Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live FTP Servers securely in real time.
-
Use the CData ODBC Driver for Perigon from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Perigon to connect to Perigon from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Perigon in Excel.
-
Query Airtable Data as a MySQL Database in Node.js
Execute MySQL queries against Airtable from Node.js.
-
Explore Geographical Relationships in eBay Analytics Data with Power Map
Create data visualizations with eBay Analytics in Power Map.
-
How to Work with Microsoft Planner Data in ETL Validator JDBC
Connect to Microsoft Planner from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Splunk Data in TIBCO Spotfire through ADO.NET
Integrate Splunk into dashboards in TIBCO Spotfire.
-
Create Reports with Pinterest Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pinterest.
-
Validate Microsoft Entra ID Data with QuerySurge
Access and validate Microsoft Entra ID in QuerySurge using the CData JDBC Driver.
-
Use the CData API Server to Access Sage Intacct Data in Microsoft PowerPivot
Use the CData API Server to connect to live Sage Intacct in the Power Pivot business intelligence tool.
-
Integrate Live WordPress Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to WordPress and integrate live WordPress into apps built in Microsoft Power Apps.
-
Access SpaceX Data from MySQL in PHP
Connect to SpaceX through the standard MySQL libraries in PHP.
-
How to connect and process Calendly from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Calendly.
-
Query MYOB AccountRight Data through ODBC in Node.js
Use node-odbc to execute SQL queries against MYOB AccountRight from Node.js.
-
Use the CData Software ODBC Driver for Dynamics CRM in MicroStrategy
Connect to Microsoft Dynamics CRM in MicroStrategy Developer using the CData Software ODBC Driver for Dynamics CRM.
-
Rapidly Develop ElevenLabs-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 ElevenLabs.
-
How to Query ShipStation Data in MySQL Workbench
Execute MySQL queries against live ShipStation from MySQL Workbench.
-
ETL Bitbucket in Oracle Data Integrator
This article shows how to transfer Bitbucket into a data warehouse using Oracle Data Integrator.
-
Model, Search, and Visualize Live EnterpriseDB Data in ThoughtSpot
Use CData Connect AI to connect to live EnterpriseDB for modeling, searching, and visualizing.
-
Automated Continuous Google Campaign Manager 360 Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to delimited files (CSV/TSV).
-
Use CData Connect AI to Access Oracle Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle Database in the Power Pivot business intelligence tool.
-
Connect to LinkedIn Ads in SpagoBI
Create reports featuring live LinkedIn Ads in SpagoBI Studio. Host LinkedIn Ads reports on SpagoBI Server.
-
Use the CData ODBC Driver for Stack Exchange in Microsoft Power Query
You can use the CData Stack Exchange ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Stack Exchange into Microsoft Power Query.
-
Automated Continuous Humanity Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Humanity replication to AlloyDB.
-
Build JotForm-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live JotForm Data in Cursor to assist with building JotForm-powered applications.
-
Integrating Kiro CLI with Float 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.
-
Replicate Multiple Sage Cloud Accounting Accounts
Replicate multiple Sage Cloud Accounting accounts to one or many databases.
-
Automate ServiceDesk Plus Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live ServiceDesk Plus and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
View Reports on Real-Time MailChimp Data in Power BI Report Server
Use the CData ODBC Driver for MailChimp to visualize MailChimp in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Cassandra with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Cassandra with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apache Cassandra.
-
Visualize ClickUp Data in TIBCO Spotfire through ADO.NET
Integrate ClickUp into dashboards in TIBCO Spotfire.
-
Integrate with live Sybase Data in Jitterbit
Use CData Connect AI to connect to and integrate live Sybase in Jitterbit.
-
Connect to LaunchDarkly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for LaunchDarkly to connect to LaunchDarkly and execute queries in PowerBuilder.
-
Automated Continuous QuickBooks Time Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to delimited files (CSV/TSV).
-
Extract, Transform, and Load Okta Data in Informatica PowerCenter
Create a simple Workflow for Okta in Informatica PowerCenter.
-
Access Reckon Accounts Hosted Data from MySQL in Amazon QuickSight
Connect to Reckon Accounts Hosted and build visualizations of Reckon Accounts Hosted using a MySQL Connection in Amazon QuickSight.
-
How to Query Sybase IQ Data in MySQL Workbench
Execute MySQL queries against live Sybase IQ from MySQL Workbench.
-
Build Dashboards with REST Data in Dundas BI
Create dynamic dashboards and perform analytics based on REST in Dundas BI.
-
Visualize Opsgenie Data in TIBCO Spotfire through ADO.NET
Integrate Opsgenie into dashboards in TIBCO Spotfire.
-
Connect to Paymo Data in DBeaver
Use the CData ODBC Driver to connect to Paymo in DBeaver.
-
Access Live BambooHR Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate BambooHR into the statistical analysis tools available in SAS JMP. This article shows how to use BambooHR in the Graph Builder and Query Builder.
-
Extract, Transform, and Load GitHub Data in Informatica PowerCenter
Create a simple Workflow for GitHub in Informatica PowerCenter.
-
How to create Visio diagrams from BigCommerce Data
Automatically update BigCommerce with the changes you make to Visio master shapes.
-
Access Live ShipEngine Data in Coginiti Pro
Connect to and query live ShipEngine from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect to Live Stripe Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Stripe for you.
-
Automated Continuous MessageBird Replication to SQL Server
Use CData Sync for automated, continuous, customizable MessageBird replication to SQL Server.
-
Build SendInBlue-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live SendInBlue Data in Claude Code to assist with building SendInBlue-powered applications.
-
Connect to Zuora Data in Jaspersoft Studio
Execute SQL to remote Zuora in Jaspersoft Studio.