CData Software - Knowledge Base
Recent Articles
-
Stream Mouseflow Data into Apache Kafka Topics
Access and stream Mouseflow in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Grafana Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Grafana data access from reports, embedded analytics, and more.
-
Use CData Connect AI to Access Blackbaud FE NXT Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Blackbaud FE NXT in the Power Pivot business intelligence tool.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Calendar
Create Google Calendar data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Google Forms Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Forms replication to SQLite.
-
Getting Started with the CData Tableau Connector for ConvertKit
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Harvest-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Harvest and build web apps with connectivity to live Harvest.
-
Automated Continuous ADP Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ADP replication to Google BigQuery.
-
Integrating Cursor CLI with ConstantContact 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.
-
Automated Continuous Figshare Replication to MySQL
Use CData Sync for automated, continuous, customizable Figshare replication to MySQL.
-
How to Connect Flowise AI Agents to Live Zuora 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 Zuora without replication.
-
Visualize Rebilly Data in TIBCO Spotfire through OData
Integrate Rebilly into dashboards in TIBCO Spotfire.
-
Feed Trello Data into FineReport
How to set Trello as a JDBC data source in FineReport.
-
Consume Paymo OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Paymo feeds that reflect any changes in SAP Lumira.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Directory
Create an ODBC connection to Google Directory in Informatica and browse and transfer Google Directory.
-
Working with MySQL Data in LINQPad
Execute LINQ queries to MySQL in LINQPad.
-
Query Azure Analysis Services Data as a SQL Server Database in Node.js
Execute SQL Server queries against Azure Analysis Services from Node.js.
-
Getting Started with the CData Excel Add-In for Rebilly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Rebilly.
-
Integrate Bright Data with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Bright Data with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Bright Data.
-
Feed Asana Data into FineReport
How to set Asana as a JDBC data source in FineReport.
-
How to Connect to Live Kintone Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Kintone for you.
-
Feed Spark Data into FineReport
How to set Apache Spark SQL as a JDBC data source in FineReport.
-
How to Connect CSV Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live CSV data in real time using natural language.
-
Manage Microsoft Teams Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Microsoft Teams.
-
Integrating Antigravity CLI with GraphQL via CData CLI
Connect GraphQL to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData Excel Add-In for ConstantContact
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ConstantContact.
-
Create NASA Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time NASA data access from reports, embedded analytics, and more.
-
Access Kintone Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Kintone from your Oracle system.
-
Build Apps with Live YouTube Analytics in Adalo using CData Connect AI
Use CData Connect AI to integrate live YouTube Analytics into the Adalo platform and build custom mobile and web applications with real-time YouTube Analytics.
-
A PostgreSQL Interface for SAP Business Warehouse Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Business Warehouse JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData ODBC Driver for Monday.com in Microsoft Power Query
You can use the CData Monday.com ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Monday.com into Microsoft Power Query.
-
How to Import Data from Contentful into Google Sheets
Import Contentful into a Google spreadsheet that is automatically refreshed.
-
Replicate SAP HANA XS Advanced Data from PowerShell
Write a quick PowerShell script to query SAP HANA XS Advanced. Use connectivity to the live data to replicate SAP HANA XS Advanced to SQL Server.
-
How to integrate Metabase with ActiveCampaign Data
Use CData Connect AI to connect to live ActiveCampaign and create an interactive dashboard in Metabase from ActiveCampaign.
-
Getting Started with the CData ADO.NET Provider for Opsgenie
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Back Up Procore 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 Procore data.
-
Excel Spreadsheet Automation on ZohoPeople Data with the QUERY Formula
Pull data from ZohoPeople, automate spreadsheets, and more with the QUERY formula.
-
How to integrate Keap with Apache Airflow
Access and process Keap in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous ShipStation Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ShipStation replication to delimited files (CSV/TSV).
-
Access Live EnterpriseDB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live EnterpriseDB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build a PostgreSQL Interface for SAP BusinessObjects BI Data using the CData JDBC Driver
Use the Remoting features of the SAP BusinessObjects BI JDBC Driver to create a PostgreSQL entry-point for data access.
-
Using the CData Software ODBC Driver for PingOne in PyCharm
Connect to PingOne as an ODBC data source in PyCharm using the CData Software ODBC Driver for PingOne.
-
Configure the CData JDBC Driver for JobNimbus in a Connection Pool in Tomcat
Connect to JobNimbus from a connection pool in Tomcat.
-
Use the CData ODBC Driver for VWO from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for VWO to connect to VWO from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring VWO in Excel.
-
Use the CData Software JDBC Driver for ZohoPeople in MicroStrategy Desktop
Connect to ZohoPeople in MicroStrategy Desktop using the CData Software JDBC Driver for ZohoPeople.
-
Build MVC Applications with Connectivity to Snapchat Ads Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Snapchat Ads from an ASP.NET MVC application.
-
Use the CData Software ODBC Driver for SQL Analysis Services in MicroStrategy Desktop
Connect to SQL Analysis Services in MicroStrategy Desktop using the CData Software ODBC Driver for SQL Analysis Services.
-
Access Coda Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Coda from your Oracle system.
-
Create Apps from Splunk Data in Qlik Sense Cloud
Use CData Connect AI to connect to Splunk Data and build apps from live Splunk in Qlik Sense Cloud.
-
Automated Continuous Highrise Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Highrise replication to IBM DB2.
-
Create Data Visualizations in Cognos BI with Autopilot Data
Access Autopilot as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Placid with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Placid with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Placid.
-
Automated Continuous SAP Netweaver Gateway Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Apache Kafka.
-
Manage Miro Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Miro.
-
Connect to and Query Tally Data in QlikView over ODBC
Create data visualizations with Tally ERP in QlikView.
-
Query Tanda Data as a MySQL Database in Node.js
Execute MySQL queries against Tanda from Node.js.
-
Create Reports with XML Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date XML Files.
-
Connect to Microsoft OneDrive Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft OneDrive and the SQL Gateway to access Microsoft OneDrive from Google Apps Script.
-
Import Zoom Data Using Azure Data Factory
Use CData Connect AI to connect to Zoom Data from Azure Data Factory and import live Zoom.
-
How to Query Live Todoist Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Todoist data in natural language using Python.
-
Choosing the Best Method to Connect Salesforce CRM Analytics to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Salesforce CRM Analytics from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect SharePoint with Wrike Data through external lists
Provide Wrike to SharePoint users as an external list.
-
Object-Relational Mapping (ORM) with Salesloft 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 Salesloft into a Java-based ORM framework, Hibernate.
-
Create a Data Access Object for Bullhorn CRM Data using JDBI
A brief overview of creating a SQL Object API for Bullhorn CRM in JDBI.
-
Back Up Grafana 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 Grafana data.
-
Connect Insightly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Insightly using the CData Python MCP Server.
-
Connect to Cloudant Data in CloverDX (formerly CloverETL)
Transfer IBM Cloudant using the visual workflow in the CloverDX data integration tool.
-
Feed Facebook Data into FineReport
How to set Facebook as a JDBC data source in FineReport.
-
Explore Geographical Relationships in Scrapfly Data with Power Map
Create data visualizations with Scrapfly in Power Map.
-
Use Microsoft Copilot Studio to talk to your Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Act-On for you.
-
Build Dashboards with Excel Online Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Excel Online in Dundas BI.
-
Viewing Stack Exchange Data in RAD Studio Data Explorer
How to view Stack Exchange in RAD Studio Data Explorer using the CData ODBC Driver for Stack Exchange.
-
Access Live Copper Data in AWS Lambda
Connect to live Copper in AWS Lambda using the CData JDBC Driver.
-
Build Pipelines with Live Airtable Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Airtable from Google Cloud Data Fusion, enabling the integration of live Airtable into the building and management of effective data pipelines.
-
Automated Continuous OnePageCrm Replication to SQL Server
Use CData Sync for automated, continuous, customizable OnePageCrm replication to SQL Server.
-
Connect to Front Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Front as an External Source in Dremio.
-
Build Charts with Shortcut Data in Clear Analytics
Create dynamic charts and perform analytics based on Shortcut in Clear Analytics.
-
Connect to Zendesk Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Zendesk to connect to Zendesk and execute queries in PowerBuilder.
-
How to Connect to Live Zoho Creator Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Zoho Creator securely in real time.
-
Build an OLAP Cube in SSAS from PivotalTracker Data
Establish a connection to PivotalTracker data from SQL Server Analysis Services, and use the PivotalTracker Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Teamwork Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Teamwork replication to delimited files (CSV/TSV).
-
Build MVC Applications with Connectivity to Notion Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Notion from an ASP.NET MVC application.
-
Manage Dynamics NAV Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Dynamics NAV.
-
How to Connect to Live BigCommerce Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your BigCommerce for you.
-
Replicate Blackbaud FE NXT Data in Heroku for Use in Salesforce Connect
Replicate Blackbaud FE NXT to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Amazon DynamoDB Data in RazorSQL
Connect to Amazon DynamoDB from wizards and query Amazon DynamoDB from the GUI in the RazorSQL database management tool.
-
Edit and Search External SAP Concur Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP Concur to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP Concur Data objects that you can access from apps and the dashboard.
-
Import Epicor Kinetic Data Using Azure Data Factory
Use CData Connect AI to connect to Epicor Kinetic Data from Azure Data Factory and import live Epicor Kinetic.
-
How to create an RPA flow for Exa Data in UiPath Studio
Use the Exa ODBC Driver to create workflows that access real-time Exa without any coding.
-
Connect to and Visualize Live SurveyMonkey Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SurveyMonkey.
-
Analyze Factorial Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Factorial from Power Pivot. You will use the Table Import Wizard to load Factorial. You can visually build the import query or use any SQL supported by the driver.
-
How to publish and share Google Tasks Data dashboards with Tableau Server
The CData ODBC driver for Google Tasks enables you integrate Google Tasks into Tableau dashboards.
-
Import Sybase IQ Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Sybase IQ. In this article, you will use the OData format to import Sybase IQ into Microsoft Power Query.
-
Natively Connect to OpenWeatherMap Data in PHP
The CData ODBC driver for OpenWeatherMap enables you to create PHP applications with connectivity to OpenWeatherMap. Leverage the native support for ODBC in PHP.
-
How to Connect to & Open Marketo Data in Microsoft Excel
This article uses the CData ODBC driver for Marketo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Grafana Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Grafana to connect to Grafana and execute queries in PowerBuilder.
-
DataBind Controls to Drip Data in Delphi
DataBind to Drip in Delphi with standard data access components and controls.
-
Query Google Ads Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Ads.
-
Connect to Databricks from Asprova with CData Software ODBC Driver for Databricks
This article shows how to connect faster to Databricks data from Asprova.
-
Provide OData Services of Zoho Recruit Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zoho Recruit by developing a WCF Service Application.