CData Software - Knowledge Base

Recent Articles

---

• «
• 1308
• 1309
• 1310
• 1311
• 1312
• 1313
• 1314
• 1315
• 1316
• 1317
• »

• How to update MySQL from Excel

  This article explains how to transfer data from Excel to MySQL using the Excel Add-In for MySQL.

• Integrate LibreChat with Live SAP HANA Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAP HANA from within the chat interface.

• Visualize SQL Analysis Services Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to SQL Analysis Services.

• Connect to Discourse Data in NetBeans

  Connect to Discourse in NetBeans with the data source configuration wizard.

• Integrate with Facebook Data in JReport Designer

  Create charts and reports based on Facebook in JReport Designer.

• Stream Intercom Data into Apache Kafka Topics

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

• How to work with DB2 Data in Apache Spark using SQL

  Access and process DB2 Data in Apache Spark using the CData Software JDBC Driver.

• Create Authorize.Net-Connected Applications in Appsmith

  Connect to Authorize.Net Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Authorize.Net.

• Connect to Amplitude Data from PowerBuilder via JDBC

  This article demonstrates how to access Amplitude from PowerBuilder using the Amplitude JDBC Driver.

• Google Directory Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Google Directory facts in real time.

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

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

• How to integrate SageHR with Apache Airflow

  Access and process SageHR in Apache Airflow using the CData JDBC Driver.

• Connect to OnePageCrm Data from PowerBuilder via JDBC

  This article demonstrates how to access OnePageCrm from PowerBuilder using the OnePageCrm JDBC Driver.

• Access Live ConvertAPI Data in AWS Lambda

  Connect to live ConvertAPI in AWS Lambda using the CData JDBC Driver.

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

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

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

  Use CData API Driver for Power BI and Dataflow to import and use Printify in Power Apps.

• Automated Continuous SAP Concur Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable SAP Concur replication to Amazon Redshift.

• Automated Continuous Amazon Athena Replication to Oracle

  Use CData Sync for automated, continuous, customizable Amazon Athena replication to Oracle.

• Automated Continuous Cosmos DB Replication to SQLite

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

• How to connect to Amplitude Data from IntelliJ

  Integrate connectivity to Amplitude with wizards in IntelliJ.

• Query Jodoo Data as a MySQL Database in Node.js

  Execute MySQL queries against Jodoo from Node.js.

• Trigger HubSpot IFTTT Flows in Azure App Service

  Automate IFTTT (if-this-then-that) workflows for HubSpot with standard wizards in Logic Apps.

• Automate Confluence Tasks in Power Automate Using CData API Server

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

• Automated Klipfolio Data Replication to Teradata

  Use CData Sync to Customize and automate Klipfolio replication to Teradata.

• Getting Started with the CData ADO.NET Provider for MYOB AccountRight

  Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for MYOB AccountRight.

• Query Redis Data from Node.js

  Use the OData endpoint of the CData API Server to connect to your Redis and perform CRUD operations on Redis from Node.js.

• Stream Xero Data into Apache Kafka Topics

  Access and stream Xero Accounting in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Build Splunk-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Splunk.

• LINQ to Ontraport 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 Ontraport Data Provider.

• Create Beeminder Dataflows on PowerBI.com

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

• Publish LightSpeedRetail-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live LightSpeedRetail.

• Design BIRT Reports on Amazon DynamoDB Data

  Provide current Amazon DynamoDB to your embedded analytics.

• LINQ to SAP Fieldglass 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 SAP Fieldglass Data Provider.

• Connect to Demio Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

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

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

• Visualize Google Tasks Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Google Tasks.

• How to Query Live Salesforce Data in Claude Desktop

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

• Use the CData Software JDBC Driver for Pinecone in MicroStrategy

  Connect to Pinecone in MicroStrategy Developer using the CData Software JDBC Driver for Pinecone.

• How to Access Live Adobe Commerce Data in Power Automate Desktop via ODBC

  The CData ODBC Driver for Adobe Commerce enables you to integrate Adobe Commerce into workflows built using Microsoft Power Automate Desktop.

• Add SendInBlue Data to Informatica Enterprise Data Catalog

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

• Use Dash to Build to Web Apps on OpenWeatherMap Data

  Create Python applications that use pandas and Dash to build OpenWeatherMap-connected web apps.

• ETL Exact Online in Oracle Data Integrator

  This article shows how to transfer Exact Online into a data warehouse using Oracle Data Integrator.

• Integrating GitHub Copilot CLI with Power BI XMLA 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.

• View Reports on Real-Time Optimizely Data in Power BI Report Server

  Use the CData ODBC Driver for Optimizely to visualize Optimizely in Power BI Desktop and then publish them to Power BI Report Server.

• Visualize Live OnePageCrm Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live OnePageCrm using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Operational Reporting on Exact Online Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Exact Online.

• Automated Continuous Wrike Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Wrike replication to Amazon S3.

• Connect to Figshare Data from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Figshare using standard SQL.

• ETL Mouseflow in Oracle Data Integrator

  This article shows how to transfer Mouseflow into a data warehouse using Oracle Data Integrator.

• Connect to Zoho Books Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Zoho Books.

• How to connect to Authorize.Net Data from IntelliJ

  Integrate connectivity to Authorize.Net with wizards in IntelliJ.

• Import Real-Time Xero Data via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Xero Accounting in ColdFusion.

• Connect to Miro Data in Ruby

  Connect to Miro in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Perform Batch Operations with Cvent Data in Apache NiFi

  Connect to Cvent and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for JDBC-ODBC Bridge

  Provide connectivity to JDBC-ODBC Bridge through an SAP BusinessObjects universe.

• Create Data Visualizations in Cognos BI with PolarTeamPro Data

  Access PolarTeamPro as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

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

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

• Visualize Couchbase Data in Tableau

  The CData ODBC driver for Couchbase enables you integrate Couchbase into Tableau dashboards.

• Load Amplitude Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Amplitude to a database.

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

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

• Use the CData ODBC Driver for Paymo in Microsoft Power Query

  You can use the CData Paymo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Paymo into Microsoft Power Query.

• How to Design Instagram Power Apps with Database-Like Connectivity

  Gain real-time, database-like connectivity to Instagram from mobile and tablet Power Apps.

• How to connect PolyBase to ADP

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

• Query, Visualize, and Share live Airtable Data in Redash

  Use CData Connect AI to connect to live Airtable in Redash for querying, visualizing, and sharing.

• Viewing Quaderno Data in RAD Studio Data Explorer

  How to view Quaderno in RAD Studio Data Explorer using the CData ODBC Driver for Quaderno.

• Visualize XML Data in TIBCO Spotfire through ADO.NET

  Integrate XML Files into dashboards in TIBCO Spotfire.

• Establish a Live Connection with Postmark Data using Tableau Bridge

  The CData ODBC Driver for Postmark enables you to integrate live Postmark into Tableau Cloud dashboards using the Tableau Bridge.

• Build MVC Applications with Connectivity to Mailgun Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Mailgun from an ASP.NET MVC application.

• Visualize FreeAgent Data in Sisense

  Create an ElastiCube in Sisense app with access to FreeAgent.

• Integrate Greenplum Data into Automated Tasks with Power Automate

  Use CData Connect AI to connect to Pivotal GreenPlum and integrate live Pivotal GreenPlum into your Power Automate tasks.

• Access Snapchat Ads Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Snapchat Ads from your Oracle system.

• Automated Continuous SAP Replication to Databricks

  Use CData Sync for automated, continuous, customizable SAP replication to Databricks.

• Bind Live Redshift Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Redshift data

• Automated Continuous Sybase Replication to Databricks

  Use CData Sync for automated, continuous, customizable Sybase replication to Databricks.

• How to Connect to Datadog Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Datadog. Leverage the pyodbc module for ODBC in Python.

• Automated Continuous SAP Ariba Procurement Replication to Oracle

  Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Oracle.

• Integrate Google Drive with External Services using SnapLogic

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

• Natively Connect to Jodoo Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Jodoo. Leverage the native support for ODBC in PHP.

• Query HCL Domino Data as a MySQL Database in Node.js

  Execute MySQL queries against HCL Domino from Node.js.

• Add PagerDuty Data to Informatica Enterprise Data Catalog

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

• Use the CData Software JDBC Driver for Sage 200 in MicroStrategy

  Connect to Sage 200 in MicroStrategy Developer using the CData Software JDBC Driver for Sage 200.

• Building Dynamic Web Pages with MarkLogic Data Using AngularJS

  Create single-page applications with live connectivity to MarkLogic using the CData API Server.

• Connect to RabbitMQ Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for RabbitMQ.

• Create a Data Access Object for SAP Ariba Source Data using JDBI

  A brief overview of creating a SQL Object API for SAP Ariba Source in JDBI.

• Getting Started with the CData Python Connector for Helpscout

  Learn to install and license the CData Python Connector

• Create Datasets from Snapchat Ads in Domo Workbench and Build Visualizations of Snapchat Ads Data in Domo

  Use the CData Software ODBC Driver for Snapchat Ads to create datasets from Snapchat Ads in Domo Workbench and then build visualizations in the Domo service.

• Integrate with ChargeOver Data using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ChargeOver to a JSON file on disk.

• Integrate Copper Data in Your Informatica Cloud Instance

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

• Process & Analyze ServiceNow Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live ServiceNow Data.

• How to connect PolyBase to PivotalTracker

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

• Load Reckon Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Reckon to a database.

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

  Use CData Power BI Connectors to visualize Todoist in Power BI.

• Query Auth0 Data in ColdFusion

  Write standard ColdFusion data access code to connect to Auth0.

• FTP Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on FTP facts in real time.

• Analyze Humanity Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Humanity in Microsoft R Open.

• Publish Reports with Landbot Data in SAP Crystal Reports

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

• Connect to and Visualize Live Azure DevOps Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure DevOps.

• How to Import Data from Facebook Ads into Google Sheets

  Import Facebook Ads into a Google spreadsheet that is automatically refreshed.

• Access Live Apollo Data in AWS Lambda

  Connect to live Apollo in AWS Lambda using the CData JDBC Driver.

• Publish LightSpeedRetail-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live LightSpeedRetail.

• «
• 1308
• 1309
• 1310
• 1311
• 1312
• 1313
• 1314
• 1315
• 1316
• 1317
• »