CData Software - Knowledge Base
Recent Articles
-
Access Live WordPress Data in AWS Lambda
Connect to live WordPress data in AWS Lambda using the CData JDBC Driver.
-
Analyze Salesforce Data 360 Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Salesforce Data 360 data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect and Query Live DB2 Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live DB2 data into Databricks and enable direct, live querying and analysis without replication.
-
How to publish and share Microsoft Exchange Data dashboards with Tableau Server
The CData ODBC driver for Microsoft Exchange enables you integrate Microsoft Exchange data into Tableau dashboards.
-
Connect to and Query SAP HANA XS Advanced Data in QlikView over ODBC
Create data visualizations with SAP HANA XS Advanced data in QlikView.
-
Automated Continuous Elasticsearch Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Google BigQuery.
-
Build HDFS-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to HDFS data and build web apps with connectivity to live HDFS data.
-
Connect to Power BI XMLA Data from PowerBuilder via JDBC
This article demonstrates how to access Power BI XMLA data from PowerBuilder using the Power BI XMLA JDBC Driver.
-
ETL Mouseflow in Oracle Data Integrator
This article shows how to transfer Mouseflow data into a data warehouse using Oracle Data Integrator.
-
Feed ZohoMarketingHub Data into FineReport
How to set ZohoMarketingHub data as a JDBC data source in FineReport.
-
Connect to QuickBooks Time from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from QuickBooks Time data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrating Claude Code with Sugar CRM Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Sugar CRM data within assisted coding and automated development workflows.
-
Connect Postmark Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Postmark data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Model, Search, and Visualize Live Authorize.Net Data in ThoughtSpot
Use CData Connect AI to connect to live Authorize.Net data for modeling, searching, and visualizing.
-
Create Datasets from Vimeo in Domo Workbench and Build Visualizations of Vimeo Data in Domo
Use the CData Software ODBC Driver for Vimeo to create datasets from Vimeo data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to and Visualize Live Amazon Marketplace Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Amazon Marketplace data.
-
Create Rebilly Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Rebilly from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData ODBC Driver for Shopify
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Shopify.
-
Migrating data from Microsoft Teams to Snowflake using CData SSIS Components.
Easily push Microsoft Teams data to Snowflake using the CData SSIS Tasks for Microsoft Teams and Snowflake.
-
Validate Toggl Data with QuerySurge
Access and validate Toggl data in QuerySurge using the CData JDBC Driver.
-
Build MVC Applications with Connectivity to Oracle Eloqua Reporting Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Oracle Eloqua Reporting from an ASP.NET MVC application.
-
Integrate with Live Pinterest Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Pinterest from the MuleSoft Anypoint Platform to integrate live Pinterest data into custom reports and dashboards.
-
Create Power BI Reports on Real-Time Mailgun Data
Use the CData ODBC Driver for Mailgun to visualize Mailgun data in Power BI Desktop.
-
How to Connect DBeaver to Microsoft Planner via a JDBC Driver
Manage Microsoft Planner data with visual tools in DBeaver like the query browser.
-
Use the CData ODBC Driver for Paymo in Microsoft Power Query
You can use the CData Paymo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Paymo data into Microsoft Power Query.
-
DataBind Controls to Active Directory Data in C++Builder
DataBind to Active Directory data in C++Builder with standard components and controls.
-
Create Reports from Cosmos DB Data in Looker Studio
Use CData Connect AI to gain access to live Cosmos DB data and create custom reports in Looker Studio.
-
Replicate JotForm Data to Multiple Databases
Replicate JotForm data to disparate databases with a point-and-click configuration.
-
Establish a Live Connection with Pushbullet Data using Tableau Bridge
The CData ODBC Driver for Pushbullet enables you to integrate live Pushbullet data into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live Mailjet Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Mailjet data into the statistical analysis tools available in SAS JMP. This article shows how to use Mailjet data in the Graph Builder and Query Builder.
-
Add Spotify Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Spotify with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Live MariaDB Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to MariaDB data and integrate live MariaDB data into apps built in Microsoft Power Apps.
-
Build Marketo-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Marketo data and build Marketo-connected web apps with Axios.
-
How to connect to Teamwork Data in DBVisualizer
Integrate Teamwork data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to PhantomBuster Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to PhantomBuster and work with PhantomBuster data in your FileMaker applications.
-
Use the CData Software JDBC Driver for Demio in MicroStrategy Web
Connect to Demio data in MicroStrategy Web using the CData Software JDBC Driver for Demio.
-
How to use SQLAlchemy ORM to access ZendeskSell Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ZendeskSell data.
-
Visualize FreeAgent Data in Sisense
Create an ElastiCube in Sisense app with access to FreeAgent data.
-
Create BenchmarkEmail-Connected Business Apps in AppSheet
Connect to BenchmarkEmail Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to BenchmarkEmail data.
-
Replicate Invoiced Data from PowerShell
Write a quick PowerShell script to query Invoiced data. Use connectivity to the live data to replicate Invoiced data to SQL Server.
-
How to Connect to Live Microsoft Planner Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Microsoft Planner data for you.
-
Create a Data Access Object for Paddle Data using JDBI
A brief overview of creating a SQL Object API for Paddle data in JDBI.
-
Use the CData Software ODBC Driver for XML in SAS for Real-Time Reporting and Analytics
Connect to real-time XML data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for XML.
-
Create Informatica Mappings From/To a JDBC Data Source for Dynamics 365 Business Central
Create Dynamics 365 Business Central data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData JDBC Driver for Email
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Email.
-
Manage Retently Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Retently.
-
How to Easily Query JSON Services in OpenOffice Base
Connect to JSON data in OpenOffice Base using the CData ODBC Driver for JSON and generate reports with live data insights.
-
Integrating Kiro with Notion 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.
-
Natively Connect to Jodoo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Jodoo data. Leverage the native support for ODBC in PHP.
-
Build a PostgreSQL Interface for Oracle SCM Data using the CData JDBC Driver
Use the Remoting features of the Oracle SCM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Sage 200 in MicroStrategy
Connect to Sage 200 data in MicroStrategy Developer using the CData Software JDBC Driver for Sage 200.
-
How to Access Superchat Data Using Entity Framework
This article shows how to access Superchat data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Attio Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Attio data from Informatica Cloud.
-
Create a Data Access Object for SAP Ariba Source Data using JDBI
A brief overview of creating a SQL Object API for SAP Ariba Source data in JDBI.
-
Access Live Oracle SCM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle SCM data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to connect PolyBase to Everhour
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Everhour data.
-
Access LightSpeedRetail Data from MySQL in Amazon QuickSight
Connect to LightSpeedRetail and build visualizations of LightSpeedRetail data using a MySQL Connection in Amazon QuickSight.
-
Integrate Adobe Experience Manager Data in the Pentaho Report Designer
Publish reports based on Adobe Experience Manager data in the Pentaho BI tool.
-
Analyze WordPress Data in Looker
Use CData Connect AI to connect to WordPress Data from Looker and build custom apps using live WordPress data.
-
Use the CData ODBC Driver for Exact Online in Microsoft Power Query
You can use the CData Exact Online ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Exact Online data into Microsoft Power Query.
-
Use Manus AI to Talk to Your Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Shopify data.
-
How to import SingleStore Data into Apache Solr
Use the CData Software JDBC Driver for SingleStore in Data Import Handler and create an automated import of SingleStore data to Apache Solr Enterprise Search platform.
-
How to Connect to Live Square Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Square data without replication.
-
Bind Live Gmail Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Gmail data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to Create Power BI Visual Reports with Real-Time Todoist Data
Use CData Power BI Connectors to visualize Todoist data in Power BI.
-
Use the CData Software ODBC Driver for OneNote in MicroStrategy
Connect to OneNote data in MicroStrategy Developer using the CData Software ODBC Driver for OneNote.
-
Replicate Multiple Gorgias Accounts via the CData Sync CLI
Replicate multiple Gorgias accounts to one or many databases.
-
Building Dynamic Web Pages with ServiceNow Data Using AngularJS
Create single-page applications with live connectivity to ServiceNow using the CData API Server.
-
How to Connect to Live Snowflake 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 Snowflake data through natural language.
-
DataBind Charts to ZohoSubscriptions Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ZohoSubscriptions 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.
-
Integrating OpenCode with SharePoint Excel 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.
-
Connecting Pipedream with Oracle Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Oracle data in real time.
-
How to Build an ETL App for ActiveCampaign Data in Python with CData Connect AI
Build ETL pipelines that read and write live ActiveCampaign data in Python with petl and the CData Connect AI Python SDK.
-
Connect to PingOne Data from Crystal Reports
Use CData Connect AI to connect to and report on live PingOne data from Crystal Reports.
-
Integrate Goose with Live Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Oracle Financials Cloud data from within the local AI agent.
-
Automated Continuous Postmark Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Postmark data replication to OneLake in Microsoft Fabric.
-
Use the CData Software ODBC Driver for Avro in MicroStrategy Desktop
Connect to Avro data in MicroStrategy Desktop using the CData Software ODBC Driver for Avro.
-
Automated Continuous GitHub Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable GitHub replication to Google BigQuery.
-
Integrate Pipedrive Data in Pentaho Data Integration
Build ETL pipelines based on Pipedrive data in the Pentaho Data Integration tool.
-
How to Connect to Live Salesforce 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 Salesforce data for you.
-
Integrate Google's Antigravity Agent with Live SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAS xpt data using the Model Context Protocol.
-
Connect to Microsoft Planner Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Planner data from PowerBuilder using the Microsoft Planner JDBC Driver.
-
Working with FormSite Data in LINQPad
Execute LINQ queries to FormSite data in LINQPad.
-
Use Biml to Build SSIS Tasks to Replicate Xero Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Xero data to SQL Server.
-
Natively Connect to PDFMonkey Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PDFMonkey data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Oracle Financials Cloud Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Google BigQuery.
-
Create Reports with Microsoft Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Ads data.
-
Publish QuickBooks Time-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live QuickBooks Time data.
-
Connect to Cohere Data in DBeaver
Use the CData ODBC Driver to connect to Cohere data in DBeaver.
-
How to Visualize Adobe Analytics Data in Python with pandas
Use pandas and other modules to analyze and visualize live Adobe Analytics data in Python.
-
Replicate Multiple Aha! Accounts
Replicate multiple Aha! accounts to one or many databases.
-
DataBind Controls to Excel Online Data in C++Builder
DataBind to Excel Online data in C++Builder with standard components and controls.
-
Build Voice Agents in ElevenLabs with access to Live Bright Data Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Bright Data data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Salesloft
Provide connectivity to Salesloft data through an SAP BusinessObjects universe.
-
How to Easily Query ClickUp Data in OpenOffice Base
Connect to ClickUp data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Visualize Live SparkPost Data in the Power BI Service
Use CData Connect AI to connect to live SparkPost data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Live ZohoPeople Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live ZohoPeople data securely in real time.
-
Use the CData Software JDBC Driver for VWO in MicroStrategy Web
Connect to VWO data in MicroStrategy Web using the CData Software JDBC Driver for VWO.
-
Getting Started with the CData ADO.NET Provider for Close
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build Pipelines with Live Sugar CRM Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Sugar CRM from Google Cloud Data Fusion, enabling the integration of live Sugar CRM data into the building and management of effective data pipelines.