CData Software - Knowledge Base
Recent Articles
-
Connect Placid Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Placid using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Access Live SAP Netweaver Gateway Data in Visual Studio Code via Cline
Run CData MCP Server for SAP Netweaver Gateway on Windows Subsytem for Linux (WSL) and connect to live SAP Netweaver Gateway from the Cline extension in Visual Studio Code.
-
Getting Started with the CData Power BI Connector for SpaceX
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build Dashboards with Redshift Data in Dundas BI
Create dynamic dashboards and perform analytics based on Amazon Redshift in Dundas BI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP ByDesign
Provide connectivity to SAP Business ByDesign through an SAP BusinessObjects universe.
-
Build a Singer.io Tap for Monday.com With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Monday.com data using
-
Consume Cvent OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Cvent feeds that reflect any changes in SAP Lumira.
-
How to load Cloudant data into Elasticsearch via Logstash
Introducing a simple method to load Cloudant data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Simplesat Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Simplesat and work with Simplesat in your FileMaker application.
-
Natively Connect to SAP Business One Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP Business One. Leverage the native support for ODBC in PHP.
-
DataBind Controls to OneNote Data in Delphi
DataBind to Microsoft OneNote in Delphi with standard data access components and controls.
-
How to Query Everhour Data in MySQL Workbench
Execute MySQL queries against live Everhour from MySQL Workbench.
-
Connect to Amazon Marketplace Data in Aqua Data Studio
Access Amazon Marketplace from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Deploy the ADO.NET Provider for Wistia on an SSRS Report Server
Connect to Wistia 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.
-
Access Live Google Translate Data in AWS Lambda
Connect to live Google Translate in AWS Lambda using the CData JDBC Driver.
-
Trigger Paylocity IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Paylocity with standard wizards in Logic Apps.
-
Natively Connect to Mistral AI Data in PHP
The CData ODBC driver for Mistral AI enables you to create PHP applications with connectivity to Mistral AI. Leverage the native support for ODBC in PHP.
-
Use ChatGPT to Talk to Your SAS xpt 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 SAS XPORT for you.
-
Build an OLAP Cube in SSAS from Everhour Data
Establish a connection to Everhour data from SQL Server Analysis Services, and use the Everhour Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Reports from SAP Ariba Source Data in Looker Studio
Use CData Connect AI to gain access to live SAP Ariba Source and create custom reports in Looker Studio.
-
Use Dash to Build Web Apps on Dynamics 365 Data via CData Connect AI
Build interactive Dash web apps on live Microsoft Dynamics 365 using pandas and the CData Connect AI Python SDK.
-
Connect to Acumatica Data in Jaspersoft Studio
Execute SQL to remote Acumatica ERP in Jaspersoft Studio.
-
Automated Continuous SAP Business One Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SAP Business One replication to Amazon Redshift.
-
How to Connect the Power BI Service to Instantly: Complete Guide
Connect to the CData Software Power BI Connector for Instantly from PowerBI.com to provide real-time Instantly across the organization.
-
Connect to Teamwork Data in HULFT Integrate
Connect to Teamwork as a JDBC data source in HULFT Integrate
-
Getting Started with the CData Tableau Connector for Dynamics NAV
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Dynamics NAV.
-
Use Claude to Talk to Your Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Facebook Ads for you.
-
Integrating Antigravity CLI with SAP SuccessFactors via CData CLI
Connect SAP SuccessFactors to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData Power BI Connector for Retently
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Email actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
How to Query ScrapingBee Data in MySQL Workbench
Execute MySQL queries against live ScrapingBee from MySQL Workbench.
-
Write a Simple Go Application to work with REST Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to REST.
-
Integrate SendPulse with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SendPulse with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SendPulse.
-
Create Access Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Access data access from reports, embedded analytics, and more.
-
Automate Salesforce Data 360 Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Salesforce Data 360 and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to connect PolyBase to Auth0
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Auth0.
-
How to Access Live LinkedIn Data in Power Automate Desktop via ODBC
The CData ODBC Driver for LinkedIn enables you to integrate LinkedIn into workflows built using Microsoft Power Automate Desktop.
-
How to connect SharePoint with HubSpot Data through external lists
Provide HubSpot to SharePoint users as an external list.
-
Replicate Multiple Square Accounts via the CData Sync CLI
Replicate multiple Square accounts to one or many databases.
-
Automated Continuous Freshsales Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Freshsales replication to delimited files (CSV/TSV).
-
Connect to Clio in SpagoBI
Create reports featuring live Clio in SpagoBI Studio. Host Clio reports on SpagoBI Server.
-
How to Build an ETL App for Pipeline CRM Data in Python with CData
Create ETL applications and real-time data pipelines for Pipeline CRM in Python with petl.
-
How to Connect to & Open TigerGraph Data in Microsoft Excel
This article uses the CData ODBC driver for TigerGraph to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Access Live Greenplum Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Greenplum enables you to integrate Pivotal GreenPlum into workflows built using Microsoft Power Automate Desktop.
-
Integrate ActiveCampaign with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ActiveCampaign with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ActiveCampaign.
-
Use Databricks Agent Bricks to Talk to Your Presto Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Presto for you.
-
Use Biml to Build SSIS Tasks to Replicate Amazon Athena Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Amazon Athena to SQL Server.
-
How to Access Live Coda Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Coda enables you to integrate Coda into workflows built using Microsoft Power Automate Desktop.
-
Integrate Live Salesforce Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Salesforce from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Salesforce & Force.com.
-
Perform Batch Operations with SAP Netweaver Gateway Data in Apache NiFi
Connect to SAP Netweaver Gateway and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Create Power BI Reports on Real-Time Microsoft Planner Data
Use the CData ODBC Driver for Microsoft Planner to visualize Microsoft Planner in Power BI Desktop.
-
Publish Reports with Front Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Front.
-
Use Dash to Build to Web Apps on Salesforce Data
Create Python applications that use pandas and Dash to build Salesforce-connected web apps.
-
Automate SAP Hybris C4C Data Replication to Couchbase
Use CData Sync to Customize and automate SAP Hybris C4C replication to Couchbase.
-
Working with Testmonitor Data in LINQPad
Execute LINQ queries to Testmonitor in LINQPad.
-
Connect Close to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Close with IBM WebSphere for seamless data integration and connectivity.
-
Build ZarMoney-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ZarMoney and build web apps with connectivity to live ZarMoney.
-
Integrate Real-Time Access to HubDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to HubDB in real time.
-
Provide OData Services of Beeminder Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Beeminder by developing a WCF Service Application.
-
Automated Continuous Bitbucket Replication to MySQL
Use CData Sync for automated, continuous, customizable Bitbucket replication to MySQL.
-
Integrate Real-Time Access to HDFS in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache HDFS in real time.
-
Integrate LibreChat with Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Dataverse (CDS) from within the chat interface.
-
Use the CData Software ODBC Driver for ScrapingBee in MicroStrategy Web
Connect to ScrapingBee in MicroStrategy Web using the CData Software ODBC Driver for ScrapingBee.
-
Work with Klaviyo Data in FoxPro
Load Klaviyo into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData Power BI Connector for Microsoft Entra ID
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Microsoft Entra ID.
-
How to Design Twilio Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Twilio from mobile and tablet Power Apps.
-
Build Testmonitor-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Testmonitor and build web apps with connectivity to live Testmonitor.
-
Replicate Multiple Copper Accounts via the CData Sync CLI
Replicate multiple Copper accounts to one or many databases.
-
Use Databricks Agent Bricks to Talk to Your Salesforce Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Salesforce & Force.com for you.
-
Consume HCL Domino OData Feeds in PowerBuilder
This article demonstrates how to consume HCL Domino as OData feeds from PowerBuilder using the API Server.
-
Connect to Amazon S3 Data from HeidiSQL
Use CData Connect AI to connect to and query live Amazon S3 from HeidiSQL.
-
Access Live Office 365 Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Office 365 from your Google Sheets.
-
How to Connect to Live LinkedIn Ads 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 LinkedIn Ads without replication.
-
Extract, Transform, and Load Browserless Data in Informatica PowerCenter
Create a simple Workflow for Browserless in Informatica PowerCenter.
-
Connect to Microsoft Dataverse Data from a Connection Pool in Jetty
The Microsoft Dataverse JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Dataverse (CDS) from Web apps in Jetty.
-
Manage SAP Fieldglass Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP Fieldglass.
-
Build Apps with Live Odoo Data Using the Low-Code Development Platform of Mendix
Connect Odoo ERP with Mendix to build apps using the CData JDBC Driver for Odoo.
-
Integrating LangGraph with Neo4J Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Neo4J within automated workflows.
-
Prepare, Blend, and Analyze Lakebase Data in Alteryx Designer (Connect AI)
Build workflows to access live Lakebase for self-service data analytics.
-
Connect to GetResponse Data in RapidMiner
Integrate GetResponse with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Semantic Layer Views for Insightly Data in APOS Live Data Gateway
Use the CData Connector for Insightly in APOS Live Data Gateway to build Semantic Layer Views for Insightly.
-
Create Everhour Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Everhour from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Live Short.io Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Short.io to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Bitly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Bitly to connect to Bitly and execute queries in PowerBuilder.
-
Connect to Qualaroo Data from PowerBuilder via JDBC
This article demonstrates how to access Qualaroo from PowerBuilder using the Qualaroo JDBC Driver.
-
Replicate Multiple Shippo Accounts via the CData Sync CLI
Replicate multiple Shippo accounts to one or many databases.
-
Consume Sage Cloud Accounting OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Sage Cloud Accounting feeds that reflect any changes in SAP Lumira.
-
Provide OData Services of Dynamics 365 Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft Dynamics 365 by developing a WCF Service Application.
-
Integrate Live Box Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Box to Blue Prism using the CData ODBC Driver for Box to create automated workflows for repetitive business tasks.
-
Integrate ZohoExpense Data in the Pentaho Report Designer
Publish reports based on ZohoExpense in the Pentaho BI tool.
-
Analyze SAS xpt Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAS XPORT and visualize SAS XPORT in SAP Analytics Cloud.
-
Access Hacker News Data from MySQL in Amazon QuickSight
Connect to Hacker News and build visualizations of Hacker News using a MySQL Connection in Amazon QuickSight.
-
Getting Started with the CData ADO.NET Provider for Zendesk
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Zendesk.
-
Automated Continuous Databricks Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Databricks replication to IBM DB2.
-
Automated Continuous Reckon Accounts Hosted Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Apache Kafka.
-
Analyze SAP ByDesign Data in Looker
Use CData Connect AI to connect to SAP ByDesign Data from Looker and build custom apps using live SAP Business ByDesign.
-
Prepare, Blend, and Analyze SAP HANA XS Advanced Data in Alteryx Designer (ODBC)
Build workflows to access live SAP HANA XS Advanced for self-service data analytics.
-
Use the CData Software JDBC Driver for Salesforce CRM Analytics in MicroStrategy
Connect to Salesforce CRM Analytics in MicroStrategy Developer using the CData Software JDBC Driver for Salesforce CRM Analytics.
-
Integrate with Oracle HCM Cloud Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Oracle HCM Cloud in SnapLogic.
-
Connecting GenSpark with SAP Concur Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP Concur without any replication or custom integration required.