CData Software - Knowledge Base

Recent Articles

---

• «
• 529
• 530
• 531
• 532
• 533
• 534
• 535
• 536
• 537
• 538
• »

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

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

• Automated Continuous Codat Replication to Google Cloud SQL

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

• Access Live Zoho Recruit Data in AWS Lambda

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

• Automate Tasks in Power Automate Using the CData API Server

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

• Connect to Highrise Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Highrise CRM in the Denodo Virtual DataPort Administrator.

• Use the CData Software JDBC Driver for Office 365 in MicroStrategy Web

  Connect to Microsoft Office 365 in MicroStrategy Web using the CData Software JDBC Driver for Office 365.

• How to connect to Google Directory Data with Squirrel SQL client

  Connect to Google Directory and execute queries in the Squirrel SQL Client.

• Viewing Active Directory Data in RAD Studio Data Explorer

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

• Connect to JotForm Data in CloverDX (formerly CloverETL)

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

• Analyze Quickbase Data in R via ODBC

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

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

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

• Build Apps with Live MYOB AccountRight in Adalo using CData Connect AI

  Use CData Connect AI to integrate live MYOB AccountRight into the Adalo platform and build custom mobile and web applications with real-time MYOB AccountRight.

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

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

• How to Connect to & Open Supabase Data in Microsoft Excel

  This article uses the CData ODBC driver for Supabase to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Query DB2 Data in ColdFusion

  Write standard ColdFusion data access code to connect to IBM DB2.

• Build MVC Applications with Connectivity to Parallel Data

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

• How to import Gorgias Data into Apache Solr

  Use the CData Software JDBC Driver for Gorgias in Data Import Handler and create an automated import of Gorgias to Apache Solr Enterprise Search platform.

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

• Process & Analyze TaxJar Data in Databricks (AWS)

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

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

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

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

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

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

  Use the CData API Server to connect to live NetSuite CRM & ERP in the Power Pivot business intelligence tool.

• Easily Integrate Google Search Results in Lazarus Pascal IDE

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

• How to Connect to Live BambooHR Data from Gemini CLI (via CData Connect AI)

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

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

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

• Automated Continuous Front Replication to SingleStore

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

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

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

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

  Execute MySQL queries against Codat from Node.js.

• Query Tavily Data in DataGrip

  Create a Data Source for Tavily in DataGrip and use SQL to query live Tavily.

• Automated Continuous SendInBlue Replication to SingleStore

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

• Excel Spreadsheet Automation on JobNimbus Data with the QUERY Formula

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

• Connect to Stripe Data in NetBeans

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

• Automated Continuous Float Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Float replication to Snowflake.

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

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

• Connect to Azure Synapse Data from HeidiSQL

  Use CData Connect AI to connect to and query live Azure Synapse from HeidiSQL.

• Connect to FormSite Data in DBeaver

  Use the CData ODBC Driver to connect to FormSite in DBeaver.

• Viewing Todoist Data in RAD Studio Data Explorer

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

• Building Dynamic Web Pages with Google Ad Manager Data Using AngularJS

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

• Query Azure Data Lake Storage Data as a SQL Server Database in Node.js

  Execute SQL Server queries against Azure Data Lake Storage from Node.js.

• Replicate Multiple Accelo Accounts

  Replicate multiple Accelo accounts to one or many databases.

• Create Power BI Reports on Real-Time Sage 300 Data

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

• Create SSAS Tabular Models from Airtable Data

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

• Query CouchDB Data using the OData SDK for PHP

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

• Integrating GitHub Copilot CLI with Retently 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 FreshBooks Data in Aqua Data Studio

  Access FreshBooks from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Operational Reporting on Klipfolio Data from Spotfire Server

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

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

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

  Use CData ODBC drivers to import and use Azure Synapse in ColdFusion.

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

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

• Automated Continuous HCL Domino Replication to SQLite

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

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

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

• Analyze BigQuery Data in Infragistics Reveal

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

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

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

• Automated Continuous SendPulse Replication to Local Delimited Files

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

• Create Power BI Reports on Real-Time Google Analytics Data

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

• Connect to BigQuery Data in DBeaver

  Use the CData ODBC Driver to connect to Google BigQuery in DBeaver.

• Use the CData Software ODBC Driver for Salesforce CRM Analytics in MicroStrategy Desktop

  Connect to Salesforce CRM Analytics in MicroStrategy Desktop using the CData Software ODBC Driver for Salesforce CRM Analytics.

• Getting Started with the CData ADO.NET Provider for Active Directory

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

• Access Printify Data from MySQL in HeidiSQL

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

• Automated Continuous Cassandra Replication to AlloyDB

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

• Getting Started with the CData SSIS Components for Bright Data

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

• Connect to Adobe Target Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to Xero Data from a Connection Pool in Jetty

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

• Connect to CockroachDB from Excel & GoogleSheets!

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

• Integrate Cosmos DB with External Services using SnapLogic

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

• Analyze Rebilly Data in R via JDBC

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

• Import and Visualize Trello Data in Power View

  Create data visualizations based on Trello in Excel.

• How to Access HubSpot Data Using Entity Framework

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

• Feed Procore Data into FineReport

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

• How to Connect Flowise AI Agents to Live MongoDB 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 MongoDB without replication.

• Working with FreeAgent Data in LINQPad

  Execute LINQ queries to FreeAgent in LINQPad.

• How to Connect to & Open GitHub Data in Microsoft Excel

  This article uses the CData ODBC driver for GitHub to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Use the CData Software JDBC Driver for Procore in MicroStrategy

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

• Use the CData Software ODBC Driver for Delighted in MicroStrategy Desktop

  Connect to Delighted in MicroStrategy Desktop using the CData Software ODBC Driver for Delighted.

• Build MVC Applications with Connectivity to IBM Informix Data

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

• Operational Reporting on Brex Data from Spotfire Server

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

• Build Freshteam-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Freshteam and build web apps with connectivity to live Freshteam.

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

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

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

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

• Edit and Search SAP Netweaver Gateway External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of SAP Netweaver Gateway to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SAP Netweaver Gateway objects that you can access from apps and the dashboard.

• Analyze Zoho Projects Data in Cognos Analytics

  Use CData Connect AI to connect to Zoho Projects Data from Cognos Analytics and analyze live Zoho Projects.

• Integrate Real-Time Access to LinkedIn in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to LinkedIn in real time.

• Integrate Live SAP ByDesign Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live SAP Business ByDesign to Blue Prism using the CData ODBC Driver for SAP ByDesign to create automated workflows for repetitive business tasks.

• Analyze Lakebase Data in Infragistics Reveal

  Use CData Connect AI to create on OData API on top of Lakebase and visualize live Lakebase in Infragistics Reveal.

• Automated Continuous SAP Business One Replication to SQL Server

  Use CData Sync for automated, continuous, customizable SAP Business One replication to SQL Server.

• Choosing the Best Method to Connect Adobe Experience Manager to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Adobe Experience Manager from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

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

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

• Work with Clockify Data in FoxPro

  Load Clockify into a FoxPro database. This article includes full code and a walk-through of the process.

• Connect to Auth0 Data in DBArtisan

  Use wizards in DBArtisan to configure Auth0 as a data source.

• Connect to and Visualize Live Sage 200 Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sage 200.

• Load Spark Data to a Database Using Embulk

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

• Access Dynamics 365 Business Central Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Dynamics 365 Business Central from HeidiSQL.

• Create Reports from Asana Data in Looker Studio

  Use CData Connect AI to gain access to live Asana and create custom reports in Looker Studio.

• Automated Continuous Invoiced Replication to Google BigQuery

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

• Build Dashboards with eBay Data in Dundas BI

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

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

• Query Smartsheet Data using the OData SDK for PHP

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

• How to connect to Sage 300 Data from IntelliJ

  Integrate connectivity to Sage 300 with wizards in IntelliJ.

• Access LightSpeedRetail Data as a Remote Oracle Database

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

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

  Execute MySQL queries against Todoist from Node.js.

• «
• 529
• 530
• 531
• 532
• 533
• 534
• 535
• 536
• 537
• 538
• »