CData Software - Knowledge Base
Recent Articles
-
Integrate Facebook Data in the Pentaho Report Designer
Publish reports based on Facebook data in the Pentaho BI tool.
-
Analyze Facebook Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Facebook data and visualize Facebook data in SAP Analytics Cloud.
-
Connect to SAP Ariba Procurement Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Ariba Procurement data from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Ariba Procurement.
-
Access Live Paylocity Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Paylocity data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automate Google Cloud Storage Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Cloud Storage data replication to Azure Data Lake.
-
Query Reckon Accounts Hosted Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Reckon Accounts Hosted entities in PHP by modeling them as objects.
-
Connect to SAP Business One Data in Ruby
Connect to SAP Business One data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Tickspot in SpagoBI
Create reports featuring live Tickspot data in SpagoBI Studio. Host Tickspot reports on SpagoBI Server.
-
How to Connect the Power BI Service to CampaignMonitor: Complete Guide
Connect to the CData Software Power BI Connector for CampaignMonitor from PowerBI.com to provide real-time CampaignMonitor data across the organization.
-
How to connect to Sugar CRM Data from Spring Boot
Connect to Sugar CRM in a Spring Boot Application using the CData JDBC Driver for Sugar CRM
-
Access Google Ad Manager Data from MySQL in Amazon QuickSight
Connect to Google Ad Manager and build visualizations of Google Ad Manager data using a MySQL Connection in Amazon QuickSight.
-
Access Live Jira Data in Excel 365 Online (Excel for the web)
Connect to Jira data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to SAP Hybris C4C Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Hybris C4C data from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Hybris C4C.
-
Connect to Webflow Data from a Connection Pool in Jetty
The Webflow JDBC Driver supports connection pooling: This article shows how to connect faster to Webflow data from Web apps in Jetty.
-
Connect to Instagram Data in RapidMiner
Integrate Instagram data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to work with LeadDesk Data in Apache Spark using SQL
Access and process LeadDesk Data in Apache Spark using the CData Software JDBC Driver.
-
How to Access SAP Data Using Entity Framework
This article shows how to access SAP data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Google's Antigravity Agent with Live Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Vertica data using the Model Context Protocol.
-
Integrating Cursor with MongoDB 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 to Google Cloud Storage Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Google Cloud Storage.
-
Query SAP ByDesign Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP ByDesign data from Node.js.
-
Publish Crystal Reports on DB2 Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date DB2 data.
-
Import Real-Time Gong Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Gong data in ColdFusion.
-
Connect to and Visualize Live Hacker News Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Hacker News data.
-
Natively Connect to Azure Table Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Azure Table data. Leverage the native support for ODBC in PHP.
-
Create Notion Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Notion from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automate SAP Concur Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Concur data from PowerShell? This article demonstrates how to utilize the SAP Concur Cmdlets for tasks like connecting to SAP Concur data, automating operations, downloading data, and more.
-
Cvent Reporting in OBIEE with the Cvent JDBC Driver
Deploy the Cvent JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Oracle SCM 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 Oracle SCM data.
-
Build Oracle HCM Cloud-Connected Apps in Choreo
Use CData Connect AI to connect to Oracle HCM Cloud Data from Choreo and build custom apps using live Oracle HCM Cloud data.
-
Build Apps with Live Zoho Inventory Data Using the Low-Code Development Platform of Mendix
Connect Zoho Inventory data with Mendix to build apps using the CData JDBC Driver for Zoho Inventory.
-
Connect to Outreach.io Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Outreach.io data in Airbyte.
-
Migrating data from GraphQL to Databricks using CData SSIS Components.
Easily push GraphQL data to Databricks using the CData SSIS Tasks for GraphQL and Databricks.
-
How to Build an ETL App for Facebook Ads Data in Python with CData
Create ETL applications and real-time data pipelines for Facebook Ads data in Python with petl.
-
Use the CData ODBC Driver for Supabase from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Supabase to connect to Supabase data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Supabase data in Excel.
-
Connect to Gong Data from PowerBuilder via ADO.NET
This article demonstrates how to access Gong data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrating LlamaIndex with Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Microsoft Ads data in real time.
-
LINQ to SAP Ariba Source 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 SAP Ariba Source Data Provider.
-
Getting Started with the CData Tableau Connector for Smartsheet
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Smartsheet.
-
Analyze Azure Analysis Services Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Azure Analysis Services data with the CData JDBC Driver for Azure Analysis Services.
-
Query Microsoft Entra ID Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft Entra ID data from Node.js.
-
Analyze Snapchat Ads Data in Looker
Use CData Connect AI to connect to Snapchat Ads Data from Looker and build custom apps using live Snapchat Ads data.
-
Access Live Shopify Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Shopify data through MCP integration.
-
How to connect to SAS Data Sets Data in DBVisualizer
Integrate SAS Data Sets data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Live xBase Data in MicroStrategy through CData Connect AI
Create a live connection to xBase Data in CData Connect AI and connect to your xBase data from MicroStrategy.
-
Connect to Amazon S3 from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Amazon S3 data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Amazon DynamoDB Data in Jaspersoft Studio
Execute SQL to remote Amazon DynamoDB data in Jaspersoft Studio.
-
Create SSAS Tabular Models from Timely Data
How to build a SQL Server Analysis Service Tabular Model from Timely data using CData drivers.
-
Replicate Salesforce CRM Analytics Data in Heroku for Use in Salesforce Connect
Replicate Salesforce CRM Analytics data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate SAP SuccessFactors LMS Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP SuccessFactors LMS data and integrate live SAP SuccessFactors LMS data into your Power Automate tasks.
-
Build AI/ML Models with Live SingleStore Data using Dataiku
Connect SingleStore Data with Dataiku using the CData JDBC Driver for SingleStore.
-
Migrating data from Airtable to Google BigQuery using CData SSIS Components.
Easily push Airtable data to Google BigQuery using the CData SSIS Tasks for Airtable and Google BigQuery.
-
Publish Box-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Box data.
-
How to Easily Query Neo4J Data in OpenOffice Base
Connect to Neo4J data in OpenOffice Base using the CData ODBC Driver for Neo4J and generate reports with live data insights.
-
Getting Started with the CData ADO.NET Provider for Retently
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Analyze AlloyDB Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of AlloyDB data and visualize live AlloyDB data in Infragistics Reveal.
-
Trigger MailChimp IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for MailChimp with standard wizards in Logic Apps.
-
How to use SQLAlchemy ORM to access Airtable Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Airtable data.
-
Connect Printful to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Printful with IBM WebSphere for seamless data integration and connectivity.
-
How to Build an ETL App for Apollo Data in Python with CData
Create ETL applications and real-time data pipelines for Apollo data in Python with petl.
-
Access Live Dropbox Data in Coginiti Pro
Connect to and query live Dropbox data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create SSAS Tabular Models from Microsoft OneDrive Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft OneDrive data using CData drivers.
-
Connect to SpaceX Data in DBeaver
Use the CData ODBC Driver to connect to SpaceX data in DBeaver.
-
Object-Relational Mapping (ORM) with ActiveCampaign 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 ActiveCampaign data into a Java-based ORM framework, Hibernate.
-
Getting Started with the CData Power BI Connector for Okta
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Okta.
-
DataBind Charts to Oracle Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle 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.
-
Create Apps from Adobe Commerce Data in Qlik Sense Cloud
Use CData Connect AI to connect to Adobe Commerce Data and build apps from live Adobe Commerce data in Qlik Sense Cloud.
-
How to Access Live Google Sheets Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Sheets enables you to integrate Google Sheets data into workflows built using Microsoft Power Automate Desktop.
-
Work with Microsoft Teams Data in FoxPro
Load Microsoft Teams data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Seamlessly Bring SingleStore Data into Retool Using CData Connect AI
Integrate SingleStore data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous RSS Replication to MongoDB
Use CData Sync for automated, continuous, customizable RSS replication to MongoDB.
-
Operational Reporting on PagerDuty Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PagerDuty data.
-
Use the CData Software ODBC Driver for Tavily in MicroStrategy
Connect to Tavily data in MicroStrategy Developer using the CData Software ODBC Driver for Tavily.
-
Integrating Claude Code with QuickBooks Time Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on QuickBooks Time data within assisted coding and automated development workflows.
-
Connect to SQL Analysis Services in SpagoBI
Create reports featuring live SQL Analysis Services data in SpagoBI Studio. Host SQL Analysis Services reports on SpagoBI Server.
-
Build a PostgreSQL Interface for Customer.io Data using the CData JDBC Driver
Use the Remoting features of the Customer.io JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Sage Cloud Accounting Data in Talend Cloud Data Management Platform
Connect Sage Cloud Accounting Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Sage Cloud Accounting.
-
How to Create Power BI Visual Reports with Real-Time Dynamics CRM Data
Use CData Power BI Connectors to visualize Dynamics CRM data in Power BI.
-
How to Query Active Directory Data in MySQL Workbench
Execute MySQL queries against live Active Directory data from MySQL Workbench.
-
Access Live Google Sheets Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Google Sheets data through MCP integration.
-
Replicate Multiple LeadDesk Accounts via the CData Sync CLI
Replicate multiple LeadDesk accounts to one or many databases.
-
Integrating Antigravity CLI with Exa data via CData CLI
Connect Exa data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Seamlessly Import Landbot Data into IBM SPSS Modeler
Integrate Landbot data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Facebook Ads Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Facebook Ads as an External Source in Dremio.
-
Connect to Real-Time Tickspot Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Tickspot data in Power Apps.
-
Create Reports from Gmail Data in Looker Studio
Use CData Connect AI to gain access to live Gmail data and create custom reports in Looker Studio.
-
Getting Started with the CData ODBC Driver for Calendly
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Calendly.
-
Connect to Egnyte Data in ACL Analytics
Connect to Egnyte data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Egnyte data.
-
Connect to Timely Data from HeidiSQL
Use CData Connect AI to connect to and query live Timely data from HeidiSQL.
-
Provide OData Services of Cosmos DB Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Cosmos DB data by developing a WCF Service Application.
-
Rapidly Develop ZohoDesk-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 ZohoDesk.
-
Access Live Azure Table Data in Coginiti Pro
Connect to and query live Azure Table data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Google Contacts Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Contacts replication to Databricks.
-
Import Instagram Data Using Azure Data Factory
Use CData Connect AI to connect to Instagram Data from Azure Data Factory and import live Instagram data.
-
Query Jumpseller Data in ColdFusion
Write standard ColdFusion data access code to connect to Jumpseller data.
-
Prepare, Blend, and Analyze Tavily Data in Alteryx Designer (Connect AI)
Build workflows to access live Tavily data for self-service data analytics.
-
Provide OData Services of Shippo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Shippo data by developing a WCF Service Application.
-
Replicate Multiple EmailOctopus Accounts via the CData Sync CLI
Replicate multiple EmailOctopus accounts to one or many databases.
-
Connect to Microsoft Planner Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Planner data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous MongoDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MongoDB replication to Google BigQuery.