CData Software - Knowledge Base
Recent Articles
-
How to Visualize Azure Synapse Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Azure Synapse in Python.
-
Automate Chargebee Data Replication to Couchbase
Use CData Sync to Customize and automate Chargebee replication to Couchbase.
-
Working with SAP BusinessObjects BI Data in LINQPad
Execute LINQ queries to SAP BusinessObjects BI in LINQPad.
-
Use Manus AI to Talk to Your SQL Analysis Services 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 SQL Analysis Services.
-
Query Salesforce Pardot Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Salesforce Pardot entities in PHP by modeling them as objects.
-
Explore Geographical Relationships in Figshare Data with Power Map
Create data visualizations with Figshare in Power Map.
-
Automated Continuous Parquet Replication to MySQL
Use CData Sync for automated, continuous, customizable Parquet replication to MySQL.
-
Connect to FreshBooks Data from AWS Glue
Use CData Connect AI to gain access to live FreshBooks from your AWS Glue jobs.
-
Connect to Sage Cloud Accounting Data in RazorSQL
Connect to Sage Cloud Accounting from wizards and query Sage Business Cloud Accounting from the GUI in the RazorSQL database management tool.
-
Prepare, Blend, and Analyze Sage Intacct Data in Alteryx Designer (Connect AI)
Build workflows to access live Sage Intacct for self-service data analytics.
-
Natively Connect to HubSpot Data in PHP
The CData ODBC driver for HubSpot enables you to create PHP applications with connectivity to HubSpot. Leverage the native support for ODBC in PHP.
-
Create Data Visualizations in Cognos BI with Amazon Marketplace Data
Access Amazon Marketplace as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft OneNote using the Model Context Protocol.
-
Build Data Flows from BigQuery to SQL Server using SSIS
Easily back up Google BigQuery to SQL Server using the SSIS components for BigQuery.
-
Connect to and Query Miro Data in QlikView over ODBC
Create data visualizations with Miro in QlikView.
-
Connecting Pipedream with IBM Cloud Object Storage 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 IBM Cloud Object Storage data in real time.
-
DataBind Controls to Short.io Data in Delphi
DataBind to Short.io in Delphi with standard data access components and controls.
-
Build Quickbase-Connected Apps in Choreo
Use CData Connect AI to connect to Quickbase Data from Choreo and build custom apps using live Quickbase.
-
Create a Data Access Object for PivotalTracker Data using JDBI
A brief overview of creating a SQL Object API for PivotalTracker in JDBI.
-
Build Adobe Analytics-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Adobe Analytics Data and create custom apps in Mendix.
-
Natively Connect to SpaceX Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SpaceX. Leverage the native support for ODBC in PHP.
-
Integrating OpenCode Terminal with Timely 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 Live Azure Analysis Services Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Azure Analysis Services for you.
-
Establish a Live Connection with SAP Business Warehouse Data using Tableau Bridge
The CData ODBC Driver for SAP Business Warehouse enables you to integrate live SAP Business Warehouse into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Oracle Financials Cloud Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating OpenCode Terminal with Pingdom 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.
-
Build MVC Applications with Connectivity to HubDB Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access HubDB from an ASP.NET MVC application.
-
Connect to and Query Excel Online Data in QlikView over ODBC
Create data visualizations with Microsoft Excel Online in QlikView.
-
Create Reports from JSON Services in Looker Studio
Use CData Connect AI to gain access to live JSON and create custom reports in Looker Studio.
-
Connect to Oracle Service Cloud Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Oracle Service Cloud Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect to & Open Oracle Service Cloud Data in Microsoft Excel
This article uses the CData ODBC driver for Oracle Service Cloud to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect DBeaver to LDAP via a JDBC Driver
Manage LDAP with visual tools in DBeaver like the query browser.
-
Migrating data from Couchbase to Databricks using CData SSIS Components.
Easily push Couchbase to Databricks using the CData SSIS Tasks for Couchbase and Databricks.
-
Automated Continuous Bitbucket Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Bitbucket replication to OneLake in Microsoft Fabric.
-
Access Slack 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 Slack.
-
Build a PostgreSQL Interface for IBM Cloud Object Storage Data using the CData JDBC Driver
Use the Remoting features of the IBM Cloud Object Storage JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Reports with Bright Data Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bright Data.
-
Integrating Codex CLI with IBM Informix 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 an SAP BusinessObjects Universe on the CData ODBC Driver for Intercom
Provide connectivity to Intercom through an SAP BusinessObjects universe.
-
Easily Integrate Klipfolio Data in Lazarus Pascal IDE
Learn how to easily integrate live Klipfolio in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use CData Connect AI to Access Box Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Box in the Power Pivot business intelligence tool.
-
Connect to Apollo Data in Aqua Data Studio
Access Apollo from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Object-Relational Mapping (ORM) with Elorus 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 Elorus into a Java-based ORM framework, Hibernate.
-
Analyze Certinia Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Certinia in Microsoft R Open.
-
Microsoft Exchange Reporting in OBIEE with the Microsoft Exchange JDBC Driver
Deploy the Microsoft Exchange JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Cvent Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Cvent and the Script function in FileMaker Pro to connect to Cvent and work with Cvent in your FileMaker application.
-
Create CSV-Connected Nintex Workflows
Use CData Connect AI to connect to CSV Data from Nintex Workflow Cloud and build custom workflows using live CSV/TSV Files.
-
Migrating data from Pipeliner CRM to Google BigQuery using CData SSIS Components.
Easily push Pipeliner CRM to Google BigQuery using the CData SSIS Tasks for Pipeliner CRM and Google BigQuery.
-
Prepare, Blend, and Analyze Apollo Data in Alteryx Designer (Connect AI)
Build workflows to access live Apollo for self-service data analytics.
-
Getting Started with the CData Power BI Connector for Delighted
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build Dashboards with Exa Data in Dundas BI
Create dynamic dashboards and perform analytics based on Exa in Dundas BI.
-
Create Data Visualizations in Cognos BI with Sybase IQ Data
Access Sybase IQ as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Perplexity Data in Talend Cloud Data Management Platform
Connect Perplexity Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect SAP Concur to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Concur with IBM WebSphere for seamless data integration and connectivity.
-
Analyze MarkLogic Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MarkLogic in Microsoft R Open.
-
Import and Visualize IBM Cloud Object Storage Data in Power View
Create data visualizations based on IBM Cloud Object Storage in Excel.
-
Automate Aircall Data Replication to Couchbase
Use CData Sync to Customize and automate Aircall replication to Couchbase.
-
Connect to Real-Time Oracle Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Oracle and Dataflow to import and use Oracle Database in Power Apps.
-
Use Databricks Agent Bricks to Talk to Your Azure Analysis Services Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Azure Analysis Services for you.
-
Connect to Beeminder Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Beeminder as an External Source in Dremio.
-
Visualize Live Okta Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Okta using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Acumatica from a Connection Pool in WebLogic
Use the CData JDBC Driver for Acumatica to connect to Acumatica ERP from Web applications running on WebLogic.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAS Data Sets
Provide connectivity to SAS Data Sets through an SAP BusinessObjects universe.
-
How to load IBM Informix data into Elasticsearch via Logstash
Introducing a simple method to load IBM Informix data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live DocuSign Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to DocuSign from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build GitHub Visualizations in Tableau Cloud
Use CData Connect AI to connect to live GitHub and build visualizations in Tableau Cloud.
-
Choosing the Best Method to Connect Gumroad to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Gumroad from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Analyze Live Neo4J Data in SAS Viya
Use CData Connect AI to connect to Neo4J from SAS Viya and deploy self-service analytics using live Neo4J.
-
Access Live Exa Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Exa into the statistical analysis tools available in SAS JMP. This article shows how to use Exa in the Graph Builder and Query Builder.
-
How to work with OpenWeatherMap Data in Apache Spark using SQL
Access and process OpenWeatherMap Data in Apache Spark using the CData Software JDBC Driver.
-
Replicate ServiceDesk Plus Data from PowerShell
Write a quick PowerShell script to query ServiceDesk Plus. Use connectivity to the live data to replicate ServiceDesk Plus to SQL Server.
-
Replicate Tickspot Data from PowerShell
Write a quick PowerShell script to query Tickspot. Use connectivity to the live data to replicate Tickspot to SQL Server.
-
How to integrate Metabase with Google Contacts Data
Use CData Connect AI to connect to live Google Contacts and create an interactive dashboard in Metabase from Google Contacts.
-
Import HDFS Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache HDFS. In this article, you will use the OData format to import Apache HDFS into Microsoft Power Query.
-
How to Query Live Microsoft Teams Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Teams data in natural language using Python.
-
Publish eBay-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live eBay.
-
Access Live Kintone Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Kintone into the statistical analysis tools available in SAS JMP. This article shows how to use Kintone in the Graph Builder and Query Builder.
-
Automated Continuous QuickBooks Time Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Apache Kafka.
-
Connect to Confluence Data from HeidiSQL
Use CData Connect AI to connect to and query live Atlassian Confluence from HeidiSQL.
-
Use the CData Software ODBC Driver for Tickspot in MicroStrategy
Connect to Tickspot in MicroStrategy Developer using the CData Software ODBC Driver for Tickspot.
-
Connect to Customer.io Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Customer.io and the SQL Gateway to access Customer.io from Google Apps Script.
-
Use Manus AI to Talk to Your Google Search Results 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 Google Search.
-
Viewing Bitly Data in RAD Studio Data Explorer
How to view Bitly in RAD Studio Data Explorer using the CData ODBC Driver for Bitly.
-
Use ChatGPT to Talk to Your Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Couchbase for you.
-
Automated Continuous SAP Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP replication to Vertica.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for JSON
Provide connectivity to JSON through an SAP BusinessObjects universe.
-
Automated Continuous Greenplum Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Greenplum replication to PostgreSQL.
-
Use the CData Software JDBC Driver for Azure DevOps in MicroStrategy Desktop
Connect to Azure DevOps in MicroStrategy Desktop using the CData Software JDBC Driver for Azure DevOps.
-
Automated Continuous ZarMoney Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ZarMoney replication to Apache Kafka.
-
How to Seamlessly Import Pipedrive Data into IBM SPSS Modeler
Integrate Pipedrive data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Deploy the ADO.NET Provider for SendGrid on an SSRS Report Server
Connect to SendGrid 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.
-
Building Dynamic Web Pages with Gmail Data Using AngularJS
Create single-page applications with live connectivity to Gmail using the CData API Server.
-
Connecting Moonlit Workflow with SQL Analysis Services Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SQL Analysis Services in real time.
-
Manage AgileCRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for AgileCRM.
-
Building Dynamic Web Pages with Shopify Data Using AngularJS
Create single-page applications with live connectivity to Shopify using the CData API Server.
-
Access Oracle SCM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Oracle SCM from your Oracle system.
-
Connect to JDBC-ODBC Bridge Data in RapidMiner
Integrate JDBC-ODBC Bridge with standard components and data source configuration wizards in RapidMiner Studio.
-
Build a Singer.io Tap for Freshservice With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Freshservice data using
-
Connecting Moonlit Workflow with Microsoft Teams Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Microsoft Teams in real time.
-
Automated Continuous Autopilot Replication to Snowflake
Use CData Sync for automated, continuous, customizable Autopilot replication to Snowflake.