CData Software - Knowledge Base
Recent Articles
-
How to Connect the Power BI Service to SurveyMonkey: Complete Guide
Connect to the CData Software Power BI Connector for SurveyMonkey from PowerBI.com to provide real-time SurveyMonkey across the organization.
-
How to work with Salesloft Data in Apache Spark using SQL
Access and process Salesloft Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating Codex CLI with Apollo 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.
-
Object-Relational Mapping (ORM) with Cvent 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 Cvent into a Java-based ORM framework, Hibernate.
-
Natively Connect to Highrise Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Highrise CRM. Leverage the native support for ODBC in PHP.
-
Provide OData Services of Onfleet Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Onfleet by developing a WCF Service Application.
-
Build SAP Netweaver Gateway-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SAP Netweaver Gateway to explore live SAP Netweaver Gateway Data in Gemini Code Assist to assist with building SAP Netweaver Gateway-powered applications.
-
Load MessageBird Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MessageBird to a database.
-
Build a Singer.io Tap for Elorus With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Elorus data using
-
Create Data Visualizations in Cognos BI with Testmonitor Data
Access Testmonitor as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Keap in SpagoBI
Create reports featuring live Keap in SpagoBI Studio. Host Keap reports on SpagoBI Server.
-
Publish Oracle Financials Cloud-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Oracle Financials Cloud.
-
How to connect to Pingdom Data with Squirrel SQL client
Connect to Pingdom and execute queries in the Squirrel SQL Client.
-
Build MVC Applications with Connectivity to Parquet Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Parquet from an ASP.NET MVC application.
-
Create a Data Access Object for Aweber Data using JDBI
A brief overview of creating a SQL Object API for Aweber in JDBI.
-
Use the CData Software ODBC Driver for MailerLite in MicroStrategy Web
Connect to MailerLite in MicroStrategy Web using the CData Software ODBC Driver for MailerLite.
-
Access Live Active Directory Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Active Directory from your Google Sheets.
-
Automated Continuous PagerDuty Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable PagerDuty replication to delimited files (CSV/TSV).
-
How to Design Lakebase Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Lakebase from mobile and tablet Power Apps.
-
Connect to ZohoPeople Data in DBArtisan
Use wizards in DBArtisan to configure ZohoPeople as a data source.
-
Bind Live MailerSend Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live MailerSend data
-
Migrating data from Perplexity to Databricks using CData SSIS Components.
Easily push Perplexity to Databricks using the CData SSIS Tasks for Perplexity and Databricks.
-
Integrating Antigravity CLI with Apache Hive via CData CLI
Connect Apache Hive to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Query SAP Business One Data in DataGrip
Create a Data Source for SAP Business One in DataGrip and use SQL to query live SAP Business One.
-
Trigger Salesforce IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Salesforce with standard wizards in Logic Apps.
-
Integrating Tickspot Data in Talend Cloud Data Management Platform
Connect Tickspot Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to connect to PayPal Data from Spring Boot
Connect to PayPal in a Spring Boot Application using the CData JDBC Driver for PayPal
-
Connect to Google Campaign Manager 360 Data in Jaspersoft Studio
Execute SQL to remote Google Campaign Manager 360 in Jaspersoft Studio.
-
Create Data Visualizations Based On HBase Data in Mode
Use CData Connect AI to connect to HBase Data from Mode and build visualizations using live
-
Deploy the ADO.NET Provider for Impala on an SSRS Report Server
Connect to Apache Impala from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to Connect to SAS Data Sets Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAS Data Sets. Leverage the pyodbc module for ODBC in Python.
-
How to Connect to Live Google Spanner 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 Google Spanner for you.
-
A PostgreSQL Interface for Webflow Data (MySQL Remoting via JDBC)
Use the Remoting features of the Webflow JDBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze Reply.io Data in Alteryx Designer (ODBC)
Build workflows to access live Reply.io for self-service data analytics.
-
Build an OLAP Cube in SSAS from Hive Data
Establish a connection to Apache Hive data from SQL Server Analysis Services, and use the Hive Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create SAP Netweaver Gateway-Connected Applications in Appsmith
Connect to SAP Netweaver Gateway Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Netweaver Gateway.
-
Getting Started with the CData ADO.NET Provider for Oracle Financials Cloud
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Oracle Financials Cloud.
-
Integrating Codex CLI with AgileCRM 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.
-
How to Visualize Deel Data in Python with pandas
Use pandas and other modules to analyze and visualize live Deel in Python.
-
Query Billsby Data in DataGrip
Create a Data Source for Billsby in DataGrip and use SQL to query live Billsby.
-
Getting Started with the CData JDBC Driver for Box
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Box.
-
Automated Continuous Google Contacts Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Contacts replication to delimited files (CSV/TSV).
-
Build Charts with Parquet Data in Clear Analytics
Create dynamic charts and perform analytics based on Apache Parquet in Clear Analytics.
-
Build Semantic Layer Views for Printify Data in APOS Live Data Gateway
Use the CData Connector for Printify in APOS Live Data Gateway to build Semantic Layer Views for Printify.
-
How to integrate Metabase with NetSuite Data
Use CData Connect AI to connect to live NetSuite CRM & ERP and create an interactive dashboard in Metabase from NetSuite CRM & ERP.
-
Connect to Mailjet Data in HULFT Integrate
Connect to Mailjet as a JDBC data source in HULFT Integrate
-
Enable the Qualaroo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Qualaroo.
-
Access Live Power BI XMLA Data in AWS Lambda
Connect to live Power BI XMLA in AWS Lambda using the CData JDBC Driver.
-
Process & Analyze Impala Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Impala Data.
-
Getting Started with the CData Tableau Connector for Zoho Creator
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Zoho Creator.
-
Use the CData Software JDBC Driver for Tavily in MicroStrategy Web
Connect to Tavily in MicroStrategy Web using the CData Software JDBC Driver for Tavily.
-
Connect to SAP Netweaver Gateway Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP Netweaver Gateway as an External Source in Dremio.
-
How to Access SharePoint Excel Services Data Using Entity Framework
This article shows how to access SharePoint Excel Services using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Real-Time AdRoll Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use AdRoll in Power Apps.
-
Stream EmailOctopus Data into Apache Kafka Topics
Access and stream EmailOctopus in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Business Warehouse
Provide connectivity to SAP Business Warehouse through an SAP BusinessObjects universe.
-
Create Reports from Oracle Eloqua Data in Looker Studio
Use CData Connect AI to gain access to live Oracle Eloqua and create custom reports in Looker Studio.
-
Configure the CData JDBC Driver for Close in a Connection Pool in Tomcat
Connect to Close from a connection pool in Tomcat.
-
Analyze Office 365 Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Office 365 from Power Pivot. You will use the Table Import Wizard to load Microsoft Office 365. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect to Live SAP Ariba Procurement 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 SAP Ariba Procurement for you.
-
Integrating Codex CLI with Okta 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.
-
Bind Live Attio Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Attio data
-
Create Power BI Reports on Real-Time Beeminder Data
Use the CData ODBC Driver for Beeminder to visualize Beeminder in Power BI Desktop.
-
Connect to ActiveCampaign Data from AWS Glue
Use CData Connect AI to gain access to live ActiveCampaign from your AWS Glue jobs.
-
Write a Simple Go Application to work with Cloudant Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to IBM Cloudant.
-
Integrate Live Microsoft Entra ID Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Use Dash to Build to Web Apps on Demio Data
Create Python applications that use pandas and Dash to build Demio-connected web apps.
-
Automated Continuous Oracle Eloqua Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Apache Kafka.
-
Visualize Live SAP Fieldglass Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP Fieldglass into custom reports in Power BI.
-
Connect to Wave Financial Data in HULFT Integrate
Connect to Wave Financial as a JDBC data source in HULFT Integrate
-
Integrating LlamaIndex with Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Azure Table Storage in real time.
-
Connect to Office 365 Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Office 365 and the Script function in FileMaker Pro to connect to Office 365 and work with Microsoft Office 365 in your FileMaker application.
-
Build a Simple VCL Application for ZohoInvoice Data
How to build a simple VCL Application to view ZohoInvoice in RAD Studio using the CData ODBC Driver for ZohoInvoice.
-
Use the CData Software JDBC Driver for MariaDB in MicroStrategy Desktop
Connect to MariaDB in MicroStrategy Desktop using the CData Software JDBC Driver for MariaDB.
-
Build Data Flows from Drift to SQL Server using SSIS
Easily back up Drift to SQL Server using the SSIS components for Drift.
-
Analyze YouTube Analytics Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of YouTube Analytics and visualize YouTube Analytics in SAP Analytics Cloud.
-
Use the CData API Server to Access Exact Online Data in Microsoft PowerPivot
Use the CData API Server to connect to live Exact Online in the Power Pivot business intelligence tool.
-
Access Live Greenhouse Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Greenhouse into the statistical analysis tools available in SAS JMP. This article shows how to use Greenhouse in the Graph Builder and Query Builder.
-
Automate SAP SuccessFactors Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP SuccessFactors from PowerShell? This article demonstrates how to utilize the SAP SuccessFactors Cmdlets for tasks like connecting to SAP SuccessFactors, automating operations, downloading data, and more.
-
Query Opsgenie Data as a MySQL Database in Node.js
Execute MySQL queries against Opsgenie from Node.js.
-
Connect to Keap Data from PowerBuilder via ADO.NET
This article demonstrates how to access Keap from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Working with SendPulse Data in LINQPad
Execute LINQ queries to SendPulse in LINQPad.
-
Model, Search, and Visualize Live Acumatica Data in ThoughtSpot
Use CData Connect AI to connect to live Acumatica ERP for modeling, searching, and visualizing.
-
Migrating data from SAP Ariba Procurement to Databricks using CData SSIS Components.
Easily push SAP Ariba Procurement to Databricks using the CData SSIS Tasks for SAP Ariba Procurement and Databricks.
-
ETL Paymo in Oracle Data Integrator
This article shows how to transfer Paymo into a data warehouse using Oracle Data Integrator.
-
A PostgreSQL Interface for Snapchat Ads Data (MySQL Remoting via JDBC)
Use the Remoting features of the Snapchat Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access MongoDB Data from MySQL in Amazon QuickSight
Connect to MongoDB and build visualizations of MongoDB using a MySQL Connection in Amazon QuickSight.
-
Publish Crystal Reports on Onfleet Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Onfleet.
-
Connect to and Visualize Live Harvest Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Harvest.
-
Visualize ServiceDesk Plus Data in TIBCO Spotfire through ADO.NET
Integrate ServiceDesk Plus into dashboards in TIBCO Spotfire.
-
Automated Continuous Phoenix Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Phoenix replication to Amazon Redshift.
-
Visualize Live SparkPost Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SparkPost using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Instantly Data in Jaspersoft Studio
Execute SQL to remote Instantly in Jaspersoft Studio.
-
Use the CData Software JDBC Driver for Everhour in MicroStrategy Desktop
Connect to Everhour in MicroStrategy Desktop using the CData Software JDBC Driver for Everhour.
-
How to Query Live Freshteam Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Freshteam data in natural language using Python.
-
Create Power BI Reports on Real-Time SAP Business Warehouse Data
Use the CData ODBC Driver for SAP Business Warehouse to visualize SAP Business Warehouse in Power BI Desktop.
-
How to Use a Microsoft Access Database to Update IBM Informix Data in Real Time
Update IBM Informix data by creating a linked table in Microsoft Access with the CData IBM Informix ODBC Driver.
-
Use the CData SSIS Components to Insert New or Update Existing Jira Assets Records from SQL Server
Easily push SQL Server data to Jira Assets using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Jira Assets or update existing records with data from a SQL Server database.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP HANA XS Advanced
Provide connectivity to SAP HANA XS Advanced through an SAP BusinessObjects universe.
-
Getting Started with the CData ODBC Driver for Deel
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Deel.