CData Software - Knowledge Base
Recent Articles
-
Migrating data from Typeform to Snowflake using CData SSIS Components.
Easily push Typeform to Snowflake using the CData SSIS Tasks for Typeform and Snowflake.
-
How to Easily Query HubSpot Data in OpenOffice Base
Connect to HubSpot data in OpenOffice Base using the CData ODBC Driver for HubSpot and generate reports with live data insights.
-
Integrate Google Tasks Data in the Pentaho Report Designer
Publish reports based on Google Tasks in the Pentaho BI tool.
-
How to create an RPA flow for SAP Fieldglass Data in UiPath Studio
Use the SAP Fieldglass ODBC Driver to create workflows that access real-time SAP Fieldglass without any coding.
-
Automated Continuous Sage Intacct Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Sage Intacct replication to IBM DB2.
-
Automated Continuous Instagram Replication to Snowflake
Use CData Sync for automated, continuous, customizable Instagram replication to Snowflake.
-
Access Live Cvent Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Cvent through MCP integration.
-
Viewing SuiteCRM Data in RAD Studio Data Explorer
How to view SuiteCRM in RAD Studio Data Explorer using the CData ODBC Driver for SuiteCRM.
-
How to Query Live Float Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Float data in natural language using Python.
-
Visualize Live Sage 200 Data in the Power BI Service
Use CData Connect AI to connect to live Sage 200 and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Microsoft Copilot Studio to talk to your IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your IBM Cloud Object Storage for you.
-
How to work with MYOB AccountRight Data in Apache Spark using SQL
Access and process MYOB AccountRight Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live AlloyDB Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google AlloyDB from your Excel spreadsheets.
-
How to create Hubstaff federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Hubstaff in MySQL .
-
Use Grok to Talk to Your ADP 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 ADP for you.
-
Automated Continuous Salesforce Pardot Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Amazon Redshift.
-
Create Zoho CRM-Connected Applications in Appsmith
Connect to Zoho CRM Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Zoho CRM.
-
Connect to Wistia Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Wistia using standard SQL.
-
How to Connect DBeaver to Dynamics 365 Business Central via a JDBC Driver
Manage Dynamics 365 Business Central with visual tools in DBeaver like the query browser.
-
Replicate Jira Assets Data from PowerShell
Write a quick PowerShell script to query Jira Assets. Use connectivity to the live data to replicate Jira Assets to SQL Server.
-
Access Live GetResponse Data in AWS Lambda
Connect to live GetResponse in AWS Lambda using the CData JDBC Driver.
-
Extract, Transform, and Load Tally Data in Informatica PowerCenter
Create a simple Workflow for Tally ERP in Informatica PowerCenter.
-
Build Dashboards with Gmail Data in Dundas BI
Create dynamic dashboards and perform analytics based on Gmail in Dundas BI.
-
Integrating OpenCode Terminal with Bitbucket 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 an SAP BusinessObjects Universe on the CData JDBC Driver for Google Drive
Provide connectivity to Google Drive through an SAP BusinessObjects universe.
-
How to publish and share Microsoft Dataverse Data dashboards with Tableau Server
The CData ODBC driver for Microsoft Dataverse enables you integrate Microsoft Dataverse (CDS) into Tableau dashboards.
-
Connect to QuickBooks Data as an External Source in Dremio
Use the CData JDBC Driver to connect to QuickBooks as an External Source in Dremio.
-
How to work with Oracle Financials Cloud Data in Apache Spark using SQL
Access and process Oracle Financials Cloud Data in Apache Spark using the CData Software JDBC Driver.
-
Build a Simple VCL Application for Salesloft Data
How to build a simple VCL Application to view Salesloft in RAD Studio using the CData ODBC Driver for Salesloft.
-
How to Create Power BI Visual Reports with Real-Time Square Data
Use CData Power BI Connectors to visualize Square in Power BI.
-
Integrate LibreChat with Live FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live FreshBooks from within the chat interface.
-
How to import Epicor Kinetic Data into Apache Solr
Use the CData Software JDBC Driver for Epicor Kinetic in Data Import Handler and create an automated import of Epicor Kinetic to Apache Solr Enterprise Search platform.
-
DataBind Azure Analysis Services Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Azure Analysis Services with the DevExpress Windows Forms and Web controls to provide Azure Analysis Services to a chart.
-
Use the CData Software ODBC Driver for Postmark in SAS for Real-Time Reporting and Analytics
Connect to real-time Postmark in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Postmark.
-
Automated Continuous Azure Blob Storage Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to AlloyDB.
-
Connect to Real-Time Oracle Eloqua Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Oracle Eloqua and Dataflow to import and use Oracle Eloqua in Power Apps.
-
Create Google Calendar-Connected Business Apps in AppSheet
Connect to Google Calendar Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Calendar.
-
Easily Integrate FreeAgent Data in Lazarus Pascal IDE
Learn how to easily integrate live FreeAgent in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Query Insightly Data in ColdFusion
Write standard ColdFusion data access code to connect to Insightly.
-
Manage Azure Analysis Services Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Azure Analysis Services.
-
Access Pushbullet Data from MySQL in PHP
Connect to Pushbullet through the standard MySQL libraries in PHP.
-
Integrating Kiro CLI with Customer.io 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 Microsoft OneDrive-Connected Dashboards in Grafana
Connect to Microsoft OneDrive Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Microsoft OneDrive.
-
How to Access Live SendGrid Data in Visual Studio Code via Cline
Run CData MCP Server for SendGrid on Windows Subsytem for Linux (WSL) and connect to live SendGrid from the Cline extension in Visual Studio Code.
-
Connecting Pipedream with Oracle Eloqua 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 Oracle Eloqua data in real time.
-
Use the CData ODBC Driver for Jumpseller from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Jumpseller to connect to Jumpseller from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Jumpseller in Excel.
-
Use the CData Software ODBC Driver for WordPress in MicroStrategy Desktop
Connect to WordPress in MicroStrategy Desktop using the CData Software ODBC Driver for WordPress.
-
How to Connect to Live Reckon Accounts Hosted 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 Reckon Accounts Hosted for you.
-
How to connect to VWO Data in DBVisualizer
Integrate VWO with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating Claude Code with SQL Server Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft SQL Server within assisted coding and automated development workflows.
-
Build Automated Workflows with Live GraphQL Data in Workato
Use CData Connect AI to connect to live GraphQL and build automated workflows in Workato.
-
Use Databricks Agent Bricks to Talk to Your Reckon Accounts Hosted Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Reckon Accounts Hosted for you.
-
Create Gong-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Gong Data from OutSystems and build custom enterprise apps using live Gong.
-
Access Live SAP Fieldglass Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Fieldglass in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to connect and process Adobe Target from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Adobe Target.
-
View Reports on Real-Time Nuclia Data in Power BI Report Server
Use the CData ODBC Driver for Nuclia to visualize Nuclia in Power BI Desktop and then publish them to Power BI Report Server.
-
Work with Live Zuora Data in Power Query
Use CData Connect AI to connect to Zuora and work with live Zuora in Microsoft Power Query.
-
Connect to ZeroBounce from a Connection Pool in WebLogic
Use the CData JDBC Driver for ZeroBounce to connect to ZeroBounce from Web applications running on WebLogic.
-
Integrate with Live SAP Ariba Source Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP Ariba Source from the MuleSoft Anypoint Platform to integrate live SAP Ariba Source into custom reports and dashboards.
-
Connect to Templated Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Templated and work with Templated in your FileMaker applications.
-
Integrate Goose with Live Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Zoho Inventory from within the local AI agent.
-
Build Data Flows from Coda to SQL Server using SSIS
Easily back up Coda to SQL Server using the SSIS components for Coda.
-
Integrate LibreChat with Live Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Apache Cassandra from within the chat interface.
-
Integrate Real-Time Access to MariaDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to MariaDB in real time.
-
Create Data Visualizations in Cognos BI with FreeAgent Data
Access FreeAgent as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Open WebUI with Live Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Oracle Sales from within the chat interface.
-
Connect to SAS Data Sets from Asprova with CData Software ODBC Driver for SAS Data Sets
This article shows how to connect faster to SAS Data Sets data from Asprova.
-
Replicate Grafana Data to Multiple Databases via the CData Sync CLI
Replicate Grafana to disparate databases with a single configuration.
-
Create SSAS Tabular Models from Placid Data
How to build a SQL Server Analysis Service Tabular Model from Placid using CData drivers.
-
Migrating data from PivotalTracker to Google BigQuery using CData SSIS Components.
Easily push PivotalTracker to Google BigQuery using the CData SSIS Tasks for PivotalTracker and Google BigQuery.
-
Choosing the Best Method to Connect Amazon DynamoDB to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Amazon DynamoDB from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Agno to Talk to Your Smartsheet 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 Smartsheet for you.
-
How to connect and process Zoom from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Zoom.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Campaign Manager 360
Provide connectivity to Google Campaign Manager 360 through an SAP BusinessObjects universe.
-
Operational Reporting on Postmark Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Postmark.
-
Connect to Act CRM Data in CloverDX (formerly CloverETL)
Transfer Act CRM using the visual workflow in the CloverDX data integration tool.
-
Create Data Visualizations Based On Oracle Eloqua Data in Mode
Use CData Connect AI to connect to Oracle Eloqua Data from Mode and build visualizations using live
-
ETL LaunchDarkly in Oracle Data Integrator
This article shows how to transfer LaunchDarkly into a data warehouse using Oracle Data Integrator.
-
Create Greenplum-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Greenplum Data from OutSystems and build custom enterprise apps using live Pivotal GreenPlum.
-
Query Epicor Kinetic Data in DataGrip
Create a Data Source for Epicor Kinetic in DataGrip and use SQL to query live Epicor Kinetic.
-
Integrate Freshdesk Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Freshdesk and integrate live Freshdesk into your Power Automate tasks.
-
How to load BenchmarkEmail data into Elasticsearch via Logstash
Introducing a simple method to load BenchmarkEmail data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build an OLAP Cube in SSAS from Monday.com Data
Establish a connection to Monday.com data from SQL Server Analysis Services, and use the Monday.com Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Pipeline CRM Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Pipeline CRM and work with Pipeline CRM in your FileMaker applications.
-
How to update Impala from Excel
This article explains how to transfer data from Excel to Impala using the Excel Add-In for Impala.
-
Build a PostgreSQL Interface for QuickBooks Data using the CData JDBC Driver
Use the Remoting features of the QuickBooks JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use JayDeBeApi to access Humanity Data in Python
Use standard Python scripting and the development environment of your choice to access live Humanity.
-
Consume RSS OData Feeds in PowerBuilder
This article demonstrates how to consume RSS Feeds as OData feeds from PowerBuilder using the API Server.
-
Analyze JSON Services with Power Pivot
This article walks you through the process of using the CData ODBC Driver for JSON from Power Pivot. You will use the Table Import Wizard to load JSON. You can visually build the import query or use any SQL supported by the driver.
-
Using the CData Software ODBC Driver for Adobe Analytics in PyCharm
Connect to Adobe Analytics as an ODBC data source in PyCharm using the CData Software ODBC Driver for Adobe Analytics.
-
Connect to Dynamics 365 Business Central Data in Ruby
Connect to Dynamics 365 Business Central in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate Figshare Data in Heroku for Use in Salesforce Connect
Replicate Figshare to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect and process Cvent from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Cvent.
-
Create Informatica Mappings From/To a JDBC Data Source for Odoo
Create Odoo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query Sybase IQ Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Sybase IQ and perform CRUD operations on Sybase IQ from Node.js.
-
Automated Continuous Amazon S3 Replication to Oracle
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Oracle.
-
Build a PostgreSQL Interface for Redis Data using the CData JDBC Driver
Use the Remoting features of the Redis JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Apps with Live ServiceNow in Adalo using CData Connect AI
Use CData Connect AI to integrate live ServiceNow into the Adalo platform and build custom mobile and web applications with real-time ServiceNow.
-
Integrate with live Acumatica Data in Jitterbit
Use CData Connect AI to connect to and integrate live Acumatica ERP in Jitterbit.
-
How to Easily Query IBM Informix Data in OpenOffice Base
Connect to IBM Informix data in OpenOffice Base using the CData ODBC Driver for IBM Informix and generate reports with live data insights.