CData Software - Knowledge Base
Recent Articles
-
Create DB2-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to DB2 Data from OutSystems and build custom enterprise apps using live IBM DB2.
-
Load Microsoft Exchange Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Exchange to a database.
-
Analyze Zendesk Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Zendesk and visualize Zendesk in SAP Analytics Cloud.
-
How to Query Live LinkedIn Data in Claude Desktop
Connect to and query live LinkedIn Data in Claude Desktop using CData MCP Server.
-
Integrate with Live Oracle Sales Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Oracle Sales from the MuleSoft Anypoint Platform to integrate live Oracle Sales into custom reports and dashboards.
-
Back Up Facebook Ads to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Facebook Ads. In this article, we will employ an SSIS workflow to populate a database with Facebook Ads data.
-
Model Presto Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Presto, enabling the direct import of real-time Presto.
-
How to connect SharePoint with Front Data through external lists
Provide Front to SharePoint users as an external list.
-
Integrate with Live Databricks Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Databricks from the MuleSoft Anypoint Platform to integrate live Databricks into custom reports and dashboards.
-
Connect to Rootly Data from PowerBuilder via JDBC
This article demonstrates how to access Rootly from PowerBuilder using the Rootly JDBC Driver.
-
Build Quickbase Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Quickbase and build visualizations in Tableau.
-
How to Access Live Sybase IQ Data in Visual Studio Code via Cline
Run CData MCP Server for Sybase IQ on Windows Subsytem for Linux (WSL) and connect to live Sybase IQ from the Cline extension in Visual Studio Code.
-
How to Seamlessly Import Reply.io Data into IBM SPSS Modeler
Integrate Reply.io data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Work with ZohoInvoice Data in FoxPro
Load ZohoInvoice into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Scrapfly-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Scrapfly Data in Gemini Code Assist to assist with building Scrapfly-powered applications.
-
How to Query Live SAP Concur Data in Perplexity MacOS Desktop
Connect to and query live SAP Concur Data in Perplexity Desktop using CData MCP Server.
-
Add SAP Hybris C4C Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Hybris C4C with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Query AfterShip Data in MySQL Workbench
Execute MySQL queries against live AfterShip from MySQL Workbench.
-
Edit and Search External Dynamics 365 Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft Dynamics 365 to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Dynamics 365 Data objects that you can access from apps and the dashboard.
-
Create Greenhouse Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Greenhouse data access from reports, embedded analytics, and more.
-
Process & Analyze xBase Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live xBase Data.
-
Build OneNote Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft OneNote and build visualizations in Tableau.
-
Query Google Search Results using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Search entities in PHP by modeling them as objects.
-
Integrating Gumloop with Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Salesforce Pardot within automated workflows.
-
Connect Oracle to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Oracle Database using the CData Python MCP Server.
-
Connect GraphQL to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live GraphQL using the CData Python MCP Server.
-
Connect to Neo4J Data from PowerBuilder via JDBC
This article demonstrates how to access Neo4J from PowerBuilder using the Neo4J JDBC Driver.
-
Automate Zuora Data Replication to Couchbase
Use CData Sync to Customize and automate Zuora replication to Couchbase.
-
Use CData Connect AI to Access Snowflake Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Snowflake in the Power Pivot business intelligence tool.
-
Integrate with BigQuery Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google BigQuery to a JSON file on disk.
-
Connect to Salesforce Data from PowerBuilder via JDBC
This article demonstrates how to access Salesforce & Force.com from PowerBuilder using the Salesforce JDBC Driver.
-
Visualize Live MessageBird Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MessageBird using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Power BI XMLA Data as a SQL Server Database in Node.js
Execute SQL Server queries against Power BI XMLA from Node.js.
-
Automated Continuous SAP Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP ERP/NetWeaver replication to OneLake in Microsoft Fabric.
-
Build Dashboards with Reply.io Data in Dundas BI
Create dynamic dashboards and perform analytics based on Reply.io in Dundas BI.
-
Create Dynamic PagerDuty Grids Using the Infragistics XamDataGrid
Learn how you can connect PagerDuty to Infragistics XamDataGrid to build dynamic grids.
-
Automate Stripe Data Replication to Couchbase
Use CData Sync to Customize and automate Stripe replication to Couchbase.
-
Natively Connect to Factorial Data in PHP
The CData ODBC driver for Factorial enables you to create PHP applications with connectivity to Factorial. Leverage the native support for ODBC in PHP.
-
How to Connect the Power BI Service to Google Spanner: Complete Guide
Connect to the CData Software Power BI Connector for Google Spanner from PowerBI.com to provide real-time Google Spanner across the organization.
-
Build Apps with Live Basecamp Data Using the Low-Code Development Platform of Mendix
Connect Basecamp with Mendix to build apps using the CData JDBC Driver for Basecamp.
-
Provide OData Services of Databricks Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Databricks by developing a WCF Service Application.
-
Build Semantic Layer Views for Parquet Data in APOS Live Data Gateway
Use the CData Connector for Parquet in APOS Live Data Gateway to build Semantic Layer Views for Apache Parquet.
-
Work with Live Avalara AvaTax Data in Power Query
Use CData Connect AI to connect to Avalara AvaTax and work with live Avalara AvaTax in Microsoft Power Query.
-
How to connect to Datadog Data from IntelliJ
Integrate connectivity to Datadog with wizards in IntelliJ.
-
NASA Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on NASA facts in real time.
-
Automated Continuous Email Replication to MongoDB
Use CData Sync for automated, continuous, customizable Email replication to MongoDB.
-
Automated Continuous Databricks Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Databricks replication to delimited files (CSV/TSV).
-
Use Databricks Agent Bricks to Talk to Your Amazon DynamoDB Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Amazon DynamoDB for you.
-
Connect to Amazon S3 Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Amazon S3 Data and connect to Amazon S3 in Akorbi Digital RunMyProcess.
-
Automate Dropbox Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Dropbox from PowerShell? This article demonstrates how to utilize the Dropbox Cmdlets for tasks like connecting to Dropbox, automating operations, downloading data, and more.
-
Explore Geographical Relationships in CircleCI Data with Power Map
Create data visualizations with CircleCI in Power Map.
-
Use Manus AI to Talk to Your Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Sage 200.
-
Connect to Stripe from Asprova with CData Software ODBC Driver for Stripe
This article shows how to connect faster to Stripe data from Asprova.
-
Connect ZohoSubscriptions to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZohoSubscriptions with IBM WebSphere for seamless data integration and connectivity.
-
Consume BenchmarkEmail OData Feeds in SAP Lumira
Use the API Server to create data visualizations on BenchmarkEmail feeds that reflect any changes in SAP Lumira.
-
CampaignMonitor Reporting in OBIEE with the CampaignMonitor JDBC Driver
Deploy the CampaignMonitor JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Stream Google Tasks Data into Apache Kafka Topics
Access and stream Google Tasks in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Jira Assets Data into Power Automate Desktop using CData Connect
CData Connect for Jira Assets Data enables you to integrate Jira Assets into workflows built using Microsoft Power Automate Desktop.
-
How to Visualize Omnisend Data in Python with pandas
Use pandas and other modules to analyze and visualize live Omnisend in Python.
-
Getting Started with the CData Tableau Connector for Cassandra
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Apache Cassandra.
-
Query Rootly Data as a MySQL Database in Node.js
Execute MySQL queries against Rootly from Node.js.
-
Integrate Mailgun with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Mailgun with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Mailgun.
-
Process & Analyze Databricks Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Databricks Data.
-
Access Live Adobe Commerce Data in AWS Lambda
Connect to live Adobe Commerce in AWS Lambda using the CData JDBC Driver.
-
Create Freshdesk-Connected Dashboards in Grafana
Connect to Freshdesk Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Freshdesk.
-
Explore Geographical Relationships in Workable Data with Power Map
Create data visualizations with Workable in Power Map.
-
Automated Continuous Marketo Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Marketo replication to Azure SQL Database.
-
Connect to PayPal Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for PayPal and the Script function in FileMaker Pro to connect to PayPal and work with PayPal in your FileMaker application.
-
Query Simplesat Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Simplesat from Node.js.
-
Connect to Tickspot Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Tickspot in the Denodo Virtual DataPort Administrator.
-
Create Power BI Reports on Real-Time Instantly Data
Use the CData ODBC Driver for Instantly to visualize Instantly in Power BI Desktop.
-
Connect to ShipEngine Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ShipEngine to connect to ShipEngine and execute queries in PowerBuilder.
-
Visualize TaxJar Data in TIBCO Spotfire through ADO.NET
Integrate TaxJar into dashboards in TIBCO Spotfire.
-
Connect to Google Translate Data from a Connection Pool in Jetty
The Google Translate JDBC Driver supports connection pooling: This article shows how to connect faster to Google Translate from Web apps in Jetty.
-
Replicate Multiple Quickbase Accounts
Replicate multiple Quickbase accounts to one or many databases.
-
Connect to Recurly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Recurly to connect to Recurly and execute queries in PowerBuilder.
-
Create a Data Access Object for Invoiced Data using JDBI
A brief overview of creating a SQL Object API for Invoiced in JDBI.
-
Automated Continuous Nethunt Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Nethunt replication to OneLake in Microsoft Fabric.
-
How to connect to LinkedIn Data from IntelliJ
Integrate connectivity to LinkedIn with wizards in IntelliJ.
-
Use Grok to Talk to Your Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Atlassian Jira for you.
-
How to use SQLAlchemy ORM to access Certinia Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Certinia.
-
Connect to MariaDB Data in NetBeans
Connect to MariaDB in NetBeans with the data source configuration wizard.
-
Integrating LlamaIndex with Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle Service Cloud in real time.
-
How to Query Live Cvent Data in Claude Desktop
Connect to and query live Cvent Data in Claude Desktop using CData MCP Server.
-
Connect to Paymo Data in Jaspersoft Studio
Execute SQL to remote Paymo in Jaspersoft Studio.
-
How to use SQLAlchemy ORM to access TaxJar Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of TaxJar.
-
Access Live HubSpot Data in Excel 365 Online (Excel for the web)
Connect to HubSpot from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData ODBC Driver for PostgreSQL in Microsoft Power Query
You can use the CData PostgreSQL ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import PostgreSQL into Microsoft Power Query.
-
Automated Continuous ServiceNow Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ServiceNow replication to Google BigQuery.
-
Getting Started with the CData Tableau Connector for Shippo
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Consume Oracle Financials Cloud OData Feeds in PowerBuilder
This article demonstrates how to consume Oracle Financials Cloud as OData feeds from PowerBuilder using the API Server.
-
Create Informatica Mappings From/To a JDBC Data Source for Attio
Create Attio data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Wrike-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Wrike Data in Claude Code to assist with building Wrike-powered applications.
-
Analyze Live Zoho Inventory Data in SAS Viya
Use CData Connect AI to connect to Zoho Inventory from SAS Viya and deploy self-service analytics using live Zoho Inventory.
-
How to Use a Microsoft Access Database to Update Google Drive Data in Real Time
Update Google Drive data by creating a linked table in Microsoft Access with the CData Google Drive ODBC Driver.
-
Create IBM Cloud Object Storage Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time IBM Cloud Object Storage data access from reports, embedded analytics, and more.
-
Connect to Workday Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Workday using standard SQL.
-
Build Couchbase-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Couchbase.
-
Automated Continuous Teamwork Replication to Oracle
Use CData Sync for automated, continuous, customizable Teamwork replication to Oracle.
-
Viewing ZendeskSell Data in RAD Studio Data Explorer
How to view ZendeskSell in RAD Studio Data Explorer using the CData ODBC Driver for ZendeskSell.