CData Software - Knowledge Base
Recent Articles
-
Create Informatica Mappings From/To a JDBC Data Source for Google Directory
Create Google Directory data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Provide OData Services of Asana Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Asana by developing a WCF Service Application.
-
Connect Pingdom to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Pingdom with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData Python Connector for Attio
Learn to install and license the CData Python Connector
-
How to Connect to Live BigQuery Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Google BigQuery for you.
-
Connect to SAP ByDesign Data in Aqua Data Studio
Access SAP Business ByDesign from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Parallel Data from PowerBuilder via ADO.NET
This article demonstrates how to access Parallel from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build AI Agents with Snapchat Ads Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Snapchat Ads through CData Connect AI.
-
How to connect to Okta Data in DBVisualizer
Integrate Okta with visual data analysis tools and data connection wizards in DBVisualizer
-
Build SharePoint Excel Services-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SharePoint Excel Services.
-
Use the CData ODBC Driver for Azure Data Catalog from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Azure Data Catalog to connect to Azure Data Catalog from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure Data Catalog in Excel.
-
Connect to Pinterest Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Pinterest and the SQL Gateway to access Pinterest from Google Apps Script.
-
Replicate Multiple Bannerbear Accounts
Replicate multiple Bannerbear accounts to one or many databases.
-
Replicate Moosend Data in Heroku for Use in Salesforce Connect
Replicate Moosend to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to OnePageCrm Data in Aqua Data Studio
Access OnePageCrm from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to update FTP from Excel
This article explains how to transfer data from Excel to FTP using the Excel Add-In for FTP.
-
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.
-
Publish Gmail-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Gmail.
-
Import Real-Time Azure Data Lake Storage Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Azure Data Lake Storage in ColdFusion.
-
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.
-
Connect to Sage Intacct Data from AWS Glue
Use CData Connect AI to gain access to live Sage Intacct from your AWS Glue jobs.
-
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.
-
Access ZohoExpense 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 ZohoExpense.
-
Establish a Live Connection with Insightly Data using Tableau Bridge
The CData ODBC Driver for Insightly enables you to integrate live Insightly into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating LangGraph with Instagram Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Instagram within automated workflows.
-
Feed Spark Data into FineReport
How to set Apache Spark SQL as a JDBC data source in FineReport.
-
Integrate Teamgate with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Teamgate with External Services.
-
Visualize Apollo Data in Tableau
The CData ODBC driver for Apollo enables you integrate Apollo into Tableau dashboards.
-
Build MVC Applications with Connectivity to Google Cloud Storage Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Cloud Storage from an ASP.NET MVC application.
-
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.
-
Publish Reports with Ontraport Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Ontraport.
-
Seamlessly Bring PayPal Data into Retool Using CData Connect AI
Integrate PayPal data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Dashboards with Microsoft Teams Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Teams in Dundas BI.
-
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.
-
Connect to BigCommerce from Asprova with CData Software ODBC Driver for BigCommerce
This article shows how to connect faster to BigCommerce data from Asprova.
-
How to connect to Oracle Sales Data from IntelliJ
Integrate connectivity to Oracle Sales with wizards in IntelliJ.
-
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 Seamlessly Import Zoom Data into IBM SPSS Modeler
Integrate Zoom data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Add Short.io Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Short.io with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated PostgreSQL Data Replication to Teradata
Use CData Sync to Customize and automate PostgreSQL replication to Teradata.
-
Operational Reporting on Chargebee Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Chargebee.
-
How to create an RPA flow for MailerLite Data in UiPath Studio
Use the MailerLite ODBC Driver to create workflows that access real-time MailerLite without any coding.
-
Build a Simple VCL Application for Timely Data
How to build a simple VCL Application to view Timely in RAD Studio using the CData ODBC Driver for Timely.
-
Build Adobe Analytics-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Adobe Analytics to explore live Adobe Analytics Data in Claude Code to assist with building Adobe Analytics-powered applications.
-
Integrate with Procore Data in JReport Designer
Create charts and reports based on Procore in JReport Designer.
-
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.
-
Work with ADP Data in FoxPro
Load ADP into a FoxPro database. This article includes full code and a walk-through of the process.
-
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.
-
Publish SAP-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP ERP/NetWeaver.
-
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.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Facebook using the Model Context Protocol.
-
Build DocuSign-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live DocuSign and build DocuSign-connected web apps with Axios.
-
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.
-
Build Salesforce Marketing-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Salesforce Marketing to explore live Salesforce Marketing Data in Claude Code to assist with building Salesforce Marketing-powered applications.
-
Automated Continuous Highrise Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Highrise replication to IBM DB2.
-
Integrate Goose with Live Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Basecamp from within the local AI agent.
-
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.
-
Create SQL Server-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SQL Server Data from OutSystems and build custom enterprise apps using live Microsoft SQL Server.
-
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.
-
Manage Miro Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Miro.
-
Create Office 365-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Office 365 Data from Klipfolio and build custom visualizations using live Microsoft Office 365.
-
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.
-
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.
-
Create API-Connected Business Apps in AppSheet
Connect to API Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to API.
-
How to Connect to Live GitLab Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your GitLab for you.
-
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.
-
Integrate with SAP ByDesign Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Business ByDesign to a JSON file on disk.
-
Import Dynamics 365 Business Central Data Using Azure Data Factory
Use CData Connect AI to connect to Dynamics 365 Business Central Data from Azure Data Factory and import live Dynamics 365 Business Central.
-
Provide OData Services of ChargeOver Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ChargeOver by developing a WCF Service Application.
-
Visualize Planio Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Planio into TIBCO Spotfire.
-
Build Voice Agents in ElevenLabs with access to Live Square Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Square.
-
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.
-
How to Connect to & Open Helpscout Data in Microsoft Excel
This article uses the CData ODBC driver for Helpscout to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous FHIR Replication to SingleStore
Use CData Sync for automated, continuous, customizable FHIR replication to SingleStore.
-
Automate Clari Data Replication to Couchbase
Use CData Sync to Customize and automate Clari replication to Couchbase.
-
Connect to Drift Data in RapidMiner
Integrate Drift with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous ConstantContact Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ConstantContact replication to PostgreSQL.
-
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.
-
Process & Analyze OpenWeatherMap Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live OpenWeatherMap Data.
-
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.
-
How to Query Amazon Athena Data in MySQL Workbench
Execute MySQL queries against live Amazon Athena from MySQL Workbench.
-
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.
-
Building Dynamic Web Pages with SAP Hybris C4C Data Using AngularJS
Create single-page applications with live connectivity to SAP Hybris C4C using the CData API Server.
-
Connect to ZohoPeople Data in Ruby
Connect to ZohoPeople in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
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.
-
Automated Continuous Tickspot Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Tickspot replication to Azure SQL Database.
-
Build Semantic Layer Views for Redis Data in APOS Live Data Gateway
Use the CData Connector for Redis in APOS Live Data Gateway to build Semantic Layer Views for Redis.