CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Notion Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Notion replication to Apache Cassandra.
-
Viewing Pushbullet Data in RAD Studio Data Explorer
How to view Pushbullet in RAD Studio Data Explorer using the CData ODBC Driver for Pushbullet.
-
Build Semantic Layer Views for WooCommerce Data in APOS Live Data Gateway
Use the CData Connector for WooCommerce in APOS Live Data Gateway to build Semantic Layer Views for WooCommerce.
-
Consume Spark OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Spark feeds that reflect any changes in SAP Lumira.
-
Create Informatica Mappings From/To a JDBC Data Source for Typeform
Create Typeform data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Azure Data Catalog Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Amazon S3.
-
Work with Live JSON Services in Power Query
Use CData Connect AI to connect to JSON and work with live JSON in Microsoft Power Query.
-
How to Design Slack Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Slack from mobile and tablet Power Apps.
-
Work with Live IBM Informix Data in Power Query
Use CData Connect AI to connect to IBM Informix and work with live IBM Informix in Microsoft Power Query.
-
View Reports on Real-Time Drip Data in Power BI Report Server
Use the CData ODBC Driver for Drip to visualize Drip in Power BI Desktop and then publish them to Power BI Report Server.
-
Build a Singer.io Tap for OneNote With the CData Python Connector
Learn how to easily build a Singer.io Tap for live OneNote data using
-
Build Oracle Eloqua-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Oracle Eloqua and build Oracle Eloqua-connected web apps with Axios.
-
Create Apps from Smartsheet Data in Qlik Sense Cloud
Use CData Connect AI to connect to Smartsheet Data and build apps from live Smartsheet in Qlik Sense Cloud.
-
Connect to Live HubSpot Data in MicroStrategy through CData Connect AI
Create a live connection to HubSpot Data in CData Connect AI and connect to your HubSpot from MicroStrategy.
-
How to Query BigQuery Data in MySQL Workbench
Execute MySQL queries against live Google BigQuery from MySQL Workbench.
-
Use the CData Software ODBC Driver for eBay in MicroStrategy Web
Connect to eBay in MicroStrategy Web using the CData Software ODBC Driver for eBay.
-
How to Query Live Opsgenie Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Opsgenie data in natural language using Python.
-
Integrating Claude Code CLI with Epicor Kinetic 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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Freshsales
Provide connectivity to Freshsales through an SAP BusinessObjects universe.
-
Automated Continuous Everhour Replication to SingleStore
Use CData Sync for automated, continuous, customizable Everhour replication to SingleStore.
-
Integrating LangChain with WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on WordPress within automated workflows.
-
CampaignMonitor Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on CampaignMonitor facts in real time.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SAP ERP/NetWeaver to Power BI dashboards. Simply drag and drop SAP ERP/NetWeaver into data visuals on the Power BI canvas.
-
Build Data Flows from Google Analytics to SQL Server using SSIS
Easily back up Google Analytics to SQL Server using the SSIS components for Google Analytics.
-
How to Build an ETL App for Grafana Data in Python with CData
Create ETL applications and real-time data pipelines for Grafana in Python with petl.
-
Access Live Salesforce Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Salesforce & Force.com in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Back Up Paddle to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Paddle data.
-
Building Dynamic Web Pages with Amazon Athena Data Using AngularJS
Create single-page applications with live connectivity to Amazon Athena using the CData API Server.
-
Connect to Elasticsearch Data in DBArtisan
Use wizards in DBArtisan to configure Elasticsearch as a data source.
-
Connect to Toggl Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Toggl to connect to Toggl and execute queries in PowerBuilder.
-
Connect to HCL Domino Data in Jaspersoft Studio
Execute SQL to remote HCL Domino in Jaspersoft Studio.
-
Establish a Live Connection with Datadog Data using Tableau Bridge
The CData ODBC Driver for Datadog enables you to integrate live Datadog into Tableau Cloud dashboards using the Tableau Bridge.
-
Create SSAS Tabular Models from Redshift Data
How to build a SQL Server Analysis Service Tabular Model from Amazon Redshift using CData drivers.
-
Operational Reporting on Zoho Creator Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zoho Creator.
-
Use the CData Software JDBC Driver for ZohoPeople in MicroStrategy Web
Connect to ZohoPeople in MicroStrategy Web using the CData Software JDBC Driver for ZohoPeople.
-
Build an OLAP Cube in SSAS from Google Drive Data
Establish a connection to Google Drive data from SQL Server Analysis Services, and use the Google Drive Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Azure Synapse Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Google BigQuery.
-
Create Dashboards and Visualize Live Freshdesk Data in Geckoboard
Use CData Connect AI to connect to live Freshdesk and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Testmonitor Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Testmonitor and the SQL Gateway to access Testmonitor from Google Apps Script.
-
Use the CData Software ODBC Driver for Apollo in MicroStrategy
Connect to Apollo in MicroStrategy Developer using the CData Software ODBC Driver for Apollo.
-
Replicate Oracle Eloqua Reporting Data to Multiple Databases
Replicate Oracle Eloqua Reporting to disparate databases with a point-and-click configuration.
-
Feed ClickUp Data into FineReport
How to set ClickUp as a JDBC data source in FineReport.
-
Integrate PDFMonkey Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live PDFMonkey from Informatica Cloud.
-
Easily Integrate SAP Ariba Procurement Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP Ariba Procurement in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Power BI Connector for Google Search
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Search.
-
How to Work with Factorial Data in ETL Validator JDBC
Connect to Factorial from ETL Validator jobs using the CData Software JDBC Driver.
-
Rapidly Develop GraphQL-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 GraphQL.
-
Build IBM Informix-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for IBM Informix Data and create custom apps in Mendix.
-
Publish Reports with IBM Cloud Object Storage Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date IBM Cloud Object Storage.
-
Deploy the ADO.NET Provider for Reply.io on an SSRS Report Server
Connect to Reply.io 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.
-
Automated Continuous Jumpseller Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Jumpseller replication to PostgreSQL.
-
Integrate with Jumpseller Data in JReport Designer
Create charts and reports based on Jumpseller in JReport Designer.
-
Query Live LinkedIn Ads 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 LinkedIn Ads directly from the development environment.
-
Build Data Flows from SQL Server to SAP Concur through SSIS
Easily push SQL Server data to SAP Concur using the CData SSIS Tasks for SAP Concur.
-
Bidirectional Access to Dynamics CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Dynamics CRM in Filemaker Pro for Mac or Windows.
-
Natively Connect to Google Contacts Data in PHP
The CData ODBC driver for Google Contacts enables you to create PHP applications with connectivity to Google Contacts. Leverage the native support for ODBC in PHP.
-
Build Avro Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Apache Avro and build visualizations in Tableau.
-
Connect to Deel Data in HULFT Integrate
Connect to Deel as a JDBC data source in HULFT Integrate
-
How to Connect the Power BI Service to Flowlu: Complete Guide
Connect to the CData Software Power BI Connector for Flowlu from PowerBI.com to provide real-time Flowlu across the organization.
-
Visualize Live Jira Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Atlassian Jira into custom reports in Power BI.
-
Integrate Live Bannerbear Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Bannerbear to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Use Dash to Build to Web Apps on Mouseflow Data
Create Python applications that use pandas and Dash to build Mouseflow-connected web apps.
-
Query Active Directory Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Active Directory and perform CRUD operations on Active Directory from Node.js.
-
Use Agno to Talk to Your Twitter Ads 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 Twitter Ads for you.
-
Connect to Mailgun Data in HULFT Integrate
Connect to Mailgun as a JDBC data source in HULFT Integrate
-
Integrate with OpenWeatherMap Data in JReport Designer
Create charts and reports based on OpenWeatherMap in JReport Designer.
-
Visualize SurveyMonkey Data in TIBCO Spotfire through ADO.NET
Integrate SurveyMonkey into dashboards in TIBCO Spotfire.
-
Create Data Visualizations Based On DocuSign Data in Mode
Use CData Connect AI to connect to DocuSign Data from Mode and build visualizations using live
-
Import Oracle Service Cloud Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Oracle Service Cloud. In this article, you will use the OData format to import Oracle Service Cloud into Microsoft Power Query.
-
Visualize Excel Data in Tableau
The CData ODBC driver for Excel enables you integrate Microsoft Excel into Tableau dashboards.
-
Object-Relational Mapping (ORM) with Excel 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 Microsoft Excel into a Java-based ORM framework, Hibernate.
-
Automated Continuous Greenplum Replication to MongoDB
Use CData Sync for automated, continuous, customizable Greenplum replication to MongoDB.
-
Integrate Cline with Live Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Salesforce & Force.com from within your IDE.
-
How to Generate SQL Command Schemas for the CData BizTalk Adapter for Salesforce
The CData BizTalk Adapter makes it easy to process Salesforce data in BizTalk by returning the data as XML. You can use this data in a BizTalk orchestration by creating an XML schema file for the table you want to access in BizTalk.
-
How to Design Dropbox Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Dropbox from mobile and tablet Power Apps.
-
Connect to Mailjet Data from a Connection Pool in JBoss
Integrate Mailjet into Java servlets: Use the Management Console in JBoss to install the Mailjet JDBC Driver.
-
Use the CData ODBC Driver for Aweber from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Aweber to connect to Aweber from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Aweber in Excel.
-
Publish SageHR-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SageHR.
-
Automate Epicor Kinetic Data Replication to Azure Synapse
Use CData Sync to customize and automate Epicor Kinetic replication to Azure Synapse.
-
Work with HBase Data in FoxPro
Load Apache HBase into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Build an ETL App for ZohoSubscriptions Data in Python with CData
Create ETL applications and real-time data pipelines for ZohoSubscriptions in Python with petl.
-
OData Reporting in OBIEE with the OData JDBC Driver
Deploy the OData JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to MongoDB Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for MongoDB Data and connect to MongoDB in Akorbi Digital RunMyProcess.
-
Access Live Perplexity Data in AWS Lambda
Connect to live Perplexity in AWS Lambda using the CData JDBC Driver.
-
Connect to Zendesk in SpagoBI
Create reports featuring live Zendesk in SpagoBI Studio. Host Zendesk reports on SpagoBI Server.
-
How to Connect DBeaver to Quaderno via a JDBC Driver
Manage Quaderno with visual tools in DBeaver like the query browser.
-
Connect to ADP Data in Jaspersoft Studio
Execute SQL to remote ADP in Jaspersoft Studio.
-
Connect SendGrid Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SendGrid using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Edit and Search Anaplan External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Anaplan to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Anaplan objects that you can access from apps and the dashboard.
-
Create Informatica Mappings From/To an ODBC Data Source for Authorize.Net
Create an ODBC connection to Authorize.Net in Informatica and browse and transfer Authorize.Net.
-
Automated Continuous Zoho CRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Zoho CRM replication to SingleStore.
-
Connect to Live Google Calendar Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Calendar in CData Connect AI and connect to your Google Calendar from PostgreSQL.
-
Integrating SharePoint Excel Services Data in Talend Cloud Data Management Platform
Connect SharePoint Excel Services Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SharePoint Excel Services.
-
Integrating Cursor CLI with EmailOctopus 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.
-
Build a Simple VCL Application for TaxJar Data
How to build a simple VCL Application to view TaxJar in RAD Studio using the CData ODBC Driver for TaxJar.
-
Visualize Asana Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Asana.
-
Integrate with Cloudflare Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Cloudflare to a JSON file on disk.
-
Replicate Multiple SAP Ariba Source Accounts via the CData Sync CLI
Replicate multiple SAP Ariba Source accounts to one or many databases.
-
Use the CData Software ODBC Driver for Tavily in SAS for Real-Time Reporting and Analytics
Connect to real-time Tavily in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Tavily.
-
Connect Google Cloud Storage to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Cloud Storage using the CData Python MCP Server.