CData Software - Knowledge Base
Recent Articles
-
Integrate Google Campaign Manager 360 Data in Pentaho Data Integration
Build ETL pipelines based on Google Campaign Manager 360 data in the Pentaho Data Integration tool.
-
Import BenchmarkEmail Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to BenchmarkEmail Data and provide access to live BenchmarkEmail data for custom reports in the Power BI Service.
-
How to connect PolyBase to Foursquare
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Foursquare data.
-
Getting Started with the CData Power BI Connector for Dynamics 365
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Dynamics 365.
-
Use CData Connect AI to Access SAP Hybris C4C Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Hybris C4C data in the Power Pivot business intelligence tool.
-
Build Data Flows from SQL Server to Shopify through SSIS
Easily push SQL Server data to Shopify using the CData SSIS Tasks for Shopify.
-
Trigger Azure Table IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Azure Table with standard wizards in Logic Apps.
-
Connect to Deel Data from PowerBuilder via ADO.NET
This article demonstrates how to access Deel data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create ZohoMarketingHub-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to ZohoMarketingHub Data from OutSystems and build custom enterprise apps using live ZohoMarketingHub data.
-
Publish Certinia-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Certinia data.
-
Automated Continuous Power BI XMLA Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Azure SQL Database.
-
How to Build an ETL App for Oracle Sales Data in Python with CData
Create ETL applications and real-time data pipelines for Oracle Sales data in Python with petl.
-
Publish Crystal Reports on Act CRM Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Act CRM data.
-
Build Dashboards with Certinia Data in Dundas BI
Create dynamic dashboards and perform analytics based on Certinia data in Dundas BI.
-
Build Charts with iContact Data in Clear Analytics
Create dynamic charts and perform analytics based on iContact data in Clear Analytics.
-
Import Real-Time MailChimp Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use MailChimp data in ColdFusion.
-
Automated Continuous Coinbase Replication to Vertica
Use CData Sync for automated, continuous, customizable Coinbase replication to Vertica.
-
Integrating OpenCode with Planio 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 an SAP BusinessObjects Universe on the CData ODBC Driver for Bright Data
Provide connectivity to Bright Data data through an SAP BusinessObjects universe.
-
Connect to Teradata from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Teradata data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Operational Reporting on Aircall Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Aircall data.
-
How to Seamlessly Import Insightly Data into IBM SPSS Modeler
Integrate Insightly data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Oracle SCM Data in CloverDX (formerly CloverETL)
Transfer Oracle SCM data using the visual workflow in the CloverDX data integration tool.
-
IBM Cloud Object Storage Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on IBM Cloud Object Storage facts in real time.
-
Model, Search, and Visualize Live XML Data in ThoughtSpot
Use CData Connect AI to connect to live XML data for modeling, searching, and visualizing.
-
Back Up Pushbullet 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 Pushbullet data data.
-
How to Use a Microsoft Access Database to Update QuickBooks Data in Real Time
Update QuickBooks data by creating a linked table in Microsoft Access with the CData QuickBooks ODBC Driver.
-
Import and Visualize Planio Data in Power View
Create data visualizations based on Planio data in Excel.
-
Use Databricks Agent Bricks to Talk to Your Adobe Target Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Adobe Target data for you.
-
Use Azure AI Foundry to Talk to Your Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Cloudant data for you.
-
Automated Continuous Azure Data Catalog Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Azure Data Catalog data replication to OneLake in Microsoft Fabric.
-
How to Connect to Live Redshift 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 Redshift data for you.
-
Connect to Teamwork Data from a Connection Pool in JBoss
Integrate Teamwork data into Java servlets: Use the Management Console in JBoss to install the Teamwork JDBC Driver.
-
Connect to Confluence Data in Ruby
Connect to Confluence data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to import Dynamics 365 Business Central Data into Apache Solr
Use the CData Software JDBC Driver for Dynamics 365 Business Central in Data Import Handler and create an automated import of Dynamics 365 Business Central data to Apache Solr Enterprise Search platform.
-
How to Visualize SAP Ariba Procurement 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 SAP Ariba Procurement data in Python.
-
Integrate with live Suadeo Data in Jitterbit
Use CData Connect AI to connect to and integrate live Suadeo data in Jitterbit.
-
Create Reports from Greenplum Data in Looker Studio
Use CData Connect AI to gain access to live Greenplum data and create custom reports in Looker Studio.
-
Connecting Pipedream with Google Cloud Storage Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Google Cloud Storage data in real time.
-
Build a Simple VCL Application for GitLab Data
How to build a simple VCL Application to view GitLab data in RAD Studio using the CData ODBC Driver for GitLab.
-
Use Agno to Talk to Your Impala 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 Impala data for you.
-
Create Insightly Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Insightly from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Google's Antigravity Agent with Live Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Certinia data using the Model Context Protocol.
-
How to Connect Cloudant 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 Cloudant data in real time using natural language.
-
How to Connect to Live Klaviyo 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 Klaviyo data for you.
-
Model, Search, and Visualize Live Raisers Edge NXT Data in ThoughtSpot
Use CData Connect AI to connect to live Raisers Edge NXT data for modeling, searching, and visualizing.
-
How to publish and share SAS Data Sets Data dashboards with Tableau Server
The CData ODBC driver for SAS Data Sets enables you integrate SAS Data Sets data into Tableau dashboards.
-
Connect to Zoho Inventory from Asprova with CData Software ODBC Driver for Zoho Inventory
This article shows how to connect faster to Zoho Inventory data from Asprova.
-
Connect to Real-Time Aircall Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Aircall data in Power Apps.
-
Access Live Supabase Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Supabase data into the statistical analysis tools available in SAS JMP. This article shows how to use Supabase data in the Graph Builder and Query Builder.
-
How to connect to Avaza Data in DBVisualizer
Integrate Avaza data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Parallel Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Parallel replication to Amazon S3.
-
Create Dynamic Pipedrive Grids Using the Infragistics XamDataGrid
Learn how you can connect Pipedrive to Infragistics XamDataGrid to build dynamic grids.
-
Build Semantic Layer Views for Codat Data in APOS Live Data Gateway
Use the CData Connector for Codat in APOS Live Data Gateway to build Semantic Layer Views for Codat data.
-
Integrate with SurveyMonkey Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SurveyMonkey data in SnapLogic.
-
Automated Continuous Avro Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Avro replication to IBM DB2.
-
Publish Crystal Reports on Smartsheet Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Smartsheet data.
-
Automated Impala Data Replication to Teradata
Use CData Sync to Customize and automate Impala data replication to Teradata.
-
Automate HCL Domino Data Replication to SAP HANA
Use CData Sync to customize and automate HCL Domino data replication to SAP HANA.
-
Use the CData ODBC Driver for SpaceX from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SpaceX to connect to SpaceX data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SpaceX data in Excel.
-
Connect to Pingdom Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Pingdom as an External Source in Dremio.
-
How to integrate Strava with Apache Airflow
Access and process Strava data in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData Power BI Connector for XML
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for XML.
-
Connect to Cohere Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Cohere data.
-
Migrating data from PolarTeamPro to Databricks using CData SSIS Components.
Easily push PolarTeamPro data to Databricks using the CData SSIS Tasks for PolarTeamPro and Databricks.
-
Integrating Boomi Agentstudio with SFTP Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SFTP data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Couchbase Data from PowerBuilder via JDBC
This article demonstrates how to access Couchbase data from PowerBuilder using the Couchbase JDBC Driver.
-
Interact with Live Bullhorn CRM Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Bullhorn CRM data.
-
Integrate Theia IDE with Live Azure Data Lake Storage 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 Azure Data Lake Storage data from within the development environment.
-
Create ZohoExpense-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ZohoExpense Data from Klipfolio and build custom visualizations using live ZohoExpense data.
-
How to Work with Cvent Data in ETL Validator JDBC
Connect to Cvent from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to SAP Business One Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP Business One as an External Source in Dremio.
-
Connect to MailChimp Data in NetBeans
Connect to MailChimp data in NetBeans with the data source configuration wizard.
-
How to integrate Ontraport with Apache Airflow
Access and process Ontraport data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Asana Replication to Oracle
Use CData Sync for automated, continuous, customizable Asana replication to Oracle.
-
Enable the Dynamics NAV JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Dynamics NAV data.
-
Automated Continuous Dynamics 365 Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to PostgreSQL.
-
How to Seamlessly Import OpenWeatherMap Data into IBM SPSS Modeler
Integrate OpenWeatherMap data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous EnterpriseDB Replication to AlloyDB
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to AlloyDB.
-
Manage ZohoExpense Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ZohoExpense.
-
Use Azure AI Foundry to Talk to Your Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Airtable data for you.
-
Create Informatica Mappings From/To a JDBC Data Source for Klaviyo
Create Klaviyo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Explore Geographical Relationships in Freshservice Data with Power Map
Create data visualizations with Freshservice data in Power Map.
-
How to Access LinkedIn Data Using Entity Framework
This article shows how to access LinkedIn data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Mouseflow Data in the Pentaho Report Designer
Publish reports based on Mouseflow data in the Pentaho BI tool.
-
Replicate Blackbaud FE NXT Data to Multiple Databases via the CData Sync CLI
Replicate Blackbaud FE NXT data to disparate databases with a single configuration.
-
Integrate Cline with Live Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Phoenix data from within your IDE.
-
Create Reports with ConvertKit Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ConvertKit data.
-
Link Coda with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Coda data in Filemaker Pro for Mac or Windows.
-
Build Visualizations of Office 365 Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Office 365 data in Birst.
-
How to Connect Flowise AI Agents to Live SAP Netweaver Gateway 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 SAP Netweaver Gateway data without replication.
-
How to Connect DBeaver to Tally via a JDBC Driver
Manage Tally data with visual tools in DBeaver like the query browser.
-
How to connect PolyBase to LaunchDarkly
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live LaunchDarkly data.
-
Getting Started with the CData Tableau Connector for PhantomBuster
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
A PostgreSQL Interface for Slack Data using the CData ODBC Driver
Use the SQL Gateway and Slack ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Seamlessly Import Microsoft Exchange Data into IBM SPSS Modeler
Integrate Microsoft Exchange data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Deploy the ADO.NET Provider for Unbounce on an SSRS Report Server
Connect to Unbounce 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.
-
Connecting Mastra with Guru 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 Guru data, no replication required.
-
Prepare, Blend, and Analyze ServiceNow Data in Alteryx Designer (ODBC)
Build workflows to access live ServiceNow data for self-service data analytics.
-
Getting Started with the CData Excel Add-In for Workday
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Workday.