CData Software - Knowledge Base
Recent Articles
-
Access Live OnePageCrm Data in Coginiti Pro
Connect to and query live OnePageCrm from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate with SAP Ariba Procurement Data in JReport Designer
Create charts and reports based on SAP Ariba Procurement in JReport Designer.
-
Outlook Reporting in OBIEE with the Outlook JDBC Driver
Deploy the Outlook JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
LINQ to Marketo 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 Marketo Data Provider.
-
View Reports on Real-Time Basecamp Data in Power BI Report Server
Use the CData ODBC Driver for Basecamp to visualize Basecamp in Power BI Desktop and then publish them to Power BI Report Server.
-
Consume Google Contacts OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Contacts feeds that reflect any changes in SAP Lumira.
-
Build Apps with Live SendGrid Data Using the Low-Code Development Platform of Mendix
Connect SendGrid with Mendix to build apps using the CData JDBC Driver for SendGrid.
-
Bridge Yelp Connectivity with Apache NiFi
Access and process Yelp in Apache NiFi using the CData JDBC Driver.
-
Feed Shopify Data into FineReport
How to set Shopify as a JDBC data source in FineReport.
-
Create Informatica Mappings From/To a JDBC Data Source for LightSpeedRetail
Create LightSpeedRetail data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automate Teamgate Data Replication to Azure Data Lake
Use CData Sync to customize and automate Teamgate replication to Azure Data Lake.
-
How to connect to AlloyDB Data in DBVisualizer
Integrate Google AlloyDB with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP SuccessFactors LMS within intelligent workflows.
-
Natively Connect to MariaDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MariaDB. Leverage the native support for ODBC in PHP.
-
Automated Continuous Dynamics 365 Replication to Oracle
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Oracle.
-
Integrating Zoho Recruit Data in Talend Cloud Data Management Platform
Connect Zoho Recruit Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Live Superchat Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Superchat into the statistical analysis tools available in SAS JMP. This article shows how to use Superchat in the Graph Builder and Query Builder.
-
Connect to Demio Data in Jaspersoft Studio
Execute SQL to remote Demio in Jaspersoft Studio.
-
Getting Started with the CData ODBC Driver for Outlook
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Outlook.
-
Access SFTP Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SFTP from your Oracle system.
-
How to create an RPA flow for SurveyMonkey Data in UiPath Studio
Use the SurveyMonkey ODBC Driver to create workflows that access real-time SurveyMonkey without any coding.
-
Getting Started with the CData Python Connector for Printify
Learn to install and license the CData Python Connector
-
Automate Samanage Data Replication to Azure Data Lake
Use CData Sync to customize and automate Samanage replication to Azure Data Lake.
-
Integrating Claude Code CLI with Paddle 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.
-
How to Create Power BI Visual Reports with Real-Time Workday Data
Use CData Power BI Connectors to visualize Workday in Power BI.
-
Access Opsgenie 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 Opsgenie.
-
Connect to SendPulse Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SendPulse in the Denodo Virtual DataPort Administrator.
-
Choosing the Best Method to Connect SharePoint to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft SharePoint from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect to HCL Domino Data from Spring Boot
Connect to HCL Domino in a Spring Boot Application using the CData JDBC Driver for HCL Domino
-
Build a PostgreSQL Interface for Act CRM Data using the CData JDBC Driver
Use the Remoting features of the Act CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Microsoft Ads Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Microsoft Ads data access from reports, embedded analytics, and more.
-
Create Reports with Parallel Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Parallel.
-
Visualize Azure DevOps Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Azure DevOps.
-
Bind Live IBM Informix Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live IBM Informix data
-
Automated Continuous Mode Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Mode replication to delimited files (CSV/TSV).
-
Edit and Search SAP HANA XS Advanced External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SAP HANA XS Advanced to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SAP HANA XS Advanced objects that you can access from apps and the dashboard.
-
Consume Microsoft OneDrive OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Microsoft OneDrive feeds that reflect any changes in SAP Lumira.
-
How to publish and share Chargebee Data dashboards with Tableau Server
The CData ODBC driver for Chargebee enables you integrate Chargebee into Tableau dashboards.
-
Automated Continuous OneNote Replication to SingleStore
Use CData Sync for automated, continuous, customizable OneNote replication to SingleStore.
-
Create Office 365-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Office 365 Data from OutSystems and build custom enterprise apps using live Microsoft Office 365.
-
Query Hive Data as a SQL Server Database in Node.js
Execute SQL Server queries against Apache Hive from Node.js.
-
Connect to Live Microsoft OneDrive Data in MicroStrategy through CData Connect AI
Create a live connection to Microsoft OneDrive Data in CData Connect AI and connect to your Microsoft OneDrive from MicroStrategy.
-
Visualize Live Typeform Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Typeform.
-
Build Charts with Microsoft Planner Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft Planner in Clear Analytics.
-
Build a PostgreSQL Interface for ScrapingBee Data using the CData JDBC Driver
Use the Remoting features of the ScrapingBee JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Twitter Ads Data in DBeaver
Use the CData ODBC Driver to connect to Twitter Ads in DBeaver.
-
Use JayDeBeApi to access ServiceNow Data in Python
Use standard Python scripting and the development environment of your choice to access live ServiceNow.
-
Connect to VWO Data in Aqua Data Studio
Access VWO from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Hubstaff Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Hubstaff replication to Azure SQL Database.
-
Connect to Apollo Data in RazorSQL
Connect to Apollo from wizards and query Apollo from the GUI in the RazorSQL database management tool.
-
Build MVC Applications with Connectivity to Avaza Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Avaza from an ASP.NET MVC application.
-
Access Live SAP Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP ERP/NetWeaver in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData API Server to Access Zendesk Data in Microsoft PowerPivot
Use the CData API Server to connect to live Zendesk in the Power Pivot business intelligence tool.
-
ETL Apify in Oracle Data Integrator
This article shows how to transfer Apify into a data warehouse using Oracle Data Integrator.
-
How to update Azure Synapse from Excel
This article explains how to transfer data from Excel to Azure Synapse using the Excel Add-In for Azure Synapse.
-
How to work with CockroachDB Data in Apache Spark using SQL
Access and process CockroachDB Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous OData Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable OData replication to Azure SQL Database.
-
Natively Connect to SAP Fieldglass Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP Fieldglass. Leverage the native support for ODBC in PHP.
-
Create Data Visualizations in Cognos BI with SAP Ariba Source Data
Access SAP Ariba Source as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live MailerLite Data in AWS Lambda
Connect to live MailerLite in AWS Lambda using the CData JDBC Driver.
-
A PostgreSQL Interface for Shippo Data using the CData ODBC Driver
Use the SQL Gateway and Shippo ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Create Power BI Visual Reports with Real-Time ScrapingBee Data
Use CData Power BI Connectors to visualize ScrapingBee in Power BI.
-
Build Semantic Layer Views for Gumroad Data in APOS Live Data Gateway
Use the CData Connector for Gumroad in APOS Live Data Gateway to build Semantic Layer Views for Gumroad.
-
How to connect to CSV Data from Spring Boot
Connect to CSV in a Spring Boot Application using the CData JDBC Driver for CSV
-
How to Visualize Impala 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 Apache Impala in Python.
-
Build Semantic Layer Views for Dropbox Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Dropbox.
-
Choosing the Best Method to Connect Oracle Eloqua to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle Eloqua from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Amazon DynamoDB Data in Pentaho Data Integration
Build ETL pipelines based on Amazon DynamoDB in the Pentaho Data Integration tool.
-
Connect to Hive Data in Google Apps Script via Connect AI
Use CData Connect AI to access Apache Hive in Google Apps Script.
-
Wistia Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Wistia facts in real time.
-
Create Data Visualizations Based On IBM Cloud Object Storage Data in Mode
Use CData Connect AI to connect to IBM Cloud Object Storage Data from Mode and build visualizations using live
-
Moving Data from ZohoInvoice to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ZohoInvoice data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Query Float Data in MySQL Workbench
Execute MySQL queries against live Float from MySQL Workbench.
-
Create Reports with ZohoSubscriptions Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoSubscriptions.
-
Work with Teamwork Data in FoxPro
Load Teamwork into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Codex CLI with Foursquare 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 Agno to Talk to Your Salesforce Marketing 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 Salesforce Marketing Cloud for you.
-
Use Azure AI Foundry to Talk to Your MariaDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your MariaDB for you.
-
Automated Continuous Clari Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Clari replication to Azure SQL Database.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Microsoft Exchange
Provide connectivity to Microsoft Exchange through an SAP BusinessObjects universe.
-
Automated Continuous MailerLite Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable MailerLite replication to PostgreSQL.
-
Use the CData API Server to Access Epicor Kinetic Data in Microsoft PowerPivot
Use the CData API Server to connect to live Epicor Kinetic in the Power Pivot business intelligence tool.
-
LINQ to Epicor Kinetic 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 Epicor Kinetic Data Provider.
-
Getting Started with the CData SSIS Components for Amazon DynamoDB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Amazon DynamoDB.
-
Connect to Live Cassandra Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Cassandra in CData Connect AI and connect to your Apache Cassandra from PostgreSQL.
-
Integrating LangChain with GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on GraphQL within automated workflows.
-
Build SAP HANA XS Advanced-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SAP HANA XS Advanced to explore live SAP HANA XS Advanced Data in Gemini Code Assist to assist with building SAP HANA XS Advanced-powered applications.
-
Connect to Parquet in SpagoBI
Create reports featuring live Apache Parquet in SpagoBI Studio. Host Parquet reports on SpagoBI Server.
-
Automated Continuous DocuSign Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable DocuSign replication to Apache Cassandra.
-
Analyze QuickBooks Online Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for QuickBooks Online from Power Pivot. You will use the Table Import Wizard to load QuickBooks Online. You can visually build the import query or use any SQL supported by the driver.
-
Analyze Pinterest Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Pinterest in Microsoft R Open.
-
Stream ZeroBounce Data into Apache Kafka Topics
Access and stream ZeroBounce in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to import Azure Data Lake Storage Data into Apache Solr
Use the CData Software JDBC Driver for Azure Data Lake Storage in Data Import Handler and create an automated import of Azure Data Lake Storage to Apache Solr Enterprise Search platform.
-
Automated Continuous Toggl Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Toggl replication to IBM DB2.
-
Query Recurly Data as a MySQL Database in Node.js
Execute MySQL queries against Recurly from Node.js.
-
Connect to Paddle in SpagoBI
Create reports featuring live Paddle in SpagoBI Studio. Host Paddle reports on SpagoBI Server.
-
Analyze SAS Data Sets Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAS Data Sets and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Visualize Lakebase Data in Python with pandas
Use pandas and other modules to analyze and visualize live Lakebase in Python.
-
Integrating LangGraph with Highrise Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Highrise CRM within automated workflows.
-
Connect Phoenix Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Apache Phoenix using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.