CData Software - Knowledge Base
Recent Articles
-
DataBind Controls to Zoom in C++Builder
DataBind to Zoom in C++Builder with standard components and controls.
-
Migrating data from SingleStore to Databricks using CData SSIS Components.
Easily push SingleStore to Databricks using the CData SSIS Tasks for SingleStore and Databricks.
-
Automate Harvest Replication to SAP HANA
Use CData Sync to customize and automate Harvest replication to SAP HANA.
-
Validate Pipedrive with QuerySurge
Access and validate Pipedrive in QuerySurge using the CData JDBC Driver.
-
Build Square-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Square and build Square-connected web apps with Axios.
-
Migrating data from Zoho Projects to Snowflake using CData SSIS Components.
Easily push Zoho Projects to Snowflake using the CData SSIS Tasks for Zoho Projects and Snowflake.
-
Rapidly Develop Google Campaign Manager 360-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
How to Connect to Live Jira Service Management 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 Atlassian Jira Service Management for you.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Apache Impala to Power BI dashboards. Simply drag and drop Apache Impala into data visuals on the Power BI canvas.
-
Automated Continuous Act-On Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Act-On replication to Microsoft Access.
-
Enable the Sage Cloud Accounting JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Sage Business Cloud Accounting.
-
Integrate with CockroachDB in JReport Designer
Create charts and reports based on CockroachDB in JReport Designer.
-
Getting Started with the CData Python Connector for Bing Ads
Learn to install and license the CData Python Connector
-
How to Connect to Live Splunk in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Splunk for you.
-
Edit and Search Epicor Kinetic External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Epicor Kinetic to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Epicor Kinetic objects that you can access from apps and the dashboard.
-
Build Sage 200-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Sage 200.
-
How to Connect to & Open Act-On in Microsoft Excel
This article uses the CData ODBC driver for Act-On to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Publish SAP BusinessObjects BI-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP BusinessObjects BI.
-
Automated Continuous LinkedIn Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable LinkedIn replication to PostgreSQL.
-
Replicate Multiple MongoDB Accounts
Replicate multiple MongoDB accounts to one or many databases.
-
Use the CData Software ODBC Driver for SAP SuccessFactors in MicroStrategy
Connect to SAP SuccessFactors in MicroStrategy Developer using the CData Software ODBC Driver for SAP SuccessFactors.
-
Klipfolio Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Klipfolio facts in real time.
-
How to connect to CockroachDB with Squirrel SQL client
Connect to CockroachDB and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData Excel Add-In for SAS Data Sets
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAS Data Sets.
-
Replicate Coinbase in Heroku for Use in Salesforce Connect
Replicate Coinbase to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query Tally in DataGrip
Create a Data Source for Tally in DataGrip and use SQL to query live Tally ERP.
-
How to Build an ETL App for SAP in Python with CData
Create ETL applications and real-time data pipelines for SAP ERP/NetWeaver in Python with petl.
-
How to Seamlessly Import SAP HANA Data into IBM SPSS Modeler
Integrate SAP HANA data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to SAP SuccessFactors as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP SuccessFactors.
-
How to Connect to Live eBay in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live eBay without replication.
-
Excel Spreadsheet Automation on Salesloft with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
DataBind Charts to Jira Service Management
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Atlassian Jira Service Management from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Use the CData ODBC Driver for Asana in Microsoft Power Query
You can use the CData Asana ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Asana into Microsoft Power Query.
-
Bridge Oracle Connectivity with Apache NiFi
Access and process Oracle Database in Apache NiFi using the CData JDBC Driver.
-
Natively Connect to Jira Service Management in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Atlassian Jira Service Management. Leverage the native support for ODBC in PHP.
-
Automated Continuous ClickUp Replication to SingleStore
Use CData Sync for automated, continuous, customizable ClickUp replication to SingleStore.
-
DataBind Controls to HDFS in Delphi
DataBind to Apache HDFS in Delphi with standard data access components and controls.
-
How to Access Live ServiceNow in Power Automate Desktop via ODBC
The CData ODBC Driver for ServiceNow enables you to integrate ServiceNow into workflows built using Microsoft Power Automate Desktop.
-
DataBind Controls to OneNote in Delphi
DataBind to Microsoft OneNote in Delphi with standard data access components and controls.
-
Access Live eBay in Excel 365 Online (Excel for the web)
Connect to eBay from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Query Live Cloudant in Perplexity MacOS Desktop
Connect to and query live Cloudant in Perplexity Desktop using the CData MCP Server.
-
Easily Integrate Oracle Eloqua Reporting in Lazarus Pascal IDE
Learn how to easily integrate live Oracle Eloqua Reporting in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Azure DevOps Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Azure DevOps replication to OneLake in Microsoft Fabric.
-
Connect to Redis in Aqua Data Studio
Access Redis from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Outreach.io Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Outreach.io data access from reports, embedded analytics, and more.
-
Analyze Sage 200 in R via JDBC
Use standard R functions and the development environment of your choice to analyze Sage 200 with the CData JDBC Driver for Sage 200.
-
How to Connect DBeaver to Sage Intacct via a JDBC Driver
Manage Sage Intacct with visual tools in DBeaver like the query browser.
-
Connect and Query Live Greenplum Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Pivotal GreenPlum into Databricks
-
Integrate Redis in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Redis from Informatica Cloud.
-
How to Work with HDFS in AWS Glue Jobs Using JDBC
Connect to HDFS from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Reckon Replication to MySQL
Use CData Sync for automated, continuous, customizable Reckon replication to MySQL.
-
Automated Continuous Active Directory Replication to MySQL
Use CData Sync for automated, continuous, customizable Active Directory replication to MySQL.
-
Analyze YouTube Analytics in Cognos Analytics
Use CData Connect AI to connect to YouTube Analytics from Cognos Analytics and analyze live YouTube Analytics.
-
Build Automated Splunk-Connected Workflows in Zapier
Use CData Connect AI to connect to live Splunk and build automated workflows in Zapier.
-
Connecting to MongoDB Atlas with MongoDB Drivers
Connect to a MongoDB Atlas instance using any CData Software Driver for MongoDB.
-
How to Connect to & Open Salesforce Data Cloud in Microsoft Excel
This article uses the CData ODBC driver for Salesforce Data Cloud to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect to Live Monday.com 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 Monday.com for you.
-
How to load eBay Analytics data into Elasticsearch via Logstash
Introducing a simple method to load eBay Analytics data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Bind Live Confluence Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Confluence data
-
Connect to SendGrid in Jaspersoft Studio
Execute SQL to remote SendGrid in Jaspersoft Studio.
-
How to Connect to Live SAP Ariba Procurement in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SAP Ariba Procurement for you.
-
How to Access Jira Using Entity Framework
This article shows how to access Atlassian Jira using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Google Campaign Manager 360 Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Campaign Manager 360 and build visualizations in Tableau Cloud.
-
Connect Coinbase to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Coinbase with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Zoho Projects Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Amazon Redshift.
-
How to Query Azure Active Directory in MySQL Workbench
Execute MySQL queries against live Azure Active Directory from MySQL Workbench.
-
Use Dash to Build to Web Apps on Confluence
Create Python applications that use pandas and Dash to build Confluence-connected web apps.
-
How to Address ‘Token has been expired or revoked.’ Errors When Using OAuth 2.0 grant_type=refresh_token with Google Cloud Platform
How to troubleshoot and resolve “Token has been expired or revoked” errors when using OAuth 2.0 grant_type=refresh_token in GCP, with recommended best practices.
-
Build Harvest-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Harvest.
-
Extend Google Sheets with SQL Analysis Services
Make calls to the API Server from Google Apps Script.
-
Connect to Coinbase in Claris FileMaker Pro
-