CData Software - Knowledge Base
Recent Articles
-
Integrating Gumloop with VWO Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on VWO data within automated workflows.
-
Connect to and Visualize Live Excel Online Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Excel Online data.
-
Integrate Drip with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Drip with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Drip data.
-
Automated Continuous SharePoint Replication to Oracle
Use CData Sync for automated, continuous, customizable SharePoint replication to Oracle.
-
How to connect Amazon QuickSight to Azure Table Data
Create a connection to Azure Table data in CData Connect AI and insert Azure Table data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automate Pipedrive Data Replication to SAP HANA
Use CData Sync to customize and automate Pipedrive data replication to SAP HANA.
-
Connect to ChargeOver Data in RapidMiner
Integrate ChargeOver data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to work with Mouseflow Data in Apache Spark using SQL
Access and process Mouseflow Data in Apache Spark using the CData Software JDBC Driver.
-
Create Datasets from QuickBooks Online in Domo Workbench and Build Visualizations of QuickBooks Online Data in Domo
Use the CData Software ODBC Driver for QuickBooks Online to create datasets from QuickBooks Online data in Domo Workbench and then build visualizations in the Domo service.
-
Build a Singer.io Tap for SAS Data Sets With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAS Data Sets data using the CData Python Connector.
-
Create Data Visualizations Based On Xero Data in Mode
Use CData Connect AI to connect to Xero Data from Mode and build visualizations using live Xero data.
-
Edit and Search External Sybase Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Sybase data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Sybase Data objects that you can access from apps and the dashboard.
-
Use Dash to Build to Web Apps on LinkedIn Data
Create Python applications that use pandas and Dash to build LinkedIn-connected web apps.
-
Use the CData Software ODBC Driver for PabblySubscriptions in MicroStrategy Web
Connect to PabblySubscriptions data in MicroStrategy Web using the CData Software ODBC Driver for PabblySubscriptions.
-
Connect to Quaderno Data from a Connection Pool in Jetty
The Quaderno JDBC Driver supports connection pooling: This article shows how to connect faster to Quaderno data from Web apps in Jetty.
-
How to Connect to Superchat Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Superchat data. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData JDBC Driver for Paymo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Paymo.
-
Operational Reporting on OData Services from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote OData services.
-
Integrate Live Blackbaud FE NXT Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Blackbaud FE NXT from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Blackbaud FE NXT data.
-
Query Zoho Creator Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Zoho Creator entities in PHP by modeling them as objects.
-
How to connect SharePoint with Google Campaign Manager 360 Data through external lists
Provide Google Campaign Manager 360 data to SharePoint users as an external list.
-
Getting Started with the CData ODBC Driver for Adobe Target
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Adobe Target.
-
Visualize Live Scrapfly Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Scrapfly data.
-
Build MVC Applications with Connectivity to Acumatica Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Acumatica from an ASP.NET MVC application.
-
How to Connect to Live Hive Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Hive data without replication.
-
Integrating OpenCode with Elasticsearch 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 Reports with Humanity Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Humanity data.
-
Build xBase-Connected Apps in Choreo
Use CData Connect AI to connect to xBase Data from Choreo and build custom apps using live xBase data.
-
Automated Continuous Sugar CRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sugar CRM replication to PostgreSQL.
-
Viewing Quickbase Data in RAD Studio Data Explorer
How to view Quickbase data in RAD Studio Data Explorer using the CData ODBC Driver for Quickbase.
-
Build Apps with Live SAP Fieldglass data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP Fieldglass data into the Adalo platform and build custom mobile and web applications with real-time SAP Fieldglass data.
-
Automate Exact Online Data Replication to Couchbase
Use CData Sync to Customize and automate Exact Online data replication to Couchbase.
-
Use JayDeBeApi to access Box Data in Python
Use standard Python scripting and the development environment of your choice to access live Box data.
-
How to connect and process ElevenLabs data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ElevenLabs data.
-
Getting Started with the CData ADO.NET Provider for Amplitude
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrating OpenCode with Azure Analysis Services 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.
-
Nethunt Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Nethunt facts in real time.
-
How to connect PolyBase to ZarMoney
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ZarMoney data.
-
Automate Templated Data Replication to Azure Synapse
Use CData Sync to customize and automate Templated data replication to Azure Synapse.
-
Analyze Snapchat Ads Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Snapchat Ads from Power Pivot. You will use the Table Import Wizard to load Snapchat Ads data. You can visually build the import query or use any SQL supported by the driver.
-
Build Sybase IQ-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Sybase IQ data and build web apps with connectivity to live Sybase IQ data.
-
Connect to Salesloft Data in Aqua Data Studio
Access Salesloft data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Dynamic Dynamics CRM Grids Using the Infragistics XamDataGrid
Learn how you can connect Dynamics CRM to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Parallel Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Parallel replication to IBM DB2.
-
How to connect to Paylocity Data from Spring Boot
Connect to Paylocity in a Spring Boot Application using the CData JDBC Driver for Paylocity
-
Automated Continuous Google Analytics Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Analytics replication to Amazon Redshift.
-
Build an OLAP Cube in SSAS from PabblySubscriptions Data
Establish a connection to PabblySubscriptions data data from SQL Server Analysis Services, and use the PabblySubscriptions Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Certinia Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Certinia replication to Azure SQL Database.
-
Create OData-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to OData Services from OutSystems and build custom enterprise apps using live OData services.
-
Create Dynamic CapsuleCRM Grids Using the Infragistics XamDataGrid
Learn how you can connect CapsuleCRM to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Teradata Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Teradata data from Filemaker Pro on Mac.
-
How to create an RPA flow for Mailjet Data in UiPath Studio
Use the Mailjet ODBC Driver to create workflows that access real-time Mailjet data without any coding.
-
Automated Continuous Acumatica Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Acumatica replication to AlloyDB.
-
How to Access BenchmarkEmail Data Using Entity Framework
This article shows how to access BenchmarkEmail data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Extract, Transform, and Load Pipeliner CRM Data in Informatica PowerCenter
Create a simple Workflow for Pipeliner CRM data in Informatica PowerCenter.
-
Build Dashboards with LaunchDarkly Data in Dundas BI
Create dynamic dashboards and perform analytics based on LaunchDarkly data in Dundas BI.
-
Connect to Aha! Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Aha!.
-
Access Live ActiveCampaign Data in Coginiti Pro
Connect to and query live ActiveCampaign data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating Kiro with Azure Synapse 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 Easily Query Aha! Data in OpenOffice Base
Connect to Aha! data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Anaplan Data from PowerBuilder via ADO.NET
This article demonstrates how to access Anaplan data from Appeon PowerBuilder using the CData ADO.NET Provider for Anaplan.
-
Integrating Gumloop with HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on HCL Domino data within automated workflows.
-
Connect to Google Translate Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Translate data using standard SQL.
-
Build an OLAP Cube in SSAS from Aircall Data
Establish a connection to Aircall data data from SQL Server Analysis Services, and use the Aircall Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData ODBC Driver for Drip from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Drip to connect to Drip data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Drip data in Excel.
-
How to Connect to & Open GitHub Data in Microsoft Excel
This article uses the CData ODBC driver for GitHub to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous SendPulse Replication to SQLite
Use CData Sync for automated, continuous, customizable SendPulse replication to SQLite.
-
Stream Anaplan Data into Apache Kafka Topics
Access and stream Anaplan data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect Amazon QuickSight to SAP HANA XS Advanced Data
Create a connection to SAP HANA XS Advanced data in CData Connect AI and insert SAP HANA XS Advanced data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Freshdesk Data in RapidMiner
Integrate Freshdesk data with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate Factorial Data to Multiple Databases
Replicate Factorial data to disparate databases with a point-and-click configuration.
-
How to connect to MessageBird Data from IntelliJ
Integrate connectivity to MessageBird data with wizards in IntelliJ.
-
Edit and Search External Outreach.io Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Outreach.io data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Outreach.io Data objects that you can access from apps and the dashboard.
-
Create SSAS Tabular Models from Oracle SCM Data
How to build a SQL Server Analysis Service Tabular Model from Oracle SCM data using CData drivers.
-
Build Charts with Testmonitor Data in Clear Analytics
Create dynamic charts and perform analytics based on Testmonitor data in Clear Analytics.
-
Connecting Agentforce with ZohoMarketingHub 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 ZohoMarketingHub data for you.
-
How to connect and process Klaviyo data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Klaviyo data.
-
How to Connect the Power BI Service to SAP ByDesign: Complete Guide
Connect to the CData Software Power BI Connector for SAP ByDesign from PowerBI.com to provide real-time SAP ByDesign data across the organization.
-
Build Automated SQL Analysis Services-Connected Workflows in Zapier
Use CData Connect AI to connect to live SQL Analysis Services data and build automated workflows in Zapier.
-
Visualize Klaviyo Data in TIBCO Spotfire through OData
Integrate Klaviyo data into dashboards in TIBCO Spotfire.
-
Prepare, Blend, and Analyze Ontraport Data in Alteryx Designer (ODBC)
Build workflows to access live Ontraport data for self-service data analytics.
-
Build Google Ads-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Ads data.
-
Use ChatGPT to Talk to Your HDFS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your HDFS data for you.
-
Use Agno to Talk to Your OData Services 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 OData services for you.
-
Create a Data Access Object for Oracle Eloqua Reporting Data using JDBI
A brief overview of creating a SQL Object API for Oracle Eloqua Reporting data in JDBI.
-
Deploy the ADO.NET Provider for RabbitMQ on an SSRS Report Server
Connect to RabbitMQ 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.
-
Use the CData ODBC Driver for Act-On from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Act-On to connect to Act-On data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Act-On data in Excel.
-
Work with ZendeskSell Data in FoxPro
Load ZendeskSell data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Using the CData Software ODBC Driver for ServiceDesk Plus in PyCharm
Connect to ServiceDesk Plus as an ODBC data source in PyCharm using the CData Software ODBC Driver for ServiceDesk Plus.
-
Build Voice Agents in ElevenLabs with access to Live LinkedIn Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live LinkedIn data.
-
Build Dashboards with SAP Hybris C4C Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP Hybris C4C data in DBxtra.
-
Access Databricks Data from MySQL in Amazon QuickSight
Connect to Databricks and build visualizations of Databricks data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous ClickUp Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ClickUp replication to Apache Kafka.
-
How to integrate Flowlu with Apache Airflow
Access and process Flowlu data in Apache Airflow using the CData JDBC Driver.
-
Access Live HBase Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live HBase data from your Google Sheets.
-
Create Dashboards and Visualize Live SAS xpt Data in Geckoboard
Use CData Connect AI to connect to live SAS xpt data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Analyze Zoho CRM Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Zoho CRM data and visualize live Zoho CRM data in Infragistics Reveal.
-
Use Dash to Build Web Apps on Cosmos DB Data via CData Connect AI
Build interactive Dash web apps on live Cosmos DB data using pandas and the CData Connect AI Python SDK.
-
How to Connect the Power BI Service to Sage 200: Complete Guide
Connect to the CData Software Power BI Connector for Sage 200 from PowerBI.com to provide real-time Sage 200 data across the organization.
-
Back Up CSV data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for CSV. In this article, we will employ an SSIS workflow to populate a database with CSV data data.