CData Software - Knowledge Base
Recent Articles
-
How to connect to AdRoll Data with Squirrel SQL client
Connect to AdRoll data and execute queries in the Squirrel SQL Client.
-
Build VWO-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live VWO data.
-
How to connect to Scrapfly Data from Spring Boot
Connect to Scrapfly in a Spring Boot Application using the CData API Driver for JDBC
-
Use JayDeBeApi to access ClickUp Data in Python
Use standard Python scripting and the development environment of your choice to access live ClickUp data.
-
Natively Connect to Google Forms Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Forms data. Leverage the native support for ODBC in PHP.
-
Prepare, Blend, and Analyze Authorize.Net Data in Alteryx Designer (ODBC)
Build workflows to access live Authorize.Net data for self-service data analytics.
-
Integrate Live SAP SuccessFactors LMS Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP SuccessFactors LMS from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP SuccessFactors LMS data.
-
How to Connect to Live Square 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 Square data through natural language.
-
Connect to Sendwithus 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 Sendwithus data.
-
Build Agents in Relevance AI with Access to Live Optimizely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Optimizely data within intelligent agent workflows.
-
Automated Continuous REST Replication to Oracle
Use CData Sync for automated, continuous, customizable REST replication to Oracle.
-
Connect to Notion in SpagoBI
Create reports featuring live Notion data in SpagoBI Studio. Host Notion reports on SpagoBI Server.
-
How to create Visio diagrams from SingleStore Data
Automatically update SingleStore data with the changes you make to Visio master shapes.
-
How to Connect the Power BI Service to TigerGraph: Complete Guide
Connect to the CData Software Power BI Connector for TigerGraph from PowerBI.com to provide real-time TigerGraph data across the organization.
-
View Reports on Real-Time Scrapfly Data in Power BI Report Server
Use the CData ODBC Driver for Scrapfly to visualize Scrapfly data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Google Translate Data in RapidMiner
Integrate Google Translate data with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData ODBC Driver for Zendesk
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zendesk.
-
Getting Started with the CData Excel Add-In for Confluence
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Confluence.
-
Use JayDeBeApi to access Customer.io Data in Python
Use standard Python scripting and the development environment of your choice to access live Customer.io data.
-
Use Dash to Build to Web Apps on Xero Data
Create Python applications that use pandas and Dash to build Xero-connected web apps.
-
Access Miro Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Miro data from your Oracle system.
-
Connect to and Visualize Live Salesforce Data 360 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Salesforce Data 360 data.
-
Automated Continuous Todoist Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Todoist replication to Google Cloud SQL.
-
How to Connect to Live QuickBooks 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 QuickBooks data for you.
-
Create Azure Analysis Services-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Azure Analysis Services Data from Klipfolio and build custom visualizations using live Azure Analysis Services data.
-
Automated Continuous Zuora Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zuora replication to IBM DB2.
-
Build Freshservice-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Freshservice data and build Freshservice-connected web apps with Axios.
-
DataBind Charts to MailerSend Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to MailerSend 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.
-
How to connect to SAS Data Sets Data from IntelliJ
Integrate connectivity to SAS Data Sets data with wizards in IntelliJ.
-
Create Simplesat Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Simplesat from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query, Visualize, and Share live SuiteCRM Data in Redash
Use CData Connect AI to connect to live SuiteCRM data in Redash for querying, visualizing, and sharing.
-
Build Campaigner-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Campaigner Data and create custom apps in Bubble.
-
Access Live Shortcut Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Shortcut data from your Excel spreadsheets.
-
Integrating Kiro 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.
-
Access Live Phoenix Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Phoenix data from your Google Sheets.
-
Connect to GetResponse Data in JRuby
Create a simple JRuby app with access to live GetResponse data.
-
Build SAP HANA XS Advanced-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAP HANA XS Advanced Data from Zoho Analytics and import live SAP HANA XS Advanced data.
-
Use Biml to Build SSIS Tasks to Replicate Eventbrite Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Eventbrite data to SQL Server.
-
Create API-Connected Dashboards in Grafana
Connect to API Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to API data.
-
Create Power BI Reports on Real-Time ADP Data
Use the CData ODBC Driver for ADP to visualize ADP data in Power BI Desktop.
-
Automate Salesforce Pardot Data Replication to Couchbase
Use CData Sync to Customize and automate Salesforce Pardot data replication to Couchbase.
-
Link Reply.io with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Reply.io data in Filemaker Pro for Mac or Windows.
-
Create Informatica Mappings From/To an ODBC Data Source for ZohoPeople
Create an ODBC connection to ZohoPeople in Informatica and browse and transfer ZohoPeople data.
-
How to Work with PostgreSQL Data in ETL Validator JDBC
Connect to PostgreSQL from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Act CRM in SpagoBI
Create reports featuring live Act CRM data in SpagoBI Studio. Host Act CRM reports on SpagoBI Server.
-
How to Connect the Power BI Service to Zoho Creator: Complete Guide
Connect to the CData Software Power BI Connector for Zoho Creator from PowerBI.com to provide real-time Zoho Creator data across the organization.
-
Integrate TaxJar Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live TaxJar data from Informatica Cloud.
-
Connect to Aha! Data in RapidMiner
Integrate Aha! data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Mocean Data in Aqua Data Studio
Access Mocean data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to connect to Deel Data in DBVisualizer
Integrate Deel data with visual data analysis tools and data connection wizards in DBVisualizer
-
Process & Analyze ElevenLabs Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ElevenLabs Data.
-
Access Live Paylocity Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Paylocity data from your Google Sheets.
-
Create PDFMonkey Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PDFMonkey data access from reports, embedded analytics, and more.
-
Create Oracle Financials Cloud-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Oracle Financials Cloud Data from Klipfolio and build custom visualizations using live Oracle Financials Cloud data.
-
How to Connect Flowise AI Agents to Live Odoo 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 Odoo data without replication.
-
Extract, Transform, and Load FreshBooks Data in Informatica PowerCenter
Create a simple Workflow for FreshBooks data in Informatica PowerCenter.
-
Add SageHR Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SageHR with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Front Replication to Snowflake
Use CData Sync for automated, continuous, customizable Front replication to Snowflake.
-
Automated Continuous Facebook Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Facebook replication to delimited files (CSV/TSV).
-
Integrating Cursor with FormSite 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.
-
Connect to and Visualize Live AgileCRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live AgileCRM data.
-
Access Live Salesforce CRM Analytics Data in AWS Lambda
Connect to live Salesforce CRM Analytics data in AWS Lambda using the CData JDBC Driver.
-
Migrating data from Splunk to Snowflake using CData SSIS Components.
Easily push Splunk data to Snowflake using the CData SSIS Tasks for Splunk and Snowflake.
-
How to Query Live Oracle Service Cloud Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle Service Cloud data data in natural language using Python.
-
Build Data Flows from Teamwork to SQL Server using SSIS
Easily back up Teamwork data to SQL Server using the SSIS components for Teamwork.
-
Back Up Teamgate 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 Teamgate data data.
-
Integrate Vimeo Data in the Pentaho Report Designer
Publish reports based on Vimeo data in the Pentaho BI tool.
-
Integrating Discourse Data in Talend Cloud Data Management Platform
Connect Discourse Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use the CData Software JDBC Driver for Brex in MicroStrategy
Connect to Brex data in MicroStrategy Developer using the CData Software JDBC Driver for Brex.
-
Visualize Live Lakebase Data in the Power BI Service
Use CData Connect AI to connect to live Lakebase data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Dynamic SparkPost Grids Using the Infragistics XamDataGrid
Learn how you can connect SparkPost to Infragistics XamDataGrid to build dynamic grids.
-
Access Live ChartMogul Data in AWS Lambda
Connect to live ChartMogul data in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Snowflake in MicroStrategy Desktop
Connect to Snowflake data in MicroStrategy Desktop using the CData Software ODBC Driver for Snowflake.
-
DataBind Controls to Gmail Data in Delphi
DataBind to Gmail data in Delphi with standard data access components and controls.
-
Analyze BigCommerce Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for BigCommerce from Power Pivot. You will use the Table Import Wizard to load BigCommerce data. You can visually build the import query or use any SQL supported by the driver.
-
DataBind Charts to ShipStation Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ShipStation 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.
-
Visualize Simplesat Data in TIBCO Spotfire through ADO.NET
Integrate Simplesat data into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Connect AI Python SDK for Redis
Install the CData Connect AI Python SDK to read and write live Redis data with standard DB-API 2.0 Python code.
-
Build Pipelines with Live Bullhorn CRM Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Bullhorn CRM from Google Cloud Data Fusion, enabling the integration of live Bullhorn CRM data into the building and management of effective data pipelines.
-
Rapidly Develop Tanda-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 Tanda.
-
Integrate Hubstaff with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Hubstaff with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Hubstaff data.
-
Query SAP Fieldglass Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP Fieldglass data.
-
Build Sage Intacct-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Sage Intacct Data from Zoho Analytics and import live Sage Intacct data.
-
Build Voice Agents in ElevenLabs with access to Live Microsoft Entra ID Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft Entra ID data.
-
Automate Reply.io Data Replication to Azure Synapse
Use CData Sync to customize and automate Reply.io data replication to Azure Synapse.
-
Automate eBay Data Replication to SAP HANA
Use CData Sync to customize and automate eBay data replication to SAP HANA.
-
Connect to Airtable from Asprova with CData Software ODBC Driver for Airtable
This article shows how to connect faster to Airtable data from Asprova.
-
Create Informatica Mappings From/To an ODBC Data Source for Tanda
Create an ODBC connection to Tanda in Informatica and browse and transfer Tanda data.
-
Build AI/ML Models with Live Google Translate Data using Dataiku
Connect Google Translate Data with Dataiku using the CData API Driver for JDBC.
-
How to integrate Bitbucket with Apache Airflow
Access and process Bitbucket data in Apache Airflow using the CData JDBC Driver.
-
Connect Presto to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Presto data using the CData Python MCP Server.
-
Build Automated Workflows with Live SAS xpt Data in Workato
Use CData Connect AI to connect to live SAS xpt data and build automated workflows in Workato.
-
How to Visualize Perplexity Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Perplexity data in Python.
-
Publish Crystal Reports on eBay Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date eBay data.
-
Connect to SharePoint Excel Services Data in Aqua Data Studio
Access SharePoint Excel Services data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Aweber Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Aweber data replication to OneLake in Microsoft Fabric.
-
Use the CData Software ODBC Driver for PDFMonkey in SAS for Real-Time Reporting and Analytics
Connect to real-time PDFMonkey data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for PDFMonkey.
-
Connect Greenhouse Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Greenhouse data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Google's Vertex AI Agent with Live Azure Analysis Services 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 Azure Analysis Services data within intelligent workflows.
-
Analyze Amazon DynamoDB Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Amazon DynamoDB data and visualize Amazon DynamoDB data in SAP Analytics Cloud.