CData Software - Knowledge Base
Recent Articles
-
Access Pinecone Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Pinecone from your Oracle system.
-
Visualize Live MYOB AccountRight Data in the Power BI Service
Use CData Connect AI to connect to live MYOB AccountRight and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind CouchDB Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for CouchDB with the DevExpress Windows Forms and Web controls to provide Apache CouchDB to a chart.
-
Automated Continuous MailChimp Replication to AlloyDB
Use CData Sync for automated, continuous, customizable MailChimp replication to AlloyDB.
-
Build an OLAP Cube in SSAS from Sentry Data
Establish a connection to Sentry data from SQL Server Analysis Services, and use the Sentry Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrating Kiro CLI with ActiveCampaign 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 MarkLogic Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MarkLogic from PowerShell? This article demonstrates how to utilize the MarkLogic Cmdlets for tasks like connecting to MarkLogic, automating operations, downloading data, and more.
-
Visualize Asana Data in TIBCO Spotfire through ADO.NET
Integrate Asana into dashboards in TIBCO Spotfire.
-
Create Omnisend Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Omnisend data access from reports, embedded analytics, and more.
-
Integrate Live Chargebee Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Chargebee to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Bridge Cosmos DB Connectivity with Apache NiFi
Access and process Azure Cosmos DB in Apache NiFi using the CData JDBC Driver.
-
Natively Connect to Teradata Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Teradata. Leverage the native support for ODBC in PHP.
-
Automated Typeform Data Replication to Teradata
Use CData Sync to Customize and automate Typeform replication to Teradata.
-
Replicate Multiple Microsoft Dataverse Accounts via the CData Sync CLI
Replicate multiple Microsoft Dataverse accounts to one or many databases.
-
Connecting Mastra with Microsoft Planner Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Microsoft Planner, no replication required.
-
Build Office 365-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Office 365.
-
Create Datasets from Apify in Domo Workbench and Build Visualizations of Apify Data in Domo
Use the CData Software ODBC Driver for Apify to create datasets from Apify in Domo Workbench and then build visualizations in the Domo service.
-
DataBind Controls to Shippo Data in Delphi
DataBind to Shippo in Delphi with standard data access components and controls.
-
Edit and Search Mistral AI External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Mistral AI to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Mistral AI objects that you can access from apps and the dashboard.
-
Create Dynamic Mailjet Grids Using the Infragistics XamDataGrid
Learn how you can connect Mailjet to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Shopify Data in Pentaho Data Integration
Build ETL pipelines based on Shopify in the Pentaho Data Integration tool.
-
Back Up FHIR to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for FHIR. In this article, we will employ an SSIS workflow to populate a database with FHIR data.
-
Connect to API Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for API in Airbyte.
-
Access Live Mailjet Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Mailjet 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 Oracle Sales
Provide connectivity to Oracle Sales through an SAP BusinessObjects universe.
-
Build Apps with Live SAP Netweaver Gateway in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP Netweaver Gateway into the Adalo platform and build custom mobile and web applications with real-time SAP Netweaver Gateway.
-
Connect to Cloudflare Data in DBArtisan
Use wizards in DBArtisan to configure Cloudflare as a data source.
-
Build Pipelines with Live Microsoft Teams Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Teams from Google Cloud Data Fusion, enabling the integration of live Microsoft Teams into the building and management of effective data pipelines.
-
Query Sybase Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sybase from Node.js.
-
Analyze LionDesk Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze LionDesk with the CData JDBC Driver for LionDesk.
-
Use the CData Software JDBC Driver for Pushbullet in MicroStrategy Desktop
Connect to Pushbullet in MicroStrategy Desktop using the CData Software JDBC Driver for Pushbullet.
-
Analyze Redis Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Redis from Power Pivot. You will use the Table Import Wizard to load Redis. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData ODBC Driver for Samanage from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Samanage to connect to Samanage from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Samanage in Excel.
-
Automated Continuous DB2 for i Replication to AlloyDB
Use CData Sync for automated, continuous, customizable DB2 for i replication to AlloyDB.
-
Enable the Adobe Commerce JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Adobe Commerce.
-
DataBind Controls to Pushbullet Data in Delphi
DataBind to Pushbullet in Delphi with standard data access components and controls.
-
Use Dash to Build to Web Apps on SAP SuccessFactors LMS Data
Create Python applications that use pandas and Dash to build SAP SuccessFactors LMS-connected web apps.
-
Integrating GitHub Copilot CLI with Mode 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.
-
DataBind Controls to Apify Data in C++Builder
DataBind to Apify in C++Builder with standard components and controls.
-
Build GitHub Visualizations in Tableau Desktop
Use CData Connect AI to connect to live GitHub and build visualizations in Tableau.
-
Import Real-Time YouTube Analytics Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use YouTube Analytics in ColdFusion.
-
How to connect SharePoint with Billsby Data through external lists
Provide Billsby to SharePoint users as an external list.
-
How to Connect to Live SAP Ariba Source 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 SAP Ariba Source for you.
-
A PostgreSQL Interface for Amplitude Data using the CData ODBC Driver
Use the SQL Gateway and Amplitude ODBC Driver to create a PostgreSQL entry-point for data access.
-
ETL Greenplum in Oracle Data Integrator
This article shows how to transfer Pivotal GreenPlum into a data warehouse using Oracle Data Integrator.
-
Access Oracle 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 Database.
-
Access Live API Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live API from your Excel spreadsheets.
-
Integrate Real-Time Access to Pipeliner CRM in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Pipeliner CRM in real time.
-
Back Up SAP Ariba Procurement to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Ariba Procurement. In this article, we will employ an SSIS workflow to populate a database with SAP Ariba Procurement data.
-
How to Connect Flowise AI Agents to Live Adobe Analytics 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 Adobe Analytics without replication.
-
Getting Started with the CData SSIS Components for Spotify
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Spotify.
-
Explore Geographical Relationships in Aha! Data with Power Map
Create data visualizations with Aha! in Power Map.
-
Build Data Flows from Helpscout to SQL Server using SSIS
Easily back up Helpscout to SQL Server using the SSIS components for Helpscout.
-
Working with Procore Data in LINQPad
Execute LINQ queries to Procore in LINQPad.
-
Build PayPal-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PayPal.
-
Analyze IBM Informix Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze IBM Informix with the CData JDBC Driver for IBM Informix.
-
Build Visualizations of Neo4J Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Neo4J in Birst.
-
How to create Visio diagrams from SAS Data Sets Data
Automatically update SAS Data Sets with the changes you make to Visio master shapes.
-
Working with Amazon DynamoDB Data in LINQPad
Execute LINQ queries to Amazon DynamoDB in LINQPad.
-
Build an OLAP Cube in SSAS from Elorus Data
Establish a connection to Elorus data from SQL Server Analysis Services, and use the Elorus Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrating Gumloop with Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Ads within automated workflows.
-
Create Reports from Avalara AvaTax Data in Looker Studio
Use CData Connect AI to gain access to live Avalara AvaTax and create custom reports in Looker Studio.
-
Visualize Live Procore Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Procore using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access ZohoExpense Data from MySQL in Amazon QuickSight
Connect to ZohoExpense and build visualizations of ZohoExpense using a MySQL Connection in Amazon QuickSight.
-
Replicate Multiple Perplexity Accounts
Replicate multiple Perplexity accounts to one or many databases.
-
Connect to Optimizely Data in HULFT Integrate
Connect to Optimizely as a JDBC data source in HULFT Integrate
-
Access Live Google Sheets Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Sheets from your Excel spreadsheets.
-
How to Connect to Live Salesforce Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Salesforce & Force.com for you.
-
Choosing the Best Method to Connect Trello to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Trello from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Import Act-On Data Using Azure Data Factory
Use CData Connect AI to connect to Act-On Data from Azure Data Factory and import live Act-On.
-
Connect to Freshteam Data in Ruby
Connect to Freshteam in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate with Live PayPal Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to PayPal from the MuleSoft Anypoint Platform to integrate live PayPal into custom reports and dashboards.
-
Connecting Mastra with Zoho Creator Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Zoho Creator, no replication required.
-
Connect Superchat to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Superchat using the CData Python MCP Server.
-
Replicate Quaderno Data to Multiple Databases
Replicate Quaderno to disparate databases with a point-and-click configuration.
-
Analyze CSV Data in Looker
Use CData Connect AI to connect to CSV Data from Looker and build custom apps using live CSV/TSV Files.
-
Import and Visualize Parquet Data in Power View
Create data visualizations based on Apache Parquet in Excel.
-
Prepare, Blend, and Analyze Google Cloud Storage Data in Alteryx Designer (ODBC)
Build workflows to access live Google Cloud Storage for self-service data analytics.
-
Automate GetResponse Data Replication to Azure Synapse
Use CData Sync to customize and automate GetResponse replication to Azure Synapse.
-
Connect to ClickTime Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ClickTime and the SQL Gateway to access ClickTime from Google Apps Script.
-
Use Agno to Talk to Your Freshdesk 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 Freshdesk for you.
-
Import Zoho Inventory Data Using Azure Data Factory
Use CData Connect AI to connect to Zoho Inventory Data from Azure Data Factory and import live Zoho Inventory.
-
Build AI Agents with Google Ads Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Google Ads through CData Connect AI.
-
Connect to SAP Netweaver Gateway Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Netweaver Gateway.
-
How to Access Zoho Projects Data Using Entity Framework
This article shows how to access Zoho Projects using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Apps with Live Apache Impala in Adalo using CData Connect AI
Use CData Connect AI to integrate live Apache Impala into the Adalo platform and build custom mobile and web applications with real-time Apache Impala.
-
Configure the CData JDBC Driver for PivotalTracker in a Connection Pool in Tomcat
Connect to PivotalTracker from a connection pool in Tomcat.
-
Integrating LangGraph with Zoho Inventory Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Zoho Inventory within automated workflows.
-
Use the CData Software ODBC Driver for Auth0 in MicroStrategy Web
Connect to Auth0 in MicroStrategy Web using the CData Software ODBC Driver for Auth0.
-
Connect Grafana to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Grafana using the CData Python MCP Server.
-
Access Salesloft Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Salesloft from HeidiSQL.
-
Easily Integrate Freshdesk Data in Lazarus Pascal IDE
Learn how to easily integrate live Freshdesk in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Highrise Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Highrise replication to Amazon Redshift.
-
How to Access Live ScrapingBee Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live ScrapingBee from the Cline extension in Visual Studio Code.
-
Process & Analyze Basecamp Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Basecamp Data.
-
Automated Continuous MarkLogic Replication to SingleStore
Use CData Sync for automated, continuous, customizable MarkLogic replication to SingleStore.
-
Using the CData Software ODBC Driver for Placid in PyCharm
Connect to Placid as an ODBC data source in PyCharm using the CData Software ODBC Driver for Placid.
-
Automated Continuous Autopilot Replication to SingleStore
Use CData Sync for automated, continuous, customizable Autopilot replication to SingleStore.
-
SAP Concur Reporting in OBIEE with the SAP Concur JDBC Driver
Deploy the SAP Concur JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Perform API Operations Using the CData SharePoint Task
The CData SharePoint Task allows you to easily call stored procedures to perform SharePoint API operations.