CData Software - Knowledge Base

Recent Articles

---

• «
• 668
• 669
• 670
• 671
• 672
• 673
• 674
• 675
• 676
• 677
• »

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

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

• Integrating Kiro CLI with Excel 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.

• Automated Continuous Tanda Replication to MySQL

  Use CData Sync for automated, continuous, customizable Tanda replication to MySQL.

• Query Azure Analysis Services Data as a MySQL Database in Node.js

  Execute MySQL queries against Azure Analysis Services from Node.js.

• How to integrate Metabase with Marketo Data

  Use CData Connect AI to connect to live Marketo and create an interactive dashboard in Metabase from Marketo.

• Import Real-Time Front Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Front in ColdFusion.

• Integrate Ontraport with JetBrains RubyMine using CData JDBC Drivers

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

• Create Informatica Mappings From/To a JDBC Data Source for Shopify

  Create Shopify data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Object-Relational Mapping (ORM) with Amplitude 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 Amplitude into a Java-based ORM framework, Hibernate.

• How to create an RPA flow for MYOB AccountRight Data in UiPath Studio

  Use the MYOB AccountRight ODBC Driver to create workflows that access real-time MYOB AccountRight without any coding.

• Connect to Certinia Data Using the Script Function in Claris FileMaker Pro

  Use the CData ODBC Driver for Certinia and the Script function in FileMaker Pro to connect to Certinia and work with Certinia in your FileMaker application.

• Automate Cvent Tasks in Power Automate Using CData API Server

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

• Using the CData Software ODBC Driver for Perplexity in PyCharm

  Connect to Perplexity as an ODBC data source in PyCharm using the CData Software ODBC Driver for Perplexity.

• Import Real-Time MYOB AccountRight Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use MYOB AccountRight in ColdFusion.

• Connect to Mixpanel Data in CloverDX (formerly CloverETL)

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

• How to connect SharePoint with Smartsheet Data through external lists

  Provide Smartsheet to SharePoint users as an external list.

• Automate Tasks in Power Automate Using the CData API Server

  Automate Spark actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.

• Build MVC Applications with Connectivity to Supabase Data

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

• Publish Crystal Reports on ZohoPeople Data

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ZohoPeople.

• Building Dynamic Web Pages with Google Campaign Manager 360 Data Using AngularJS

  Create single-page applications with live connectivity to Google Campaign Manager 360 using the CData API Server.

• Integrating GitHub Copilot CLI with Omnisend 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.

• DataBind Controls to Cosmos DB Data in C++Builder

  DataBind to Azure Cosmos DB in C++Builder with standard components and controls.

• Publish ADP-Connected Dashboards in Tableau Server via JDBC

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

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

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

• How to create WooCommerce federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for WooCommerce in MySQL .

• Process & Analyze Access Data in Databricks (AWS)

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

• Build Semantic Layer Views for XML Data in APOS Live Data Gateway

  Use the CData Connector for XML in APOS Live Data Gateway to build Semantic Layer Views for XML Files.

• Access Live Microsoft Entra ID Data in SAS JMP via ODBC

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Reply.io

  Provide connectivity to Reply.io through an SAP BusinessObjects universe.

• Create Power BI Reports on Real-Time SendInBlue Data

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

• How to integrate Guru with Apache Airflow

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

• Automated Continuous Hive Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Hive replication to Google BigQuery.

• How to Use a Microsoft Access Database to Update Avalara AvaTax Data in Real Time

  Update Avalara AvaTax data by creating a linked table in Microsoft Access with the CData Avalara AvaTax ODBC Driver.

• Connect to Azure Analysis Services Data in HULFT Integrate

  Connect to Azure Analysis Services as a JDBC data source in HULFT Integrate

• Create Informatica Mappings From/To a JDBC Data Source for Quickbase

  Create Quickbase data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• How to use SQLAlchemy ORM to access Google Translate Data in Python

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

• How to update Oracle from Excel

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

• Connect to MongoDB Data from PowerBuilder via ODBC

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

• Use the CData Software ODBC Driver for Google Contacts in MicroStrategy

  Connect to Google Contacts in MicroStrategy Developer using the CData Software ODBC Driver for Google Contacts.

• Integrate Cline with Live Azure DevOps Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Azure DevOps from within your IDE.

• Connect to Guru in SpagoBI

  Create reports featuring live Guru in SpagoBI Studio. Host Guru reports on SpagoBI Server.

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

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

• How to create Jumpseller federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Jumpseller in MySQL .

• Getting Started with the CData ODBC Driver for Drip

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

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

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

• Connect to Strava Data from Blazor Apps

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

• Design BIRT Reports on Salesforce Pardot Data

  Provide current Salesforce Pardot to your embedded analytics.

• Connect to Shortcut Data in Claris FileMaker Pro

  Use the CData API Driver for ODBC in FileMaker Pro to connect to Shortcut and work with Shortcut in your FileMaker applications.

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

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

• Replicate Parquet Data to Multiple Databases

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

• Easily Integrate Anaplan Data in Lazarus Pascal IDE

  Learn how to easily integrate live Anaplan in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

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

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

• ETL Pinecone in Oracle Data Integrator

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

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

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

• How to Access Chargebee Data Using Entity Framework

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

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

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

• Access ChartMogul Data from MySQL in Amazon QuickSight

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

• Getting Started with the CData SSIS Components for Perigon

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

• Connect to FormSite Data from a Connection Pool in Jetty

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

• Integrate Google

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

• Connect to Flowlu Data in Jaspersoft Studio

  Execute SQL to remote Flowlu in Jaspersoft Studio.

• Automated Continuous FreshBooks Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable FreshBooks replication to Azure SQL Database.

• Use the CData ODBC Driver for Dynamics 365 in Microsoft Power Query

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

• Publish SAP Business One-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live SAP Business One.

• Integrate Cline with Live Basecamp Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Basecamp from within your IDE.

• Connect to FreeAgent from a Connection Pool in WebLogic

  Use the CData JDBC Driver for FreeAgent to connect to FreeAgent from Web applications running on WebLogic.

• Integrate with Microsoft Exchange Data using Apache Camel2

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

• Add Microsoft Ads Data to Informatica Enterprise Data Catalog

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

• Use Agno to Talk to Your NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics for you.

• Connect to EmailOctopus Data in Ruby

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

• Create Data Visualizations in Cognos BI with Freshservice Data

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

• Automated Continuous SAP Netweaver Gateway Replication to MySQL

  Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to MySQL.

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

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

• ETL Landbot in Oracle Data Integrator

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

• Analyze Google Sheets Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Google Sheets and visualize live Google Sheets in Infragistics Reveal.

• How to connect to Invoiced Data with Squirrel SQL client

  Connect to Invoiced and execute queries in the Squirrel SQL Client.

• Automated Continuous Oracle SCM Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Oracle SCM replication to MongoDB.

• Analyze AlloyDB Data in R via JDBC

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

• Automated Continuous SAP Ariba Source Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Google Cloud SQL.

• Build Gumroad-Connected ETL Processes in Google Data Fusion

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

• How to Work with Highrise Data in ETL Validator JDBC

  Connect to Highrise from ETL Validator jobs using the CData Software JDBC Driver.

• Deploy the ADO.NET Provider for GitLab on an SSRS Report Server

  Connect to GitLab from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Build Vault CRM-Connected Apps in Bubble

  Use CData Connect AI to create an OData feed for Vault CRM Data and create custom apps in Bubble.

• Natively Connect to LDAP Objects in PHP via ODBC (Linux)

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

• Integrate AgileCRM Data in the Pentaho Report Designer

  Publish reports based on AgileCRM in the Pentaho BI tool.

• Extract, Transform, and Load Copper Data in Informatica PowerCenter

  Create a simple Workflow for Copper in Informatica PowerCenter.

• Automated Continuous LionDesk Replication to AlloyDB

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

• Use the CData Software JDBC Driver for Marketo in MicroStrategy Web

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

• Process & Analyze SAP SuccessFactors Data in Databricks (AWS)

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

• Connect ZendeskSell to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live ZendeskSell using the CData Python MCP Server.

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

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

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

• Build Data Flows from ShipStation to SQL Server using SSIS

  Easily back up ShipStation to SQL Server using the SSIS components for ShipStation.

• Automated Continuous MongoDB Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable MongoDB replication to Apache Cassandra.

• Build Charts with Google Ad Manager Data in Clear Analytics

  Create dynamic charts and perform analytics based on Google Ad Manager in Clear Analytics.

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

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

• Create Datasets from SAP HANA in Domo Workbench and Build Visualizations of SAP HANA Data in Domo

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

• DataBind Controls to PolarTeamPro Data in C++Builder

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

• Connect to Microsoft Dataverse in SpagoBI

  Create reports featuring live Microsoft Dataverse (CDS) in SpagoBI Studio. Host Microsoft Dataverse reports on SpagoBI Server.

• «
• 668
• 669
• 670
• 671
• 672
• 673
• 674
• 675
• 676
• 677
• »