CData Software - Knowledge Base
Recent Articles
-
Create Amazon Marketplace-Connected Dashboards in Grafana
Connect to Amazon Marketplace Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Amazon Marketplace.
-
How to Build an ETL App for Spark Data in Python with CData Connect AI
Build ETL pipelines that read and write live Apache Spark SQL in Python with petl and the CData Connect AI Python SDK.
-
Connect to Guru Data in JRuby
Create a simple JRuby app with access to live Guru.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Calendly
Provide connectivity to Calendly through an SAP BusinessObjects universe.
-
Build FreeAgent-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to FreeAgent and build web apps with connectivity to live FreeAgent.
-
Access Live LinkedIn Ads Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live LinkedIn Ads from your Excel spreadsheets.
-
Build Aircall-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Aircall and build web apps with connectivity to live Aircall.
-
Create Datasets from Microsoft Teams in Domo Workbench and Build Visualizations of Microsoft Teams Data in Domo
Use the CData Software ODBC Driver for Microsoft Teams to create datasets from Microsoft Teams in Domo Workbench and then build visualizations in the Domo service.
-
Prepare, Blend, and Analyze LaunchDarkly Data in Alteryx Designer (ODBC)
Build workflows to access live LaunchDarkly for self-service data analytics.
-
Getting Started with the CData Power BI Connector for Campaigner
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Use the CData Software ODBC Driver for GitHub in SAS for Real-Time Reporting and Analytics
Connect to real-time GitHub in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for GitHub.
-
Getting Started with the CData ADO.NET Provider for Couchbase
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Couchbase.
-
Automated Continuous Phoenix Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Phoenix replication to delimited files (CSV/TSV).
-
How to create Visio diagrams from Elasticsearch Data
Automatically update Elasticsearch with the changes you make to Visio master shapes.
-
How to Work with Redis Data in AWS Glue Jobs Using JDBC
Connect to Redis from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect to Raisers Edge NXT Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Raisers Edge NXT. Leverage the pyodbc module for ODBC in Python.
-
Analyze Kintone Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Kintone and visualize live Kintone in Infragistics Reveal.
-
Connect to Printify Data in HULFT Integrate
Connect to Printify as a JDBC data source in HULFT Integrate
-
Consume Cloudant OData Feeds in PowerBuilder
This article demonstrates how to consume IBM Cloudant as OData feeds from PowerBuilder using the API Server.
-
How to Connect to Live Act CRM Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Act CRM through natural language.
-
View Reports on Real-Time Browserless Data in Power BI Report Server
Use the CData ODBC Driver for Browserless to visualize Browserless in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Amazon S3 Data from MySQL in Amazon QuickSight
Connect to Amazon S3 and build visualizations of Amazon S3 using a MySQL Connection in Amazon QuickSight.
-
Integrate with Microsoft Planner Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft Planner in SnapLogic.
-
How to Build an ETL App for SAP SuccessFactors LMS Data in Python with CData Connect AI
Build ETL pipelines that read and write live SAP SuccessFactors LMS in Python with petl and the CData Connect AI Python SDK.
-
Integrating LlamaIndex with SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAP BusinessObjects BI in real time.
-
How to Build an ETL App for Zoho Projects Data in Python with CData Connect AI
Build ETL pipelines that read and write live Zoho Projects in Python with petl and the CData Connect AI Python SDK.
-
Integrate Real-Time Access to Email in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Email in real time.
-
Connect to Salesforce Pardot Data in ACL Analytics
Connect to Salesforce Pardot via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Salesforce Pardot.
-
Visualize Zendesk 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 Zendesk into TIBCO Spotfire.
-
Automated Continuous Reckon Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Reckon replication to PostgreSQL.
-
Query CloudConvert Data in DataGrip
Create a Data Source for CloudConvert in DataGrip and use SQL to query live CloudConvert.
-
How to connect to Google Drive Data from IntelliJ
Integrate connectivity to Google Drive with wizards in IntelliJ.
-
Create Reports with Google Analytics Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Analytics.
-
Build Voice Agents in ElevenLabs with access to Live Amazon Marketplace Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Amazon Marketplace.
-
Build a PostgreSQL Interface for AgileCRM Data using the CData JDBC Driver
Use the Remoting features of the AgileCRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Mailgun Replication to MySQL
Use CData Sync for automated, continuous, customizable Mailgun replication to MySQL.
-
Operational Reporting on Sentry Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sentry.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sentry
Provide connectivity to Sentry through an SAP BusinessObjects universe.
-
Use Grok to Talk to Your SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SQL Analysis Services for you.
-
Extract, Transform, and Load QuickBooks Time Data in Informatica PowerCenter
Create a simple Workflow for QuickBooks Time in Informatica PowerCenter.
-
Access Lakebase Data from MySQL in PHP
Connect to Lakebase through the standard MySQL libraries in PHP.
-
How to Seamlessly Import ConvertAPI Data into IBM SPSS Modeler
Integrate ConvertAPI data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData Software ODBC Driver for Microsoft Teams in MicroStrategy Web
Connect to Microsoft Teams in MicroStrategy Web using the CData Software ODBC Driver for Microsoft Teams.
-
Connect to Elasticsearch Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Elasticsearch from Filemaker Pro on Mac.
-
Use Dash to Build to Web Apps on SAP Data
Create Python applications that use pandas and Dash to build SAP-connected web apps.
-
DataBind Controls to Adobe Commerce Data in Delphi
DataBind to Adobe Commerce in Delphi with standard data access components and controls.
-
Automated Continuous Redis Replication to SQL Server
Use CData Sync for automated, continuous, customizable Redis replication to SQL Server.
-
How to use SQLAlchemy ORM to access Authorize.Net Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Authorize.Net.
-
Connect to eBay Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live eBay from Filemaker Pro on Mac.
-
Automated Continuous EnterpriseDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to OneLake in Microsoft Fabric.
-
Automated Continuous Cvent Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Cvent replication to Google Cloud SQL.
-
Integrating Claude Code with Email Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Email within assisted coding and automated development workflows.
-
Connect to Dynamics NAV Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Dynamics NAV to connect to Microsoft Dynamics NAV and execute queries in PowerBuilder.
-
Work with Live Box Data in Power Query
Use CData Connect AI to connect to Box and work with live Box in Microsoft Power Query.
-
How to connect and process Azure Data Lake Storage from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Azure Data Lake Storage.
-
Access Live SAP BusinessObjects BI Data in AWS Lambda
Connect to live SAP BusinessObjects BI in AWS Lambda using the CData JDBC Driver.
-
Integrating Dataiku with CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Apache CouchDB.
-
Build Oracle Financials Cloud-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle Financials Cloud.
-
Connect Perigon to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Perigon with IBM WebSphere for seamless data integration and connectivity.
-
Extract, Transform, and Load ConvertAPI Data in Informatica PowerCenter
Create a simple Workflow for ConvertAPI in Informatica PowerCenter.
-
Access Active Directory Data from MySQL in Amazon QuickSight
Connect to Active Directory and build visualizations of Active Directory using a MySQL Connection in Amazon QuickSight.
-
Choosing the Best Method to Connect FTP to SQL Server: 5 Options Explained
Discover multiple ways to connect and use FTP Servers from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
DataBind Charts to AfterShip Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to AfterShip 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.
-
Connect to Apollo from Asprova with CData Software ODBC Driver for Apollo
This article shows how to connect faster to Apollo data from Asprova.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Azure SQL Database.
-
How to Easily Query Typeform Data in OpenOffice Base
Connect to Typeform data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use the CData Software ODBC Driver for Gorgias in MicroStrategy Web
Connect to Gorgias in MicroStrategy Web using the CData Software ODBC Driver for Gorgias.
-
Automated Continuous Paylocity Replication to SQL Server
Use CData Sync for automated, continuous, customizable Paylocity replication to SQL Server.
-
How to connect to Gong Data from IntelliJ
Integrate connectivity to Gong with wizards in IntelliJ.
-
Automated Continuous CockroachDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable CockroachDB replication to SingleStore.
-
Automated Continuous Marketo Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Marketo replication to IBM DB2.
-
Use the CData Software ODBC Driver for GitHub in MicroStrategy
Connect to GitHub in MicroStrategy Developer using the CData Software ODBC Driver for GitHub.
-
Automated Continuous Accelo Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Accelo replication to Google BigQuery.
-
Analyze Square Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Square and visualize live Square in Infragistics Reveal.
-
Build Todoist-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Todoist.
-
How to Connect Google Analytics 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 Google Analytics data in real time using natural language.
-
Operational Reporting on Testmonitor Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Testmonitor.
-
Connect to Acumatica 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 Acumatica ERP.
-
Automate Monday.com Data Replication to Azure Synapse
Use CData Sync to customize and automate Monday.com replication to Azure Synapse.
-
Visualize ZohoExpense Data in Sisense
Create an ElastiCube in Sisense app with access to ZohoExpense.
-
Analyze Slack Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Slack with the CData JDBC Driver for Slack.
-
Choosing the Best Method to Connect Adobe Target to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Adobe Target from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Microsoft Copilot Studio to talk to your Procore 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 Procore for you.
-
Build a Singer.io Tap for Marketo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Marketo data using
-
Access Live SuiteCRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SuiteCRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Acumatica Data in Tableau
The CData ODBC driver for Acumatica enables you integrate Acumatica ERP into Tableau dashboards.
-
Import Slack Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Slack. In this article, you will use the OData format to import Slack into Microsoft Power Query.
-
Natively Connect to Google Campaign Manager 360 Data in PHP
The CData ODBC driver for Google Campaign Manager 360 enables you to create PHP applications with connectivity to Google Campaign Manager 360. Leverage the native support for ODBC in PHP.
-
Publish Crystal Reports on Oracle Sales Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Oracle Sales.
-
Connect to SurveyMonkey Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SurveyMonkey using standard SQL.
-
Use the CData Software ODBC Driver for Pipeline CRM in MicroStrategy Desktop
Connect to Pipeline CRM in MicroStrategy Desktop using the CData Software ODBC Driver for Pipeline CRM.
-
Automated Continuous Azure Data Catalog Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to PostgreSQL.
-
Establish a Live Connection with Reckon Data using Tableau Bridge
The CData ODBC Driver for Reckon enables you to integrate live Reckon into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Build an ETL App for Instantly Data in Python with CData
Create ETL applications and real-time data pipelines for Instantly in Python with petl.
-
Build Insightly-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Insightly and build web apps with connectivity to live Insightly.
-
Access MessageBird 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 MessageBird.
-
Prepare, Blend, and Analyze Paddle Data in Alteryx Designer (ODBC)
Build workflows to access live Paddle for self-service data analytics.
-
How to connect to Exa Data from IntelliJ
Integrate connectivity to Exa with wizards in IntelliJ.
-
Automate SAP SuccessFactors Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP SuccessFactors replication to Azure Data Lake.
-
Query Microsoft Teams Data as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft Teams from Node.js.