CData Software - Knowledge Base
Recent Articles
-
Connect to Productboard Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Productboard to connect to Productboard data and execute queries in PowerBuilder.
-
Connect to JotForm Data in Aqua Data Studio
Access JotForm data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live Snapchat Ads Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Snapchat Ads data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Agents in Relevance AI with Access to Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Sybase IQ data within intelligent agent workflows.
-
Create Reports from Exa Data in Looker Studio
Use CData Connect AI to gain access to live Exa data and create custom reports in Looker Studio.
-
Build AI Agents with Google Ads 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 Google Ads data through CData Connect AI.
-
Integrate Sugar CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Sugar CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Sugar CRM data.
-
Access Raisers Edge NXT Data from MySQL in Amazon QuickSight
Connect to Raisers Edge NXT and build visualizations of Raisers Edge NXT data using a MySQL Connection in Amazon QuickSight.
-
Connect to Google Ads Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Google Ads data.
-
Build Data Flows from Opsgenie to SQL Server using SSIS
Easily back up Opsgenie data to SQL Server using the SSIS components for Opsgenie.
-
Integrate Hive Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Hive data from Informatica Cloud.
-
Access Live Sybase IQ Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Sybase IQ data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Query, Visualize, and Share live Smartsheet Data in Redash
Use CData Connect AI to connect to live Smartsheet data in Redash for querying, visualizing, and sharing.
-
Moving Data from Everhour to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Everhour data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Consume Asana OData Feeds in PowerBuilder
This article demonstrates how to consume Asana data as OData feeds from PowerBuilder using the API Server.
-
Seamlessly Bring Cvent Data into Retool Using CData Connect AI
Integrate Cvent data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use CData Connect AI to Access Tavily Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Tavily data in the Power Pivot business intelligence tool.
-
How to Connect to Live Optimizely Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Optimizely data for you.
-
Integrating Boomi Agentstudio with Google Search Results via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Search results, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Getting Started with the CData Excel Add-In for Aha!
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Aha!.
-
Connect to CapsuleCRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for CapsuleCRM data.
-
Natively Connect to OnePageCrm Data in PHP
The CData ODBC driver for OnePageCrm enables you to create PHP applications with connectivity to OnePageCrm data. Leverage the native support for ODBC in PHP.
-
Perform API Operations Using the CData SharePoint Task
The CData SharePoint Task allows you to easily call stored procedures to perform SharePoint API operations.
-
Search External Yelp Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Yelp data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Yelp Data objects that you can access from apps and the dashboard.
-
Connect to Email Data in Claris FileMaker Pro
Use the CData ODBC Driver for Email in FileMaker Pro to connect to Email and work with Email data in your FileMaker applications.
-
How to Work with Adobe Target Data in AWS Glue Jobs Using JDBC
Connect to Adobe Target from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Flowlu Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Flowlu data.
-
Connect to and Visualize Live Certinia Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Certinia data.
-
Integrating Gumloop with Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Stripe data within automated workflows.
-
Replicate Authorize.Net Data to Multiple Databases
Replicate Authorize.Net data to disparate databases with a point-and-click configuration.
-
Access Live Exact Online Data in Excel 365 Online (Excel for the web)
Connect to Exact Online data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
LINQ to SuiteCRM Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the SuiteCRM Data Provider.
-
Integrating GitHub Copilot with Spark 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 Live GetResponse Data in Power Automate Desktop via ODBC
The CData ODBC Driver for GetResponse enables you to integrate GetResponse data into workflows built using Microsoft Power Automate Desktop.
-
Publish ZohoSubscriptions-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZohoSubscriptions data.
-
Connect to SurveyMonkey Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SurveyMonkey Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect HelloSign Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your HelloSign data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to load Calendly data into Elasticsearch via Logstash
Introducing a simple method to load Calendly data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software JDBC Driver for Webflow in MicroStrategy
Connect to Webflow data in MicroStrategy Developer using the CData Software JDBC Driver for Webflow.
-
How to Connect to Live Snapchat Ads Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Snapchat Ads data for you.
-
Use Microsoft Copilot Studio to talk to your Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Zoho Projects data for you.
-
How to Connect to Live Anaplan 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 Anaplan data for you.
-
Integrate Google Calendar Data in Pentaho Data Integration
Build ETL pipelines based on Google Calendar data in the Pentaho Data Integration tool.
-
Create Data Visualizations Based On Guru Data in Mode
Use CData Connect AI to connect to Guru Data from Mode and build visualizations using live Guru data.
-
Build AI/ML Models with Live ZendeskSell Data using Dataiku
Connect ZendeskSell Data with Dataiku using the CData API Driver for JDBC.
-
How to connect to SendPulse Data from IntelliJ
Integrate connectivity to SendPulse data with wizards in IntelliJ.
-
Publish Crystal Reports on CockroachDB Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date CockroachDB data.
-
Getting Started with the CData SSIS Components for Helpscout
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Helpscout.
-
Integrate Freshsales Data in Pentaho Data Integration
Build ETL pipelines based on Freshsales data in the Pentaho Data Integration tool.
-
Query Customer.io Data in DataGrip
Create a Data Source for Customer.io in DataGrip and use SQL to query live Customer.io data.
-
Connect to Okta Data in RapidMiner
Integrate Okta data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Billsby Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Billsby and work with Billsby data in your FileMaker application.
-
Analyze ZohoMarketingHub Data in Looker
Use CData Connect AI to connect to ZohoMarketingHub Data from Looker and build custom apps using live ZohoMarketingHub data.
-
Connect to ZeroBounce Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZeroBounce to connect to ZeroBounce data and execute queries in PowerBuilder.
-
Automated Continuous SAP Fieldglass Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Amazon S3.
-
Connect to ADP from Asprova with CData Software ODBC Driver for ADP
This article shows how to connect faster to ADP data from Asprova.
-
Building Dynamic Web Pages with AlloyDB Data Using AngularJS
Create single-page applications with live connectivity to AlloyDB using the CData API Server.
-
Query Miro Data in DataGrip
Create a Data Source for Miro in DataGrip and use SQL to query live Miro data.
-
Migrating data from CockroachDB to Snowflake using CData SSIS Components.
Easily push CockroachDB data to Snowflake using the CData SSIS Tasks for CockroachDB and Snowflake.
-
Feed MailerLite Data into FineReport
How to set MailerLite data as a JDBC data source in FineReport.
-
Access Live Google Drive Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Drive data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build a Singer.io Tap for Suadeo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Suadeo data using the CData Python Connector.
-
Access Live Printify Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Printify data from your Excel spreadsheets.
-
Stream Parquet Data into Apache Kafka Topics
Access and stream Parquet data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to create Perplexity federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Perplexity data in MySQL .
-
Getting Started with the CData Tableau Connector for Email
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Email.
-
Feed Snowflake Data into FineReport
How to set Snowflake data as a JDBC data source in FineReport.
-
Process & Analyze Strava Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Strava Data.
-
Automated Continuous Google Tasks Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Tasks replication to delimited files (CSV/TSV).
-
How to Work with Avalara AvaTax Data in ETL Validator JDBC
Connect to Avalara AvaTax from ETL Validator jobs using the CData Software JDBC Driver.
-
DataBind Controls to ChartMogul Data in Delphi
DataBind to ChartMogul data in Delphi with standard data access components and controls.
-
Natively Connect to Bullhorn CRM Data in PHP
The CData ODBC driver for Bullhorn CRM enables you to create PHP applications with connectivity to Bullhorn CRM data. Leverage the native support for ODBC in PHP.
-
Integrating Dataiku with Jumpseller Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Jumpseller data.
-
Connecting Agentforce with ZohoPeople Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your ZohoPeople data for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sage 200
Provide connectivity to Sage 200 data through an SAP BusinessObjects universe.
-
Build Dashboards with OneNote Data in Dundas BI
Create dynamic dashboards and perform analytics based on OneNote data in Dundas BI.
-
Build SAS Data Sets-Connected Apps in Choreo
Use CData Connect AI to connect to SAS Data Sets Data from Choreo and build custom apps using live SAS Data Sets data.
-
Access Live LinkedIn Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live LinkedIn data from your Excel spreadsheets.
-
How to integrate Metabase with Azure Data Catalog Data
Use CData Connect AI to connect to live Azure Data Catalog data and create an interactive dashboard in Metabase from Azure Data Catalog data.
-
Integrate Foursquare with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Foursquare with External Services.
-
Connect to Real-Time Perigon Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Perigon data in Power Apps.
-
Model Odoo Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Odoo, enabling the direct import of real-time Odoo data.
-
Use the CData ODBC Driver for Zoom in Microsoft Power Query
You can use the CData Zoom ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zoom data into Microsoft Power Query.
-
Seamlessly Bring Epicor Kinetic Data into Retool Using CData Connect AI
Integrate Epicor Kinetic data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to create Discourse federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Discourse data in MySQL .
-
Viewing Redis Data in RAD Studio Data Explorer
How to view Redis data in RAD Studio Data Explorer using the CData ODBC Driver for Redis.
-
Build an OLAP Cube in SSAS from Outreach.io Data
Establish a connection to Outreach.io data data from SQL Server Analysis Services, and use the Outreach.io Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate with Phoenix Data in JReport Designer
Create charts and reports based on Phoenix data in JReport Designer.
-
Use the CData ODBC Driver for Google Ads in Microsoft Power Query
You can use the CData Google Ads ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Ads data into Microsoft Power Query.
-
Create Data Visualizations in Cognos BI with Demio Data
Access Demio data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Optimizely Data into Power Automate Desktop using CData Connect
CData Connect for Optimizely Data enables you to integrate Optimizely data into workflows built using Microsoft Power Automate Desktop.
-
How to Seamlessly Import Typeform Data into IBM SPSS Modeler
Integrate Typeform data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create SSAS Tabular Models from Google Drive Data
How to build a SQL Server Analysis Service Tabular Model from Google Drive data using CData drivers.
-
Use Claude to Talk to Your QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your QuickBooks Online data for you.
-
Shopify Reporting in OBIEE with the Shopify JDBC Driver
Deploy the Shopify JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Analyze Greenhouse Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Greenhouse data with the CData JDBC Driver for Greenhouse.
-
Automated Continuous Drip Replication to MySQL
Use CData Sync for automated, continuous, customizable Drip replication to MySQL.
-
Access Live Neo4J 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 Neo4J data through MCP integration.
-
Feed Figshare Data into FineReport
How to set Figshare data as a JDBC data source in FineReport.
-
Connect Google Calendar to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Calendar with IBM WebSphere for seamless data integration and connectivity.