CData Software - Knowledge Base
Recent Articles
-
Edit and Search Microsoft Exchange External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft Exchange to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Microsoft Exchange objects that you can access from apps and the dashboard.
-
How to Connect to Paymo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Paymo. Leverage the pyodbc module for ODBC in Python.
-
Connect Google Cloud Storage to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Cloud Storage with IBM WebSphere for seamless data integration and connectivity.
-
Integrate with Google Translate Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Translate to a JSON file on disk.
-
Integrating Claude Code CLI with SAP 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 SAP SuccessFactors Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SAP SuccessFactors Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous Workday Replication to Oracle
Use CData Sync for automated, continuous, customizable Workday replication to Oracle.
-
How to Connect DBeaver to Invoiced via a JDBC Driver
Manage Invoiced with visual tools in DBeaver like the query browser.
-
Use the CData Software JDBC Driver for Oracle Service Cloud in MicroStrategy
Connect to Oracle Service Cloud in MicroStrategy Developer using the CData Software JDBC Driver for Oracle Service Cloud.
-
Access Live Google Ad Manager Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Ad Manager from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating Boomi Agentstudio with SAP SuccessFactors LMS Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAP SuccessFactors LMS, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Semantic Layer Views for CloudConvert Data in APOS Live Data Gateway
Use the CData Connector for CloudConvert in APOS Live Data Gateway to build Semantic Layer Views for CloudConvert.
-
Connect to Redis Data in Aqua Data Studio
Access Redis from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to Cvent Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Cvent. Leverage the pyodbc module for ODBC in Python.
-
Connecting Mastra with Google Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Google Analytics, no replication required.
-
Access Live Zoho CRM Data in Excel 365 Online (Excel for the web)
Connect to Zoho CRM from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Analyze Freshservice Data in Cognos Analytics
Use CData Connect AI to connect to Freshservice Data from Cognos Analytics and analyze live Freshservice.
-
Integrating Cursor CLI with Greenhouse 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 Access Bitly Data Using Entity Framework
This article shows how to access Bitly using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Easily Query MailerSend Data in OpenOffice Base
Connect to MailerSend data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous SAP Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP replication to Oracle.
-
Excel Spreadsheet Automation on Google Calendar Data with the QUERY Formula
Pull data from Google Calendar, automate spreadsheets, and more with the QUERY formula.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Hacker News
Provide connectivity to Hacker News through an SAP BusinessObjects universe.
-
Integrate Snapchat Ads Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Snapchat Ads and integrate live Snapchat Ads into your Power Automate tasks.
-
Migrating data from Tanda to Google BigQuery using CData SSIS Components.
Easily push Tanda to Google BigQuery using the CData SSIS Tasks for Tanda and Google BigQuery.
-
Publish Mouseflow-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Mouseflow.
-
How to Connect to Live Sage Cloud Accounting 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 Sage Business Cloud Accounting for you.
-
Use the CData Software JDBC Driver for PagerDuty in MicroStrategy Web
Connect to PagerDuty in MicroStrategy Web using the CData Software JDBC Driver for PagerDuty.
-
Feed SAP HANA Data into FineReport
How to set SAP HANA as a JDBC data source in FineReport.
-
Edit and Search External Box Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Box to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Box Data objects that you can access from apps and the dashboard.
-
Connect to Google Cloud Storage Data from AWS Glue
Use CData Connect AI to gain access to live Google Cloud Storage from your AWS Glue jobs.
-
Build a Singer.io Tap for LaunchDarkly With the CData Python Connector
Learn how to easily build a Singer.io Tap for live LaunchDarkly data using
-
Connect to Live SAS Data Sets Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAS Data Sets in CData Connect AI and connect to your SAS Data Sets from PostgreSQL.
-
Integrating Gumloop with Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Outreach.io within automated workflows.
-
How to connect to Tally Data in DBVisualizer
Integrate Tally ERP with visual data analysis tools and data connection wizards in DBVisualizer
-
Visualize Live QuickBooks Online Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live QuickBooks Online into custom reports in Power BI.
-
Import Google Ads Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google Ads. In this article, you will use the OData format to import Google Ads into Microsoft Power Query.
-
Integrate ZohoPeople Data in the Pentaho Report Designer
Publish reports based on ZohoPeople in the Pentaho BI tool.
-
Analyze Zoho Creator Data in Cognos Analytics
Use CData Connect AI to connect to Zoho Creator Data from Cognos Analytics and analyze live Zoho Creator.
-
How to Visualize Zoho Recruit Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zoho Recruit in Python.
-
Migrating data from FreeAgent to Databricks using CData SSIS Components.
Easily push FreeAgent to Databricks using the CData SSIS Tasks for FreeAgent and Databricks.
-
Create Zoho Inventory-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Zoho Inventory Data from Klipfolio and build custom visualizations using live Zoho Inventory.
-
Automated Continuous Campaigner Replication to SingleStore
Use CData Sync for automated, continuous, customizable Campaigner replication to SingleStore.
-
Connect to CouchDB Data as an External Source in Dremio
Use the CData JDBC Driver to connect to CouchDB as an External Source in Dremio.
-
Connect to Confluence Data in HULFT Integrate
Connect to Confluence as a JDBC data source in HULFT Integrate
-
Build Microsoft OneDrive Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Microsoft OneDrive and build visualizations in Tableau Cloud.
-
Integrating LangGraph with Apollo Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Apollo within automated workflows.
-
Integrating OpenCode Terminal with JotForm 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 Query Shopify Data in MySQL Workbench
Execute MySQL queries against live Shopify from MySQL Workbench.
-
Connect Microsoft Teams to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft Teams using the CData Python MCP Server.
-
Build Semantic Layer Views for Active Directory Data in APOS Live Data Gateway
Use the CData Connector for Active Directory in APOS Live Data Gateway to build Semantic Layer Views for Active Directory.
-
Automated Continuous LeadDesk Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable LeadDesk replication to delimited files (CSV/TSV).
-
Build Google Calendar-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Google Calendar to explore live Google Calendar Data in GitHub Copilot to assist with building Google Calendar-powered applications.
-
Visualize Live Auth0 Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Auth0.
-
Create Datasets from ShipStation in Domo Workbench and Build Visualizations of ShipStation Data in Domo
Use the CData Software ODBC Driver for ShipStation to create datasets from ShipStation in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Databricks Replication to MongoDB
Use CData Sync for automated, continuous, customizable Databricks replication to MongoDB.
-
Integrating Claude Code with Google Analytics Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Analytics within assisted coding and automated development workflows.
-
Connect to Sendwithus Data in RazorSQL
Connect to Sendwithus from wizards and query Sendwithus from the GUI in the RazorSQL database management tool.
-
Visualize Adobe Commerce Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Adobe Commerce.
-
Query PostgreSQL Data from Node.js
Use the OData endpoint of the CData API Server to connect to your PostgreSQL and perform CRUD operations on PostgreSQL from Node.js.
-
Browserless Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Browserless facts in real time.
-
Easily Integrate Azure Synapse Data in Lazarus Pascal IDE
Learn how to easily integrate live Azure Synapse in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Migrating data from YouTube Analytics to Google BigQuery using CData SSIS Components.
Easily push YouTube Analytics to Google BigQuery using the CData SSIS Tasks for YouTube Analytics and Google BigQuery.
-
Validate Freshteam Data with QuerySurge
Access and validate Freshteam in QuerySurge using the CData JDBC Driver.
-
Prepare, Blend, and Analyze Zoho CRM Data in Alteryx Designer (ODBC)
Build workflows to access live Zoho CRM for self-service data analytics.
-
Build Charts with Active Directory Data in Clear Analytics
Create dynamic charts and perform analytics based on Active Directory in Clear Analytics.
-
Easily Integrate ConvertKit Data in Lazarus Pascal IDE
Learn how to easily integrate live ConvertKit in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Bridge Workable Connectivity with Apache NiFi
Access and process Workable in Apache NiFi using the CData JDBC Driver.
-
Analyze Presto Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Presto and visualize live Presto in Infragistics Reveal.
-
Query Snowflake Data as a SQL Server Database in Node.js
Execute SQL Server queries against Snowflake from Node.js.
-
Getting Started with the CData ODBC Driver for Klaviyo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Klaviyo.
-
Integrate eBay Analytics with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate eBay Analytics with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to eBay Analytics.
-
Bridge Twitter Ads Connectivity with Apache NiFi
Access and process Twitter Ads in Apache NiFi using the CData JDBC Driver.
-
Getting Started with the CData Python Connector for PostgreSQL
Learn to install and license the CData Python Connector
-
Create Dashboards and Visualize Live Office 365 Data in Geckoboard
Use CData Connect AI to connect to live Microsoft Office 365 and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create Informatica Mappings From/To a JDBC Data Source for Nuclia
Create Nuclia data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData Software ODBC Driver for Foursquare in MicroStrategy Web
Connect to Foursquare in MicroStrategy Web using the CData Software ODBC Driver for Foursquare.
-
Build MVC Applications with Connectivity to Adobe Target Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Adobe Target from an ASP.NET MVC application.
-
Analyze Epicor Kinetic Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Epicor Kinetic and visualize Epicor Kinetic in SAP Analytics Cloud.
-
Automated Continuous Aircall Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Aircall replication to delimited files (CSV/TSV).
-
Visualize Drift 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 Drift into TIBCO Spotfire.
-
Automated Continuous Kafka Replication to Databricks
Use CData Sync for automated, continuous, customizable Kafka replication to Databricks.
-
Analyze Teradata Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Teradata with the CData JDBC Driver for Teradata.
-
Use the CData Software JDBC Driver for ZohoDesk in MicroStrategy
Connect to ZohoDesk in MicroStrategy Developer using the CData Software JDBC Driver for ZohoDesk.
-
Getting Started with the CData Power BI Connector for Autopilot
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Provide OData Services of HelloSign Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for HelloSign by developing a WCF Service Application.
-
Use the CData Software JDBC Driver for MarkLogic in MicroStrategy
Connect to MarkLogic in MicroStrategy Developer using the CData Software JDBC Driver for MarkLogic.
-
Build Pipelines with Live Highrise Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Highrise from Google Cloud Data Fusion, enabling the integration of live Highrise CRM into the building and management of effective data pipelines.
-
How to Work with Freshsales Data in ETL Validator JDBC
Connect to Freshsales from ETL Validator jobs using the CData Software JDBC Driver.
-
Bidirectional Access to SageHR Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SageHR in Filemaker Pro for Mac or Windows.
-
Query SpaceX Data as a MySQL Database in Node.js
Execute MySQL queries against SpaceX from Node.js.
-
Connect to Microsoft Teams Data from a Connection Pool in JBoss
Integrate Microsoft Teams into Java servlets: Use the Management Console in JBoss to install the Microsoft Teams JDBC Driver.
-
Use the CData Software JDBC Driver for Bitly in MicroStrategy
Connect to Bitly in MicroStrategy Developer using the CData Software JDBC Driver for Bitly.
-
Integrating Antigravity CLI with Deel via CData CLI
Connect Deel to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Publish Google Spanner-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Spanner.
-
Connect to Snapchat Ads Data in Ruby
Connect to Snapchat Ads in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData Tableau Connector for SAP Business One
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Business One.
-
Getting Started with the CData JDBC Driver for Microsoft OneDrive
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Microsoft OneDrive.
-
Build Semantic Layer Views for PDFMonkey Data in APOS Live Data Gateway
Use the CData Connector for PDFMonkey in APOS Live Data Gateway to build Semantic Layer Views for PDFMonkey.
-
Viewing Cloudant Data in RAD Studio Data Explorer
How to view IBM Cloudant in RAD Studio Data Explorer using the CData ODBC Driver for Cloudant.