CData Software - Knowledge Base
Recent Articles
-
Object-Relational Mapping (ORM) with GraphQL 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 GraphQL into a Java-based ORM framework, Hibernate.
-
Connect to and Query ClickTime Data in QlikView over ODBC
Create data visualizations with ClickTime in QlikView.
-
Integrating Boomi Agentstudio with SAP HANA Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAP HANA, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create SSAS Tabular Models from Discourse Data
How to build a SQL Server Analysis Service Tabular Model from Discourse using CData drivers.
-
Access Facebook Ads Data from MySQL in PHP
Connect to Facebook Ads through the standard MySQL libraries in PHP.
-
Consume Salesforce Data 360 OData Feeds in PowerBuilder
This article demonstrates how to consume Salesforce Data 360 as OData feeds from PowerBuilder using the API Server.
-
How to connect to ScrapingBee Data from Spring Boot
Connect to ScrapingBee in a Spring Boot Application using the CData API Driver for JDBC
-
How to Seamlessly Import LinkedIn Ads Data into IBM SPSS Modeler
Integrate LinkedIn Ads data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Billsby Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Billsby.
-
Automate HubDB Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live HubDB and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Query Instagram Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Instagram entities in PHP by modeling them as objects.
-
Connect to and Visualize Live Sendwithus Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sendwithus.
-
Create Microsoft Ads-Connected Applications in Appsmith
Connect to Microsoft Ads Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Microsoft Ads.
-
Automated Continuous IBM Informix Replication to Oracle
Use CData Sync for automated, continuous, customizable IBM Informix replication to Oracle.
-
How to Access Live Cassandra Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Cassandra enables you to integrate Apache Cassandra into workflows built using Microsoft Power Automate Desktop.
-
Feed Calendly Data into FineReport
How to set Calendly as a JDBC data source in FineReport.
-
How to Connect the Power BI Service to ShipEngine: Complete Guide
Connect to the CData Software Power BI Connector for ShipEngine from PowerBI.com to provide real-time ShipEngine across the organization.
-
Import Real-Time Postmark Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Postmark in ColdFusion.
-
Use the CData API Server to Access Kintone Data in Microsoft PowerPivot
Use the CData API Server to connect to live Kintone in the Power Pivot business intelligence tool.
-
Access Billsby Data from MySQL in PHP
Connect to Billsby through the standard MySQL libraries in PHP.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Zoho Books using the Model Context Protocol.
-
Build Voice Agents in ElevenLabs with access to Live Vertica Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Vertica.
-
Integrate AdRoll Data in Pentaho Data Integration
Build ETL pipelines based on AdRoll in the Pentaho Data Integration tool.
-
Extend Google Sheets with Sage Cloud Accounting Data
Make calls to Sage Cloud Accounting from Google Apps Script via the API Server.
-
Analyze MongoDB Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of MongoDB and visualize live MongoDB in Infragistics Reveal.
-
Prepare, Blend, and Analyze JobNimbus Data in Alteryx Designer (ODBC)
Build workflows to access live JobNimbus for self-service data analytics.
-
Query MongoDB Data from Node.js
Use the OData endpoint of the CData API Server to connect to your MongoDB and perform CRUD operations on MongoDB from Node.js.
-
Perform Batch Operations with Reckon Data in Apache NiFi
Connect to Reckon and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Visualize Live PivotalTracker Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live PivotalTracker.
-
Use Biml to Build SSIS Tasks to Replicate SendInBlue Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SendInBlue to SQL Server.
-
How to use SQLAlchemy ORM to access Tavily Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Tavily.
-
A PostgreSQL Interface for SageHR Data (MySQL Remoting via JDBC)
Use the Remoting features of the SageHR JDBC Driver to create a PostgreSQL entry-point for data access.
-
Stream HBase Data into Apache Kafka Topics
Access and stream Apache HBase in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Google Ad Manager actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
How to connect to Short.io Data from Spring Boot
Connect to Short.io in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Basecamp Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Basecamp in the Denodo Virtual DataPort Administrator.
-
Import Real-Time Sage Cloud Accounting Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Sage Business Cloud Accounting in ColdFusion.
-
Trigger Presto IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Presto with standard wizards in Logic Apps.
-
Visualize Live Aha! Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Aha! using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Reports with Facebook Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Facebook.
-
Automate Google Calendar Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Calendar from PowerShell? This article demonstrates how to utilize the Google Calendar Cmdlets for tasks like connecting to Google Calendar, automating operations, downloading data, and more.
-
Create Informatica Mappings From/To a JDBC Data Source for Placid
Create Placid data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Dashboards with Omnisend Data in Dundas BI
Create dynamic dashboards and perform analytics based on Omnisend in Dundas BI.
-
Back Up IBM DB2 to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for DB2. In this article, we will employ an SSIS workflow to populate a database with IBM DB2 data.
-
Working with Pushbullet Data in LINQPad
Execute LINQ queries to Pushbullet in LINQPad.
-
Automated Continuous SAP Netweaver Gateway Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Databricks.
-
DataBind Controls to Exact Online Data in Delphi
DataBind to Exact Online in Delphi with standard data access components and controls.
-
Automated Continuous Outreach.io Replication to SingleStore
Use CData Sync for automated, continuous, customizable Outreach.io replication to SingleStore.
-
Import Real-Time AdRoll Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use AdRoll in ColdFusion.
-
Build Data Flows from Grafana to SQL Server using SSIS
Easily back up Grafana to SQL Server using the SSIS components for Grafana.
-
Access QuickBooks 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 QuickBooks Desktop.
-
How to Design Sage Intacct Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Sage Intacct from mobile and tablet Power Apps.
-
Provide OData Services of MarkLogic Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MarkLogic by developing a WCF Service Application.
-
Integrating Gumloop with Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Apache Phoenix within automated workflows.
-
Build a Simple VCL Application for Keap Data
How to build a simple VCL Application to view Keap in RAD Studio using the CData ODBC Driver for Keap.
-
How to Connect to Adobe Analytics Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Adobe Analytics. Leverage the pyodbc module for ODBC in Python.
-
Integrate Live Google Tasks Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Tasks to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Splunk Data in JRuby
Create a simple JRuby app with access to live Splunk.
-
How to work with SAP SuccessFactors LMS Data in Apache Spark using SQL
Access and process SAP SuccessFactors LMS Data in Apache Spark using the CData Software JDBC Driver.
-
Query Bannerbear Data in ColdFusion
Write standard ColdFusion data access code to connect to Bannerbear.
-
Access Live OneNote Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live OneNote data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Access Testmonitor Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Testmonitor from your Oracle system.
-
Automated Continuous Google Contacts Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Contacts replication to SQL Server.
-
Replicate LeadDesk Data to Multiple Databases
Replicate LeadDesk to disparate databases with a point-and-click configuration.
-
Extend Google Sheets with Sage Intacct Data
Make calls to Sage Intacct from Google Apps Script via the API Server.
-
Connecting Mastra with Oracle Service Cloud Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Oracle Service Cloud, no replication required.
-
Analyze Sybase IQ Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sybase IQ from Power Pivot. You will use the Table Import Wizard to load Sybase IQ. You can visually build the import query or use any SQL supported by the driver.
-
Stream Drift Data into Apache Kafka Topics
Access and stream Drift in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Work with Microsoft Exchange Data in FoxPro
Load Microsoft Exchange into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData ADO.NET Provider for Everhour
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Getting Started with the CData Excel Add-In for Nuclia
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Nuclia.
-
Access iContact 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 iContact.
-
Query Azure DevOps Data as a SQL Server Database in Node.js
Execute SQL Server queries against Azure DevOps from Node.js.
-
How to Connect Flowise AI Agents to Live Spark Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Apache Spark SQL without replication.
-
Design BIRT Reports on SurveyMonkey Data
Provide current SurveyMonkey to your embedded analytics.
-
Jira Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Atlassian Jira through CData Connect AI using different applications and tools.
-
Moving Data from SAP Ariba Procurement to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP Ariba Procurement data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Bidirectional Access to ElevenLabs Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ElevenLabs in Filemaker Pro for Mac or Windows.
-
Viewing Certinia Data in RAD Studio Data Explorer
How to view Certinia in RAD Studio Data Explorer using the CData ODBC Driver for Certinia.
-
Replicate DocuSign Data to Multiple Databases via the CData Sync CLI
Replicate DocuSign to disparate databases with a single configuration.
-
Visualize Live PostgreSQL Data in the Power BI Service
Use CData Connect AI to connect to live PostgreSQL and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live Google Cloud Storage Data in AWS Lambda
Connect to live Google Cloud Storage in AWS Lambda using the CData JDBC Driver.
-
Publish Reports with Cvent Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Cvent.
-
Automated Continuous Oracle Eloqua Reporting Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Google Cloud SQL.
-
Excel Spreadsheet Automation on FTP Data with the QUERY Formula
Pull data from FTP, automate spreadsheets, and more with the QUERY formula.
-
Create Datasets from Salesloft in Domo Workbench and Build Visualizations of Salesloft Data in Domo
Use the CData Software ODBC Driver for Salesloft to create datasets from Salesloft in Domo Workbench and then build visualizations in the Domo service.
-
Access HubSpot Data from MySQL in Amazon QuickSight
Connect to HubSpot and build visualizations of HubSpot using a MySQL Connection in Amazon QuickSight.
-
Integrating OpenCode Terminal with Intercom 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.
-
Using the CData Software ODBC Driver for PayPal in PyCharm
Connect to PayPal as an ODBC data source in PyCharm using the CData Software ODBC Driver for PayPal.
-
Connect to and Query Bugsnag Data in QlikView over ODBC
Create data visualizations with Bugsnag in QlikView.
-
Connect to Vault CRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Veeva Vault & Vault CRM from Appeon PowerBuilder using the CData ADO.NET Provider for Vault CRM.
-
How to Query Live CampaignMonitor Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live CampaignMonitor data in natural language using Python.
-
Connect to Adobe Commerce Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Adobe Commerce.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Sugar CRM
Provide connectivity to Sugar CRM through an SAP BusinessObjects universe.
-
Automated Continuous Wrike Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Wrike replication to delimited files (CSV/TSV).
-
Prepare, Blend, and Analyze ConvertKit Data in Alteryx Designer (ODBC)
Build workflows to access live ConvertKit for self-service data analytics.
-
Replicate FHIR Data to Multiple Databases via the CData Sync CLI
Replicate FHIR to disparate databases with a single configuration.
-
Build a Singer.io Tap for Printify With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Printify data using
-
Automated Continuous Billsby Replication to SQLite
Use CData Sync for automated, continuous, customizable Billsby replication to SQLite.
-
Connect to Insightly Data in DBArtisan
Use wizards in DBArtisan to configure Insightly as a data source.