CData Software - Knowledge Base

Recent Articles

---

• «
• 903
• 904
• 905
• 906
• 907
• 908
• 909
• 910
• 911
• 912
• »

• Create SSAS Tabular Models from Eventbrite Data

  How to build a SQL Server Analysis Service Tabular Model from Eventbrite using CData drivers.

• Connect to Anaplan Data in RazorSQL

  Connect to Anaplan from wizards and query Anaplan from the GUI in the RazorSQL database management tool.

• Query Email Data as a SQL Server Database in Node.js

  Execute SQL Server queries against Email from Node.js.

• How to Connect the Power BI Service to Timely: Complete Guide

  Connect to the CData Software Power BI Connector for Timely from PowerBI.com to provide real-time Timely across the organization.

• Use the CData Software ODBC Driver for Asana in SAS for Real-Time Reporting and Analytics

  Connect to real-time Asana in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Asana.

• Integrate ShipEngine with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate ShipEngine with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ShipEngine.

• Feed Amazon Athena Data into FineReport

  How to set Amazon Athena as a JDBC data source in FineReport.

• Build Raisers Edge NXT-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Raisers Edge NXT.

• Automated Continuous PivotalTracker Replication to SQLite

  Use CData Sync for automated, continuous, customizable PivotalTracker replication to SQLite.

• Automated Continuous Zoho Inventory Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Zoho Inventory replication to PostgreSQL.

• How to connect PolyBase to LightSpeedRetail

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live LightSpeedRetail.

• Add Outreach.io Data to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Outreach.io with the Informatica Enterprise Data Catalog to classify and organize data.

• Analyze Dynamics CRM Data in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Microsoft Dynamics CRM and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.

• Query Google Forms Data in ColdFusion

  Write standard ColdFusion data access code to connect to Google Forms.

• Integrate SAP HANA Data in Pentaho Data Integration

  Build ETL pipelines based on SAP HANA in the Pentaho Data Integration tool.

• Build a Simple VCL Application for Mistral AI Data

  How to build a simple VCL Application to view Mistral AI in RAD Studio using the CData ODBC Driver for Mistral AI.

• Access Live Acumatica Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Acumatica data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Query OneNote Data using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume OneNote entities in PHP by modeling them as objects.

• Integrate Auth0 with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate Auth0 with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Auth0.

• Integrate Zoho Books Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zoho Books from Informatica Cloud.

• Use Azure AI Foundry to Talk to Your SAP Fieldglass Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SAP Fieldglass for you.

• Connecting Agentforce with ADP Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your ADP for you.

• Feed ShipEngine Data into FineReport

  How to set ShipEngine as a JDBC data source in FineReport.

• Access Live ActiveCampaign Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to ActiveCampaign from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Publish Reports with Adobe Commerce Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Adobe Commerce.

• Connect to Outreach.io Data from a Connection Pool in JBoss

  Integrate Outreach.io into Java servlets: Use the Management Console in JBoss to install the Outreach.io JDBC Driver.

• Build Google Calendar-Connected Apps in Choreo

  Use CData Connect AI to connect to Google Calendar Data from Choreo and build custom apps using live Google Calendar.

• Stream SharePoint Data into Apache Kafka Topics

  Access and stream Microsoft SharePoint in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Replicate Multiple Microsoft Entra ID Accounts via the CData Sync CLI

  Replicate multiple Microsoft Entra ID accounts to one or many databases.

• Access AfterShip Data from MySQL in Amazon QuickSight

  Connect to AfterShip and build visualizations of AfterShip using a MySQL Connection in Amazon QuickSight.

• Use Agno to Talk to Your Quickbase Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Quickbase for you.

• Connect to Twilio from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Twilio, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Migrating data from SAP HANA XS Advanced to Google BigQuery using CData SSIS Components.

  Easily push SAP HANA XS Advanced to Google BigQuery using the CData SSIS Tasks for SAP HANA XS Advanced and Google BigQuery.

• Access Live Google Sheets Data in Excel 365 Online (Excel for the web)

  Connect to Google Sheets from Excel 365 Online (Excel for the web) with CData Connect AI.

• Automated Continuous Google Calendar Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Google Calendar replication to Apache Kafka.

• Access ConvertKit Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live ConvertKit from HeidiSQL.

• Connect to PolarTeamPro Data from a Connection Pool in JBoss

  Integrate PolarTeamPro into Java servlets: Use the Management Console in JBoss to install the PolarTeamPro JDBC Driver.

• Create Power BI Reports on Real-Time Gumroad Data

  Use the CData ODBC Driver for Gumroad to visualize Gumroad in Power BI Desktop.

• Validate SAP HANA Data with QuerySurge

  Access and validate SAP HANA in QuerySurge using the CData JDBC Driver.

• Build a Singer.io Tap for SAP Fieldglass With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live SAP Fieldglass data using

• Visualize Mocean Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Mocean.

• Publish Oracle Sales-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Oracle Sales.

• Build Apps with Live Email Data Using the Low-Code Development Platform of Mendix

  Connect Email with Mendix to build apps using the CData JDBC Driver for Email.

• Create Gorgias Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Gorgias data access from reports, embedded analytics, and more.

• Integrate MarkLogic with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate MarkLogic with External Services.

• Automated Continuous GitLab Replication to SingleStore

  Use CData Sync for automated, continuous, customizable GitLab replication to SingleStore.

• Connect to Real-Time HubSpot Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData Power BI Connector for HubSpot and Dataflow to import and use HubSpot in Power Apps.

• Integrate Live Snapchat Ads Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Snapchat Ads to Blue Prism using the CData ODBC Driver for Snapchat Ads to create automated workflows for repetitive business tasks.

• Access Live SAP Netweaver Gateway Data in AWS Lambda

  Connect to live SAP Netweaver Gateway in AWS Lambda using the CData JDBC Driver.

• Build QuickBooks-Powered Applications in Claude Code with CData MCP Server

  Use the CData MCP Server for QuickBooks to explore live QuickBooks Data in Claude Code to assist with building QuickBooks-powered applications.

• How to use SQLAlchemy ORM to access PayPal Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of PayPal.

• Access Phoenix 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 Apache Phoenix.

• Connect to Sage Cloud Accounting from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Sage Cloud Accounting to connect to Sage Business Cloud Accounting from Web applications running on WebLogic.

• Moving Data from Chargebee to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live Chargebee data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• Build Amazon S3-Powered Applications in Gemini Code Assist with CData MCP Server

  Use the CData MCP Server for Amazon S3 to explore live Amazon S3 Data in Gemini Code Assist to assist with building Amazon S3-powered applications.

• Build Visualizations of Tally Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Tally ERP in Birst.

• Use Agno to Talk to Your PayPal Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your PayPal for you.

• Use JayDeBeApi to access Email Data in Python

  Use standard Python scripting and the development environment of your choice to access live Email.

• Getting Started with the CData ODBC Driver for SAP Fieldglass

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP Fieldglass.

• Connect to Parquet Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Parquet to connect to Apache Parquet and execute queries in PowerBuilder.

• How to Query Live SAP ByDesign Data in Claude Desktop

  Connect to and query live SAP ByDesign Data in Claude Desktop using CData MCP Server.

• Model Instagram Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Instagram, enabling the direct import of real-time Instagram.

• AfterShip Reporting in OBIEE with the AfterShip JDBC Driver

  Deploy the AfterShip JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Access Live Zoho Creator Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Zoho Creator from your Excel spreadsheets.

• Connect to Oracle SCM Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to Oracle SCM as an External Source in Dremio.

• Automate DB2 Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live IBM DB2 and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Analyze Intercom Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Intercom from Power Pivot. You will use the Table Import Wizard to load Intercom. You can visually build the import query or use any SQL supported by the driver.

• Getting Started with the CData SSIS Components for HBase

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for HBase.

• Visualize Live Twitter Ads Data in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live Twitter Ads into custom reports in Power BI.

• Access Live Dropbox Data in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Dropbox from your Google Sheets.

• DataBind Controls to Factorial Data in C++Builder

  DataBind to Factorial in C++Builder with standard components and controls.

• Connect to Printful Data from a Connection Pool in Jetty

  The Printful JDBC Driver supports connection pooling: This article shows how to connect faster to Printful from Web apps in Jetty.

• Analyze OData Services in R via JDBC

  Use standard R functions and the development environment of your choice to analyze OData with the CData JDBC Driver for OData.

• Build Charts with Rootly Data in Clear Analytics

  Create dynamic charts and perform analytics based on Rootly in Clear Analytics.

• A PostgreSQL Interface for Freshservice Data (MySQL Remoting via JDBC)

  Use the Remoting features of the Freshservice JDBC Driver to create a PostgreSQL entry-point for data access.

• Access Live Excel Online Data in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live Microsoft Excel Online from your Excel spreadsheets.

• Build AI Agents with MariaDB 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 MariaDB through CData Connect AI.

• Publish Reports with Jira Assets Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Jira Assets.

• Build Automated Workflows with Live Neo4J Data in Workato

  Use CData Connect AI to connect to live Neo4J and build automated workflows in Workato.

• How to Connect to Live Hive 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 Apache Hive through natural language.

• Access Live Onfleet Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Onfleet into the statistical analysis tools available in SAS JMP. This article shows how to use Onfleet in the Graph Builder and Query Builder.

• How to Access Scrapfly Data Using Entity Framework

  This article shows how to access Scrapfly using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• How to connect and process RSS Feeds from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live RSS Feeds.

• Create Data Visualizations Based On Exact Online Data in Mode

  Use CData Connect AI to connect to Exact Online Data from Mode and build visualizations using live

• Automated Continuous Oracle SCM Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Oracle SCM replication to delimited files (CSV/TSV).

• DataBind Controls to SAP Business Warehouse Data in C++Builder

  DataBind to SAP Business Warehouse in C++Builder with standard components and controls.

• Create ZeroBounce Dataflows on PowerBI.com

  Connect to the CData Power BI Connector for ZeroBounce from PowerBI.com to create Power BI Dataflows with real-time data.

• Replicate Procore Data from PowerShell

  Write a quick PowerShell script to query Procore. Use connectivity to the live data to replicate Procore to SQL Server.

• Use the CData Software ODBC Driver for Workable in SAS for Real-Time Reporting and Analytics

  Connect to real-time Workable in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Workable.

• Publish Reports with ADP Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date ADP.

• Excel Spreadsheet Automation on Invoiced Data with the QUERY Formula

  Pull data from Invoiced, automate spreadsheets, and more with the QUERY formula.

• Create JobNimbus Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time JobNimbus data access from reports, embedded analytics, and more.

• How to Build an ETL App for LionDesk Data in Python with CData

  Create ETL applications and real-time data pipelines for LionDesk in Python with petl.

• How to Create Power BI Visual Reports with Real-Time Adobe Commerce Data

  Use CData Power BI Connectors to visualize Adobe Commerce in Power BI.

• Automate Notion Data Replication to SAP HANA

  Use CData Sync to customize and automate Notion replication to SAP HANA.

• Connect to Salesloft Data from a Connection Pool in JBoss

  Integrate Salesloft into Java servlets: Use the Management Console in JBoss to install the Salesloft JDBC Driver.

• Query Trello Data in ColdFusion

  Write standard ColdFusion data access code to connect to Trello.

• Integrate Open WebUI with Live EnterpriseDB Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live EnterpriseDB from within the chat interface.

• Access Live Shopify Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Shopify from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Prepare, Blend, and Analyze QuickBooks Data in Alteryx Designer (ODBC)

  Build workflows to access live QuickBooks Desktop for self-service data analytics.

• «
• 903
• 904
• 905
• 906
• 907
• 908
• 909
• 910
• 911
• 912
• »