CData Software - Knowledge Base
Recent Articles
-
Build Figshare-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Figshare data and build web apps with connectivity to live Figshare data.
-
Automated Continuous Greenplum Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Greenplum replication to IBM DB2.
-
Establish a Live Connection with Rebilly Data using Tableau Bridge
The CData ODBC Driver for Rebilly enables you to integrate live Rebilly data into Tableau Cloud dashboards using the Tableau Bridge.
-
Cassandra Reporting in OBIEE with the Cassandra JDBC Driver
Deploy the Cassandra JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to create an RPA flow for XML Data in UiPath Studio
Use the XML ODBC Driver to create workflows that access real-time XML data without any coding.
-
How to Visualize Freshdesk Data in Python with pandas
Use pandas and other modules to analyze and visualize live Freshdesk data in Python.
-
Use the CData Software JDBC Driver for Google Spanner in MicroStrategy Desktop
Connect to Google Spanner data in MicroStrategy Desktop using the CData Software JDBC Driver for Google Spanner.
-
How to connect PolyBase to Google Ads
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Ads data.
-
Connecting GenSpark with Okta Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Okta data without any replication or custom integration required.
-
Connect to NASA Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for NASA to connect to NASA data and execute queries in PowerBuilder.
-
Connecting Pipedream with Microsoft Planner 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 Microsoft Planner data in real time.
-
Getting Started with the CData SSIS Components for Intercom
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Intercom.
-
Connecting Mastra with Oracle SCM 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 Oracle SCM data, no replication required.
-
Working with Vault CRM Data in LINQPad
Execute LINQ queries to Vault CRM data in LINQPad.
-
Getting Started with the CData ADO.NET Provider for ShipEngine
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrating Gumloop with Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Xero data within automated workflows.
-
A PostgreSQL Interface for LinkedIn Ads Data (MySQL Remoting via JDBC)
Use the Remoting features of the LinkedIn Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Productboard Data in DataGrip
Create a Data Source for Productboard in DataGrip and use SQL to query live Productboard data.
-
How to Connect the Power BI Service to Clio: Complete Guide
Connect to the CData Software Power BI Connector for Clio from PowerBI.com to provide real-time Clio data across the organization.
-
Manage SAP Hybris C4C Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP Hybris C4C.
-
Visualize Tanda Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Tanda data.
-
How to Connect to Live Google Contacts 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 Google Contacts data through natural language.
-
View Reports on Real-Time Pushbullet Data in Power BI Report Server
Use the CData ODBC Driver for Pushbullet to visualize Pushbullet data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automate Mode Data Replication to SAP HANA
Use CData Sync to customize and automate Mode data replication to SAP HANA.
-
Visualize Live Google Translate Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Translate data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Publish ZohoDesk-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZohoDesk data.
-
How to Query Certinia Data in MySQL Workbench
Execute MySQL queries against live Certinia data from MySQL Workbench.
-
Build Shippo-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Shippo data.
-
Create Google Sheets-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Sheets Data from OutSystems and build custom enterprise apps using live Google Sheets data.
-
Automate Planio Data Replication to SAP HANA
Use CData Sync to customize and automate Planio data replication to SAP HANA.
-
Visualize Live VWO Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live VWO data into custom reports in Power BI.
-
Getting Started with the CData Python Connector for Cvent
Learn to install and license the CData Python Connector and configure a connection to live Cvent data.
-
Build Agents in Relevance AI with Access to Live Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Vault CRM data within intelligent agent workflows.
-
How to Work with Billsby Data in ETL Validator JDBC
Connect to Billsby from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Excel Add-In for SAP Ariba Source
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP Ariba Source.
-
Build Simplesat-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Simplesat data.
-
Use the CData Software JDBC Driver for Google Calendar in MicroStrategy
Connect to Google Calendar data in MicroStrategy Developer using the CData Software JDBC Driver for Google Calendar.
-
Publish Perigon-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Perigon data.
-
Getting Started with the CData JDBC Driver for BigQuery
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for BigQuery.
-
Integrate with Azure Data Catalog Data in JReport Designer
Create charts and reports based on Azure Data Catalog data in JReport Designer.
-
Analyze Pinterest Data in Cognos Analytics
Use CData Connect AI to connect to Pinterest Data from Cognos Analytics and analyze live Pinterest data.
-
How to Connect to & Open Stripe Data in Microsoft Excel
This article uses the CData ODBC driver for Stripe to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Redshift Data in DBArtisan
Use wizards in DBArtisan to configure Redshift data as a data source.
-
Automated Continuous Cloudant Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Cloudant replication to Google Cloud SQL.
-
Import Real-Time Zoho CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoho CRM data in ColdFusion.
-
Automated Sybase Data Replication to Teradata
Use CData Sync to Customize and automate Sybase data replication to Teradata.
-
Integrating OpenCode with Zoho Inventory 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.
-
Analyze MarkLogic Data in Cognos Analytics
Use CData Connect AI to connect to MarkLogic Data from Cognos Analytics and analyze live MarkLogic data.
-
How to Query Zoho Books Data in MySQL Workbench
Execute MySQL queries against live Zoho Books data from MySQL Workbench.
-
Integrate Cvent Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Cvent data from Informatica Cloud.
-
Automate Bitbucket Data Replication to SAP HANA
Use CData Sync to customize and automate Bitbucket data replication to SAP HANA.
-
Access Gong Data from MySQL in Amazon QuickSight
Connect to Gong and build visualizations of Gong data using a MySQL Connection in Amazon QuickSight.
-
Load ActiveCampaign Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ActiveCampaign data to a database.
-
Build Dashboards with SQL Server Data in DBxtra
Create dynamic dashboards and perform analytics based on SQL Server data in DBxtra.
-
How to Connect to Live Certinia Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Certinia data for you.
-
Connect to Coinbase Data in Jaspersoft Studio
Execute SQL to remote Coinbase data in Jaspersoft Studio.
-
Build Apps with Live SurveyMonkey data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SurveyMonkey data into the Adalo platform and build custom mobile and web applications with real-time SurveyMonkey data.
-
Integrate Google's Vertex AI Agent with Live Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Trello data within intelligent workflows.
-
Automate OpenWeatherMap Data Replication to Couchbase
Use CData Sync to Customize and automate OpenWeatherMap data replication to Couchbase.
-
Query Mouseflow Data in ColdFusion
Write standard ColdFusion data access code to connect to Mouseflow data.
-
Integrate NetSuite Data in the Pentaho Report Designer
Publish reports based on NetSuite data in the Pentaho BI tool.
-
Getting Started with the CData JDBC Driver for Zoho Creator
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Zoho Creator.
-
Provide OData Services of Freshsales Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Freshsales data by developing a WCF Service Application.
-
Integrating Kiro with Clari 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 Perplexity-Connected Nintex Workflows
Use CData Connect AI to connect to Perplexity Data from Nintex Workflow Cloud and build custom workflows using live Perplexity data.
-
Access JSON Services 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 JSON services.
-
Integrating Codex with CockroachDB 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 SharePoint with Salesforce CRM Analytics Data through external lists
Provide Salesforce CRM Analytics data to SharePoint users as an external list.
-
Automate AfterShip Data Replication to Azure Synapse
Use CData Sync to customize and automate AfterShip data replication to Azure Synapse.
-
Use the CData ODBC Driver for QuickBooks from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for QuickBooks to connect to QuickBooks data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring QuickBooks data in Excel.
-
Build Dashboards with BigCommerce Data in Dundas BI
Create dynamic dashboards and perform analytics based on BigCommerce data in Dundas BI.
-
How to Work with Act-On Data in AWS Glue Jobs Using JDBC
Connect to Act-On from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous QuickBooks Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable QuickBooks replication to Apache Kafka.
-
Connect to Zoho Books Data from a Connection Pool in Jetty
The Zoho Books JDBC Driver supports connection pooling: This article shows how to connect faster to Zoho Books data from Web apps in Jetty.
-
Configure the CData JDBC Driver for JDBC-ODBC Bridge in a Connection Pool in Tomcat
Connect to JDBC-ODBC Bridge data from a connection pool in Tomcat.
-
Build Facebook Ads-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Facebook Ads Data and create custom apps in Mendix.
-
How to load Reckon data into Elasticsearch via Logstash
Introducing a simple method to load Reckon data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to Live SAP Business Warehouse 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 SAP Business Warehouse data for you.
-
Connect to Google Spanner Data in JRuby
Create a simple JRuby app with access to live Google Spanner data.
-
Automated Continuous Azure Data Lake Storage Replication to MongoDB
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to MongoDB.
-
Connect to Facebook Ads Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Facebook Ads and the Script function in FileMaker Pro to connect to Facebook Ads and work with Facebook Ads data in your FileMaker application.
-
Prepare, Blend, and Analyze BenchmarkEmail Data in Alteryx Designer (Connect AI)
Build workflows to access live BenchmarkEmail data for self-service data analytics.
-
Create Dashboards and Visualize Live Splunk Data in Geckoboard
Use CData Connect AI to connect to live Splunk data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to work with ZohoInvoice Data in Apache Spark using SQL
Access and process ZohoInvoice Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live Oracle Eloqua Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Oracle Eloqua data through MCP integration.
-
How to create Microsoft Exchange federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Exchange data in MySQL .
-
Connect to Tally Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Tally.
-
Automated Continuous Google Search Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Search replication to Amazon Redshift.
-
Connect to Instagram from a Connection Pool in WebLogic
Use the CData JDBC Driver for Instagram to connect to Instagram data from Web applications running on WebLogic.
-
How to Connect the Power BI Service to QuickBooks Online: Complete Guide
Connect to the CData Software Power BI Connector for QuickBooks Online from PowerBI.com to provide real-time QuickBooks Online data across the organization.
-
Moving Data from Pipeliner CRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Pipeliner CRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Rapidly Develop SAP Hybris C4C-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by SAP Hybris C4C.
-
Use the CData Software ODBC Driver for Splunk in MicroStrategy Web
Connect to Splunk data in MicroStrategy Web using the CData Software ODBC Driver for Splunk.
-
Build PagerDuty-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PagerDuty data.
-
Integrating LangChain with Tavily Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Tavily data within automated workflows.
-
Integrating Gumloop with MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on MYOB AccountRight data within automated workflows.
-
Build MVC Applications with Connectivity to Twitter Ads Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Twitter Ads from an ASP.NET MVC application.
-
Moving Data from Mocean to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Mocean data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
DataBind Controls to Apollo Data in C++Builder
DataBind to Apollo data in C++Builder with standard components and controls.
-
Automated Continuous xBase Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable xBase replication to PostgreSQL.