CData Software - Knowledge Base
Recent Articles
-
Connect SAP Fieldglass to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Fieldglass using the CData Python MCP Server.
-
How to connect to Paylocity Data in DBVisualizer
Integrate Paylocity with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Real-Time Access to Toggl in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Toggl in real time.
-
Connect to Procore Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Procore in Airbyte.
-
Choosing the Best Method to Connect GitHub to SQL Server: 5 Options Explained
Discover multiple ways to connect and use GitHub from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Real-Time Yelp Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Yelp in Power Apps.
-
Automated Continuous Keap Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Keap replication to delimited files (CSV/TSV).
-
Connect to QuickBooks Online Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for QuickBooks Online.
-
Manage Microsoft Entra ID Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Microsoft Entra ID.
-
Consume SAP Concur OData Feeds in PowerBuilder
This article demonstrates how to consume SAP Concur as OData feeds from PowerBuilder using the API Server.
-
Analyze SAS xpt Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAS XPORT and visualize live SAS XPORT in Infragistics Reveal.
-
Build Automated Workflows with Live Azure DevOps Data in Workato
Use CData Connect AI to connect to live Azure DevOps and build automated workflows in Workato.
-
Integrating Highrise Data in Talend Cloud Data Management Platform
Connect Highrise Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Highrise.
-
Write a Simple Go Application to work with HDFS Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Apache HDFS.
-
How to Connect PayPal 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 PayPal data in real time using natural language.
-
Automated Continuous Phoenix Replication to Databricks
Use CData Sync for automated, continuous, customizable Phoenix replication to Databricks.
-
How to Connect to Live Asana Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Asana for you.
-
Design BIRT Reports on Perigon Data
Provide current Perigon to your embedded analytics.
-
Integrating Claude Code CLI with IBM Cloud Object Storage 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.
-
Visualize Live Dynamics CRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Dynamics CRM.
-
Integrate Azure Analysis Services Data in the Pentaho Report Designer
Publish reports based on Azure Analysis Services in the Pentaho BI tool.
-
Moving Data from Salesforce to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Salesforce data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Real-Time Access to HCL Domino in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to HCL Domino in real time.
-
Analyze Microsoft Planner Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Planner and visualize Microsoft Planner in SAP Analytics Cloud.
-
Validate Cloudant Data with QuerySurge
Access and validate IBM Cloudant in QuerySurge using the CData JDBC Driver.
-
Integrating Spark Data in Talend Cloud Data Management Platform
Connect Spark Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Apache Spark.
-
Automated Continuous LaunchDarkly Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Apache Cassandra.
-
Feed Microsoft Ads Data into FineReport
How to set Microsoft Ads as a JDBC data source in FineReport.
-
Validate HubDB Data with QuerySurge
Access and validate HubDB in QuerySurge using the CData JDBC Driver.
-
Migrating data from Reckon Accounts Hosted to Google BigQuery using CData SSIS Components.
Easily push Reckon Accounts Hosted to Google BigQuery using the CData SSIS Tasks for Reckon Accounts Hosted and Google BigQuery.
-
DataBind Controls to SingleStore Data in C++Builder
DataBind to SingleStore in C++Builder with standard components and controls.
-
Build MariaDB Visualizations in Tableau Desktop
Use CData Connect AI to connect to live MariaDB and build visualizations in Tableau.
-
Import Real-Time WordPress Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use WordPress in ColdFusion.
-
Connect to Redshift Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Amazon Redshift.
-
Use the CData API Server to Access SAP Concur Data in Microsoft PowerPivot
Use the CData API Server to connect to live SAP Concur in the Power Pivot business intelligence tool.
-
Analyze PolarTeamPro Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of PolarTeamPro and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Data Visualizations Based On SQL Analysis Services Data in Mode
Use CData Connect AI to connect to SQL Analysis Services Data from Mode and build visualizations using live
-
Work with PagerDuty Data in FoxPro
Load PagerDuty into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Redis Data in DataGrip
Create a Data Source for Redis in DataGrip and use SQL to query live Redis.
-
Integrate Live Parquet Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Apache Parquet to Blue Prism using the CData ODBC Driver for Parquet to create automated workflows for repetitive business tasks.
-
Build Charts with Mode Data in Clear Analytics
Create dynamic charts and perform analytics based on Mode in Clear Analytics.
-
How to Connect to Live Gmail Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Gmail for you.
-
How to connect SharePoint with Clari Data through external lists
Provide Clari to SharePoint users as an external list.
-
Build Charts with Auth0 Data in Clear Analytics
Create dynamic charts and perform analytics based on Auth0 in Clear Analytics.
-
Access Google Cloud Storage Data from MySQL in PHP
Connect to Google Cloud Storage through the standard MySQL libraries in PHP.
-
How to Seamlessly Import HCL Domino Data into IBM SPSS Modeler
Integrate HCL Domino data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to GetResponse Data in Ruby
Connect to GetResponse in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Exa Data in TIBCO Spotfire through ADO.NET
Integrate Exa into dashboards in TIBCO Spotfire.
-
Import and Visualize Highrise Data in Power View
Create data visualizations based on Highrise CRM in Excel.
-
Connecting Pipedream with FreshBooks 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 FreshBooks data in real time.
-
Process & Analyze PagerDuty Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live PagerDuty Data.
-
Replicate Multiple ZohoMarketingHub Accounts via the CData Sync CLI
Replicate multiple ZohoMarketingHub accounts to one or many databases.
-
Build Bright Data-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Bright Data and build web apps with connectivity to live Bright Data.
-
Connect to Excel Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Oracle Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Oracle Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build AI Agents with Amazon S3 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 Amazon S3 through CData Connect AI.
-
Automated Continuous ZohoInvoice Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to OneLake in Microsoft Fabric.
-
How to import SAP Netweaver Gateway Data into Apache Solr
Use the CData Software JDBC Driver for SAP Netweaver Gateway in Data Import Handler and create an automated import of SAP Netweaver Gateway to Apache Solr Enterprise Search platform.
-
Use JayDeBeApi to access TaxJar Data in Python
Use standard Python scripting and the development environment of your choice to access live TaxJar.
-
Stream Active Directory Data into Apache Kafka Topics
Access and stream Active Directory in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to Codat Data in DBVisualizer
Integrate Codat with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Perplexity to Power BI dashboards. Simply drag and drop Perplexity into data visuals on the Power BI canvas.
-
Connect to Dynamics 365 Business Central Data in DBArtisan
Use wizards in DBArtisan to configure Dynamics 365 Business Central as a data source.
-
Integrating GitHub Copilot CLI with Deel 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.
-
ETL FreshBooks in Oracle Data Integrator
This article shows how to transfer FreshBooks into a data warehouse using Oracle Data Integrator.
-
How to Connect the Power BI Service to Email: Complete Guide
Connect to the CData Software Power BI Connector for Email from PowerBI.com to provide real-time Email across the organization.
-
Integrate Live EmailOctopus Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live EmailOctopus to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Access Live Toggl Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Toggl from the Cline extension in Visual Studio Code.
-
Automated Continuous Kintone Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Kintone replication to PostgreSQL.
-
Build Pipelines with Live PayPal Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to PayPal from Google Cloud Data Fusion, enabling the integration of live PayPal into the building and management of effective data pipelines.
-
Integrating OpenCode Terminal with FormSite 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.
-
Automated Continuous Pipeline CRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to SingleStore.
-
Visualize Close Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Close.
-
Access Live Cassandra Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Cassandra data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Automated Continuous LightSpeedRetail Replication to Oracle
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Oracle.
-
How to Query Live SingleStore Data in Perplexity MacOS Desktop
Connect to and query live SingleStore Data in Perplexity Desktop using CData MCP Server.
-
How to Work with Avaza Data in AWS Glue Jobs Using JDBC
Connect to Avaza from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
A PostgreSQL Interface for ConvertKit Data (MySQL Remoting via JDBC)
Use the Remoting features of the ConvertKit JDBC Driver to create a PostgreSQL entry-point for data access.
-
Stream ConvertKit Data into Apache Kafka Topics
Access and stream ConvertKit in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Semantic Layer Views for Trello Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Trello.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle SCM
Provide connectivity to Oracle SCM through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To an ODBC Data Source for Adobe Analytics
Create an ODBC connection to Adobe Analytics in Informatica and browse and transfer Adobe Analytics.
-
Connect to Mouseflow Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Mouseflow to connect to Mouseflow and execute queries in PowerBuilder.
-
Visualize Vault CRM Data in TIBCO Spotfire through ADO.NET
Integrate Veeva Vault & Vault CRM into dashboards in TIBCO Spotfire.
-
How to Build an ETL App for Clockify Data in Python with CData
Create ETL applications and real-time data pipelines for Clockify in Python with petl.
-
Query FTP Data from Node.js
Use the OData endpoint of the CData API Server to connect to your FTP Servers and perform CRUD operations on FTP from Node.js.
-
How to use SQLAlchemy ORM to access Sybase Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sybase.
-
Use the CData Software JDBC Driver for Jodoo in MicroStrategy Desktop
Connect to Jodoo in MicroStrategy Desktop using the CData Software JDBC Driver for Jodoo.
-
How to Connect SharePoint 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 SharePoint data in real time using natural language.
-
Analyze Live Workday Data in SAS Viya
Use CData Connect AI to connect to Workday from SAS Viya and deploy self-service analytics using live Workday.
-
Connect to Real-Time Zoho Books Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Zoho Books and Dataflow to import and use Zoho Books in Power Apps.
-
Getting Started with the CData Excel Add-In for AgileCRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for AgileCRM.
-
Edit and Search Klaviyo External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Klaviyo to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Klaviyo objects that you can access from apps and the dashboard.
-
JDBC-ODBC Bridge Reporting in OBIEE with the JDBC-ODBC Bridge JDBC Driver
Deploy the JDBC-ODBC Bridge JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Build an ETL App for MarkLogic Data in Python with CData
Create ETL applications and real-time data pipelines for MarkLogic in Python with petl.
-
Connect to Neo4J 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 Neo4J.
-
Use CData Connect AI to Access Sage 200 Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Sage 200 in the Power Pivot business intelligence tool.
-
Bidirectional Access to Simplesat Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Simplesat in Filemaker Pro for Mac or Windows.
-
How to create an RPA flow for Wrike Data in UiPath Studio
Use the Wrike ODBC Driver to create workflows that access real-time Wrike without any coding.
-
Build a PostgreSQL Interface for OnePageCrm Data using the CData JDBC Driver
Use the Remoting features of the OnePageCrm JDBC Driver to create a PostgreSQL entry-point for data access.