CData Software - Knowledge Base
Recent Articles
-
Create Reports with Raisers Edge NXT Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Raisers Edge NXT.
-
How to update Microsoft Planner from Excel
This article explains how to transfer data from Excel to Microsoft Planner using the Excel Add-In for Microsoft Planner.
-
Integrate with live Highrise Data in Jitterbit
Use CData Connect AI to connect to and integrate live Highrise CRM in Jitterbit.
-
Use the CData Software ODBC Driver for SAP in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP ERP/NetWeaver in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP.
-
Integrate with Avalara AvaTax Data in JReport Designer
Create charts and reports based on Avalara AvaTax in JReport Designer.
-
Publish Optimizely-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Optimizely.
-
Build a Simple VCL Application for Gmail Data
How to build a simple VCL Application to view Gmail in RAD Studio using the CData ODBC Driver for Gmail.
-
How to Use a Microsoft Access Database to Update Reckon Accounts Hosted Data in Real Time
Update Reckon Accounts Hosted data by creating a linked table in Microsoft Access with the CData Reckon Accounts Hosted ODBC Driver.
-
Analyze Live Oracle Sales Data in SAS Viya
Use CData Connect AI to connect to Oracle Sales from SAS Viya and deploy self-service analytics using live Oracle Sales.
-
Create Datasets from Databricks in Domo Workbench and Build Visualizations of Databricks Data in Domo
Use the CData Software ODBC Driver for Databricks to create datasets from Databricks in Domo Workbench and then build visualizations in the Domo service.
-
Reckon Reporting in OBIEE with the Reckon JDBC Driver
Deploy the Reckon JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData Software ODBC Driver for Oracle Eloqua in MicroStrategy
Connect to Oracle Eloqua in MicroStrategy Developer using the CData Software ODBC Driver for Oracle Eloqua.
-
Integrate Cline with Live Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Zendesk from within your IDE.
-
Object-Relational Mapping (ORM) with Sage Intacct 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 Sage Intacct into a Java-based ORM framework, Hibernate.
-
Connect to GitLab Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for GitLab in Airbyte.
-
Visualize Live SAP BusinessObjects BI Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP BusinessObjects BI into custom reports in Power BI.
-
Working with Opsgenie Data in LINQPad
Execute LINQ queries to Opsgenie in LINQPad.
-
DataBind Controls to MailerLite Data in C++Builder
DataBind to MailerLite in C++Builder with standard components and controls.
-
Integrate Cursor with Live Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Act CRM from within the editor.
-
Access Live SAP Concur Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP Concur from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to IBM Cloud Object Storage Data in ACL Analytics
Connect to IBM Cloud Object Storage via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to IBM Cloud Object Storage.
-
Connect Amazon Marketplace to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Amazon Marketplace with IBM WebSphere for seamless data integration and connectivity.
-
Build Charts with Teradata Data in Clear Analytics
Create dynamic charts and perform analytics based on Teradata in Clear Analytics.
-
Integrating Cursor CLI with Todoist 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.
-
Connect to and Visualize Live Guru Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Guru.
-
DataBind Bullhorn CRM Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Bullhorn CRM with the DevExpress Windows Forms and Web controls to provide Bullhorn CRM to a chart.
-
Create Datasets from Planio in Domo Workbench and Build Visualizations of Planio Data in Domo
Use the CData Software ODBC Driver for Planio to create datasets from Planio in Domo Workbench and then build visualizations in the Domo service.
-
Integrate HCL Domino Data into Power Automate Desktop using CData Connect
CData Connect for HCL Domino Data enables you to integrate HCL Domino into workflows built using Microsoft Power Automate Desktop.
-
How to integrate Wave Financial with Apache Airflow
Access and process Wave Financial in Apache Airflow using the CData JDBC Driver.
-
Create Apps from Okta Data in Qlik Sense Cloud
Use CData Connect AI to connect to Okta Data and build apps from live Okta in Qlik Sense Cloud.
-
Build Deel-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Deel and build web apps with connectivity to live Deel.
-
How to work with Box Data in Apache Spark using SQL
Access and process Box Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Google Sheets Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Sheets from Crystal Reports.
-
Create Informatica Mappings From/To an ODBC Data Source for Dynamics NAV
Create an ODBC connection to Dynamics NAV in Informatica and browse and transfer Microsoft Dynamics NAV.
-
Create Informatica Mappings From/To a JDBC Data Source for AgileCRM
Create AgileCRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Access Access Data Using Entity Framework
This article shows how to access Microsoft Access using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect to Live Amazon Athena Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Amazon Athena for you.
-
Automated Continuous Dynamics NAV Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Apache Kafka.
-
Query ShipEngine Data in ColdFusion
Write standard ColdFusion data access code to connect to ShipEngine.
-
How to work with Google Contacts Data in Apache Spark using SQL
Access and process Google Contacts Data in Apache Spark using the CData Software JDBC Driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Freshsales
Create Freshsales data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Publish SAP BusinessObjects BI-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP BusinessObjects BI.
-
Build Yelp-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Yelp and build web apps with connectivity to live Yelp.
-
How to Connect to Live Microsoft Dataverse Data 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 Microsoft Dataverse (CDS) without replication.
-
Publish Reports with Parquet Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Parquet.
-
Analyze Box Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Box and visualize Box in SAP Analytics Cloud.
-
Integrate Mocean Data in Pentaho Data Integration
Build ETL pipelines based on Mocean in the Pentaho Data Integration tool.
-
Use the CData ODBC Driver for Yelp in Microsoft Power Query
You can use the CData Yelp ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Yelp into Microsoft Power Query.
-
Automate Codat Data Replication to Azure Synapse
Use CData Sync to customize and automate Codat replication to Azure Synapse.
-
How to create Google Ads federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Ads in MySQL .
-
Create Data Visualizations Based On Microsoft Teams Data in Mode
Use CData Connect AI to connect to Microsoft Teams Data from Mode and build visualizations using live
-
How to integrate Metabase with Oracle Data
Use CData Connect AI to connect to live Oracle Database and create an interactive dashboard in Metabase from Oracle Database.
-
How to Access Live XML Data in Power Automate Desktop via ODBC
The CData ODBC Driver for XML enables you to integrate XML Files into workflows built using Microsoft Power Automate Desktop.
-
How to Visualize Pinterest Data in Python with pandas
Use pandas and other modules to analyze and visualize live Pinterest in Python.
-
Integrate with Postmark Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Postmark to a JSON file on disk.
-
How to Access SFTP Data Using Entity Framework
This article shows how to access SFTP using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Gumroad Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Gumroad from your Oracle system.
-
How to integrate Intercom with Apache Airflow
Access and process Intercom in Apache Airflow using the CData JDBC Driver.
-
Access BenchmarkEmail Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access BenchmarkEmail from your Oracle system.
-
Integrating MYOB AccountRight Data in Talend Cloud Data Management Platform
Connect MYOB AccountRight Data with Talend Cloud Data Management Platform using the CData JDBC Driver for MYOB AccountRight.
-
How to Query Live Redis Data in Claude Desktop
Connect to and query live Redis Data in Claude Desktop using CData MCP Server.
-
How to Access Live Google Directory Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Directory enables you to integrate Google Directory into workflows built using Microsoft Power Automate Desktop.
-
Publish Reports with Printify Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Printify.
-
Integrate Sentry Data in the Pentaho Report Designer
Publish reports based on Sentry in the Pentaho BI tool.
-
How to Create Power BI Visual Reports with Real-Time FHIR Data
Use CData Power BI Connectors to visualize FHIR in Power BI.
-
Publish Recurly-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Recurly.
-
Connect to Cloudant Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Creating Quickbase-Connected Applications in Unqork
You can use CData Connect AI to feed Quickbase to Unqork and build custom business apps.
-
Build BambooHR Visualizations in Tableau Desktop
Use CData Connect AI to connect to live BambooHR and build visualizations in Tableau.
-
Connect to Foursquare Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Foursquare using standard SQL.
-
Access Helpscout Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Helpscout.
-
Use the CData Software JDBC Driver for ElevenLabs in MicroStrategy Desktop
Connect to ElevenLabs in MicroStrategy Desktop using the CData Software JDBC Driver for ElevenLabs.
-
Integrating Claude Code CLI with Strava 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.
-
Visualize SparkPost Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SparkPost into TIBCO Spotfire.
-
Import JSON Services into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access JSON. In this article, you will use the OData format to import JSON into Microsoft Power Query.
-
Connect to Onfleet Data from PowerBuilder via ADO.NET
This article demonstrates how to access Onfleet from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Instagram-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Instagram and build web apps with connectivity to live Instagram.
-
Use the CData Software ODBC Driver for Box in MicroStrategy Web
Connect to Box in MicroStrategy Web using the CData Software ODBC Driver for Box.
-
Process & Analyze Google Search Results in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Search Results.
-
How to connect to PhantomBuster Data in DBVisualizer
Integrate PhantomBuster with visual data analysis tools and data connection wizards in DBVisualizer
-
Back Up Webex to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Webex data.
-
Integrate Avaza with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Avaza with External Services.
-
Automated Continuous Nethunt Replication to MySQL
Use CData Sync for automated, continuous, customizable Nethunt replication to MySQL.
-
Connect to Act CRM Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Rapidly Develop Jumpseller-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 Jumpseller.
-
Integrating Dataiku with Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Dynamics CRM.
-
Build Charts with Yelp Data in Clear Analytics
Create dynamic charts and perform analytics based on Yelp in Clear Analytics.
-
Create JobNimbus Dataflows on PowerBI.com
Connect to the CData Power BI Connector for JobNimbus from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Placid in SpagoBI
Create reports featuring live Placid in SpagoBI Studio. Host Placid reports on SpagoBI Server.
-
Connect to Snowflake Data in Ruby
Connect to Snowflake in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Visualize Xero Data in Python with pandas
Use pandas and other modules to analyze and visualize live Xero Accounting in Python.
-
Replicate Active Directory Data in Heroku for Use in Salesforce Connect
Replicate Active Directory to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData JDBC Driver for Salesforce Data 360
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Salesforce Data 360.
-
How to Work with Helpscout Data in ETL Validator JDBC
Connect to Helpscout from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Accelo Data in Ruby
Connect to Accelo in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData ODBC Driver for Salesloft from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Salesloft to connect to Salesloft from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Salesloft in Excel.
-
Automated Bannerbear Data Replication to Teradata
Use CData Sync to Customize and automate Bannerbear replication to Teradata.
-
How to Connect to & Open NetSuite Data in Microsoft Excel
This article uses the CData ODBC driver for NetSuite to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect the Power BI Service to ClickTime: Complete Guide
Connect to the CData Software Power BI Connector for ClickTime from PowerBI.com to provide real-time ClickTime across the organization.
-
Analyze ClickTime Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ClickTime from Power Pivot. You will use the Table Import Wizard to load ClickTime. You can visually build the import query or use any SQL supported by the driver.