CData Software - Knowledge Base
Recent Articles
-
Build a Singer.io Tap for Zoho Creator With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Zoho Creator data using
-
Working with Auth0 Data in LINQPad
Execute LINQ queries to Auth0 in LINQPad.
-
Build Charts with SAP Concur Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP Concur in Clear Analytics.
-
Build AI Agents with Microsoft Exchange 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 Microsoft Exchange through CData Connect AI.
-
Create Informatica Mappings From/To a JDBC Data Source for Stack Exchange
Create Stack Exchange data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData ODBC Driver for Stripe in Microsoft Power Query
You can use the CData Stripe ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Stripe into Microsoft Power Query.
-
Use CData Connect AI to Access Acumatica Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Acumatica ERP in the Power Pivot business intelligence tool.
-
Import Real-Time FTP Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use FTP Servers in ColdFusion.
-
How to Connect to & Open SAP BusinessObjects BI Data in Microsoft Excel
This article uses the CData ODBC driver for SAP BusinessObjects BI to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous MYOB AccountRight Replication to IBM DB2
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to IBM DB2.
-
Excel Spreadsheet Automation on Onfleet Data with the QUERY Formula
Pull data from Onfleet, automate spreadsheets, and more with the QUERY formula.
-
Replicate Vertica Data to Multiple Databases
Replicate Vertica to disparate databases with a point-and-click configuration.
-
Explore Geographical Relationships in SharePoint Data with Power Map
Create data visualizations with Microsoft SharePoint in Power Map.
-
Automated Continuous Keap Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Keap replication to Amazon Redshift.
-
Getting Started with the CData JDBC Driver for Sage 300
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Sage 300.
-
Connect to Zoho Projects from a Connection Pool in WebLogic
Use the CData JDBC Driver for Zoho Projects to connect to Zoho Projects from Web applications running on WebLogic.
-
Getting Started with the CData Tableau Connector for MYOB AccountRight
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for MYOB AccountRight.
-
Create DB2-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to DB2 Data from Klipfolio and build custom visualizations using live IBM DB2.
-
Bridge Blackbaud FE NXT Connectivity with Apache NiFi
Access and process Blackbaud FE NXT in Apache NiFi using the CData JDBC Driver.
-
Connect to Delighted Data in RazorSQL
Connect to Delighted from wizards and query Delighted from the GUI in the RazorSQL database management tool.
-
Publish Contentful-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Contentful.
-
Build Dashboards with Zoho Books Data in Dundas BI
Create dynamic dashboards and perform analytics based on Zoho Books in Dundas BI.
-
Replicate Sage Intacct Data to Multiple Databases
Replicate Sage Intacct to disparate databases with a point-and-click configuration.
-
Query Typeform Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Typeform from Node.js.
-
Bright Data Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Bright Data facts in real time.
-
Provide OData Services of RabbitMQ Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for RabbitMQ by developing a WCF Service Application.
-
Integrating BambooHR Data in Talend Cloud Data Management Platform
Connect BambooHR Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Publish Microsoft Entra ID-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Entra ID.
-
Integrating Discord Data in Talend Cloud Data Management Platform
Connect Discord Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect Oracle Service Cloud to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Oracle Service Cloud using the CData Python MCP Server.
-
Create Data Visualizations in Cognos BI with Figshare Data
Access Figshare as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to QuickBooks Online Data in Jaspersoft Studio
Execute SQL to remote QuickBooks Online in Jaspersoft Studio.
-
Integrating OpenCode Terminal with Toggl 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.
-
Import Real-Time Microsoft Exchange Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Exchange in ColdFusion.
-
Create Informatica Mappings From/To a JDBC Data Source for YouTube Analytics
Create YouTube Analytics data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Using the CData Software ODBC Driver for Datadog in PyCharm
Connect to Datadog as an ODBC data source in PyCharm using the CData Software ODBC Driver for Datadog.
-
Access Live Cloudflare Data in Coginiti Pro
Connect to and query live Cloudflare from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Tableau Connector for Tavily
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Replicate FormSite Data to Multiple Databases via the CData Sync CLI
Replicate FormSite to disparate databases with a single configuration.
-
Integrating OpenCode Terminal with Mistral AI 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 Informatica Mappings From/To an ODBC Data Source for Qualaroo
Create an ODBC connection to Qualaroo in Informatica and browse and transfer Qualaroo.
-
Edit and Search YouTube Analytics External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of YouTube Analytics to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create YouTube Analytics objects that you can access from apps and the dashboard.
-
Visualize Nethunt Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Nethunt.
-
Connect to SAP Ariba Source from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP Ariba Source, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Semantic Layer Views for SAS Data Sets Data in APOS Live Data Gateway
Use the CData Connector for SAS Data Sets in APOS Live Data Gateway to build Semantic Layer Views for SAS Data Sets.
-
Automated Continuous Google Directory Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Directory replication to Databricks.
-
Prepare, Blend, and Analyze Databricks Data in Alteryx Designer (ODBC)
Build workflows to access live Databricks for self-service data analytics.
-
How to connect to PivotalTracker Data from Spring Boot
Connect to PivotalTracker in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous Asana Replication to SQLite
Use CData Sync for automated, continuous, customizable Asana replication to SQLite.
-
Validate Pinecone Data with QuerySurge
Access and validate Pinecone in QuerySurge using the CData JDBC Driver.
-
Integrate Live SAP Netweaver Gateway Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP Netweaver Gateway from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Netweaver Gateway.
-
Build a Simple VCL Application for FreshBooks Data
How to build a simple VCL Application to view FreshBooks in RAD Studio using the CData ODBC Driver for FreshBooks.
-
How to Connect the Power BI Service to Pingdom: Complete Guide
Connect to the CData Software Power BI Connector for Pingdom from PowerBI.com to provide real-time Pingdom across the organization.
-
Visualize Amazon DynamoDB Data in Tableau
The CData ODBC driver for Amazon DynamoDB enables you integrate Amazon DynamoDB into Tableau dashboards.
-
Use Azure AI Foundry to Talk to Your Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Epicor Kinetic for you.
-
Connect Samanage to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Samanage with IBM WebSphere for seamless data integration and connectivity.
-
Create Power BI Reports on Real-Time Google Campaign Manager 360 Data
Use the CData ODBC Driver for Google Campaign Manager 360 to visualize Google Campaign Manager 360 in Power BI Desktop.
-
How to connect to Salesforce Data 360 Data from Spring Boot
Connect to Salesforce Data 360 in a Spring Boot Application using the CData JDBC Driver for Salesforce Data 360
-
Build Charts with Marketo Data in Clear Analytics
Create dynamic charts and perform analytics based on Marketo in Clear Analytics.
-
Integrate Live Workday Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Workday and integrate live Workday into apps built in Microsoft Power Apps.
-
Access PayPal Data from MySQL in PHP
Connect to PayPal through the standard MySQL libraries in PHP.
-
Publish Crystal Reports on Presto Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Presto.
-
Automated Continuous Facebook Replication to SQLite
Use CData Sync for automated, continuous, customizable Facebook replication to SQLite.
-
How to load Samanage data into Elasticsearch via Logstash
Introducing a simple method to load Samanage data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Avalara AvaTax Data in Google Apps Script via Connect AI
Use CData Connect AI to access Avalara AvaTax in Google Apps Script.
-
DataBind Controls to Paymo Data in Delphi
DataBind to Paymo in Delphi with standard data access components and controls.
-
Confluence Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Confluence facts in real time.
-
Explore Geographical Relationships in Accelo Data with Power Map
Create data visualizations with Accelo in Power Map.
-
Integrate Sentry with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Sentry with External Services.
-
Integrating GitHub Copilot CLI with Basecamp 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.
-
Use JayDeBeApi to access Highrise Data in Python
Use standard Python scripting and the development environment of your choice to access live Highrise CRM.
-
DataBind Google Sheets Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Google Sheets with the DevExpress Windows Forms and Web controls to provide Google Sheets to a chart.
-
Connect to Sage Intacct Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Sage Intacct and the Script function in FileMaker Pro to connect to Sage Intacct and work with Sage Intacct in your FileMaker application.
-
Build Dynamics 365 Business Central-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Dynamics 365 Business Central to explore live Dynamics 365 Business Central Data in Cursor to assist with building Dynamics 365 Business Central-powered applications.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Calendar within intelligent workflows.
-
Replicate Stripe Data to Multiple Databases
Replicate Stripe to disparate databases with a point-and-click configuration.
-
Access Live Hive Data in AWS Lambda
Connect to live Apache Hive in AWS Lambda using the CData JDBC Driver.
-
Build a Singer.io Tap for Facebook Ads With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Facebook Ads data using
-
Automated Continuous ConvertKit Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ConvertKit replication to Azure SQL Database.
-
Integrate Outreach.io Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Outreach.io from Informatica Cloud.
-
Access Live Lakebase Data in AWS Lambda
Connect to live Lakebase in AWS Lambda using the CData JDBC Driver.
-
Query Live Databricks 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 Databricks directly from the development environment.
-
Use the CData ODBC Driver for Notion in Microsoft Power Query
You can use the CData Notion ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Notion into Microsoft Power Query.
-
Working with Helpscout Data in LINQPad
Execute LINQ queries to Helpscout in LINQPad.
-
Connect to NASA Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to NASA and work with NASA in your FileMaker applications.
-
Replicate Multiple Chargebee Accounts via the CData Sync CLI
Replicate multiple Chargebee accounts to one or many databases.
-
Connect to Drift Data in RazorSQL
Connect to Drift from wizards and query Drift from the GUI in the RazorSQL database management tool.
-
Query, Visualize, and Share live SAP Hybris C4C Data in Redash
Use CData Connect AI to connect to live SAP Hybris C4C in Redash for querying, visualizing, and sharing.
-
Configure the CData JDBC Driver for Excel Online in a Connection Pool in Tomcat
Connect to Microsoft Excel Online from a connection pool in Tomcat.
-
Connect to Oracle Service Cloud Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle Service Cloud.
-
Integrate LibreChat with Live Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Highrise CRM from within the chat interface.
-
Connecting Pipedream with MarkLogic Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on MarkLogic data in real time.
-
Connect to Live SAP BusinessObjects BI Data in MicroStrategy through CData Connect AI
Create a live connection to SAP BusinessObjects BI Data in CData Connect AI and connect to your SAP BusinessObjects BI from MicroStrategy.
-
How to connect to ADP Data in DBVisualizer
Integrate ADP with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to BigCommerce Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for BigCommerce and the Script function in FileMaker Pro to connect to BigCommerce and work with BigCommerce in your FileMaker application.
-
Use the CData Software ODBC Driver for Google Spanner in MicroStrategy Web
Connect to Google Spanner in MicroStrategy Web using the CData Software ODBC Driver for Google Spanner.
-
Automated Continuous Blackbaud FE NXT Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to delimited files (CSV/TSV).
-
How to use SQLAlchemy ORM to access Microsoft Exchange Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Exchange.
-
Visualize Live Airtable Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Airtable using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Automated Workflows with Live Zoho Projects Data in Workato
Use CData Connect AI to connect to live Zoho Projects and build automated workflows in Workato.