CData Software - Knowledge Base
Recent Articles
-
Back Up Paylocity data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Paylocity. In this article, we will employ an SSIS workflow to populate a database with Paylocity data data.
-
Integrate with Square Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Square data to a JSON file on disk.
-
Use Biml to Build SSIS Tasks to Replicate Suadeo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Suadeo data to SQL Server.
-
Write a Simple Go Application to work with Avalara AvaTax Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Avalara AvaTax data.
-
Automate EnterpriseDB Data Replication to Azure Synapse
Use CData Sync to customize and automate EnterpriseDB data replication to Azure Synapse.
-
Build Apps with Live Yelp data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Yelp data into the Adalo platform and build custom mobile and web applications with real-time Yelp data.
-
Accelo Reporting in OBIEE with the Accelo JDBC Driver
Deploy the Accelo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Explore Geographical Relationships in LinkedIn Data with Power Map
Create data visualizations with LinkedIn data in Power Map.
-
Getting Started with the CData Connect AI Python SDK for HCL Domino
Install the CData Connect AI Python SDK to read live HCL Domino data with standard DB-API 2.0 Python code.
-
Connect to Mailjet Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Mailjet as an External Source in Dremio.
-
How to Query EnterpriseDB Data in MySQL Workbench
Execute MySQL queries against live EnterpriseDB data from MySQL Workbench.
-
Visualize Nuclia Data in Tableau
The CData ODBC driver for Nuclia enables you integrate Nuclia data into Tableau dashboards.
-
Connect to Gmail Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Gmail.
-
Automated Continuous Confluence Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Confluence data replication to OneLake in Microsoft Fabric.
-
Automated Continuous Postmark Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Postmark replication to Amazon S3.
-
View Reports on Real-Time Chargebee Data in Power BI Report Server
Use the CData ODBC Driver for Chargebee to visualize Chargebee data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect the Power BI Service to Paddle: Complete Guide
Connect to the CData Software Power BI Connector for Paddle from PowerBI.com to provide real-time Paddle data across the organization.
-
Build Active Directory-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Active Directory Data and create custom apps in Mendix.
-
Create Datasets from Ontraport in Domo Workbench and Build Visualizations of Ontraport Data in Domo
Use the CData Software ODBC Driver for Ontraport to create datasets from Ontraport data in Domo Workbench and then build visualizations in the Domo service.
-
Build a Singer.io Tap for ZohoExpense With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ZohoExpense data using the CData Python Connector.
-
Query Zuora Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zuora data from Node.js.
-
Connect to Clari Data in DBArtisan
Use wizards in DBArtisan to configure Clari data as a data source.
-
How to create Visio diagrams from Microsoft Ads Data
Automatically update Microsoft Ads data with the changes you make to Visio master shapes.
-
Getting Started with the CData Connect AI Python SDK for FreshBooks
Install the CData Connect AI Python SDK to read live FreshBooks data with standard DB-API 2.0 Python code.
-
Connect to Box Data in Google Apps Script via Connect AI
Use CData Connect AI to access Box data in Google Apps Script.
-
Connect Google Contacts to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Contacts data using the CData Python MCP Server.
-
Connect to Act CRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Act CRM data in the Denodo Virtual DataPort Administrator.
-
Use Manus AI to Talk to Your ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on ShipStation data.
-
Integrating GitHub Copilot with Snapchat Ads 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 connect to Suadeo Data from Spring Boot
Connect to Suadeo in a Spring Boot Application using the CData JDBC Driver for Suadeo
-
How to Seamlessly Import Amazon Athena Data into IBM SPSS Modeler
Integrate Amazon Athena data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Automated Workflows with Live PolarTeamPro Data in Workato
Use CData Connect AI to connect to live PolarTeamPro data and build automated workflows in Workato.
-
How to Connect to Live Databricks Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Databricks data through natural language.
-
How to create an RPA flow for REST Data in UiPath Studio
Use the REST ODBC Driver to create workflows that access real-time REST data without any coding.
-
Use the CData Software JDBC Driver for DB2 in MicroStrategy
Connect to DB2 data in MicroStrategy Developer using the CData Software JDBC Driver for DB2.
-
Access Live Zoho Creator Data in Coginiti Pro
Connect to and query live Zoho Creator data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Timely Data in JRuby
Create a simple JRuby app with access to live Timely data.
-
Connect to Mocean Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Mocean.
-
Create Informatica Mappings From/To a JDBC Data Source for Templated
Create Templated data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect ZeroBounce Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ZeroBounce data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData ODBC Driver for Dynamics 365 Business Central
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Dynamics 365 Business Central.
-
HelloSign Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on HelloSign facts in real time.
-
Connect to AlloyDB Data in Ruby
Connect to AlloyDB data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to import Webex Data into Apache Solr
Use the CData Software JDBC Driver for Webex in Data Import Handler and create an automated import of Webex data to Apache Solr Enterprise Search platform.
-
Use the CData ODBC Driver for Clari from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Clari to connect to Clari data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Clari data in Excel.
-
Extract, Transform, and Load Hive Data in Informatica PowerCenter
Create a simple Workflow for Hive data in Informatica PowerCenter.
-
How to load Campaigner data into Elasticsearch via Logstash
Introducing a simple method to load Campaigner data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Codex with Gorgias 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 import JDBC-ODBC Bridge Data into Apache Solr
Use the CData Software JDBC Driver for JDBC-ODBC Bridge in Data Import Handler and create an automated import of JDBC-ODBC Bridge data to Apache Solr Enterprise Search platform.
-
Object-Relational Mapping (ORM) with Opsgenie 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 Opsgenie data into a Java-based ORM framework, Hibernate.
-
Integrate LibreChat with Live Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Odoo data from within the chat interface.
-
How to create Suadeo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Suadeo data in MySQL .
-
How to create an RPA flow for Zendesk Data in UiPath Studio
Use the Zendesk ODBC Driver to create workflows that access real-time Zendesk data without any coding.
-
Interact with Live Monday.com Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Monday.com data.
-
Access Cassandra 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 Cassandra data.
-
Create Dynamic AdRoll Grids Using the Infragistics XamDataGrid
Learn how you can connect AdRoll to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Discourse from a Connection Pool in WebLogic
Use the CData JDBC Driver for Discourse to connect to Discourse data from Web applications running on WebLogic.
-
Integrating Claude Code CLI with Google Drive 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.
-
Connect to Timely Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Timely data.
-
Connect to CircleCI from a Connection Pool in WebLogic
Use the CData JDBC Driver for CircleCI to connect to CircleCI data from Web applications running on WebLogic.
-
Working with Google Campaign Manager 360 Data in LINQPad
Execute LINQ queries to Google Campaign Manager 360 data in LINQPad.
-
Access Live CapsuleCRM Data in Coginiti Pro
Connect to and query live CapsuleCRM data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Dynamic Office 365 Grids Using the Infragistics XamDataGrid
Learn how you can connect Office 365 to Infragistics XamDataGrid to build dynamic grids.
-
Connect to FreshBooks Data in NetBeans
Connect to FreshBooks data in NetBeans with the data source configuration wizard.
-
Access Live Google Ads Data in AWS Lambda
Connect to live Google Ads data in AWS Lambda using the CData JDBC Driver.
-
Connect to PhantomBuster Data in Aqua Data Studio
Access PhantomBuster data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous AfterShip Replication to Vertica
Use CData Sync for automated, continuous, customizable AfterShip replication to Vertica.
-
Create Reports with Amazon S3 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amazon S3 data.
-
Connect to QuickBooks Data from a Connection Pool in Jetty
The QuickBooks JDBC Driver supports connection pooling: This article shows how to connect faster to QuickBooks data from Web apps in Jetty.
-
Connect to Coda Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Coda data using standard SQL.
-
Connect to and Query Flowlu Data in QlikView over ODBC
Create data visualizations with Flowlu data in QlikView.
-
Query PayPal Data in ColdFusion
Write standard ColdFusion data access code to connect to PayPal data.
-
How to Connect to Live Azure Synapse 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 Azure Synapse data for you.
-
Use Biml to Build SSIS Tasks to Replicate Gmail Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Gmail data to SQL Server.
-
Connect to and Visualize Live Microsoft Planner Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Planner data.
-
Excel Spreadsheet Automation on Float Data with the QUERY Formula
Pull data from Float, automate spreadsheets, and more with the QUERY formula.
-
Publish CircleCI-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live CircleCI data.
-
Use Claude to Talk to Your Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Google Calendar data for you.
-
How to Query Live Hugging Face Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Hugging Face data data in natural language using Python.
-
Publish Crystal Reports on Mouseflow Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Mouseflow data.
-
Automate CapsuleCRM Data Replication to Couchbase
Use CData Sync to Customize and automate CapsuleCRM data replication to Couchbase.
-
Replicate Freshdesk Data from PowerShell
Write a quick PowerShell script to query Freshdesk data. Use connectivity to the live data to replicate Freshdesk data to SQL Server.
-
Deploy the ADO.NET Provider for ActiveCampaign on an SSRS Report Server
Connect to ActiveCampaign data 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.
-
Visualize Front Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Front data.
-
Integrate Shortcut Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Shortcut data from Informatica Cloud.
-
Import Guru Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Guru Data and provide access to live Guru data for custom reports in the Power BI Service.
-
Visualize Certinia Data in Sisense
Create an ElastiCube in Sisense app with access to Certinia data.
-
Import Grafana Data Using Azure Data Factory
Use CData Connect AI to connect to Grafana Data from Azure Data Factory and import live Grafana data.
-
Build a Singer.io Tap for Deel With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Deel data using the CData Python Connector.
-
Analyze Google Cloud Storage Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Cloud Storage data with the CData JDBC Driver for Google Cloud Storage.
-
Build Visualizations of Guru Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Guru data in Birst.
-
Connect to Bugsnag Data in NetBeans
Connect to Bugsnag data in NetBeans with the data source configuration wizard.
-
How to Connect to Live MarkLogic Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your MarkLogic data through natural language.
-
Building Dynamic Web Pages with Excel Data Using AngularJS
Create single-page applications with live connectivity to Excel using the CData API Server.
-
Connect to Monday.com Data in Ruby
Connect to Monday.com data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query Foursquare Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Foursquare data from Node.js.
-
Publish Reports with Oracle Eloqua Reporting Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Eloqua Reporting data.
-
Query Sage 200 Data as a SQL Server Database in Node.js
Execute SQL Server queries against Sage 200 data from Node.js.
-
Connect to Stack Exchange Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Stack Exchange to connect to Stack Exchange data and execute queries in PowerBuilder.
-
Import Real-Time FHIR Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use FHIR data in ColdFusion.