CData Software - Knowledge Base
Recent Articles
-
Create Reports with iContact Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date iContact.
-
Create Dynamic HDFS Grids Using the Infragistics XamDataGrid
Learn how you can connect HDFS to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Highrise Replication to Vertica
Use CData Sync for automated, continuous, customizable Highrise replication to Vertica.
-
How to Connect to Live Greenhouse 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 Greenhouse through natural language.
-
Connect Avalara AvaTax to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Avalara AvaTax using the CData Python MCP Server.
-
Automated Continuous Rebilly Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Rebilly replication to Apache Cassandra.
-
Use the CData Software JDBC Driver for ConvertAPI in MicroStrategy Web
Connect to ConvertAPI in MicroStrategy Web using the CData Software JDBC Driver for ConvertAPI.
-
Connecting Mastra with Act CRM 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 Act CRM, no replication required.
-
Visualize Oracle SCM Data in Sisense
Create an ElastiCube in Sisense app with access to Oracle SCM.
-
How to Build an ETL App for SAP HANA Data in Python with CData Connect AI
Build ETL pipelines that read and write live SAP HANA in Python with petl and the CData Connect AI Python SDK.
-
Analyze ServiceNow Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of ServiceNow and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Use Biml to Build SSIS Tasks to Replicate Copper Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Copper to SQL Server.
-
Build eBay Analytics-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for eBay Analytics to explore live eBay Analytics Data in GitHub Copilot to assist with building eBay Analytics-powered applications.
-
How to Design Outreach.io Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Outreach.io from mobile and tablet Power Apps.
-
Build Data Flows from SAP SuccessFactors to SQL Server using SSIS
Easily back up SAP SuccessFactors to SQL Server using the SSIS components for SAP SuccessFactors.
-
Getting Started with the CData Connect AI Python SDK for Vertica
Install the CData Connect AI Python SDK to read and write live Vertica with standard DB-API 2.0 Python code.
-
How to connect to xBase Data from Spring Boot
Connect to xBase in a Spring Boot Application using the CData JDBC Driver for xBase
-
Automate Tally Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Tally ERP and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Explore Geographical Relationships in FreeAgent Data with Power Map
Create data visualizations with FreeAgent in Power Map.
-
Access Nethunt Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Nethunt from HeidiSQL.
-
Enable the SurveyMonkey JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SurveyMonkey.
-
Access Live HCL Domino Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live HCL Domino from your Excel spreadsheets.
-
Trigger SAS Data Sets IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SAS Data Sets with standard wizards in Logic Apps.
-
Getting Started with the CData JDBC Driver for Salesforce Marketing
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Salesforce Marketing.
-
Getting Started with the CData JDBC Driver for Excel
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Excel.
-
How to create Google Tasks federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Tasks in MySQL .
-
How to create Bright Data federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Bright Data in MySQL .
-
Build Salesforce CRM Analytics-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Salesforce CRM Analytics to explore live Salesforce CRM Analytics Data in Claude Code to assist with building Salesforce CRM Analytics-powered applications.
-
Connect to Live Blackbaud FE NXT Data in MicroStrategy through CData Connect AI
Create a live connection to Blackbaud FE NXT Data in CData Connect AI and connect to your Blackbaud FE NXT from MicroStrategy.
-
Integrating Gumloop with Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Adobe Analytics within automated workflows.
-
Access Live Microsoft OneDrive Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Microsoft OneDrive through MCP integration.
-
Use the CData Software ODBC Driver for Oracle Service Cloud in SAS for Real-Time Reporting and Analytics
Connect to real-time Oracle Service Cloud in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Oracle Service Cloud.
-
Connect to Slack Data in NetBeans
Connect to Slack in NetBeans with the data source configuration wizard.
-
Feed Google Ads Data into FineReport
How to set Google Ads as a JDBC data source in FineReport.
-
Automated Continuous ZohoSubscriptions Replication to Oracle
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Oracle.
-
A PostgreSQL Interface for Ontraport Data using the CData ODBC Driver
Use the SQL Gateway and Ontraport ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize SAP Netweaver Gateway Data in Tableau
The CData ODBC driver for SAP Netweaver Gateway enables you integrate SAP Netweaver Gateway into Tableau dashboards.
-
Automate AlloyDB Data Replication to SAP HANA
Use CData Sync to customize and automate Google AlloyDB replication to SAP HANA.
-
Integrate DocuSign Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live DocuSign from Informatica Cloud.
-
Automated Continuous Reckon Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Reckon replication to Google Cloud SQL.
-
Automated Continuous Kintone Replication to SQLite
Use CData Sync for automated, continuous, customizable Kintone replication to SQLite.
-
Configure the CData JDBC Driver for Grafana in a Connection Pool in Tomcat
Connect to Grafana from a connection pool in Tomcat.
-
Use Dash to Build Web Apps on WordPress Data via CData Connect AI
Build interactive Dash web apps on live WordPress using pandas and the CData Connect AI Python SDK.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ScrapingBee
Provide connectivity to ScrapingBee through an SAP BusinessObjects universe.
-
Process & Analyze GitHub Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live GitHub Data.
-
Connect to Cosmos DB Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Cosmos DB Data and connect to Azure Cosmos DB in Akorbi Digital RunMyProcess.
-
Build Semantic Layer Views for Elasticsearch Data in APOS Live Data Gateway
Use the CData Connector for Elasticsearch in APOS Live Data Gateway to build Semantic Layer Views for Elasticsearch.
-
Access Klipfolio 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 Klipfolio.
-
Connect to Workday Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Workday.
-
How to Seamlessly Import Power BI XMLA Data into IBM SPSS Modeler
Integrate Power BI XMLA data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Okta from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Okta, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Live Databricks Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to SAP ByDesign Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP ByDesign and the Script function in FileMaker Pro to connect to SAP ByDesign and work with SAP Business ByDesign in your FileMaker application.
-
How to create an RPA flow for Testmonitor Data in UiPath Studio
Use the Testmonitor ODBC Driver to create workflows that access real-time Testmonitor without any coding.
-
How to connect to Google Analytics Data in DBVisualizer
Integrate Google Analytics with visual data analysis tools and data connection wizards in DBVisualizer
-
Migrating data from VWO to Snowflake using CData SSIS Components.
Easily push VWO to Snowflake using the CData SSIS Tasks for VWO and Snowflake.
-
Create Kintone-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Kintone Data from OutSystems and build custom enterprise apps using live Kintone.
-
Automated Continuous Microsoft Ads Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Google Cloud SQL.
-
Bind Live Oracle Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Oracle data
-
Create Dashboards and Visualize Live WooCommerce Data in Geckoboard
Use CData Connect AI to connect to live WooCommerce and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connecting Mastra with WordPress 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 WordPress, no replication required.
-
Build AlloyDB-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google AlloyDB and build web apps with connectivity to live Google AlloyDB.
-
Access Live HubSpot Data in TIBCO Data Virtualization
Use the HubSpot Tibco DV Adapter to create a HubSpot data source in TIBCO Data Virtualization Studio and gain access to live HubSpot from your TDV Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Act-On
Provide connectivity to Act-On through an SAP BusinessObjects universe.
-
Create SSAS Tabular Models from Google Sheets Data
How to build a SQL Server Analysis Service Tabular Model from Google Sheets using CData drivers.
-
Building Dynamic Web Pages with Azure Synapse Data Using AngularJS
Create single-page applications with live connectivity to Azure Synapse using the CData API Server.
-
Query MailChimp Data in ColdFusion
Write standard ColdFusion data access code to connect to MailChimp.
-
How to connect SharePoint with Amazon Marketplace Data through external lists
Provide Amazon Marketplace to SharePoint users as an external list.
-
Connect Klipfolio to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Klipfolio with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Redis Data in RapidMiner
Integrate Redis with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous SpaceX Replication to Databricks
Use CData Sync for automated, continuous, customizable SpaceX replication to Databricks.
-
Build Dashboards with Wrike Data in Dundas BI
Create dynamic dashboards and perform analytics based on Wrike in Dundas BI.
-
How to Import Data from Jira Assets into Google Sheets
Import Jira Assets into a Google spreadsheet that is automatically refreshed.
-
Access Live SAP Fieldglass Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SAP Fieldglass through MCP integration.
-
How to Work with PingOne Data in ETL Validator JDBC
Connect to PingOne from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Data Flows from Deel to SQL Server using SSIS
Easily back up Deel to SQL Server using the SSIS components for Deel.
-
Connect to Amplitude Data from a Connection Pool in JBoss
Integrate Amplitude into Java servlets: Use the Management Console in JBoss to install the Amplitude JDBC Driver.
-
Automate Redshift Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Amazon Redshift from PowerShell? This article demonstrates how to utilize the Redshift Cmdlets for tasks like connecting to Amazon Redshift, automating operations, downloading data, and more.
-
Connect to Attio Data from a Connection Pool in JBoss
Integrate Attio into Java servlets: Use the Management Console in JBoss to install the Attio JDBC Driver.
-
Build Data Flows from SuiteCRM to SQL Server using SSIS
Easily back up SuiteCRM to SQL Server using the SSIS components for SuiteCRM.
-
Visualize Live Presto Data in the Power BI Service
Use CData Connect AI to connect to live Presto and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Rapidly Develop Dynamics 365 Business Central-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 Dynamics 365 Business Central.
-
How to Connect the Power BI Service to Lakebase: Complete Guide
Connect to the CData Software Power BI Connector for Lakebase from PowerBI.com to provide real-time Lakebase across the organization.
-
Build Data Flows from SQL Server to Cassandra through SSIS
Easily push SQL Server data to Cassandra using the CData SSIS Tasks for Cassandra.
-
Process & Analyze Kintone Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Kintone Data.
-
Connect Salesloft to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Salesloft with IBM WebSphere for seamless data integration and connectivity.
-
How to Seamlessly Import AfterShip Data into IBM SPSS Modeler
Integrate AfterShip data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Dynamics 365 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 Microsoft Dynamics 365.
-
How to Create Power BI Visual Reports with Real-Time Microsoft Planner Data
Use CData Power BI Connectors to visualize Microsoft Planner in Power BI.
-
Migrating data from Flowlu to Databricks using CData SSIS Components.
Easily push Flowlu to Databricks using the CData SSIS Tasks for Flowlu and Databricks.
-
Visualize Live Reckon Accounts Hosted Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Reckon Accounts Hosted.
-
Connect to Azure Table Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Azure Table Storage using standard SQL.
-
Build AI/ML Models with Live Pingdom Data using Dataiku
Connect Pingdom Data with Dataiku using the CData API Driver for JDBC.
-
Create Reports with Google Campaign Manager 360 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Campaign Manager 360.
-
Create Data Visualizations in Cognos BI with Typeform Data
Access Typeform as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Connect to Live SAP Ariba Procurement Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SAP Ariba Procurement without replication.
-
Query JSON Services through ODBC in Node.js
Use node-odbc to execute SQL queries against JSON from Node.js.
-
Automated Continuous Wistia Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Wistia replication to Amazon Redshift.
-
Visualize Hubstaff Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Hubstaff into TIBCO Spotfire.
-
Automated Continuous ZohoInvoice Replication to Databricks
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Databricks.