CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Power BI Connector for Zoho Recruit
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Use Biml to Build SSIS Tasks to Replicate HelloSign Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate HelloSign data to SQL Server.
-
Access Insightly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Insightly data from your Oracle system.
-
Viewing Shopify Data in RAD Studio Data Explorer
How to view Shopify data in RAD Studio Data Explorer using the CData ODBC Driver for Shopify.
-
Query SFTP Data as a SQL Server Database in Node.js
Execute SQL Server queries against SFTP data from Node.js.
-
Choosing the Best Method to Connect XML to SQL Server: 5 Options Explained
Discover multiple ways to connect and use XML data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData ODBC Driver for SAP Business Warehouse in Microsoft Power Query
You can use the CData SAP Business Warehouse ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP Business Warehouse data into Microsoft Power Query.
-
Use the CData Software ODBC Driver for SAP SuccessFactors LMS in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP SuccessFactors LMS data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP SuccessFactors LMS.
-
Excel Spreadsheet Automation on Procore Data with the QUERY Formula
Pull data from Procore, automate spreadsheets, and more with the QUERY formula.
-
Rapidly Develop Invoiced-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 Invoiced.
-
Integrating Kiro with Neo4J 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.
-
Use the CData Software ODBC Driver for Sage 300 in MicroStrategy
Connect to Sage 300 data in MicroStrategy Developer using the CData Software ODBC Driver for Sage 300.
-
Publish Salesforce Data 360-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Salesforce Data 360 data.
-
Automated Continuous Klaviyo Replication to Databricks
Use CData Sync for automated, continuous, customizable Klaviyo replication to Databricks.
-
Choosing the Best Method to Connect Microsoft Planner to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Planner data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Cvent Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Cvent Data and connect to Cvent data in Akorbi Digital RunMyProcess.
-
Connect to HBase Data in Claris FileMaker Pro
Use the CData ODBC Driver for HBase in FileMaker Pro to connect to HBase and work with HBase data in your FileMaker applications.
-
How to Connect DBeaver to Azure DevOps via a JDBC Driver
Manage Azure DevOps data with visual tools in DBeaver like the query browser.
-
Connect to Couchbase Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Couchbase data in Airbyte.
-
Use CData Connect AI to Access SAP SuccessFactors Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP SuccessFactors data in the Power Pivot business intelligence tool.
-
Create Power BI Reports on Real-Time ZohoInvoice Data
Use the CData ODBC Driver for ZohoInvoice to visualize ZohoInvoice data in Power BI Desktop.
-
How to Easily Query Instantly Data in OpenOffice Base
Connect to Instantly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous Paylocity Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Paylocity replication to Google Cloud SQL.
-
DataBind Controls to Telegram Data in C++Builder
DataBind to Telegram data in C++Builder with standard components and controls.
-
Use the CData Software ODBC Driver for SAP Ariba Source in MicroStrategy
Connect to SAP Ariba Source data in MicroStrategy Developer using the CData Software ODBC Driver for SAP Ariba Source.
-
Use Microsoft Copilot Studio to talk to your Testmonitor 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 Testmonitor data for you.
-
How to connect to Trello Data from IntelliJ
Integrate connectivity to Trello data with wizards in IntelliJ.
-
Build Semantic Layer Views for SAP ByDesign Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP ByDesign data.
-
Connect to Grafana Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Grafana data.
-
Object-Relational Mapping (ORM) with Excel Online Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Excel Online data into a Java-based ORM framework, Hibernate.
-
Access Live Paymo Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Paymo data from your Google Sheets.
-
Automated Continuous SharePoint Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SharePoint replication to Google Cloud SQL.
-
Build an OLAP Cube in SSAS from ChartMogul Data
Establish a connection to ChartMogul data data from SQL Server Analysis Services, and use the ChartMogul Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live PolarTeamPro Data in Excel 365 Online (Excel for the web)
Connect to PolarTeamPro data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Object-Relational Mapping (ORM) with SAP ByDesign Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAP ByDesign data into a Java-based ORM framework, Hibernate.
-
Analyze AgileCRM Data in Looker
Use CData Connect AI to connect to AgileCRM Data from Looker and build custom apps using live AgileCRM data.
-
Publish CapsuleCRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live CapsuleCRM data.
-
Deploy the ADO.NET Provider for Discord on an SSRS Report Server
Connect to Discord data 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.
-
Connect AgileCRM to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect AgileCRM with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Zoho Books Data from HeidiSQL
Use CData Connect AI to connect to and query live Zoho Books data from HeidiSQL.
-
Add SurveyMonkey Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SurveyMonkey with the Informatica Enterprise Data Catalog to classify and organize data.
-
Add Templated Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Templated with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Access Live JSON Services in Power Automate Desktop via ODBC
The CData ODBC Driver for JSON enables you to integrate JSON services into workflows built using Microsoft Power Automate Desktop.
-
Stream SAP SuccessFactors LMS Data into Apache Kafka Topics
Access and stream SAP SuccessFactors LMS data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Mocean Data in TIBCO Spotfire through ADO.NET
Integrate Mocean data into dashboards in TIBCO Spotfire.
-
Build QuickBooks Online-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live QuickBooks Online data.
-
Edit and Search External SAP Business One Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP Business One data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP Business One Data objects that you can access from apps and the dashboard.
-
Build Charts with SendPulse Data in Clear Analytics
Create dynamic charts and perform analytics based on SendPulse data in Clear Analytics.
-
Connect to Chargebee Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Chargebee and work with Chargebee data in your FileMaker applications.
-
Create a Data Access Object for Klaviyo Data using JDBI
A brief overview of creating a SQL Object API for Klaviyo data in JDBI.
-
Visualize Live AdRoll Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live AdRoll data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build a PostgreSQL Interface for Dynamics 365 Data using the CData JDBC Driver
Use the Remoting features of the Dynamics 365 JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind MailerLite Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide MailerLite data to a chart.
-
DataBind Charts to Salesforce Data 360 Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Salesforce Data 360 data 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.
-
Automated Continuous Lakebase Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Lakebase replication to Apache Kafka.
-
Access Adobe Analytics Data from MySQL in Amazon QuickSight
Connect to Adobe Analytics and build visualizations of Adobe Analytics data using a MySQL Connection in Amazon QuickSight.
-
Integrating GitHub Copilot with Azure Analysis Services 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.
-
Build ZohoSubscriptions-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live ZohoSubscriptions data without replication.
-
Connect to Real-Time Excel Online Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Excel Online and Dataflow to import and use Excel Online data in Power Apps.
-
Automated Continuous Teradata Replication to Vertica
Use CData Sync for automated, continuous, customizable Teradata replication to Vertica.
-
Create XML-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to XML Data from OutSystems and build custom enterprise apps using live XML data.
-
Use the CData Software ODBC Driver for Reckon in MicroStrategy Desktop
Connect to Reckon data in MicroStrategy Desktop using the CData Software ODBC Driver for Reckon.
-
Automate Sage 200 Data Replication to SAP HANA
Use CData Sync to customize and automate Sage 200 data replication to SAP HANA.
-
Connect to Amazon DynamoDB Data in Google Apps Script via Connect AI
Use CData Connect AI to access Amazon DynamoDB data in Google Apps Script.
-
Create Reports with Telegram Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Telegram data.
-
Automate RSS Feeds Replication to Azure Synapse
Use CData Sync to customize and automate RSS feeds replication to Azure Synapse.
-
Query ChargeOver Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ChargeOver data from Node.js.
-
Integrate DB2 with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate DB2 with External Services.
-
Automated Continuous ServiceNow Replication to Vertica
Use CData Sync for automated, continuous, customizable ServiceNow replication to Vertica.
-
How to Visualize SAP HANA Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SAP HANA data in Python.
-
How to publish and share SAP Business One Data dashboards with Tableau Server
The CData ODBC driver for SAP Business One enables you integrate SAP Business One data into Tableau dashboards.
-
View Reports on Real-Time Teamwork Data in Power BI Report Server
Use the CData ODBC Driver for Teamwork to visualize Teamwork data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Highrise Data in Google Apps Script via Connect AI
Use CData Connect AI to access Highrise data in Google Apps Script.
-
Automated Continuous PabblySubscriptions Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Azure SQL Database.
-
Create BambooHR-Connected Dashboards in Grafana
Connect to BambooHR Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to BambooHR data.
-
Use Agno to Talk to Your Trello 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 Trello data for you.
-
Getting Started with the CData SSIS Components for LinkedIn Ads
Complete guide to installing, licensing, and connecting with the CData SSIS Components for LinkedIn Ads.
-
Replicate Multiple Attio Accounts
Replicate multiple Attio accounts to one or many databases.
-
How to connect to Salesloft Data from IntelliJ
Integrate connectivity to Salesloft data with wizards in IntelliJ.
-
Rapidly Develop OneNote-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 OneNote.
-
Connect to Oracle Service Cloud Data from AWS Glue
Use CData Connect AI to gain access to live Oracle Service Cloud data from your AWS Glue jobs.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for BenchmarkEmail
Provide connectivity to BenchmarkEmail data through an SAP BusinessObjects universe.
-
Access Live Mode Data in Excel 365 Online (Excel for the web)
Connect to Mode data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Query ScrapingBee Data in DataGrip
Create a Data Source for ScrapingBee in DataGrip and use SQL to query live ScrapingBee data.
-
How to Query Live Gmail Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Gmail data data in natural language using Python.
-
Connect to Sage Intacct 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 Sage Intacct data.
-
Connect to Coda Data in Ruby
Connect to Coda data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Easily Query Zoho Recruit Data in OpenOffice Base
Connect to Zoho Recruit data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
DataBind Outlook Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Outlook data to a chart.
-
How to Query PabblySubscriptions Data in MySQL Workbench
Execute MySQL queries against live PabblySubscriptions data from MySQL Workbench.
-
Integrate ConvertKit Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ConvertKit data from Informatica Cloud.
-
How to connect to ZohoInvoice Data from IntelliJ
Integrate connectivity to ZohoInvoice data with wizards in IntelliJ.
-
Build MVC Applications with Connectivity to Kintone Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Kintone from an ASP.NET MVC application.
-
Integrating Claude Code CLI with Coinbase 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.
-
How to Query HelloSign Data in MySQL Workbench
Execute MySQL queries against live HelloSign data from MySQL Workbench.
-
How to connect and process HubDB data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live HubDB data.
-
Connect to QuickBooks Time Data in Aqua Data Studio
Access QuickBooks Time data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Analyze Live MarkLogic Data in SAS Viya
Use CData Connect AI to connect to MarkLogic data from SAS Viya and deploy self-service analytics using live MarkLogic data.
-
How to Connect DBeaver to ConvertAPI via a JDBC Driver
Manage ConvertAPI data with visual tools in DBeaver like the query browser.
-
Replicate Azure DevOps Data from PowerShell
Write a quick PowerShell script to query Azure DevOps data. Use connectivity to the live data to replicate Azure DevOps data to SQL Server.