CData Software - Knowledge Base
Recent Articles
-
Publish Reports with Office 365 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Office 365.
-
How to Access Live Google Calendar Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Calendar enables you to integrate Google Calendar into workflows built using Microsoft Power Automate Desktop.
-
Access Live Sugar CRM Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Sugar CRM into the statistical analysis tools available in SAS JMP. This article shows how to use Sugar CRM in the Graph Builder and Query Builder.
-
Connect to PDFMonkey Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate with Gmail Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Gmail to a JSON file on disk.
-
How to connect to XML Data in DBVisualizer
Integrate XML Files with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Reports with SAP Ariba Source Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Ariba Source.
-
Automated Continuous ZohoExpense Replication to SQL Server
Use CData Sync for automated, continuous, customizable ZohoExpense replication to SQL Server.
-
Create Datasets from OpenWeatherMap in Domo Workbench and Build Visualizations of OpenWeatherMap Data in Domo
Use the CData Software ODBC Driver for OpenWeatherMap to create datasets from OpenWeatherMap in Domo Workbench and then build visualizations in the Domo service.
-
Prepare, Blend, and Analyze Browserless Data in Alteryx Designer (ODBC)
Build workflows to access live Browserless for self-service data analytics.
-
Import Real-Time Pinterest Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Pinterest in ColdFusion.
-
How to Connect to FreeAgent Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to FreeAgent. Leverage the pyodbc module for ODBC in Python.
-
How to create an RPA flow for Salesforce Pardot Data in UiPath Studio
Use the Salesforce Pardot ODBC Driver to create workflows that access real-time Salesforce Pardot without any coding.
-
Use Claude to Talk to Your Act-On 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 Act-On for you.
-
Use Grok to Talk to Your SharePoint 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 Microsoft SharePoint for you.
-
Use the CData Software JDBC Driver for Ontraport in MicroStrategy Desktop
Connect to Ontraport in MicroStrategy Desktop using the CData Software JDBC Driver for Ontraport.
-
Connect to Spark Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Spark and the Script function in FileMaker Pro to connect to Spark and work with Apache Spark SQL in your FileMaker application.
-
DataBind Controls to Mailgun Data in Delphi
DataBind to Mailgun in Delphi with standard data access components and controls.
-
Operational Reporting on Pinterest Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Pinterest.
-
Operational Reporting on Cosmos DB Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Azure Cosmos DB.
-
Connect to Pingdom Data from a Connection Pool in Jetty
The Pingdom JDBC Driver supports connection pooling: This article shows how to connect faster to Pingdom from Web apps in Jetty.
-
Migrating data from RabbitMQ to Snowflake using CData SSIS Components.
Easily push RabbitMQ to Snowflake using the CData SSIS Tasks for RabbitMQ and Snowflake.
-
Operational Reporting on Cloudflare Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Cloudflare.
-
Automated Continuous Moosend Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Moosend replication to Google BigQuery.
-
Create Reports with Eventbrite Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Eventbrite.
-
How to integrate SAP HANA XS Advanced with Apache Airflow
Access and process SAP HANA XS Advanced in Apache Airflow using the CData JDBC Driver.
-
Create Certinia-Connected Dashboards in Grafana
Connect to Certinia Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Certinia.
-
Extract, Transform, and Load Klaviyo Data in Informatica PowerCenter
Create a simple Workflow for Klaviyo in Informatica PowerCenter.
-
Automated Continuous Quickbase Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Quickbase replication to Amazon S3.
-
Automated Continuous Codat Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Codat replication to Azure SQL Database.
-
How to Build an ETL App for FreeAgent Data in Python with CData
Create ETL applications and real-time data pipelines for FreeAgent in Python with petl.
-
Automated Continuous ZohoPeople Replication to SingleStore
Use CData Sync for automated, continuous, customizable ZohoPeople replication to SingleStore.
-
Build Dashboards with Mixpanel Data in Dundas BI
Create dynamic dashboards and perform analytics based on Mixpanel in Dundas BI.
-
Publish Discourse-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Discourse.
-
Connect Couchbase to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Couchbase using the CData Python MCP Server.
-
Create Adobe Analytics-Connected Dashboards in Grafana
Connect to Adobe Analytics Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Adobe Analytics.
-
Visualize Foursquare Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Foursquare.
-
How to use SQLAlchemy ORM to access ZeroBounce Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ZeroBounce.
-
A PostgreSQL Interface for Basecamp Data (MySQL Remoting via JDBC)
Use the Remoting features of the Basecamp JDBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time Dynamics CRM Data in Power BI Report Server
Use the CData ODBC Driver for Dynamics CRM to visualize Microsoft Dynamics CRM in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Query Live ScrapingBee Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ScrapingBee data in natural language using Python.
-
Integrating GitHub Copilot CLI with Amazon S3 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.
-
Validate Mode Data with QuerySurge
Access and validate Mode in QuerySurge using the CData JDBC Driver.
-
Stream Printify Data into Apache Kafka Topics
Access and stream Printify in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Charts with Recurly Data in Clear Analytics
Create dynamic charts and perform analytics based on Recurly in Clear Analytics.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle
Provide connectivity to Oracle Database through an SAP BusinessObjects universe.
-
Connect to SendGrid Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SendGrid in the Denodo Virtual DataPort Administrator.
-
DataBind SAS xpt Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAS xpt with the DevExpress Windows Forms and Web controls to provide SAS XPORT to a chart.
-
Import Real-Time Adobe Analytics Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Adobe Analytics in ColdFusion.
-
Migrating data from Factorial to Databricks using CData SSIS Components.
Easily push Factorial to Databricks using the CData SSIS Tasks for Factorial and Databricks.
-
Connect Typeform to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Typeform using the CData Python MCP Server.
-
DataBind Aircall Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Aircall to a chart.
-
Analyze Oracle Sales Data in Cognos Analytics
Use CData Connect AI to connect to Oracle Sales Data from Cognos Analytics and analyze live Oracle Sales.
-
Connect to Access Data in NetBeans
Connect to Microsoft Access in NetBeans with the data source configuration wizard.
-
Connect to Live Stripe Data in MicroStrategy through CData Connect AI
Create a live connection to Stripe Data in CData Connect AI and connect to your Stripe from MicroStrategy.
-
Build Charts with Float Data in Clear Analytics
Create dynamic charts and perform analytics based on Float in Clear Analytics.
-
Create Power BI Reports on Real-Time Zendesk Data
Use the CData ODBC Driver for Zendesk to visualize Zendesk in Power BI Desktop.
-
Connect to Sybase Data in Google Apps Script via Connect AI
Use CData Connect AI to access Sybase in Google Apps Script.
-
Connect to Supabase Data in RapidMiner
Integrate Supabase with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Azure AI Foundry to Talk to Your Amazon DynamoDB 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 Amazon DynamoDB for you.
-
Integrating GitHub Copilot CLI with Quaderno 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.
-
A PostgreSQL Interface for Wave Financial Data using the CData ODBC Driver
Use the SQL Gateway and Wave Financial ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Jira Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Jira replication to Google BigQuery.
-
Automated Continuous Flowlu Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Flowlu replication to Apache Cassandra.
-
How to connect to MessageBird Data from Spring Boot
Connect to MessageBird in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to ScrapingBee from a Connection Pool in WebLogic
Use the CData JDBC Driver for ScrapingBee to connect to ScrapingBee from Web applications running on WebLogic.
-
How to Visualize Snapchat Ads Data in Python with pandas
Use pandas and other modules to analyze and visualize live Snapchat Ads in Python.
-
Choosing the Best Method to Connect Oracle Service Cloud to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle Service Cloud from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automate Front Data Replication to SAP HANA
Use CData Sync to customize and automate Front replication to SAP HANA.
-
Integrate LibreChat with Live Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Power BI XMLA from within the chat interface.
-
Connect to PhantomBuster Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Postmark Data in HULFT Integrate
Connect to Postmark as a JDBC data source in HULFT Integrate
-
Connect to Shortcut from Asprova with CData Software ODBC Driver for Shortcut
This article shows how to connect faster to Shortcut data from Asprova.
-
Connect to SharePoint from Asprova with CData Software ODBC Driver for SharePoint
This article shows how to connect faster to SharePoint data from Asprova.
-
Connect to MYOB AccountRight Data in DBeaver
Use the CData ODBC Driver to connect to MYOB AccountRight in DBeaver.
-
Provide OData Services of Workable Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Workable by developing a WCF Service Application.
-
Automated LaunchDarkly Data Replication to Teradata
Use CData Sync to Customize and automate LaunchDarkly replication to Teradata.
-
Build CouchDB-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for CouchDB to explore live CouchDB Data in Claude Code to assist with building CouchDB-powered applications.
-
Query, Visualize, and Share live Vertica Data in Redash
Use CData Connect AI to connect to live Vertica in Redash for querying, visualizing, and sharing.
-
Build Dashboards with AdRoll Data in Dundas BI
Create dynamic dashboards and perform analytics based on AdRoll in Dundas BI.
-
Connect to Odoo Data in JRuby
Create a simple JRuby app with access to live Odoo ERP.
-
Automate Discourse Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Discourse from PowerShell? This article demonstrates how to utilize the Discourse Cmdlets for tasks like connecting to Discourse, automating operations, downloading data, and more.
-
How to Connect the Power BI Service to Oracle Eloqua Reporting: Complete Guide
Connect to the CData Software Power BI Connector for Oracle Eloqua Reporting from PowerBI.com to provide real-time Oracle Eloqua Reporting across the organization.
-
Query Kintone Data in ColdFusion
Write standard ColdFusion data access code to connect to Kintone.
-
Connecting Mastra with Azure Data Lake Storage 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 Azure Data Lake Storage, no replication required.
-
Use Biml to Build SSIS Tasks to Replicate Amazon S3 Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Amazon S3 to SQL Server.
-
Replicate LinkedIn Data to Multiple Databases
Replicate LinkedIn to disparate databases with a point-and-click configuration.
-
Build Automated Redis-Connected Workflows in Zapier
Use CData Connect AI to connect to live Redis and build automated workflows in Zapier.
-
Extract, Transform, and Load ZeroBounce Data in Informatica PowerCenter
Create a simple Workflow for ZeroBounce in Informatica PowerCenter.
-
Use the CData Software ODBC Driver for ZohoDesk in SAS for Real-Time Reporting and Analytics
Connect to real-time ZohoDesk in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ZohoDesk.
-
Connecting Pipedream with Slack 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 Slack data in real time.
-
ZohoInvoice Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ZohoInvoice facts in real time.
-
Create Dynamic Greenplum Grids Using the Infragistics XamDataGrid
Learn how you can connect Greenplum to Infragistics XamDataGrid to build dynamic grids.
-
Feed Tally Data into FineReport
How to set Tally ERP as a JDBC data source in FineReport.
-
Viewing Helpscout Data in RAD Studio Data Explorer
How to view Helpscout in RAD Studio Data Explorer using the CData ODBC Driver for Helpscout.
-
Design BIRT Reports on Google Calendar Data
Provide current Google Calendar to your embedded analytics.
-
Analyze REST Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of REST and visualize live REST in Infragistics Reveal.
-
Moving Data from Datadog to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Datadog data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating LlamaIndex with Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Analytics in real time.
-
Automate Sybase Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sybase from PowerShell? This article demonstrates how to utilize the Sybase Cmdlets for tasks like connecting to Sybase, automating operations, downloading data, and more.