CData Software - Knowledge Base
Recent Articles
-
Connect to Moosend Data in Google Apps Script via Connect AI
Use CData Connect AI to access Moosend data in Google Apps Script.
-
Migrating data from ADP to Google BigQuery using CData SSIS Components.
Easily push ADP data to Google BigQuery using the CData SSIS Tasks for ADP and Google BigQuery.
-
Publish Reports with Parallel Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Parallel data.
-
Model, Search, and Visualize Live PingOne Data in ThoughtSpot
Use CData Connect AI to connect to live PingOne data for modeling, searching, and visualizing.
-
How to Connect to Live SAP Business One 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 SAP Business One data for you.
-
Automated Continuous Google Translate Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Translate replication to Amazon S3.
-
Getting Started with the CData SSIS Components for MariaDB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MariaDB.
-
Automated Power BI XMLA Data Replication to Teradata
Use CData Sync to Customize and automate Power BI XMLA data replication to Teradata.
-
Connect to Azure DevOps Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Azure DevOps.
-
How to Connect to & Open Unbounce Data in Microsoft Excel
This article uses the CData ODBC driver for Unbounce to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live Zoho CRM 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 Zoho CRM data through MCP integration.
-
LINQ to Amplitude 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 Amplitude Data Provider.
-
Use Biml to Build SSIS Tasks to Replicate Hive Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Hive data to SQL Server.
-
Getting Started with the CData Tableau Connector for Moosend
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Manage SendGrid Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SendGrid.
-
Use the CData Software JDBC Driver for ZohoExpense in MicroStrategy
Connect to ZohoExpense data in MicroStrategy Developer using the CData Software JDBC Driver for ZohoExpense.
-
Integrate ChargeOver Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ChargeOver data from Informatica Cloud.
-
Import Real-Time Teamgate Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Teamgate data in ColdFusion.
-
Use Biml to Build SSIS Tasks to Replicate Discourse Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Discourse data to SQL Server.
-
Access Figshare Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Figshare data from your Oracle system.
-
Integrating Codex with Office 365 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 and process Google Ads data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Ads data.
-
How to Connect to Live NetSuite Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live NetSuite data securely in real time.
-
Analyze Zoho Inventory Data in Looker
Use CData Connect AI to connect to Zoho Inventory Data from Looker and build custom apps using live Zoho Inventory data.
-
How to load Google Spanner data into Elasticsearch via Logstash
Introducing a simple method to load Google Spanner data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query Live BigQuery Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live BigQuery data directly from the development environment.
-
Build Apps with Live Redshift Data Using the Low-Code Development Platform of Mendix
Connect Redshift data with Mendix to build apps using the CData JDBC Driver for Redshift.
-
Connect and Query Live Salesloft Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Salesloft data into Databricks and enable direct, live querying and analysis without replication.
-
How to connect SharePoint with SAP Fieldglass Data through external lists
Provide SAP Fieldglass data to SharePoint users as an external list.
-
Build Data Flows from Google Forms to SQL Server using SSIS
Easily back up Google Forms data to SQL Server using the SSIS components for Google Forms.
-
Query Discourse Data in DataGrip
Create a Data Source for Discourse in DataGrip and use SQL to query live Discourse data.
-
Getting Started with the CData ODBC Driver for Airtable
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Airtable.
-
Integrating Kiro with Teamwork 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.
-
Automate GitHub Integration Tasks from PowerShell
Are you in search of a quick and easy way to access GitHub data from PowerShell? This article demonstrates how to utilize the GitHub Cmdlets for tasks like connecting to GitHub data, automating operations, downloading data, and more.
-
Query, Visualize, and Share live Epicor Kinetic Data in Redash
Use CData Connect AI to connect to live Epicor Kinetic data in Redash for querying, visualizing, and sharing.
-
ETL Apollo in Oracle Data Integrator
This article shows how to transfer Apollo data into a data warehouse using Oracle Data Integrator.
-
How to Query Live OneNote Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live OneNote data data in natural language using Python.
-
How to load Adobe Experience Manager data into Elasticsearch via Logstash
Introducing a simple method to load Adobe Experience Manager data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect to Procore Data from IntelliJ
Integrate connectivity to Procore data with wizards in IntelliJ.
-
Connect to QuickBooks Online Data as an External Source in Dremio
Use the CData JDBC Driver to connect to QuickBooks Online as an External Source in Dremio.
-
Viewing ChartMogul Data in RAD Studio Data Explorer
How to view ChartMogul data in RAD Studio Data Explorer using the CData ODBC Driver for ChartMogul.
-
Import VWO Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to VWO Data and provide access to live VWO data for custom reports in the Power BI Service.
-
Build Amazon Marketplace-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Amazon Marketplace data and build web apps with connectivity to live Amazon Marketplace data.
-
Add ServiceNow Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ServiceNow with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Live Aweber Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Aweber data from within the IDE.
-
Bind Live Access Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Access data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Publish Reports with SAS xpt Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAS xpt data.
-
Automate Apollo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apollo data from PowerShell? This article demonstrates how to utilize the Apollo Cmdlets for tasks like connecting to Apollo data, automating operations, downloading data, and more.
-
Connect to Avro Data in DBArtisan
Use wizards in DBArtisan to configure Avro data as a data source.
-
Build Salesforce Data 360-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Salesforce Data 360 data.
-
Connect to Oracle HCM Cloud Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Oracle HCM Cloud data from Filemaker Pro on Mac.
-
Use Dash to Build to Web Apps on Couchbase Data
Create Python applications that use pandas and Dash to build Couchbase-connected web apps.
-
Connect to Bitbucket Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Bitbucket Data and connect to Bitbucket data in Akorbi Digital RunMyProcess.
-
Integrate Live SingleStore Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SingleStore from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SingleStore data.
-
Integrate Trae with Live Marketo Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Marketo data from within the AI-powered IDE.
-
How to Connect to & Open MYOB AccountRight Data in Microsoft Excel
This article uses the CData ODBC driver for MYOB AccountRight to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Aha! Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Aha! from PowerBI.com to create Power BI Dataflows with real-time data.
-
Manage Freshservice Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Freshservice.
-
Connect to Odoo Data in Claris FileMaker Pro
Use the CData ODBC Driver for Odoo in FileMaker Pro to connect to Odoo and work with Odoo data in your FileMaker applications.
-
Visualize Pinterest Data in Sisense
Create an ElastiCube in Sisense app with access to Pinterest data.
-
Use JayDeBeApi to access CouchDB Data in Python
Use standard Python scripting and the development environment of your choice to access live CouchDB data.
-
A PostgreSQL Interface for Quickbase Data (MySQL Remoting via JDBC)
Use the Remoting features of the Quickbase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Bitbucket Data Replication to Couchbase
Use CData Sync to Customize and automate Bitbucket data replication to Couchbase.
-
Connect to Google Spanner Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Spanner data from HeidiSQL.
-
Automated Continuous Hugging Face Replication to Vertica
Use CData Sync for automated, continuous, customizable Hugging Face replication to Vertica.
-
Integrating LangGraph with Salesforce Pardot Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Salesforce Pardot data within automated workflows.
-
Create Greenhouse-Connected Nintex Workflows
Use CData Connect AI to connect to Greenhouse Data from Nintex Workflow Cloud and build custom workflows using live Greenhouse data.
-
Use Azure AI Foundry to Talk to Your FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your FTP data for you.
-
Connect to Copper Data in DBArtisan
Use wizards in DBArtisan to configure Copper data as a data source.
-
DataBind Charts to Vercel Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Vercel 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.
-
Automated Continuous Optimizely Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Optimizely replication to PostgreSQL.
-
Connect to Procore Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Procore data in Airbyte.
-
Excel Spreadsheet Automation on Greenplum Data with the QUERY Formula
Pull data from Greenplum, automate spreadsheets, and more with the QUERY formula.
-
Build Apps with Live Timely Data Using the Low-Code Development Platform of Mendix
Connect Timely data with Mendix to build apps using the CData API Driver for JDBC.
-
Moving Data from CloudConvert to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live CloudConvert data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Real-Time Yelp Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Yelp data in Power Apps.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for HCL Domino
Provide connectivity to HCL Domino data through an SAP BusinessObjects universe.
-
Explore Geographical Relationships in Templated Data with Power Map
Create data visualizations with Templated data in Power Map.
-
How to Use a Microsoft Access Database to Update Oracle Data in Real Time
Update Oracle data by creating a linked table in Microsoft Access with the CData Oracle ODBC Driver.
-
Manage Microsoft Entra ID Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Microsoft Entra ID.
-
Integrating Highrise Data in Talend Cloud Data Management Platform
Connect Highrise Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Highrise.
-
Connect and Query Live Cloudflare Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Cloudflare data into Databricks and enable direct, live querying and analysis without replication.
-
Use the CData Software ODBC Driver for Salesforce Pardot in SAS for Real-Time Reporting and Analytics
Connect to real-time Salesforce Pardot data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Salesforce Pardot.
-
Integrate WordPress Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to WordPress data and integrate live WordPress data into your Power Automate tasks.
-
Integrate Theia IDE with Live Campaigner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Campaigner data from within the development environment.
-
Integrate Real-Time Access to HCL Domino in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to HCL Domino data in real time.
-
Access Live ServiceDesk Plus 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 ServiceDesk Plus data through MCP integration.
-
Use Dash to Build Web Apps on QuickBooks Online Data via CData Connect AI
Build interactive Dash web apps on live QuickBooks Online data using pandas and the CData Connect AI Python SDK.
-
Use Agno to Talk to Your GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your GitLab data for you.
-
Integrating Spark Data in Talend Cloud Data Management Platform
Connect Spark Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Spark.
-
Connect to NetSuite Data from PowerBuilder via ADO.NET
This article demonstrates how to access NetSuite data from Appeon PowerBuilder using the CData ADO.NET Provider for NetSuite.
-
Automated Continuous LaunchDarkly Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Apache Cassandra.
-
Feed Microsoft Ads Data into FineReport
How to set Microsoft Ads data as a JDBC data source in FineReport.
-
Validate HubDB Data with QuerySurge
Access and validate HubDB data in QuerySurge using the CData JDBC Driver.
-
Access Live Google Analytics Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Analytics data from your Google Sheets.
-
Migrating data from Reckon Accounts Hosted to Google BigQuery using CData SSIS Components.
Easily push Reckon Accounts Hosted data to Google BigQuery using the CData SSIS Tasks for Reckon Accounts Hosted and Google BigQuery.
-
Import Real-Time FreeAgent Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use FreeAgent data in ColdFusion.
-
Access Live Redshift Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Redshift data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
DataBind Controls to SingleStore Data in C++Builder
DataBind to SingleStore data in C++Builder with standard components and controls.
-
Connect to and Visualize Live Google Translate Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Translate data.