CData Software - Knowledge Base
Recent Articles
-
Visualize Elasticsearch Data in Sisense
Create an ElastiCube in Sisense app with access to Elasticsearch data.
-
Analyze QuickBooks Data in Looker
Use CData Connect AI to connect to QuickBooks Data from Looker and build custom apps using live QuickBooks data.
-
Connect to Live SparkPost Data in MicroStrategy through CData Connect AI
Create a live connection to SparkPost Data in CData Connect AI and connect to your SparkPost data from MicroStrategy.
-
Build Salesloft-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Salesloft data and build Salesloft-connected web apps with Axios.
-
Connect to Lakebase Data in HULFT Integrate
Connect to Lakebase as a JDBC data source in HULFT Integrate
-
Create Data Visualizations Based On ConstantContact Data in Mode
Use CData Connect AI to connect to ConstantContact Data from Mode and build visualizations using live ConstantContact data.
-
How to Connect Flowise AI Agents to Live Discord Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Discord data without replication.
-
Replicate Sage Cloud Accounting Data to Multiple Databases via the CData Sync CLI
Replicate Sage Cloud Accounting data to disparate databases with a single configuration.
-
Build Data Flows from Cassandra to SQL Server using SSIS
Easily back up Cassandra data to SQL Server using the SSIS components for Cassandra.
-
Bridge Hive Connectivity with Apache NiFi
Access and process Hive data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Wave Financial Replication to MongoDB
Use CData Sync for automated, continuous, customizable Wave Financial replication to MongoDB.
-
Create Informatica Mappings From/To an ODBC Data Source for IBM Informix
Create an ODBC connection to IBM Informix in Informatica and browse and transfer IBM Informix data.
-
Visualize Oracle Eloqua Data in Tableau
The CData ODBC driver for Oracle Eloqua enables you integrate Oracle Eloqua data into Tableau dashboards.
-
Automated Continuous Pipeline CRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Apache Cassandra.
-
How to Connect to & Open SFTP Data in Microsoft Excel
This article uses the CData ODBC driver for SFTP to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live Google Calendar Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Calendar data from your Google Sheets.
-
Build Egnyte-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Egnyte Data and create custom apps in Mendix.
-
Prepare, Blend, and Analyze Xero Data in Alteryx Designer (ODBC)
Build workflows to access live Xero data for self-service data analytics.
-
Use Dash to Build to Web Apps on Yelp Data
Create Python applications that use pandas and Dash to build Yelp-connected web apps.
-
Access Live Oracle HCM Cloud Data in TIBCO Data Virtualization
Use the Oracle HCM Cloud Tibco DV Adapter to create a Oracle HCM Cloud data data source in TIBCO Data Virtualization Studio and gain access to live Oracle HCM Cloud data from your TDV Server.
-
Access Live Exa Data in Excel 365 Online (Excel for the web)
Connect to Exa data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Create Power BI Visual Reports with Real-Time Google Spanner Data
Use CData Power BI Connectors to visualize Google Spanner data in Power BI.
-
How to Connect to Live Redis Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Redis data for you.
-
Publish Testmonitor-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Testmonitor data.
-
Build Data Flows from Clockify to SQL Server using SSIS
Easily back up Clockify data to SQL Server using the SSIS components for Clockify.
-
Build Dashboards with SAP Netweaver Gateway Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP Netweaver Gateway data in DBxtra.
-
Access Live Vertica Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Vertica data through MCP integration.
-
How to Build an ETL App for ConvertKit Data in Python with CData
Create ETL applications and real-time data pipelines for ConvertKit data in Python with petl.
-
Create GitLab-Connected Business Apps in AppSheet
Connect to GitLab Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to GitLab data.
-
Create Data Visualizations in Cognos BI with CircleCI Data
Access CircleCI data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software JDBC Driver for Microsoft Entra ID in MicroStrategy
Connect to Microsoft Entra ID data in MicroStrategy Developer using the CData Software JDBC Driver for Microsoft Entra ID.
-
Query Toggl Data in DataGrip
Create a Data Source for Toggl in DataGrip and use SQL to query live Toggl data.
-
Use the CData SSIS Components to Insert New or Update Existing Sage Cloud Accounting Records from SQL Server
Easily push SQL Server data to Sage Cloud Accounting using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Sage Cloud Accounting or update existing records with data from a SQL Server database.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for QuickBooks Time
Provide connectivity to QuickBooks Time data through an SAP BusinessObjects universe.
-
Natively Connect to Kintone Data in PHP
The CData ODBC driver for Kintone enables you to create PHP applications with connectivity to Kintone data. Leverage the native support for ODBC in PHP.
-
DataBind Charts to Neo4J Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Neo4J data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build MVC Applications with Connectivity to Vault CRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Vault CRM from an ASP.NET MVC application.
-
Choosing the Best Method to Connect Google Contacts to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Contacts data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Sentry from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sentry to connect to Sentry data from Web applications running on WebLogic.
-
Visualize FormSite Data in Tableau
The CData ODBC driver for FormSite enables you integrate FormSite data into Tableau dashboards.
-
Integrating Antigravity CLI with Accelo data via CData CLI
Connect Accelo data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Connect to Live SAP Concur Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your SAP Concur data for you.
-
How to create Email federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Email data in MySQL .
-
Build a PostgreSQL Interface for Amazon S3 Data using the CData JDBC Driver
Use the Remoting features of the Amazon S3 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Dash to Build to Web Apps on ZarMoney Data
Create Python applications that use pandas and Dash to build ZarMoney-connected web apps.
-
Analyze Greenhouse Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Greenhouse data and visualize Greenhouse data in SAP Analytics Cloud.
-
Access Live QuickBooks Online Data in Excel 365 Online (Excel for the web)
Connect to QuickBooks Online data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Analyze OData Services in Infragistics Reveal
Use CData Connect AI to create on OData API on top of OData services and visualize live OData services in Infragistics Reveal.
-
How to Connect to Live Adobe Analytics 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 Adobe Analytics data for you.
-
Integrate OpenCode with Live EnterpriseDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live EnterpriseDB data from within your AI coding agent.
-
Using the CData Software ODBC Driver for Adobe Target in PyCharm
Connect to Adobe Target as an ODBC data source in PyCharm using the CData Software ODBC Driver for Adobe Target.
-
Build Charts with Pingdom Data in Clear Analytics
Create dynamic charts and perform analytics based on Pingdom data in Clear Analytics.
-
Integrate Clio with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Clio with External Services.
-
Use the CData Software JDBC Driver for Bugsnag in MicroStrategy Web
Connect to Bugsnag data in MicroStrategy Web using the CData Software JDBC Driver for Bugsnag.
-
Automate Tickspot Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Tickspot data from PowerShell? This article demonstrates how to utilize the Tickspot Cmdlets for tasks like connecting to Tickspot data, automating operations, downloading data, and more.
-
Connect to Deel Data in Jaspersoft Studio
Execute SQL to remote Deel data in Jaspersoft Studio.
-
Import and Visualize Parallel Data in Power View
Create data visualizations based on Parallel data in Excel.
-
Load MailerLite Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MailerLite data to a database.
-
Create Reports with Confluence Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Confluence data.
-
Use Biml to Build SSIS Tasks to Replicate SpaceX Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SpaceX data to SQL Server.
-
Visualize QuickBooks Data in TIBCO Spotfire through OData
Integrate QuickBooks data into dashboards in TIBCO Spotfire.
-
Automated Continuous Access Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Access replication to PostgreSQL.
-
Access Live AfterShip Data in Excel 365 Online (Excel for the web)
Connect to AfterShip data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Getting Started with the CData SSIS Components for MarkLogic
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MarkLogic.
-
Query, Visualize, and Share live Acumatica Data in Redash
Use CData Connect AI to connect to live Acumatica data in Redash for querying, visualizing, and sharing.
-
Integrating LlamaIndex with Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Spanner data in real time.
-
Excel Spreadsheet Automation on SAP Ariba Source Data with the QUERY Formula
Pull data from SAP Ariba Source, automate spreadsheets, and more with the QUERY formula.
-
How to work with Shortcut Data in Apache Spark using SQL
Access and process Shortcut Data in Apache Spark using the CData Software JDBC Driver.
-
Create Google Directory-Connected Dashboards in Grafana
Connect to Google Directory Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Directory data.
-
Deploy the ADO.NET Provider for Twilio on an SSRS Report Server
Connect to Twilio 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.
-
Automated Continuous Templated Replication to Oracle
Use CData Sync for automated, continuous, customizable Templated replication to Oracle.
-
Automated Continuous Placid Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Placid replication to Google Cloud SQL.
-
Moving Data from Google Tasks to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Tasks data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build ServiceNow-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ServiceNow data.
-
Create Dynamic Clio Grids Using the Infragistics XamDataGrid
Learn how you can connect Clio to Infragistics XamDataGrid to build dynamic grids.
-
Visualize SAP Concur Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Concur data.
-
Build a Singer.io Tap for Tanda With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Tanda data using the CData Python Connector.
-
Getting Started with the CData Python Connector for Dynamics NAV
Learn to install and license the CData Python Connector and configure a connection to live Dynamics NAV data.
-
Viewing REST Data in RAD Studio Data Explorer
How to view REST data in RAD Studio Data Explorer using the CData ODBC Driver for REST.
-
Automate Opsgenie Data Replication to Azure Synapse
Use CData Sync to customize and automate Opsgenie data replication to Azure Synapse.
-
Connect to Cassandra in SpagoBI
Create reports featuring live Cassandra data in SpagoBI Studio. Host Cassandra reports on SpagoBI Server.
-
Integrate Square Data in Pentaho Data Integration
Build ETL pipelines based on Square data in the Pentaho Data Integration tool.
-
Build Dashboards with Short.io Data in DBxtra
Create dynamic dashboards and perform analytics based on Short.io data in DBxtra.
-
Use the CData ODBC Driver for Greenplum from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Greenplum to connect to Greenplum data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Greenplum data in Excel.
-
Create Google Ads-Connected Nintex Workflows
Use CData Connect AI to connect to Google Ads Data from Nintex Workflow Cloud and build custom workflows using live Google Ads data.
-
Access Live IBM Cloud Object Storage Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live IBM Cloud Object Storage data from your Excel spreadsheets.
-
Automated Continuous Bright Data Replication to Vertica
Use CData Sync for automated, continuous, customizable Bright Data replication to Vertica.
-
How to Build an ETL App for Excel Online Data in Python with CData Connect AI
Build ETL pipelines that read and write live Excel Online data in Python with petl and the CData Connect AI Python SDK.
-
Integrating Codex with MYOB AccountRight 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.
-
Migrating data from ActiveCampaign to Google BigQuery using CData SSIS Components.
Easily push ActiveCampaign data to Google BigQuery using the CData SSIS Tasks for ActiveCampaign and Google BigQuery.
-
How to Work with Cloudant Data in AWS Glue Jobs Using JDBC
Connect to Cloudant from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Webflow in SpagoBI
Create reports featuring live Webflow data in SpagoBI Studio. Host Webflow reports on SpagoBI Server.
-
DataBind Controls to Placid Data in C++Builder
DataBind to Placid data in C++Builder with standard components and controls.
-
Connect to Kintone Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Kintone data in Airbyte.
-
How to connect to Nethunt Data in DBVisualizer
Integrate Nethunt data with visual data analysis tools and data connection wizards in DBVisualizer
-
Import SendPulse Data Using Azure Data Factory
Use CData Connect AI to connect to SendPulse Data from Azure Data Factory and import live SendPulse data.
-
How to load Oracle HCM Cloud data into Elasticsearch via Logstash
Introducing a simple method to load Oracle HCM Cloud data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live ShipStation Data in TIBCO Data Virtualization
Use the ShipStation Tibco DV Adapter to create a ShipStation data data source in TIBCO Data Virtualization Studio and gain access to live ShipStation data from your TDV Server.
-
Analyze SAP BusinessObjects BI Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP BusinessObjects BI data with the CData JDBC Driver for SAP BusinessObjects BI.
-
Explore Geographical Relationships in Nuclia Data with Power Map
Create data visualizations with Nuclia data in Power Map.