CData Software - Knowledge Base
Recent Articles
-
Integrate Marketo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Marketo with External Services.
-
Connect to Dropbox Data from PowerBuilder via JDBC
This article demonstrates how to access Dropbox from PowerBuilder using the Dropbox JDBC Driver.
-
Query Okta Data as a SQL Server Database in Node.js
Execute SQL Server queries against Okta from Node.js.
-
Consume Google Campaign Manager 360 OData Feeds in PowerBuilder
This article demonstrates how to consume Google Campaign Manager 360 as OData feeds from PowerBuilder using the API Server.
-
Use the CData Software JDBC Driver for SQL Server in MicroStrategy Web
Connect to Microsoft SQL Server in MicroStrategy Web using the CData Software JDBC Driver for SQL Server.
-
Connect to Factorial Data in Aqua Data Studio
Access Factorial from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect the Power BI Service to PagerDuty: Complete Guide
Connect to the CData Software Power BI Connector for PagerDuty from PowerBI.com to provide real-time PagerDuty across the organization.
-
Create Reports with Azure Analysis Services Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure Analysis Services.
-
How to Connect to Live SAP Hybris C4C Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your SAP Hybris C4C for you.
-
Rapidly Develop Aweber-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 Aweber.
-
Connect to Acumatica Data in Aqua Data Studio
Access Acumatica ERP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
VWO Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on VWO facts in real time.
-
Automate Samanage Data Replication to Couchbase
Use CData Sync to Customize and automate Samanage replication to Couchbase.
-
Build MVC Applications with Connectivity to ZohoMarketingHub Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZohoMarketingHub from an ASP.NET MVC application.
-
Access Live Greenplum Data in AWS Lambda
Connect to live Pivotal GreenPlum in AWS Lambda using the CData JDBC Driver.
-
Build AI/ML Models with Live Microsoft Entra ID Data using Dataiku
Connect Microsoft Entra ID Data with Dataiku using the CData JDBC Driver for Microsoft Entra ID.
-
Load SingleStore Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SingleStore to a database.
-
Use the CData API Server to Access Office 365 Data in Microsoft PowerPivot
Use the CData API Server to connect to live Microsoft Office 365 in the Power Pivot business intelligence tool.
-
Connect to Amazon S3 Data from PowerBuilder via JDBC
This article demonstrates how to access Amazon S3 from PowerBuilder using the Amazon S3 JDBC Driver.
-
Connect to Real-Time DB2 Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for DB2 and Dataflow to import and use IBM DB2 in Power Apps.
-
Stream Epicor Kinetic Data into Apache Kafka Topics
Access and stream Epicor Kinetic in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Zoho Projects with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Zoho Projects with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Zoho Projects.
-
Automated Continuous Highrise Replication to Databricks
Use CData Sync for automated, continuous, customizable Highrise replication to Databricks.
-
Access Live Act CRM Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Act CRM data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Excel Data in Aqua Data Studio
Access Microsoft Excel from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Informatica Mappings From/To a JDBC Data Source for Microsoft Planner
Create Microsoft Planner data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Build an ETL App for FHIR Data in Python with CData
Create ETL applications and real-time data pipelines for FHIR in Python with petl.
-
Deploy the ADO.NET Provider for Outlook on an SSRS Report Server
Connect to Outlook 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.
-
How to create AlloyDB federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google AlloyDB in MySQL .
-
Automated Continuous Aha! Replication to SingleStore
Use CData Sync for automated, continuous, customizable Aha! replication to SingleStore.
-
How to Connect to DB2 Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to IBM DB2. Leverage the pyodbc module for ODBC in Python.
-
Replicate QuickBooks Time Data to Multiple Databases via the CData Sync CLI
Replicate QuickBooks Time to disparate databases with a single configuration.
-
Connect Timely Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Timely using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating Gumloop with Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Asana within automated workflows.
-
DataBind Redis Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Redis with the DevExpress Windows Forms and Web controls to provide Redis to a chart.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Adobe Analytics within intelligent workflows.
-
Integrating Claude Code CLI 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.
-
Visualize Live AlloyDB Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google AlloyDB using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Using the CData Software ODBC Driver for Pipeliner CRM in PyCharm
Connect to Pipeliner CRM as an ODBC data source in PyCharm using the CData Software ODBC Driver for Pipeliner CRM.
-
How to Connect Flowise AI Agents to Live Microsoft Planner Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Microsoft Planner without replication.
-
Automated Continuous YouTube Analytics Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Google Cloud SQL.
-
Build a Simple VCL Application for Quickbase Data
How to build a simple VCL Application to view Quickbase in RAD Studio using the CData ODBC Driver for Quickbase.
-
Connect to Codat Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Codat and work with Codat in your FileMaker applications.
-
Connect to Nuclia Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate Square Data in the Pentaho Report Designer
Publish reports based on Square in the Pentaho BI tool.
-
How to Connect to Live Pipedrive Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Pipedrive securely in real time.
-
Getting Started with the CData Tableau Connector for Mode
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create Dynamics CRM-Connected Nintex Workflows
Use CData Connect AI to connect to Dynamics CRM Data from Nintex Workflow Cloud and build custom workflows using live Microsoft Dynamics CRM.
-
A PostgreSQL Interface for Access Data (MySQL Remoting via JDBC)
Use the Remoting features of the Access JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous IBM Cloud Object Storage Replication to SQL Server
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to SQL Server.
-
How to Connect the Power BI Service to Onfleet: Complete Guide
Connect to the CData Software Power BI Connector for Onfleet from PowerBI.com to provide real-time Onfleet across the organization.
-
Automated Continuous Parquet Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apache Parquet replication to OneLake in Microsoft Fabric.
-
Access Aweber 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 Aweber.
-
Connect Parallel to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Parallel with IBM WebSphere for seamless data integration and connectivity.
-
Build Dashboards with Dropbox Data in DBxtra
Create dynamic dashboards and perform analytics based on Dropbox in DBxtra.
-
Build Semantic Layer Views for Hive Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Apache Hive.
-
Connect Authorize.Net to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Authorize.Net using the CData Python MCP Server.
-
How to integrate Adobe Analytics with Apache Airflow
Access and process Adobe Analytics in Apache Airflow using the CData JDBC Driver.
-
Manage OpenWeatherMap Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for OpenWeatherMap.
-
How to connect to Twilio Data from IntelliJ
Integrate connectivity to Twilio with wizards in IntelliJ.
-
Replicate OnePageCrm Data from PowerShell
Write a quick PowerShell script to query OnePageCrm. Use connectivity to the live data to replicate OnePageCrm to SQL Server.
-
Query FTP Data in DataGrip
Create a Data Source for FTP in DataGrip and use SQL to query live FTP Servers.
-
Connect to Google Contacts Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Contacts using standard SQL.
-
Build AI/ML Models with Live Grafana Data using Dataiku
Connect Grafana Data with Dataiku using the CData API Driver for JDBC.
-
Connect and Query Live Trello Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Trello into Databricks
-
Monday.com Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Monday.com facts in real time.
-
Import and Visualize Datadog Data in Power View
Create data visualizations based on Datadog in Excel.
-
Connect to Google Campaign Manager 360 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 Google Campaign Manager 360.
-
Automate Mailgun Data Replication to SAP HANA
Use CData Sync to customize and automate Mailgun replication to SAP HANA.
-
Integrate EnterpriseDB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate EnterpriseDB with External Services.
-
Operational Reporting on Typeform Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Typeform.
-
Automated Continuous Active Directory Replication to SQLite
Use CData Sync for automated, continuous, customizable Active Directory replication to SQLite.
-
Query, Visualize, and Share live Act CRM Data in Redash
Use CData Connect AI to connect to live Act CRM in Redash for querying, visualizing, and sharing.
-
Access Live HBase Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Apache HBase through MCP integration.
-
Replicate Helpscout Data to Multiple Databases via the CData Sync CLI
Replicate Helpscout to disparate databases with a single configuration.
-
Visualize Live Authorize.Net Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Authorize.Net using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect and process Exact Online from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Exact Online.
-
Validate BenchmarkEmail Data with QuerySurge
Access and validate BenchmarkEmail in QuerySurge using the CData JDBC Driver.
-
Visualize Live Dynamics CRM Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Dynamics CRM into custom reports in Power BI.
-
Connect to Square Data in Google Apps Script via Connect AI
Use CData Connect AI to access Square in Google Apps Script.
-
Build Spark Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Apache Spark SQL and build visualizations in Tableau Cloud.
-
Getting Started with the CData SSIS Components for MYOB AccountRight
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MYOB AccountRight.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Teamwork
Provide connectivity to Teamwork through an SAP BusinessObjects universe.
-
Model, Search, and Visualize Live Apollo Data in ThoughtSpot
Use CData Connect AI to connect to live Apollo for modeling, searching, and visualizing.
-
Visualize ZohoDesk 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 ZohoDesk into TIBCO Spotfire.
-
Query SAP SuccessFactors LMS Data as a MySQL Database in Node.js
Execute MySQL queries against SAP SuccessFactors LMS from Node.js.
-
Create SAP Hybris C4C Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Hybris C4C data access from reports, embedded analytics, and more.
-
Use the CData API Server to Access Avalara AvaTax Data in Microsoft PowerPivot
Use the CData API Server to connect to live Avalara AvaTax in the Power Pivot business intelligence tool.
-
Object-Relational Mapping (ORM) with Microsoft Exchange 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 Microsoft Exchange into a Java-based ORM framework, Hibernate.
-
Enable the Procore JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Procore.
-
OData Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on OData facts in real time.
-
Use the CData ODBC Driver for PabblySubscriptions in Microsoft Power Query
You can use the CData PabblySubscriptions ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import PabblySubscriptions into Microsoft Power Query.
-
Connect to Adobe Target Data from PowerBuilder via ADO.NET
This article demonstrates how to access Adobe Target from Appeon PowerBuilder using the CData ADO.NET Provider for Adobe Target.
-
Create Dynamic SAP Ariba Procurement Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Ariba Procurement to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Microsoft Exchange Data to Multiple Databases
Replicate Microsoft Exchange to disparate databases with a point-and-click configuration.
-
Create Redis-Connected Applications in Appsmith
Connect to Redis Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Redis.
-
Automated Continuous Sybase Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Sybase replication to IBM DB2.
-
DataBind Controls to Gorgias Data in C++Builder
DataBind to Gorgias in C++Builder with standard components and controls.
-
Connect to Google Cloud Storage Data in CloverDX (formerly CloverETL)
Transfer Google Cloud Storage using the visual workflow in the CloverDX data integration tool.
-
Bridge iContact Connectivity with Apache NiFi
Access and process iContact in Apache NiFi using the CData JDBC Driver.