CData Software - Knowledge Base

Recent Articles

---

• «
• 999
• 1000
• 1001
• 1002
• 1003
• 1004
• 1005
• 1006
• 1007
• 1008
• »

• Build an OLAP Cube in SSAS from Auth0 Data

  Establish a connection to Auth0 data from SQL Server Analysis Services, and use the Auth0 Data Provider to build OLAP cubes for use in analytics and reporting.

• How to connect to Gmail Data from IntelliJ

  Integrate connectivity to Gmail with wizards in IntelliJ.

• How to Connect to Live SAP Hybris C4C 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 SAP Hybris C4C for you.

• How to update Facebook Ads from Excel

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

• Connect to ZohoPeople Data in JRuby

  Create a simple JRuby app with access to live ZohoPeople.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft SharePoint using the Model Context Protocol.

• Automated Continuous Sendwithus Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Sendwithus replication to Google Cloud SQL.

• How to Work with Retently Data in AWS Glue Jobs Using JDBC

  Connect to Retently from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Create Reports with Sentry Data in SAP Crystal Reports

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

• Analyze Hive Data in Cognos Analytics

  Use CData Connect AI to connect to Hive Data from Cognos Analytics and analyze live Apache Hive.

• Getting Started with the CData JDBC Driver for Close

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Close.

• Use the CData API Server to Access Adobe Analytics Data in Microsoft PowerPivot

  Use the CData API Server to connect to live Adobe Analytics in the Power Pivot business intelligence tool.

• Connect to Beeminder Data in CloverDX (formerly CloverETL)

  Transfer Beeminder using the visual workflow in the CloverDX data integration tool.

• Natively Connect to SAP Hybris C4C Data in PHP via ODBC (Linux)

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

• Build Dashboards with Acumatica Data in DBxtra

  Create dynamic dashboards and perform analytics based on Acumatica ERP in DBxtra.

• Manage Dropbox Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Dropbox.

• Use the CData Software JDBC Driver for Sage 300 in MicroStrategy Web

  Connect to Sage 300 in MicroStrategy Web using the CData Software JDBC Driver for Sage 300.

• How to connect to MailerSend Data in DBVisualizer

  Integrate MailerSend with visual data analysis tools and data connection wizards in DBVisualizer

• Connect to SAP Business Warehouse Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to Access Data in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Access and the SQL Gateway to access Microsoft Access from Google Apps Script.

• Integrate Live Adobe Commerce Data in the Windsurf IDE via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Windsurf

• Automated ZendeskSell Data Replication to Teradata

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

• How to Visualize AfterShip Data in Python with pandas

  Use pandas and other modules to analyze and visualize live AfterShip in Python.

• Integrating Pinecone Data in Talend Cloud Data Management Platform

  Connect Pinecone Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.

• Connect to WooCommerce Data from Filemaker Pro (Mac)

  Use CData Connect AI to connect to and query live WooCommerce from Filemaker Pro on Mac.

• Access Float Data from MySQL in Amazon QuickSight

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

• Create Procore Reports on JasperReports Server

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

• Use Agno to Talk to Your Azure Table 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 Azure Table Storage for you.

• Back Up SendInBlue 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 SendInBlue data.

• DataBind Charts to CampaignMonitor Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to CampaignMonitor from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Replicate Freshservice Data to Multiple Databases

  Replicate Freshservice to disparate databases with a point-and-click configuration.

• Integrate Act-On Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Act-On from Informatica Cloud.

• Viewing FHIR Data in RAD Studio Data Explorer

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

• Use ChatGPT to Talk to Your GraphQL 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 GraphQL for you.

• Connect Azure Synapse Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Azure Synapse using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Create Informatica Mappings From/To an ODBC Data Source for Wave Financial

  Create an ODBC connection to Wave Financial in Informatica and browse and transfer Wave Financial.

• Visualize Live Avalara AvaTax Data in Power BI (via CData Connect AI)

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

• Access Live Outlook Data in Coginiti Pro

  Connect to and query live Outlook from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Connecting Agentforce with Dynamics 365 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 Microsoft Dynamics 365 for you.

• Query Dynamics 365 Business Central Data in DataGrip

  Create a Data Source for Dynamics 365 Business Central in DataGrip and use SQL to query live Dynamics 365 Business Central.

• Bridge Teamwork Connectivity with Apache NiFi

  Access and process Teamwork in Apache NiFi using the CData JDBC Driver.

• Visualize Apify Data in Sisense

  Create an ElastiCube in Sisense app with access to Apify.

• Publish Reports with Moosend Data in SAP Crystal Reports

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

• Integrating OpenCode Terminal with Discord 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.

• Publish FreeAgent-Connected Dashboards in Tableau Server via JDBC

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

• Access MailerLite 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 MailerLite.

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

  Use CData ODBC drivers to import and use Egnyte in ColdFusion.

• How to Connect Flowise AI Agents to Live LinkedIn Data via CData Connect AI

  Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live LinkedIn without replication.

• How to connect PolyBase to JotForm

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

• Build Dashboards with Bannerbear Data in Dundas BI

  Create dynamic dashboards and perform analytics based on Bannerbear in Dundas BI.

• Automated Continuous Sage 300 Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Sage 300 replication to AlloyDB.

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

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

• Connecting Moonlit Workflow with Splunk 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 Splunk in real time.

• Create Hive-Connected Applications in Appsmith

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

• Build Voice Agents in ElevenLabs with access to Live QuickBooks Time Data

  Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live QuickBooks Time.

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

• Replicate Perigon Data from PowerShell

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

• Automated Continuous SuiteCRM Replication to Vertica

  Use CData Sync for automated, continuous, customizable SuiteCRM replication to Vertica.

• Create Stack Exchange Reports on JasperReports Server

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

• Access SAP HANA Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP HANA from your Oracle system.

• Excel Spreadsheet Automation on GitHub Data with the QUERY Formula

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

• Connect to Beeminder Data in Jaspersoft Studio

  Execute SQL to remote Beeminder in Jaspersoft Studio.

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

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

• Build an OLAP Cube in SSAS from Asana Data

  Establish a connection to Asana data from SQL Server Analysis Services, and use the Asana Data Provider to build OLAP cubes for use in analytics and reporting.

• Explore Geographical Relationships in Auth0 Data with Power Map

  Create data visualizations with Auth0 in Power Map.

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

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

• Connect to and Query Factorial Data in QlikView over ODBC

  Create data visualizations with Factorial in QlikView.

• Connect to Teradata Data in RazorSQL

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

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

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

• Integrating OpenCode Terminal with JSON Services 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 Coinbase Data from PowerShell

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

• Write a Simple Go Application to work with Omnisend Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Omnisend.

• Visualize Clio Data in Tableau

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

• Import SharePoint Excel Services Data into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SharePoint Excel Services. In this article, you will use the OData format to import SharePoint Excel Services into Microsoft Power Query.

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

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

• Bidirectional Access to Couchbase Data from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Couchbase in Filemaker Pro for Mac or Windows.

• Model, Search, and Visualize Live Freshdesk Data in ThoughtSpot

  Use CData Connect AI to connect to live Freshdesk for modeling, searching, and visualizing.

• Build Voice Agents in ElevenLabs with access to Live Outreach.io Data

  Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Outreach.io.

• Object-Relational Mapping (ORM) with Salesforce Data 360 Data Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Salesforce Data 360 into a Java-based ORM framework, Hibernate.

• Automate Gmail Tasks in Power Automate Using CData API Server

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

• Integrate with Live MariaDB Data in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to MariaDB from the MuleSoft Anypoint Platform to integrate live MariaDB into custom reports and dashboards.

• Feed Aircall Data into FineReport

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

• Use the CData SSIS Components to Insert New or Update Existing Access Records from SQL Server

  Easily push SQL Server data to Access using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Access or update existing records with data from a SQL Server database.

• Validate LinkedIn Ads Data with QuerySurge

  Access and validate LinkedIn Ads in QuerySurge using the CData JDBC Driver.

• Automated Continuous Presto Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Presto replication to SQL Server.

• Integrating Hugging Face Data in Talend Cloud Data Management Platform

  Connect Hugging Face Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.

• Build ActiveCampaign-Connected ETL Processes in Google Data Fusion

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

• Query Brex Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against Brex from Node.js.

• Connect to Superchat Data from Blazor Apps

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

• Connect to Apollo Data from Blazor Apps

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

• Automated Continuous SharePoint Replication to Vertica

  Use CData Sync for automated, continuous, customizable SharePoint replication to Vertica.

• Create Klaviyo-Connected Dashboards in Grafana

  Connect to Klaviyo Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Klaviyo.

• Build an OLAP Cube in SSAS from Microsoft OneDrive Data

  Establish a connection to Microsoft OneDrive data from SQL Server Analysis Services, and use the Microsoft OneDrive Data Provider to build OLAP cubes for use in analytics and reporting.

• Automated Continuous QuickBooks Replication to Amazon S3

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

• Build AI/ML Models with Live Avaza Data using Dataiku

  Connect Avaza Data with Dataiku using the CData API Driver for JDBC.

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

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

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

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

• Visualize Live PingOne Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live PingOne.

• Getting Started with the CData Tableau Connector for Brex

  Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.

• Query Adobe Target Data in ColdFusion

  Write standard ColdFusion data access code to connect to Adobe Target.

• «
• 999
• 1000
• 1001
• 1002
• 1003
• 1004
• 1005
• 1006
• 1007
• 1008
• »