CData Software - Knowledge Base
Recent Articles
-
Access Live Azure Data Catalog Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure Data Catalog data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Landbot
Provide connectivity to Landbot data through an SAP BusinessObjects universe.
-
Access Live PolarTeamPro Data in AWS Lambda
Connect to live PolarTeamPro data in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Vimeo Replication to Vertica
Use CData Sync for automated, continuous, customizable Vimeo replication to Vertica.
-
Integrate Supabase Data into Power Automate Desktop using CData Connect
CData Connect for Supabase Data enables you to integrate Supabase data into workflows built using Microsoft Power Automate Desktop.
-
How to Visualize Bugsnag Data in Python with pandas
Use pandas and other modules to analyze and visualize live Bugsnag data in Python.
-
Connect to AfterShip Data in Ruby
Connect to AfterShip data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData JDBC Driver for Oracle Eloqua
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Oracle Eloqua.
-
Automated Continuous Microsoft Ads Replication to Oracle
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Oracle.
-
Establish a Live Connection with Helpscout Data using Tableau Bridge
The CData ODBC Driver for Helpscout enables you to integrate live Helpscout data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Wrike Data in Aqua Data Studio
Access Wrike data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Working with Spark Data in LINQPad
Execute LINQ queries to Spark data in LINQPad.
-
Connect to and Visualize Live Twilio Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Twilio data.
-
Build a PostgreSQL Interface for Teradata Data using the CData JDBC Driver
Use the Remoting features of the Teradata JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Theia IDE with Live Box 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 Box data from within the development environment.
-
Connect to SFTP Data in DBeaver
Use the CData ODBC Driver to connect to SFTP data in DBeaver.
-
Integrate Live SAS xpt Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAS xpt data to Blue Prism using the CData ODBC Driver for SAS xpt to create automated workflows for repetitive business tasks.
-
Use Grok to Talk to Your Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Jira Assets data for you.
-
Outreach.io Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Outreach.io facts in real time.
-
Connect to Tavily Data in RazorSQL
Connect to Tavily from wizards and query Tavily data from the GUI in the RazorSQL database management tool.
-
Model Oracle Financials Cloud Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Oracle Financials Cloud, enabling the direct import of real-time Oracle Financials Cloud data.
-
Analyze VWO Data in Cognos Analytics
Use CData Connect AI to connect to VWO Data from Cognos Analytics and analyze live VWO data.
-
Connecting GenSpark with Twitter Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Twitter Ads data without any replication or custom integration required.
-
Connect to Shippo Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Shippo as an External Source in Dremio.
-
Build Sage Intacct-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Sage Intacct data and build Sage Intacct-connected web apps with Axios.
-
Connect to Egnyte Data in Ruby
Connect to Egnyte data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating LlamaIndex with Guru Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Guru data in real time.
-
How to connect PolyBase to Gong
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Gong data.
-
Create Elasticsearch-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Elasticsearch Data from Klipfolio and build custom visualizations using live Elasticsearch data.
-
Build Data Flows from Gong to SQL Server using SSIS
Easily back up Gong data to SQL Server using the SSIS components for Gong.
-
Automated Continuous SparkPost Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SparkPost replication to IBM DB2.
-
Automate Stack Exchange Data Replication to Azure Data Lake
Use CData Sync to customize and automate Stack Exchange data replication to Azure Data Lake.
-
Enable the Parquet JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Parquet data.
-
Access ClickUp Data from MySQL in Amazon QuickSight
Connect to ClickUp and build visualizations of ClickUp data using a MySQL Connection in Amazon QuickSight.
-
Access Act CRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Act CRM data from your Oracle system.
-
Query SendPulse Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SendPulse data from Node.js.
-
Automated Continuous Twitter Ads Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Twitter Ads replication to IBM DB2.
-
How to Access Live Intercom Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Intercom enables you to integrate Intercom data into workflows built using Microsoft Power Automate Desktop.
-
Gmail Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Gmail facts in real time.
-
How to Connect to Live Google Sheets 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 Google Sheets data for you.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Autopilot
Provide connectivity to Autopilot data through an SAP BusinessObjects universe.
-
Create Power BI Reports on Real-Time Planio Data
Use the CData ODBC Driver for Planio to visualize Planio data in Power BI Desktop.
-
Integrating LlamaIndex with Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Excel Online data in real time.
-
Operational Reporting on Coda Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Coda data.
-
Access Live EnterpriseDB Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate EnterpriseDB data into the statistical analysis tools available in SAS JMP. This article shows how to use EnterpriseDB data in the Graph Builder and Query Builder.
-
Replicate Reckon Data to Multiple Databases via the CData Sync CLI
Replicate Reckon data to disparate databases with a single configuration.
-
Microsoft Planner Reporting in OBIEE with the Microsoft Planner JDBC Driver
Deploy the Microsoft Planner JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Oracle Financials Cloud Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Oracle Financials Cloud data.
-
Use the CData Software ODBC Driver for CapsuleCRM in SAS for Real-Time Reporting and Analytics
Connect to real-time CapsuleCRM data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for CapsuleCRM.
-
Integrate Dify with Live SharePoint Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live SharePoint data.
-
Access Jumpseller Data from MySQL in Amazon QuickSight
Connect to Jumpseller and build visualizations of Jumpseller data using a MySQL Connection in Amazon QuickSight.
-
DataBind Opsgenie Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Opsgenie data to a chart.
-
Getting Started with the CData SSIS Components for MySQL
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MySQL.
-
Back Up Hive data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Hive. In this article, we will employ an SSIS workflow to populate a database with Hive data data.
-
How to connect PolyBase to Phoenix
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Phoenix data.
-
How to import Strava Data into Apache Solr
Use the CData Software JDBC Driver for Strava in Data Import Handler and create an automated import of Strava data to Apache Solr Enterprise Search platform.
-
Bind Live PostgreSQL Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live PostgreSQL data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to update Access from Excel
This article explains how to transfer data from Excel to Access using the Excel Add-In for Access.
-
Object-Relational Mapping (ORM) with Discourse Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Discourse data into a Java-based ORM framework, Hibernate.
-
Integrating Kiro with QuickBooks Time 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.
-
Explore Geographical Relationships in Twilio Data with Power Map
Create data visualizations with Twilio data in Power Map.
-
Integrate Goose with Live Mailjet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Mailjet data from within the local AI agent.
-
Import and Visualize Reckon Data in Power View
Create data visualizations based on Reckon data in Excel.
-
Integrate Adobe Experience Manager Data into Power Automate Desktop using CData Connect
CData Connect for Adobe Experience Manager Data enables you to integrate Adobe Experience Manager data into workflows built using Microsoft Power Automate Desktop.
-
Create Google Ad Manager-Connected Dashboards in Grafana
Connect to Google Ad Manager Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Ad Manager data.
-
Getting Started with the CData Python Connector for ActiveCampaign
Learn to install and license the CData Python Connector and configure a connection to live ActiveCampaign data.
-
Automated Continuous SageHR Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SageHR replication to Google BigQuery.
-
Connect to Live HBase Data in PostGresSQL Interface through CData Connect AI
Create a live connection to HBase in CData Connect AI and connect to your HBase data from PostgreSQL.
-
How to connect Amazon QuickSight to Active Directory Data
Create a connection to Active Directory data in CData Connect AI and insert Active Directory data into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Mode-Connected Business Apps in AppSheet
Connect to Mode Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Mode data.
-
Build Automated Workflows with Live SAP SuccessFactors Data in Workato
Use CData Connect AI to connect to live SAP SuccessFactors data and build automated workflows in Workato.
-
Connecting Agentforce with Toggl 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 Toggl data for you.
-
Build Visualizations of Demio Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Demio data in Birst.
-
Connecting Moonlit Workflow with Presto Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Presto data in real time.
-
Use Dash to Build to Web Apps on Accelo Data
Create Python applications that use pandas and Dash to build Accelo-connected web apps.
-
Automate AgileCRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate AgileCRM data replication to Azure Data Lake.
-
Build Semantic Layer Views for Square Data in APOS Live Data Gateway
Use the CData Connector for Square in APOS Live Data Gateway to build Semantic Layer Views for Square data.
-
Migrating data from Egnyte to Snowflake using CData SSIS Components.
Easily push Egnyte data to Snowflake using the CData SSIS Tasks for Egnyte and Snowflake.
-
Replicate Multiple Paymo Accounts via the CData Sync CLI
Replicate multiple Paymo accounts to one or many databases.
-
How to connect and process SingleStore data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SingleStore data.
-
How to Access Accelo Data Using Entity Framework
This article shows how to access Accelo data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData ODBC Driver for Square in Microsoft Power Query
You can use the CData Square ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Square data into Microsoft Power Query.
-
Migrating data from Box to Google BigQuery using CData SSIS Components.
Easily push Box data to Google BigQuery using the CData SSIS Tasks for Box and Google BigQuery.
-
Analyze Zoho Projects Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Zoho Projects data and visualize Zoho Projects data in SAP Analytics Cloud.
-
Back Up Helpscout 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 Helpscout data data.
-
Choosing the Best Method to Connect CSV to SQL Server: 5 Options Explained
Discover multiple ways to connect and use CSV data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Real-Time Salesforce Data 360 Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Salesforce Data 360 and Dataflow to import and use Salesforce Data 360 data in Power Apps.
-
Deploy the ADO.NET Provider for QuickBooks Time on an SSRS Report Server
Connect to QuickBooks Time 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.
-
Build Reckon-Connected Apps in Choreo
Use CData Connect AI to connect to Reckon Data from Choreo and build custom apps using live Reckon data.
-
Query Live Yelp Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Yelp data through a conversational interface.
-
Build Semantic Layer Views for Salesforce Data in APOS Live Data Gateway
Use the CData Connector for Salesforce in APOS Live Data Gateway to build Semantic Layer Views for Salesforce data.
-
How to integrate Dotmailer with Apache Airflow
Access and process Dotmailer data in Apache Airflow using the CData JDBC Driver.
-
Connect to Figshare Data in JRuby
Create a simple JRuby app with access to live Figshare data.
-
Analyze GetResponse Data in Looker
Use CData Connect AI to connect to GetResponse Data from Looker and build custom apps using live GetResponse data.
-
Automated Continuous AgileCRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable AgileCRM replication to Apache Kafka.
-
Build Sage 300-Connected Apps in Choreo
Use CData Connect AI to connect to Sage 300 Data from Choreo and build custom apps using live Sage 300 data.
-
Integrate Epicor Kinetic with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Epicor Kinetic with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Epicor Kinetic data.
-
Access Bitly Data from MySQL in Amazon QuickSight
Connect to Bitly and build visualizations of Bitly data using a MySQL Connection in Amazon QuickSight.
-
Use the CData SSIS Components to Insert New or Update Existing Gmail Records from SQL Server
Easily push SQL Server data to Gmail using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Gmail or update existing records with data from a SQL Server database.
-
Create Wistia-Connected Dashboards in Grafana
Connect to Wistia Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Wistia data.