CData Software - Knowledge Base
Recent Articles
-
Visualize Cvent Data in Sisense
Create an ElastiCube in Sisense app with access to Cvent data.
-
Replicate Keap Data in Heroku for Use in Salesforce Connect
Replicate Keap data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Seamlessly Import Coda Data into IBM SPSS Modeler
Integrate Coda data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Codex with SAP Ariba Source 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 Landbot to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Landbot with IBM WebSphere for seamless data integration and connectivity.
-
Add Landbot Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Landbot with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate with live FTP Data in Jitterbit
Use CData Connect AI to connect to and integrate live FTP data in Jitterbit.
-
Extract, Transform, and Load HDFS Data in Informatica PowerCenter
Create a simple Workflow for HDFS data in Informatica PowerCenter.
-
Salesloft Reporting in OBIEE with the Salesloft JDBC Driver
Deploy the Salesloft JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Live Datadog Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Datadog data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Use a Microsoft Access Database to Update LDAP Objects in Real Time
Update LDAP data by creating a linked table in Microsoft Access with the CData LDAP ODBC Driver.
-
Build a PostgreSQL Interface for Adobe Experience Manager Data using the CData JDBC Driver
Use the Remoting features of the Adobe Experience Manager JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Eventbrite Replication to SQL Server
Use CData Sync for automated, continuous, customizable Eventbrite replication to SQL Server.
-
Access Live Stack Exchange Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Stack Exchange data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Publish Reports with Webflow Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Webflow data.
-
Build a Simple VCL Application for ADP Data
How to build a simple VCL Application to view ADP data in RAD Studio using the CData ODBC Driver for ADP.
-
How to import Microsoft Dataverse Data into Apache Solr
Use the CData Software JDBC Driver for Microsoft Dataverse in Data Import Handler and create an automated import of Microsoft Dataverse data to Apache Solr Enterprise Search platform.
-
Automated Continuous Salesforce Pardot Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Apache Kafka.
-
How to Visualize Printify Data in Python with pandas
Use pandas and other modules to analyze and visualize live Printify data in Python.
-
Automated Continuous ChartMogul Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ChartMogul replication to Amazon S3.
-
Use Manus AI to Talk to Your BambooHR 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 BambooHR data.
-
Build Automated Coda-Connected Workflows in Zapier
Use CData Connect AI to connect to live Coda data and build automated workflows in Zapier.
-
DataBind Shippo Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Shippo data to a chart.
-
Integrate with Aha! Data in JReport Designer
Create charts and reports based on Aha! data in JReport Designer.
-
Connecting GenSpark with SAS Data Sets Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAS Data Sets data without any replication or custom integration required.
-
Cloudflare Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Cloudflare facts in real time.
-
How to Build an ETL App for Zuora Data in Python with CData Connect AI
Extract and transform live Zuora data in Python with petl and the CData Connect AI Python SDK.
-
Easily Integrate Todoist Data in Lazarus Pascal IDE
Learn how to easily integrate live Todoist data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Power BI Reports on Real-Time Salesforce Pardot Data
Use the CData ODBC Driver for Salesforce Pardot to visualize Salesforce Pardot data in Power BI Desktop.
-
Connect to Adobe Target Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Adobe Target data using standard SQL.
-
Build Charts with Zendesk Data in Clear Analytics
Create dynamic charts and perform analytics based on Zendesk data in Clear Analytics.
-
Visualize SAS xpt Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAS xpt data.
-
Access Live Dynamics NAV Data in Coginiti Pro
Connect to and query live Dynamics NAV data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Query Adobe Analytics Data in MySQL Workbench
Execute MySQL queries against live Adobe Analytics data from MySQL Workbench.
-
Use the CData ODBC Driver for Marketo in Microsoft Power Query
You can use the CData Marketo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Marketo data into Microsoft Power Query.
-
How to Seamlessly Import Instagram Data into IBM SPSS Modeler
Integrate Instagram data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build AI Agents with SAP Hybris C4C Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live SAP Hybris C4C data through CData Connect AI.
-
Integrate Trae with Live Guru Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Guru data from within the AI-powered IDE.
-
Integrate Oracle Financials Cloud Data in the Pentaho Report Designer
Publish reports based on Oracle Financials Cloud data in the Pentaho BI tool.
-
Integrating LangChain with FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on FreshBooks data within automated workflows.
-
Create Informatica Mappings From/To an ODBC Data Source for Salesforce
Create an ODBC connection to Salesforce in Informatica and browse and transfer Salesforce data.
-
How to Visualize Confluence Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Confluence data in Python.
-
Automate GitHub Data Replication to Azure Data Lake
Use CData Sync to customize and automate GitHub data replication to Azure Data Lake.
-
Access Humanity Data from MySQL in PHP
Connect to Humanity through the standard MySQL libraries in PHP.
-
Model, Search, and Visualize Live Oracle Eloqua Data in ThoughtSpot
Use CData Connect AI to connect to live Oracle Eloqua data for modeling, searching, and visualizing.
-
How to publish and share SAP Business Warehouse Data dashboards with Tableau Server
The CData ODBC driver for SAP Business Warehouse enables you integrate SAP Business Warehouse data into Tableau dashboards.
-
Automated Continuous Oracle Eloqua Reporting Replication to SQLite
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to SQLite.
-
Consume Microsoft Dataverse OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Microsoft Dataverse feeds that reflect any changes in SAP Lumira.
-
Integrate with live SendGrid Data in Jitterbit
Use CData Connect AI to connect to and integrate live SendGrid data in Jitterbit.
-
Object-Relational Mapping (ORM) with Xero 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 Xero data into a Java-based ORM framework, Hibernate.
-
Query, Visualize, and Share live Shippo Data in Redash
Use CData Connect AI to connect to live Shippo data in Redash for querying, visualizing, and sharing.
-
DataBind Jira Assets Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Jira Assets with the DevExpress Windows Forms and Web controls to provide Jira Assets data to a chart.
-
Building Dynamic Web Pages with SharePoint Excel Services Data Using AngularJS
Create single-page applications with live connectivity to SharePoint Excel Services using the CData API Server.
-
Query, Visualize, and Share live Oracle SCM Data in Redash
Use CData Connect AI to connect to live Oracle SCM data in Redash for querying, visualizing, and sharing.
-
How to Connect to Drip Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Drip data. Leverage the pyodbc module for ODBC in Python.
-
Feed Codat Data into FineReport
How to set Codat data as a JDBC data source in FineReport.
-
How to Connect to Live PingOne Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your PingOne data for you.
-
Process & Analyze Bitly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Bitly Data.
-
Connect to Live Microsoft OneDrive Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Microsoft OneDrive in CData Connect AI and connect to your Microsoft OneDrive data from PostgreSQL.
-
Query Live XML Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live XML data directly from the development environment.
-
Access Live PagerDuty Data in AWS Lambda
Connect to live PagerDuty data in AWS Lambda using the CData JDBC Driver.
-
Write a Simple Go Application to work with LaunchDarkly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to LaunchDarkly data.
-
Getting Started with the CData Power BI Connector for Shopify
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Shopify.
-
Connect to Oracle Service Cloud Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Oracle Service Cloud as an External Source in Dremio.
-
Query Aha! Data as a MySQL Database in Node.js
Execute MySQL queries against Aha! data from Node.js.
-
Connect Exa to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Exa with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for LightSpeedRetail in SAS for Real-Time Reporting and Analytics
Connect to real-time LightSpeedRetail data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for LightSpeedRetail.
-
How to Query Live Exact Online Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Exact Online data data in natural language using Python.
-
Integrate Live ConstantContact Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to ConstantContact from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live ConstantContact data.
-
Consume SAS Data Sets OData Feeds in PowerBuilder
This article demonstrates how to consume SAS Data Sets data as OData feeds from PowerBuilder using the API Server.
-
Design BIRT Reports on Notion Data
Provide current Notion data to your embedded analytics.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Cloud Storage
Create an ODBC connection to Google Cloud Storage in Informatica and browse and transfer Google Cloud Storage data.
-
Create Reports from Shippo Data in Looker Studio
Use CData Connect AI to gain access to live Shippo data and create custom reports in Looker Studio.
-
Automated Continuous Wrike Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Wrike replication to PostgreSQL.
-
Build an OLAP Cube in SSAS from Stripe Data
Establish a connection to Stripe data data from SQL Server Analysis Services, and use the Stripe Data Provider to build OLAP cubes for use in analytics and reporting.
-
Working with SingleStore Data in LINQPad
Execute LINQ queries to SingleStore data in LINQPad.
-
Access eBay Analytics Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live eBay Analytics data from HeidiSQL.
-
Automated Continuous RabbitMQ Replication to IBM DB2
Use CData Sync for automated, continuous, customizable RabbitMQ replication to IBM DB2.
-
Import Typeform Data Using Azure Data Factory
Use CData Connect AI to connect to Typeform Data from Azure Data Factory and import live Typeform data.
-
Build Agents in Relevance AI with Access to Live PolarTeamPro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on PolarTeamPro data within intelligent agent workflows.
-
Build Semantic Layer Views for Box Data in APOS Live Data Gateway
Use the CData Connector for Box in APOS Live Data Gateway to build Semantic Layer Views for Box data.
-
Automated Continuous ZohoPeople Replication to MongoDB
Use CData Sync for automated, continuous, customizable ZohoPeople replication to MongoDB.
-
How to Work with FreeAgent Data in AWS Glue Jobs Using JDBC
Connect to FreeAgent from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
A PostgreSQL Interface for CampaignMonitor Data (MySQL Remoting via JDBC)
Use the Remoting features of the CampaignMonitor JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Email-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Email data and build Email-connected web apps with Axios.
-
Viewing Scrapfly Data in RAD Studio Data Explorer
How to view Scrapfly data in RAD Studio Data Explorer using the CData ODBC Driver for Scrapfly.
-
Replicate JobNimbus Data from PowerShell
Write a quick PowerShell script to query JobNimbus data. Use connectivity to the live data to replicate JobNimbus data to SQL Server.
-
Bind Live Trello Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Trello data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to Mixpanel Data in CloverDX (formerly CloverETL)
Transfer Mixpanel data using the visual workflow in the CloverDX data integration tool.
-
Integrate Google's Antigravity Agent with Live Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Zoho Inventory data using the Model Context Protocol.
-
Use the CData Software ODBC Driver for Aircall in MicroStrategy Web
Connect to Aircall data in MicroStrategy Web using the CData Software ODBC Driver for Aircall.
-
Connect to Monday.com Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Monday.com and the SQL Gateway to access Monday.com data from Google Apps Script.
-
Publish Crystal Reports on SAP SuccessFactors LMS Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP SuccessFactors LMS data.
-
Access Live Databricks Data in AWS Lambda
Connect to live Databricks data in AWS Lambda using the CData JDBC Driver.
-
How to Connect to Live Monday.com 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 Monday.com data for you.
-
Use Claude to Talk to Your Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Power BI XMLA data for you.
-
Publish Microsoft Ads-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Ads data.
-
Search External ServiceDesk Plus Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ServiceDesk Plus data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ServiceDesk Plus Data objects that you can access from apps and the dashboard.
-
Natively Connect to Dotmailer Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Dotmailer data. Leverage the native support for ODBC in PHP.
-
Analyze Salesforce Data with PowerPivot
This article walks you through the process of using the CData ODBC Driver for Salesforce from PowerPivot. The technique described in this article can be used with any CData ODBC Driver.