CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for OData in MicroStrategy Desktop
Connect to OData in MicroStrategy Desktop using the CData Software ODBC Driver for OData.
-
Connect to Neo4J from Asprova with CData Software ODBC Driver for Neo4J
This article shows how to connect faster to Neo4J data from Asprova.
-
Visualize HubDB Data in Tableau
The CData ODBC driver for HubDB enables you integrate HubDB into Tableau dashboards.
-
Import SAP HANA Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP HANA Data and provide access to live SAP HANA for custom reports in the Power BI Service.
-
Access Live ADP Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ADP from your Excel spreadsheets.
-
How to Design QuickBooks Online Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to QuickBooks Online from mobile and tablet Power Apps.
-
Use Databricks Agent Bricks to Talk to Your Google Ad Manager Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Ad Manager for you.
-
Connect to Aircall Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Aircall and the SQL Gateway to access Aircall from Google Apps Script.
-
Automated Continuous DocuSign Replication to MongoDB
Use CData Sync for automated, continuous, customizable DocuSign replication to MongoDB.
-
Integrate Lakebase Data into Power Automate Desktop using CData Connect
CData Connect for Lakebase Data enables you to integrate Lakebase into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software JDBC Driver for Adobe Experience Manager in MicroStrategy
Connect to Adobe Experience Manager in MicroStrategy Developer using the CData Software JDBC Driver for Adobe Experience Manager.
-
How to work with ZarMoney Data in Apache Spark using SQL
Access and process ZarMoney Data in Apache Spark using the CData Software JDBC Driver.
-
Replicate Google Calendar Data to Multiple Databases
Replicate Google Calendar to disparate databases with a point-and-click configuration.
-
Automate Act CRM Data Replication to Azure Synapse
Use CData Sync to customize and automate Act CRM replication to Azure Synapse.
-
Integrating GitHub Copilot CLI with Planio 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.
-
Choosing the Best Method to Connect Instagram to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Instagram from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Autopilot Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Autopilot from your Oracle system.
-
Replicate Dynamics 365 Business Central Data to Multiple Databases
Replicate Dynamics 365 Business Central to disparate databases with a point-and-click configuration.
-
Build Spark-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Spark to explore live Spark Data in Claude Code to assist with building Spark-powered applications.
-
Query OnePageCrm Data in ColdFusion
Write standard ColdFusion data access code to connect to OnePageCrm.
-
Integrate Cline with Live Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Stripe from within your IDE.
-
How to Visualize Adobe Target Data in Python with pandas
Use pandas and other modules to analyze and visualize live Adobe Target in Python.
-
Integrate Theia IDE with Live Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect and Query Live Salesforce CRM Analytics Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Salesforce CRM Analytics into Databricks
-
Write a Simple Go Application to work with Confluence Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Atlassian Confluence.
-
Visualize ShipStation Data in TIBCO Spotfire through ADO.NET
Integrate ShipStation into dashboards in TIBCO Spotfire.
-
Connect to Copper Data in CloverDX (formerly CloverETL)
Transfer Copper using the visual workflow in the CloverDX data integration tool.
-
Create Azure Analysis Services Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Azure Analysis Services from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect Bullhorn CRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Bullhorn CRM using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create ChargeOver Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ChargeOver from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live IBM Informix Data in AWS Lambda (with IntelliJ IDEA)
Connect to live IBM Informix in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous CapsuleCRM Replication to Oracle
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Oracle.
-
Integrate GitHub Data in the Pentaho Report Designer
Publish reports based on GitHub in the Pentaho BI tool.
-
Import Zoho Inventory Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Zoho Inventory. In this article, you will use the OData format to import Zoho Inventory into Microsoft Power Query.
-
How to Easily Query Close Data in OpenOffice Base
Connect to Close data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous Azure Data Lake Storage Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Apache Cassandra.
-
Automate SAP Business One Data Replication to SAP HANA
Use CData Sync to customize and automate SAP Business One replication to SAP HANA.
-
Create Twilio Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Twilio data access from reports, embedded analytics, and more.
-
How to Access ChargeOver Data Using Entity Framework
This article shows how to access ChargeOver using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Enable the Demio JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Demio.
-
Create Google Calendar Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Calendar from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access ZohoExpense Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ZohoExpense from HeidiSQL.
-
Connect to Xero Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Replicate Multiple SAP HANA XS Advanced Accounts
Replicate multiple SAP HANA XS Advanced accounts to one or many databases.
-
Integrating LangGraph with CouchDB Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Apache CouchDB within automated workflows.
-
Automated Continuous Shopify Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Shopify replication to Apache Kafka.
-
Migrating data from HDFS to Snowflake using CData SSIS Components.
Easily push Apache HDFS to Snowflake using the CData SSIS Tasks for HDFS and Snowflake.
-
How to work with Facebook Data in Apache Spark using SQL
Access and process Facebook Data in Apache Spark using the CData Software JDBC Driver.
-
How to connect Amazon QuickSight to SendGrid Data
Create a connection to SendGrid in CData Connect AI and insert SendGrid into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Demio Data in RapidMiner
Integrate Demio with standard components and data source configuration wizards in RapidMiner Studio.
-
Feed SharePoint Excel Services Data into FineReport
How to set SharePoint Excel Services as a JDBC data source in FineReport.
-
Replicate Multiple SAP BusinessObjects BI Accounts via the CData Sync CLI
Replicate multiple SAP BusinessObjects BI accounts to one or many databases.
-
Bind Live Kintone Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Kintone data
-
Connect to Shopify Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Shopify.
-
Automated Continuous Redis Replication to Vertica
Use CData Sync for automated, continuous, customizable Redis replication to Vertica.
-
Building Dynamic Web Pages with Freshdesk Data Using AngularJS
Create single-page applications with live connectivity to Freshdesk using the CData API Server.
-
Integrating Gumloop with MarkLogic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on MarkLogic within automated workflows.
-
Use the CData Software ODBC Driver for PingOne in MicroStrategy
Connect to PingOne in MicroStrategy Developer using the CData Software ODBC Driver for PingOne.
-
Migrating data from Placid to Snowflake using CData SSIS Components.
Easily push Placid to Snowflake using the CData SSIS Tasks for Placid and Snowflake.
-
Build Visualizations of GitLab Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of GitLab in Birst.
-
Automated Continuous Excel Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Excel replication to AlloyDB.
-
Connecting Agentforce with Basecamp Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Basecamp for you.
-
Creating Act-On-Connected Applications in Unqork
You can use CData Connect AI to feed Act-On to Unqork and build custom business apps.
-
How to Use a Microsoft Access Database to Update Microsoft Dataverse Data in Real Time
Update Microsoft Dataverse data by creating a linked table in Microsoft Access with the CData Microsoft Dataverse ODBC Driver.
-
Use the CData Software ODBC Driver for Avaza in MicroStrategy Web
Connect to Avaza in MicroStrategy Web using the CData Software ODBC Driver for Avaza.
-
How to Connect Dynamics 365 Business Central Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Dynamics 365 Business Central data in real time using natural language.
-
Import and Visualize Recurly Data in Power View
Create data visualizations based on Recurly in Excel.
-
Connect to Amazon S3 Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Amazon S3.
-
Use the CData Software ODBC Driver for PingOne in SAS for Real-Time Reporting and Analytics
Connect to real-time PingOne in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for PingOne.
-
Access Live ServiceNow Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ServiceNow into the statistical analysis tools available in SAS JMP. This article shows how to use ServiceNow in the Graph Builder and Query Builder.
-
How to connect to Pinecone Data from Spring Boot
Connect to Pinecone in a Spring Boot Application using the CData API Driver for JDBC
-
DataBind Oracle HCM Cloud Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Oracle HCM Cloud with the DevExpress Windows Forms and Web controls to provide Oracle HCM Cloud to a chart.
-
Create Tally-Connected Dashboards in Grafana
Connect to Tally Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Tally ERP.
-
Build Tally-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Tally Data from Zoho Analytics and import live Tally ERP.
-
Integrating Kiro CLI with Mocean 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.
-
Getting Started with the CData Power BI Connector for LinkedIn
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for LinkedIn.
-
Add Perigon Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Perigon with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Sage Cloud Accounting-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Sage Business Cloud Accounting and build web apps with connectivity to live Sage Business Cloud Accounting.
-
Publish Crystal Reports on XML Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date XML Files.
-
Integrate Oracle Service Cloud Data in the Pentaho Report Designer
Publish reports based on Oracle Service Cloud in the Pentaho BI tool.
-
Feed Keap Data into FineReport
How to set Keap as a JDBC data source in FineReport.
-
Analyze Gmail Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Gmail and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Replicate Multiple Jira Assets Accounts via the CData Sync CLI
Replicate multiple Jira Assets accounts to one or many databases.
-
Analyze Pingdom Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Pingdom from Power Pivot. You will use the Table Import Wizard to load Pingdom. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous iContact Replication to Databricks
Use CData Sync for automated, continuous, customizable iContact replication to Databricks.
-
Easily Integrate Paymo Data in Lazarus Pascal IDE
Learn how to easily integrate live Paymo in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Apps from Marketo Data in Qlik Sense Cloud
Use CData Connect AI to connect to Marketo Data and build apps from live Marketo in Qlik Sense Cloud.
-
Visualize ServiceNow Data in Sisense
Create an ElastiCube in Sisense app with access to ServiceNow.
-
Build a Singer.io Tap for Aweber With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Aweber data using
-
Build Automated Amazon DynamoDB-Connected Workflows in Zapier
Use CData Connect AI to connect to live Amazon DynamoDB and build automated workflows in Zapier.
-
Replicate LinkedIn Data to Multiple Databases via the CData Sync CLI
Replicate LinkedIn to disparate databases with a single configuration.
-
Visualize ShipEngine Data in TIBCO Spotfire through ADO.NET
Integrate ShipEngine into dashboards in TIBCO Spotfire.
-
Connect to SAP Business One Data in JRuby
Create a simple JRuby app with access to live SAP Business One.
-
Deploy the ADO.NET Provider for SAP HANA XS Advanced on an SSRS Report Server
Connect to SAP HANA XS Advanced from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Create SSAS Tabular Models from Miro Data
How to build a SQL Server Analysis Service Tabular Model from Miro using CData drivers.
-
Use Dash to Build to Web Apps on Webex Data
Create Python applications that use pandas and Dash to build Webex-connected web apps.
-
Connect to Real-Time SAP Concur Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAP Concur and Dataflow to import and use SAP Concur in Power Apps.
-
Access Live Elasticsearch Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Elasticsearch from your Excel spreadsheets.
-
A PostgreSQL Interface for Flowlu Data (MySQL Remoting via JDBC)
Use the Remoting features of the Flowlu JDBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from AgileCRM to Google BigQuery using CData SSIS Components.
Easily push AgileCRM to Google BigQuery using the CData SSIS Tasks for AgileCRM and Google BigQuery.