CData Software - Knowledge Base
Recent Articles
-
Consume Act-On OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Act-On feeds that reflect any changes in SAP Lumira.
-
Integrating Claude Code with WordPress Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on WordPress within assisted coding and automated development workflows.
-
Analyze OData Services in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of OData and visualize the live Services in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Access LionDesk Data Using Entity Framework
This article shows how to access LionDesk using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Twilio Data from MySQL in PHP
Connect to Twilio through the standard MySQL libraries in PHP.
-
Migrating data from SAP BusinessObjects BI to Snowflake using CData SSIS Components.
Easily push SAP BusinessObjects BI to Snowflake using the CData SSIS Tasks for SAP BusinessObjects BI and Snowflake.
-
Connect to Testmonitor Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Testmonitor in the Denodo Virtual DataPort Administrator.
-
Import Cvent Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Cvent Data and provide access to live Cvent for custom reports in the Power BI Service.
-
Automated Continuous Neo4J Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Neo4J replication to Google Cloud SQL.
-
Model SAP Netweaver Gateway Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP Netweaver Gateway, enabling the direct import of real-time SAP Netweaver Gateway.
-
Access Live Adobe Analytics Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Adobe Analytics from your Excel spreadsheets.
-
Migrating data from MailerLite to Google BigQuery using CData SSIS Components.
Easily push MailerLite to Google BigQuery using the CData SSIS Tasks for MailerLite and Google BigQuery.
-
Build Data Flows from Mailjet to SQL Server using SSIS
Easily back up Mailjet to SQL Server using the SSIS components for Mailjet.
-
How to connect and process Opsgenie from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Opsgenie.
-
Automated Continuous Shippo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Shippo replication to SingleStore.
-
Access Live CockroachDB Data in Excel 365 Online (Excel for the web)
Connect to CockroachDB from Excel 365 Online (Excel for the web) with CData Connect AI.
-
ZeroBounce Reporting in OBIEE with the ZeroBounce JDBC Driver
Deploy the ZeroBounce JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query Gorgias Data in DataGrip
Create a Data Source for Gorgias in DataGrip and use SQL to query live Gorgias.
-
Connect to Oracle HCM Cloud Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Oracle HCM Cloud in Airbyte.
-
Use the CData Software JDBC Driver for CockroachDB in MicroStrategy Desktop
Connect to CockroachDB in MicroStrategy Desktop using the CData Software JDBC Driver for CockroachDB.
-
Analyze Pinecone Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Pinecone with the CData JDBC Driver for Pinecone.
-
Connect to CircleCI Data in Ruby
Connect to CircleCI in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating Cursor CLI with Gorgias 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.
-
Work with Live MarkLogic Data in Power Query
Use CData Connect AI to connect to MarkLogic and work with live MarkLogic in Microsoft Power Query.
-
Analyze Google Ad Manager Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Ad Manager with the CData JDBC Driver for Google Ad Manager.
-
How to Connect to Live Kintone 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 Kintone for you.
-
Access Amazon Marketplace 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 Amazon Marketplace.
-
Consume AlloyDB OData Feeds in SAP Lumira
Use the API Server to create data visualizations on AlloyDB feeds that reflect any changes in SAP Lumira.
-
Migrating data from Adobe Commerce to Databricks using CData SSIS Components.
Easily push Adobe Commerce to Databricks using the CData SSIS Tasks for Adobe Commerce and Databricks.
-
Access Live HBase Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live HBase data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Prepare, Blend, and Analyze Asana Data in Alteryx Designer (ODBC)
Build workflows to access live Asana for self-service data analytics.
-
Stream Zoho CRM Data into Apache Kafka Topics
Access and stream Zoho CRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Jumpseller Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Jumpseller replication to Azure SQL Database.
-
Query Shopify Data as a MySQL Database in Node.js
Execute MySQL queries against Shopify from Node.js.
-
Import and Visualize Neo4J Data in Power View
Create data visualizations based on Neo4J in Excel.
-
Access Live ActiveCampaign Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ActiveCampaign from your Excel spreadsheets.
-
Integrate Cline with Live Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Dynamics 365 Business Central from within your IDE.
-
Create Apps from SAS xpt Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAS xpt Data and build apps from live SAS XPORT in Qlik Sense Cloud.
-
Visualize MarkLogic Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MarkLogic.
-
How to connect PolyBase to GitLab
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live GitLab.
-
How to Connect to Live SAS xpt 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 SAS XPORT without replication.
-
Connect to Cloudflare Data from a Connection Pool in Jetty
The Cloudflare JDBC Driver supports connection pooling: This article shows how to connect faster to Cloudflare from Web apps in Jetty.
-
Import Real-Time PivotalTracker Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use PivotalTracker in ColdFusion.
-
Connect to NetSuite Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for NetSuite CRM & ERP in Airbyte.
-
Migrating data from Unbounce to Snowflake using CData SSIS Components.
Easily push Unbounce to Snowflake using the CData SSIS Tasks for Unbounce and Snowflake.
-
Build Microsoft Teams Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Teams and build visualizations in Tableau.
-
Create SQL Analysis Services-Connected Nintex Workflows
Use CData Connect AI to connect to SQL Analysis Services Data from Nintex Workflow Cloud and build custom workflows using live SQL Analysis Services.
-
Create Data Visualizations in Cognos BI with PhantomBuster Data
Access PhantomBuster as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Manage ADP Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ADP.
-
How to Connect to & Open Testmonitor Data in Microsoft Excel
This article uses the CData ODBC driver for Testmonitor to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
LINQ to PDFMonkey Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the PDFMonkey Data Provider.
-
Access Live HubSpot Data in AWS Lambda (with IntelliJ IDEA)
Connect to live HubSpot in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating Claude Code CLI with SAP BusinessObjects BI 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.
-
Enable the Strava JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Strava.
-
Visualize JSON Services in Tableau
The CData ODBC driver for JSON enables you integrate JSON into Tableau dashboards.
-
Connect to Box Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Box.
-
Build Dashboards with Browserless Data in Dundas BI
Create dynamic dashboards and perform analytics based on Browserless in Dundas BI.
-
How to connect to OData Services in DBVisualizer
Integrate OData with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Dynamics 365 Business Central Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Apache Cassandra.
-
How to Connect to Zoom Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zoom. Leverage the pyodbc module for ODBC in Python.
-
Use the CData ODBC Driver for Intercom in Microsoft Power Query
You can use the CData Intercom ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Intercom into Microsoft Power Query.
-
Add Telegram Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Telegram with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to SAP Ariba Source Data in Ruby
Connect to SAP Ariba Source in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Data Visualizations in Cognos BI with Bugsnag Data
Access Bugsnag as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Datasets from SendPulse in Domo Workbench and Build Visualizations of SendPulse Data in Domo
Use the CData Software ODBC Driver for SendPulse to create datasets from SendPulse in Domo Workbench and then build visualizations in the Domo service.
-
Query IBM Informix Data from Node.js
Use the OData endpoint of the CData API Server to connect to your IBM Informix and perform CRUD operations on IBM Informix from Node.js.
-
Query Exa Data in ColdFusion
Write standard ColdFusion data access code to connect to Exa.
-
How to Connect to Live WordPress 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 WordPress without replication.
-
Analyze Twitter Ads Data in Looker
Use CData Connect AI to connect to Twitter Ads Data from Looker and build custom apps using live Twitter Ads.
-
Feed SAP SuccessFactors LMS Data into FineReport
How to set SAP SuccessFactors LMS as a JDBC data source in FineReport.
-
Getting Started with the CData SSIS Components for Stripe
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Stripe.
-
Use the CData Software JDBC Driver for FTP in MicroStrategy Web
Connect to FTP Servers in MicroStrategy Web using the CData Software JDBC Driver for FTP.
-
Connect to Certinia Data from a Connection Pool in JBoss
Integrate Certinia into Java servlets: Use the Management Console in JBoss to install the Certinia JDBC Driver.
-
Integrating Cursor CLI with Rebilly 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.
-
Edit and Search External FTP Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of FTP Servers to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create FTP Data objects that you can access from apps and the dashboard.
-
Connect to Elasticsearch Data from a Connection Pool in JBoss
Integrate Elasticsearch into Java servlets: Use the Management Console in JBoss to install the Elasticsearch JDBC Driver.
-
Import Real-Time SharePoint Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft SharePoint in ColdFusion.
-
Connect to Twilio Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Twilio.
-
Connect to Bitbucket from Asprova with CData Software ODBC Driver for Bitbucket
This article shows how to connect faster to Bitbucket data from Asprova.
-
Automated Continuous ConstantContact Replication to SingleStore
Use CData Sync for automated, continuous, customizable ConstantContact replication to SingleStore.
-
Integrating Codex CLI with Dropbox 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.
-
Integrate Tally Data into Power Automate Desktop using CData Connect
CData Connect for Tally Data enables you to integrate Tally ERP into workflows built using Microsoft Power Automate Desktop.
-
Analyze MariaDB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MariaDB in Microsoft R Open.
-
Automated Continuous Bitbucket Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Bitbucket replication to delimited files (CSV/TSV).
-
Integrating Gumloop with SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft SharePoint within automated workflows.
-
Use Agno to Talk to Your Zoho Creator 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 Zoho Creator for you.
-
Use ChatGPT to Talk to Your Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google Calendar for you.
-
Integrate with IBM Cloud Object Storage Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy IBM Cloud Object Storage to a JSON file on disk.
-
Connect to Samanage Data in RazorSQL
Connect to Samanage from wizards and query Samanage from the GUI in the RazorSQL database management tool.
-
Integrating GitHub Copilot CLI with SingleStore 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 ChartMogul in MicroStrategy
Connect to ChartMogul in MicroStrategy Developer using the CData Software ODBC Driver for ChartMogul.
-
How to import Moosend Data into Apache Solr
Use the CData Software JDBC Driver for Moosend in Data Import Handler and create an automated import of Moosend to Apache Solr Enterprise Search platform.
-
Create Dynamic Azure Analysis Services Grids Using the Infragistics XamDataGrid
Learn how you can connect Azure Analysis Services to Infragistics XamDataGrid to build dynamic grids.
-
Design BIRT Reports on Auth0 Data
Provide current Auth0 to your embedded analytics.
-
How to create Wistia federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Wistia in MySQL .
-
Visualize Box Data in TIBCO Spotfire through ADO.NET
Integrate Box into dashboards in TIBCO Spotfire.
-
Build Apps with Live PolarTeamPro Data Using the Low-Code Development Platform of Mendix
Connect PolarTeamPro with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Excel Online Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Excel Online as an External Source in Dremio.
-
Prepare, Blend, and Analyze Amazon Marketplace Data in Alteryx Designer (Connect AI)
Build workflows to access live Amazon Marketplace for self-service data analytics.
-
DataBind Controls to MongoDB Data in C++Builder
DataBind to MongoDB in C++Builder with standard components and controls.