CData Software - Knowledge Base
Recent Articles
-
Create Dashboards and Visualize Live Salesforce Data in Geckoboard
Use CData Connect AI to connect to live Salesforce data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Dashboards with Contentful Data in Dundas BI
Create dynamic dashboards and perform analytics based on Contentful data in Dundas BI.
-
Access Live Instagram Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Instagram data into the statistical analysis tools available in SAS JMP. This article shows how to use Instagram data in the Graph Builder and Query Builder.
-
Natively Connect to Guru Data in PHP
The CData ODBC driver for Guru enables you to create PHP applications with connectivity to Guru data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Python Connector for Parallel
Learn to install and license the CData Python Connector and configure a connection to live Parallel data.
-
Create Datasets from Salesforce CRM Analytics in Domo Workbench and Build Visualizations of Salesforce CRM Analytics Data in Domo
Use the CData Software ODBC Driver for Salesforce CRM Analytics to create datasets from Salesforce CRM Analytics data in Domo Workbench and then build visualizations in the Domo service.
-
How to Visualize SFTP Data in Python with pandas
Use pandas and other modules to analyze and visualize live SFTP data in Python.
-
Visualize Autopilot Data in TIBCO Spotfire through ADO.NET
Integrate Autopilot data into dashboards in TIBCO Spotfire.
-
How to Work with Lakebase Data in AWS Glue Jobs Using JDBC
Connect to Lakebase from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automate TaxJar Data Replication to Couchbase
Use CData Sync to Customize and automate TaxJar data replication to Couchbase.
-
Build Gumroad-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Gumroad data and build web apps with connectivity to live Gumroad data.
-
How to Access Live Google Translate Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Translate enables you to integrate Google Translate data into workflows built using Microsoft Power Automate Desktop.
-
Visualize Jumpseller Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Jumpseller data.
-
Seamlessly Bring Klipfolio Data into Retool Using CData Connect AI
Integrate Klipfolio data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Attio in SpagoBI
Create reports featuring live Attio data in SpagoBI Studio. Host Attio reports on SpagoBI Server.
-
Connect to Cvent Data from AWS Glue
Use CData Connect AI to gain access to live Cvent data from your AWS Glue jobs.
-
Connect to Google Tasks Data from PowerBuilder via JDBC
This article demonstrates how to access Google Tasks data from PowerBuilder using the Google Tasks JDBC Driver.
-
Access Live Webex Data in AWS Lambda
Connect to live Webex data in AWS Lambda using the CData JDBC Driver.
-
How to Build an ETL App for Epicor Kinetic Data in Python with CData
Create ETL applications and real-time data pipelines for Epicor Kinetic data in Python with petl.
-
Automated Continuous CircleCI Replication to Amazon S3
Use CData Sync for automated, continuous, customizable CircleCI replication to Amazon S3.
-
Access Live SAP Concur Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Concur data from your Excel spreadsheets.
-
Build a Singer.io Tap for QuickBooks With the CData Python Connector
Learn how to easily build a Singer.io Tap for live QuickBooks data using the CData Python Connector.
-
How to integrate Metabase with Salesloft Data
Use CData Connect AI to connect to live Salesloft data and create an interactive dashboard in Metabase from Salesloft data.
-
Build Azure Analysis Services-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Azure Analysis Services data.
-
A PostgreSQL Interface for Discord Data (MySQL Remoting via JDBC)
Use the Remoting features of the Discord JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Automated ZohoSubscriptions-Connected Workflows in Zapier
Use CData Connect AI to connect to live ZohoSubscriptions data and build automated workflows in Zapier.
-
Build API-Connected Apps in Choreo
Use CData Connect AI to connect to API Data from Choreo and build custom apps using live API data.
-
Integrating Kiro with ZeroBounce 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 Work with Toggl Data in AWS Glue Jobs Using JDBC
Connect to Toggl from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Act CRM Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Act CRM data through CData Connect AI using different applications and tools.
-
Use the CData ODBC Driver for PolarTeamPro from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for PolarTeamPro to connect to PolarTeamPro data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring PolarTeamPro data in Excel.
-
Model, Search, and Visualize Live HBase Data in ThoughtSpot
Use CData Connect AI to connect to live HBase data for modeling, searching, and visualizing.
-
Connect to SurveyMonkey Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SurveyMonkey as an External Source in Dremio.
-
How to work with Kintone Data in Apache Spark using SQL
Access and process Kintone Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Azure Data Catalog Data in CloverDX (formerly CloverETL)
Transfer Azure Data Catalog data using the visual workflow in the CloverDX data integration tool.
-
Create Data Visualizations Based On VWO Data in Mode
Use CData Connect AI to connect to VWO Data from Mode and build visualizations using live VWO data.
-
Work with Live Discord Data in Power Query
Use CData Connect AI to connect to Discord data and work with live Discord data in Microsoft Power Query.
-
VWO Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to VWO data through CData Connect AI using different applications and tools.
-
Build HBase-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live HBase data.
-
Connect to Typeform from a Connection Pool in WebLogic
Use the CData JDBC Driver for Typeform to connect to Typeform data from Web applications running on WebLogic.
-
Visualize Live HBase Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live HBase data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Work with Live Microsoft Exchange Data in Power Query
Use CData Connect AI to connect to Microsoft Exchange data and work with live Microsoft Exchange data in Microsoft Power Query.
-
Build Data Flows from Oracle HCM Cloud to SQL Server using SSIS
Easily back up Oracle HCM Cloud data to SQL Server using the SSIS components for Oracle HCM Cloud.
-
How to connect and process Elasticsearch data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Elasticsearch data.
-
Integrate Live Qualaroo Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Qualaroo data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Templated Data in HULFT Integrate
Connect to Templated as a JDBC data source in HULFT Integrate
-
Build Dashboards with ScrapingBee Data in Dundas BI
Create dynamic dashboards and perform analytics based on ScrapingBee data in Dundas BI.
-
Create PolarTeamPro-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to PolarTeamPro Data from OutSystems and build custom enterprise apps using live PolarTeamPro data.
-
How to create Visio diagrams from SAP Business One Data
Automatically update SAP Business One data with the changes you make to Visio master shapes.
-
Build QuickBooks-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live QuickBooks data.
-
LINQ to Bright Data 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 Bright Data Data Provider.
-
Integrating OpenCode with Paddle 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 Sugar CRM Data in Looker
Use CData Connect AI to connect to Sugar CRM Data from Looker and build custom apps using live Sugar CRM data.
-
Automated Continuous Bullhorn CRM Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to Amazon S3.
-
Connect to Pipedrive Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Pipedrive data using standard SQL.
-
Replicate Multiple Scrapfly Accounts
Replicate multiple Scrapfly accounts to one or many databases.
-
Build Visualizations of Klipfolio Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Klipfolio data in Birst.
-
Use Databricks Agent Bricks to Talk to Your TaxJar Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your TaxJar data for you.
-
Use Microsoft Copilot Studio to talk to your JSON Services 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 JSON services for you.
-
Use Claude to Talk to Your Omnisend 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 Omnisend data for you.
-
Use Biml to Build SSIS Tasks to Replicate SAS xpt Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAS xpt data to SQL Server.
-
How to use SQLAlchemy ORM to access Testmonitor Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Testmonitor data.
-
Automated Continuous Acumatica Replication to Snowflake
Use CData Sync for automated, continuous, customizable Acumatica replication to Snowflake.
-
Model Redshift Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Redshift, enabling the direct import of real-time Redshift data.
-
Create Reports from Okta Data in Looker Studio
Use CData Connect AI to gain access to live Okta data and create custom reports in Looker Studio.
-
Connect to Productboard in SpagoBI
Create reports featuring live Productboard data in SpagoBI Studio. Host Productboard reports on SpagoBI Server.
-
Connect to Live AgileCRM Data in MicroStrategy through CData Connect AI
Create a live connection to AgileCRM Data in CData Connect AI and connect to your AgileCRM data from MicroStrategy.
-
Connect Procore Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Procore data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to SharePoint in SpagoBI
Create reports featuring live SharePoint data in SpagoBI Studio. Host SharePoint reports on SpagoBI Server.
-
Build AI/ML Models with Live SAS Data Sets Data using Dataiku
Connect SAS Data Sets Data with Dataiku using the CData JDBC Driver for SAS Data Sets.
-
How to Connect Flowise AI Agents to Live Avalara AvaTax 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 Avalara AvaTax data without replication.
-
How to Connect NetSuite Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live NetSuite data in real time using natural language.
-
Back Up Clockify data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Clockify data data.
-
How to Connect to Onfleet Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Onfleet data. Leverage the pyodbc module for ODBC in Python.
-
Access Pushbullet Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Pushbullet data from your Oracle system.
-
Connect to Adobe Experience Manager Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Adobe Experience Manager data.
-
Connect to Twilio Data in DBeaver
Use the CData ODBC Driver to connect to Twilio data in DBeaver.
-
Back Up Toggl data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Toggl data data.
-
Manage Aircall Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Aircall.
-
Visualize Beeminder Data in TIBCO Spotfire through ADO.NET
Integrate Beeminder data into dashboards in TIBCO Spotfire.
-
Integrate Live MongoDB Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to MongoDB data and integrate live MongoDB data into apps built in Microsoft Power Apps.
-
Build a Simple VCL Application for Everhour Data
How to build a simple VCL Application to view Everhour data in RAD Studio using the CData ODBC Driver for Everhour.
-
Query Figshare Data as a MySQL Database in Node.js
Execute MySQL queries against Figshare data from Node.js.
-
Creating Square-Connected Applications in Unqork
You can use CData Connect AI to feed Square data to Unqork and build custom business apps.
-
Model ClickUp Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ClickUp, enabling the direct import of real-time ClickUp data.
-
Automated Continuous Microsoft Dataverse Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to IBM DB2.
-
Integrate Google's Vertex AI Agent with Live Notion 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 Notion data within intelligent workflows.
-
Build MVC Applications with Connectivity to AfterShip Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access AfterShip from an ASP.NET MVC application.
-
Design BIRT Reports on Azure DevOps Data
Provide current Azure DevOps data to your embedded analytics.
-
Create Reports from Tally Data in Looker Studio
Use CData Connect AI to gain access to live Tally data and create custom reports in Looker Studio.
-
Connect to BenchmarkEmail Data in Jaspersoft Studio
Execute SQL to remote BenchmarkEmail data in Jaspersoft Studio.
-
Analyze Live Outreach.io Data in SAS Viya
Use CData Connect AI to connect to Outreach.io data from SAS Viya and deploy self-service analytics using live Outreach.io data.
-
Build a Simple VCL Application for Mouseflow Data
How to build a simple VCL Application to view Mouseflow data in RAD Studio using the CData ODBC Driver for Mouseflow.
-
Getting Started with the CData JDBC Driver for Google Calendar
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Calendar.
-
Connect to Salesloft Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Salesloft and the Script function in FileMaker Pro to connect to Salesloft and work with Salesloft data in your FileMaker application.
-
A PostgreSQL Interface for SparkPost Data (MySQL Remoting via JDBC)
Use the Remoting features of the SparkPost JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect and process Spotify data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Spotify data.
-
Deploy the ADO.NET Provider for HelloSign on an SSRS Report Server
Connect to HelloSign 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.
-
Integrating GitHub Copilot with Humanity 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.
-
Perform Batch Operations with Oracle Service Cloud Data in Apache NiFi
Connect to Oracle Service Cloud data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.