CData Software - Knowledge Base
Recent Articles
-
Bind Live HBase Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live HBase data
-
Integrating LangGraph with MongoDB Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on MongoDB within automated workflows.
-
ETL Freshsales in Oracle Data Integrator
This article shows how to transfer Freshsales into a data warehouse using Oracle Data Integrator.
-
Feed ConstantContact Data into FineReport
How to set ConstantContact as a JDBC data source in FineReport.
-
Explore Geographical Relationships in Cloudflare Data with Power Map
Create data visualizations with Cloudflare in Power Map.
-
Automated Continuous Figshare Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Figshare replication to Apache Kafka.
-
Access Live ZohoPeople Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ZohoPeople in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software ODBC Driver for Browserless in SAS for Real-Time Reporting and Analytics
Connect to real-time Browserless in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Browserless.
-
Create Power BI Reports on Real-Time SFTP Data
Use the CData ODBC Driver for SFTP to visualize SFTP in Power BI Desktop.
-
Build ShipStation-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ShipStation and build web apps with connectivity to live ShipStation.
-
How to connect to ShipStation Data from IntelliJ
Integrate connectivity to ShipStation with wizards in IntelliJ.
-
Moving Data from OData to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live OData data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect to Live Sage 200 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 Sage 200 for you.
-
Connect to Real-Time Short.io Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Short.io in Power Apps.
-
Query, Visualize, and Share live Oracle HCM Cloud Data in Redash
Use CData Connect AI to connect to live Oracle HCM Cloud in Redash for querying, visualizing, and sharing.
-
Integrate Live Oracle Eloqua Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Oracle Eloqua to Blue Prism using the CData ODBC Driver for Oracle Eloqua to create automated workflows for repetitive business tasks.
-
Access Live Printful Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Printful into the statistical analysis tools available in SAS JMP. This article shows how to use Printful in the Graph Builder and Query Builder.
-
Build Dashboards with Discord Data in DBxtra
Create dynamic dashboards and perform analytics based on Discord in DBxtra.
-
DataBind Bugsnag Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Bugsnag to a chart.
-
How to connect Amazon QuickSight to Databricks Data
Create a connection to Databricks in CData Connect AI and insert Databricks into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating OpenCode Terminal with Bugsnag 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 Asana 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 Asana into TIBCO Spotfire.
-
Access Live SAP Netweaver Gateway Data in Excel 365 Online (Excel for the web)
Connect to SAP Netweaver Gateway from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Mailjet Data in RapidMiner
Integrate Mailjet with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to and Visualize Live Sentry Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sentry.
-
How to create an RPA flow for SAP HANA Data in UiPath Studio
Use the SAP HANA ODBC Driver to create workflows that access real-time SAP HANA without any coding.
-
Automated Continuous Insightly Replication to SQL Server
Use CData Sync for automated, continuous, customizable Insightly replication to SQL Server.
-
How to Connect to Live Twitter Ads Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Twitter Ads for you.
-
Integrate Real-Time Access to Parquet in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Parquet in real time.
-
Back Up Strava 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 Strava data.
-
Connecting Moonlit Workflow with Zoom Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Zoom in real time.
-
Connect to Hive Data from PowerBuilder via JDBC
This article demonstrates how to access Apache Hive from PowerBuilder using the Hive JDBC Driver.
-
Analyze Dropbox Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Dropbox and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automate PostgreSQL Data Replication to SAP HANA
Use CData Sync to customize and automate PostgreSQL replication to SAP HANA.
-
Replicate Multiple Google Campaign Manager 360 Accounts
Replicate multiple Google Campaign Manager 360 accounts to one or many databases.
-
Getting Started with the CData Excel Add-In for Nethunt
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Nethunt.
-
Automated Continuous Neo4J Replication to MongoDB
Use CData Sync for automated, continuous, customizable Neo4J replication to MongoDB.
-
Easily Integrate Sugar CRM Data in Lazarus Pascal IDE
Learn how to easily integrate live Sugar CRM in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Sage 300 Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sage 300 replication to SingleStore.
-
Connecting Moonlit Workflow with WooCommerce Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your WooCommerce in real time.
-
Build a Singer.io Tap for OnePageCrm With the CData Python Connector
Learn how to easily build a Singer.io Tap for live OnePageCrm data using
-
Extract, Transform, and Load Google Ads Data in Informatica PowerCenter
Create a simple Workflow for Google Ads in Informatica PowerCenter.
-
Publish SharePoint-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft SharePoint.
-
How to Query Pushbullet Data in MySQL Workbench
Execute MySQL queries against live Pushbullet from MySQL Workbench.
-
Replicate Multiple SurveyMonkey Accounts via the CData Sync CLI
Replicate multiple SurveyMonkey accounts to one or many databases.
-
How to Work with OneNote Data in ETL Validator JDBC
Connect to OneNote from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Microsoft Planner Replication to SingleStore
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to SingleStore.
-
Access QuickBooks Time 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 QuickBooks Time.
-
Connecting Moonlit Workflow with Snowflake Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Snowflake in real time.
-
Automated Continuous Google Contacts Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Contacts replication to MongoDB.
-
Work with Live Adobe Commerce Data in Power Query
Use CData Connect AI to connect to Adobe Commerce and work with live Adobe Commerce in Microsoft Power Query.
-
Access Live ServiceNow Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ServiceNow from your Excel spreadsheets.
-
How to Connect to Live HCL Domino Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your HCL Domino for you.
-
Connect to PhantomBuster Data from PowerBuilder via ADO.NET
This article demonstrates how to access PhantomBuster from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Analyze Live Cloudant Data in SAS Viya
Use CData Connect AI to connect to IBM Cloudant from SAS Viya and deploy self-service analytics using live IBM Cloudant.
-
Use Biml to Build SSIS Tasks to Replicate Cloudant Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate IBM Cloudant to SQL Server.
-
Access Live ZohoExpense Data in AWS Lambda
Connect to live ZohoExpense in AWS Lambda using the CData JDBC Driver.
-
Access Live Zoho Books Data in AWS Lambda
Connect to live Zoho Books in AWS Lambda using the CData JDBC Driver.
-
Import and Visualize SAP Data in Power View
Create data visualizations based on SAP ERP/NetWeaver in Excel.
-
Integrate Yelp Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Yelp from Informatica Cloud.
-
Create Power BI Reports on Real-Time Toggl Data
Use the CData ODBC Driver for Toggl to visualize Toggl in Power BI Desktop.
-
How to Connect to & Open Mode Data in Microsoft Excel
This article uses the CData ODBC driver for Mode to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Data Flows from Asana to SQL Server using SSIS
Easily back up Asana to SQL Server using the SSIS components for Asana.
-
How to import Hacker News Data into Apache Solr
Use the CData Software JDBC Driver for Hacker News in Data Import Handler and create an automated import of Hacker News to Apache Solr Enterprise Search platform.
-
Connect to ZohoPeople Data in Jaspersoft Studio
Execute SQL to remote ZohoPeople in Jaspersoft Studio.
-
Integrating OpenCode Terminal with FHIR 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.
-
Connect to Planio Data in Ruby
Connect to Planio in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize FHIR Data in Sisense
Create an ElastiCube in Sisense app with access to FHIR.
-
Create Informatica Mappings From/To an ODBC Data Source for Avaza
Create an ODBC connection to Avaza in Informatica and browse and transfer Avaza.
-
Edit and Search Impala External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Apache Impala to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Impala objects that you can access from apps and the dashboard.
-
Integrate Pipedrive Data in the Pentaho Report Designer
Publish reports based on Pipedrive in the Pentaho BI tool.
-
Connecting Mastra with WooCommerce 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 WooCommerce, no replication required.
-
How to Connect to & Open TaxJar Data in Microsoft Excel
This article uses the CData ODBC driver for TaxJar to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access ChartMogul Data from MySQL in PHP
Connect to ChartMogul through the standard MySQL libraries in PHP.
-
Validate Recurly Data with QuerySurge
Access and validate Recurly in QuerySurge using the CData JDBC Driver.
-
LINQ to Sage 300 Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Sage 300 Data Provider.
-
How to Seamlessly Import Snapchat Ads Data into IBM SPSS Modeler
Integrate Snapchat Ads data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Codex CLI with Pinecone 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.
-
Replicate Zoho Creator Data to Multiple Databases via the CData Sync CLI
Replicate Zoho Creator to disparate databases with a single configuration.
-
How to Query Live Pipeliner CRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Pipeliner CRM data in natural language using Python.
-
How to connect to Act-On Data from Spring Boot
Connect to Act-On in a Spring Boot Application using the CData JDBC Driver for Act-On
-
Integrating MailerLite Data in Talend Cloud Data Management Platform
Connect MailerLite Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Build an ETL App for Float Data in Python with CData
Create ETL applications and real-time data pipelines for Float in Python with petl.
-
Automated Oracle Eloqua Data Replication to Teradata
Use CData Sync to Customize and automate Oracle Eloqua replication to Teradata.
-
Use ChatGPT to Talk to Your Microsoft Planner 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 Microsoft Planner for you.
-
Automated Continuous Slack Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Slack replication to AlloyDB.
-
Connect to Certinia Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Certinia Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build Pipelines with Live Sage 200 Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Sage 200 from Google Cloud Data Fusion, enabling the integration of live Sage 200 into the building and management of effective data pipelines.
-
Feed Nethunt Data into FineReport
How to set Nethunt as a JDBC data source in FineReport.
-
Connect to Google Tasks Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Google Tasks and work with Google Tasks in your FileMaker applications.
-
Connect to Office 365 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Office 365 as an External Source in Dremio.
-
Extract, Transform, and Load LinkedIn Ads Data in Informatica PowerCenter
Create a simple Workflow for LinkedIn Ads in Informatica PowerCenter.
-
Building Dynamic Web Pages with Pinterest Data Using AngularJS
Create single-page applications with live connectivity to Pinterest using the CData API Server.
-
Integrate with Live Amazon Marketplace Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Amazon Marketplace from the MuleSoft Anypoint Platform to integrate live Amazon Marketplace into custom reports and dashboards.
-
Natively Connect to Oracle Financials Cloud Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Oracle Financials Cloud. Leverage the native support for ODBC in PHP.
-
Connect to HDFS Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Apache HDFS.
-
Build HBase-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for HBase to explore live HBase Data in Cursor to assist with building HBase-powered applications.
-
Build a Simple VCL Application for MessageBird Data
How to build a simple VCL Application to view MessageBird in RAD Studio using the CData ODBC Driver for MessageBird.
-
Automated Continuous ZendeskSell Replication to Snowflake
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Snowflake.
-
Integrate with Live LinkedIn Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to LinkedIn from the MuleSoft Anypoint Platform to integrate live LinkedIn into custom reports and dashboards.