CData Software - Knowledge Base
Recent Articles
-
How to connect and process Act-On from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Act-On.
-
How to Connect to Live ADP Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live ADP securely in real time.
-
Integrating LangGraph with Jira Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Atlassian Jira within automated workflows.
-
Integrating Antigravity CLI with SAS Data Sets via CData CLI
Connect SAS Data Sets to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access EnterpriseDB Data from MySQL in Amazon QuickSight
Connect to EnterpriseDB and build visualizations of EnterpriseDB using a MySQL Connection in Amazon QuickSight.
-
Connect to Parquet Data from a Connection Pool in Jetty
The Parquet JDBC Driver supports connection pooling: This article shows how to connect faster to Apache Parquet from Web apps in Jetty.
-
Publish Reports with Stack Exchange Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Stack Exchange.
-
Build Dashboards with FreshBooks Data in DBxtra
Create dynamic dashboards and perform analytics based on FreshBooks in DBxtra.
-
Build Agents in Relevance AI with Access to Live GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on GitHub within intelligent agent workflows.
-
Create Informatica Mappings From/To an ODBC Data Source for Greenplum
Create an ODBC connection to Greenplum in Informatica and browse and transfer Pivotal GreenPlum.
-
DataBind Controls to Sentry Data in Delphi
DataBind to Sentry in Delphi with standard data access components and controls.
-
Import Real-Time Google Analytics Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Analytics in ColdFusion.
-
Provide OData Services of SAP Netweaver Gateway Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Netweaver Gateway by developing a WCF Service Application.
-
How to Visualize Sage 300 Data in Python with pandas
Use pandas and other modules to analyze and visualize live Sage 300 in Python.
-
Integrating Codex CLI with Apache Phoenix 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.
-
Connect to Square Data in RazorSQL
Connect to Square from wizards and query Square from the GUI in the RazorSQL database management tool.
-
Connect to Short.io Data in Aqua Data Studio
Access Short.io from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData JDBC Driver for Campaigner
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Campaigner.
-
Integrate with Invoiced Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Invoiced to a JSON file on disk.
-
Connect to Beeminder Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Beeminder using standard SQL.
-
Build Agents in Relevance AI with Access to Live Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Box within intelligent agent workflows.
-
Bidirectional Access to Short.io Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Short.io in Filemaker Pro for Mac or Windows.
-
Connect to Microsoft Exchange Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Exchange from Appeon PowerBuilder using the CData ADO.NET Provider for Microsoft Exchange.
-
Automated Continuous SAP ByDesign Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to delimited files (CSV/TSV).
-
Access Live Coda Data in Coginiti Pro
Connect to and query live Coda from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Viewing Spotify Data in RAD Studio Data Explorer
How to view Spotify in RAD Studio Data Explorer using the CData ODBC Driver for Spotify.
-
Connect to Azure Data Lake Storage Data from a Connection Pool in Jetty
The Azure Data Lake Storage JDBC Driver supports connection pooling: This article shows how to connect faster to Azure Data Lake Storage from Web apps in Jetty.
-
How to create SAP federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP ERP/NetWeaver in MySQL .
-
Automated Continuous SharePoint Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SharePoint replication to Amazon S3.
-
How to Visualize eBay Analytics Data in Python with pandas
Use pandas and other modules to analyze and visualize live eBay Analytics in Python.
-
Connect to Azure Table Data from Crystal Reports
Use CData Connect AI to connect to and report on live Azure Table Storage from Crystal Reports.
-
Connect to Act-On Data in Jaspersoft Studio
Execute SQL to remote Act-On in Jaspersoft Studio.
-
Query Salesloft Data in DataGrip
Create a Data Source for Salesloft in DataGrip and use SQL to query live Salesloft.
-
Import Real-Time Codat Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Codat in ColdFusion.
-
How to Connect to Live SendGrid 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 SendGrid for you.
-
How to Design SFTP Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to SFTP from mobile and tablet Power Apps.
-
Automated Continuous Twilio Replication to Oracle
Use CData Sync for automated, continuous, customizable Twilio replication to Oracle.
-
How to Access Elasticsearch Data Using Entity Framework
This article shows how to access Elasticsearch using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build an OLAP Cube in SSAS from Apify Data
Establish a connection to Apify data from SQL Server Analysis Services, and use the Apify Data Provider to build OLAP cubes for use in analytics and reporting.
-
Migrating data from Salesforce to Google BigQuery using CData SSIS Components.
Easily push Salesforce & Force.com to Google BigQuery using the CData SSIS Tasks for Salesforce and Google BigQuery.
-
Getting Started with the CData ODBC Driver for Mouseflow
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Mouseflow.
-
Use the CData Software ODBC Driver for OData in MicroStrategy
Connect to OData in MicroStrategy Developer using the CData Software ODBC Driver for OData.
-
Use the CData ODBC Driver for Clockify from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Clockify to connect to Clockify from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Clockify in Excel.
-
Connect to PingOne from Asprova with CData Software ODBC Driver for PingOne
This article shows how to connect faster to PingOne data from Asprova.
-
Rapidly Develop Pushbullet-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 Pushbullet.
-
Import ActiveCampaign Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access ActiveCampaign. In this article, you will use the OData format to import ActiveCampaign into Microsoft Power Query.
-
Connect to Stack Exchange Data in RapidMiner
Integrate Stack Exchange with standard components and data source configuration wizards in RapidMiner Studio.
-
DataBind Controls to SAP Hybris C4C Data in C++Builder
DataBind to SAP Hybris C4C in C++Builder with standard components and controls.
-
Automated Continuous CampaignMonitor Replication to Vertica
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Vertica.
-
Integrate QuickBooks Online with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate QuickBooks Online with External Services.
-
Access HCL Domino Data from MySQL in Amazon QuickSight
Connect to HCL Domino and build visualizations of HCL Domino using a MySQL Connection in Amazon QuickSight.
-
Use Dash to Build Web Apps on Salesforce Pardot Data via CData Connect AI
Build interactive Dash web apps on live Salesforce Pardot using pandas and the CData Connect AI Python SDK.
-
Integrate with Discourse Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Discourse to a JSON file on disk.
-
Salesforce: Migrating to OAuthPKCE Authentication
Salesforce is requiring PKCE and Refresh Token Rotation for OAuth connected apps. CData Connect AI migrates automatically; Drivers, Sync, and Arc customers must update their connection strings and re-authenticate.
-
Build Reckon Accounts Hosted-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Reckon Accounts Hosted to explore live Reckon Accounts Hosted Data in Cursor to assist with building Reckon Accounts Hosted-powered applications.
-
Connect to Autopilot Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Autopilot and the SQL Gateway to access Autopilot from Google Apps Script.
-
Getting Started with the CData Python Connector for Microsoft Dataverse
Learn to install and license the CData Python Connector
-
How to Query Live Contentful Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Contentful data in natural language using Python.
-
Build SAP Business Warehouse-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP Business Warehouse and build web apps with connectivity to live SAP Business Warehouse.
-
Slack Reporting in OBIEE with the Slack JDBC Driver
Deploy the Slack JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData ODBC Driver for Sage 200 in Microsoft Power Query
You can use the CData Sage 200 ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sage 200 into Microsoft Power Query.
-
How to Design Zoho CRM Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Zoho CRM from mobile and tablet Power Apps.
-
Publish Crystal Reports on Access Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Access.
-
Prepare, Blend, and Analyze Tally Data in Alteryx Designer (ODBC)
Build workflows to access live Tally ERP for self-service data analytics.
-
Use Agno to Talk to Your SAP ByDesign 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 SAP Business ByDesign for you.
-
How to Work with Basecamp Data in AWS Glue Jobs Using JDBC
Connect to Basecamp from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live Cloudant Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to IBM Cloudant from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating Claude Code CLI with Zoho Projects 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.
-
Publish JobNimbus-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live JobNimbus.
-
Connect to LDAP Objects in Ruby
Connect to LDAP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Amazon Athena Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Apache Kafka.
-
How to connect Amazon QuickSight to MongoDB Data
Create a connection to MongoDB in CData Connect AI and insert MongoDB into Amazon QuickSight SPICE to build interactive dashboards.
-
Visualize Live IBM Cloud Object Storage Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live IBM Cloud Object Storage.
-
Extract, Transform, and Load Sentry Data in Informatica PowerCenter
Create a simple Workflow for Sentry in Informatica PowerCenter.
-
Connect to MailerSend Data from a Connection Pool in Jetty
The MailerSend JDBC Driver supports connection pooling: This article shows how to connect faster to MailerSend from Web apps in Jetty.
-
Process & Analyze Drip Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Drip Data.
-
Build Data Flows from SQL Server to Sage Cloud Accounting through SSIS
Easily push SQL Server data to Sage Cloud Accounting using the CData SSIS Tasks for Sage Cloud Accounting.
-
Getting Started with the CData Power BI Connector for Missive
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Access Quaderno Data Using Entity Framework
This article shows how to access Quaderno using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous WooCommerce Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable WooCommerce replication to PostgreSQL.
-
Visualize Live Freshsales Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Freshsales.
-
Integrating Antigravity CLI with Snapchat Ads via CData CLI
Connect Snapchat Ads to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Publish Webflow-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Webflow.
-
Connect Mailgun to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Mailgun with IBM WebSphere for seamless data integration and connectivity.
-
Write a Simple Go Application to work with SendPulse Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SendPulse.
-
Use the CData Software JDBC Driver for Oracle HCM Cloud in MicroStrategy Desktop
Connect to Oracle HCM Cloud in MicroStrategy Desktop using the CData Software JDBC Driver for Oracle HCM Cloud.
-
Use Biml to Build SSIS Tasks to Replicate Mode Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Mode to SQL Server.
-
CData Sync - Change Tracking in Dynamics 365 Entities for CDC Replication
How to enable automatic change tracking in Dynamics 365 entities for change-data-capture replication with CData Sync
-
Automated Continuous LinkedIn Replication to MongoDB
Use CData Sync for automated, continuous, customizable LinkedIn replication to MongoDB.
-
Design BIRT Reports on Aha! Data
Provide current Aha! to your embedded analytics.
-
Write a Simple Go Application to work with CockroachDB Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to CockroachDB.
-
Adobe Analytics Reporting in OBIEE with the Adobe Analytics JDBC Driver
Deploy the Adobe Analytics JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connecting to Azure Cosmos DB with MongoDB Drivers
Set up an Azure Cosmos DB account using the MongoDB API and connect using any CData Software Driver for MongoDB.
-
Query GitHub Data as a SQL Server Database in Node.js
Execute SQL Server queries against GitHub from Node.js.
-
Automated Continuous FreshBooks Replication to Snowflake
Use CData Sync for automated, continuous, customizable FreshBooks replication to Snowflake.
-
Publish Crystal Reports on ZohoInvoice Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ZohoInvoice.
-
Moving Data from ZohoDesk to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ZohoDesk data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Getting Started with the CData Python Connector for PolarTeamPro
Learn to install and license the CData Python Connector
-
Use Dash to Build to Web Apps on Placid Data
Create Python applications that use pandas and Dash to build Placid-connected web apps.
-
Publish Reports with Factorial Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Factorial.