CData Software - Knowledge Base

Recent Articles

---

• «
• 914
• 915
• 916
• 917
• 918
• 919
• 920
• 921
• 922
• 923
• »

• Create a Data Access Object for Deel Data using JDBI

  A brief overview of creating a SQL Object API for Deel in JDBI.

• Integrate GitLab Data into Power Automate Desktop using CData Connect

  CData Connect for GitLab Data enables you to integrate GitLab into workflows built using Microsoft Power Automate Desktop.

• Extend Google Sheets with Twilio Data

  Make calls to Twilio from Google Apps Script via the API Server.

• Connect to Sentry Data in the Denodo Platform

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

• Automate Autopilot Data Replication to Azure Data Lake

  Use CData Sync to customize and automate Autopilot replication to Azure Data Lake.

• Connect to Salesforce Pardot Data as an External Data Source using PolyBase

  Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Salesforce Pardot.

• How to Visualize SendGrid Data in Python with pandas via CData Connect AI

  Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SendGrid in Python.

• How to Access Shortcut Data Using Entity Framework

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

• Visualize Live LDAP Objects of Power BI Report Builder in Power BI Service

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

• Build Visualizations of Oracle Data in Birst

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

• Query Microsoft Dataverse Data using the OData SDK for PHP

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

• How to connect PolyBase to Azure Synapse

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

• Access Live Sentry Data in AWS Lambda (with IntelliJ IDEA)

  Connect to live Sentry in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Access Live Google Ad Manager Data in Coginiti Pro

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

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

  Execute MySQL queries against CloudConvert from Node.js.

• How to Import Data from QuickBooks Online into Google Sheets

  Import QuickBooks Online into a Google spreadsheet that is automatically refreshed.

• Use Dash to Build to Web Apps on Microsoft Exchange Data

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

• Getting Started with the CData Excel Add-In for Avalara AvaTax

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Avalara AvaTax.

• Visualize Eventbrite Data from Tableau

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

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

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

• Enable the ZohoInvoice JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with ZohoInvoice.

• Getting Started with the CData ODBC Driver for Google Campaign Manager 360

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Campaign Manager 360.

• How to Connect to & Open SAP HANA XS Advanced Data in Microsoft Excel

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

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

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

• How to connect to MYOB AccountRight Data from IntelliJ

  Integrate connectivity to MYOB AccountRight with wizards in IntelliJ.

• How to Query SingleStore Data in MySQL Workbench

  Execute MySQL queries against live SingleStore from MySQL Workbench.

• Getting Started with the CData JDBC Driver for ClickUp

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

• Use the CData ODBC Driver for Microsoft Entra ID in Microsoft Power Query

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

• Connect to Hacker News in SpagoBI

  Create reports featuring live Hacker News in SpagoBI Studio. Host Hacker News reports on SpagoBI Server.

• Replicate ClickTime Data to Multiple Databases via the CData Sync CLI

  Replicate ClickTime to disparate databases with a single configuration.

• How to Query Aha! Data in MySQL Workbench

  Execute MySQL queries against live Aha! from MySQL Workbench.

• Integrate LibreChat with Live Freshdesk Data via CData Connect AI

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

• How to Access Live Oracle Sales Data in Power Automate Desktop via ODBC

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

• Query Paylocity Data in ColdFusion

  Write standard ColdFusion data access code to connect to Paylocity.

• Build an OLAP Cube in SSAS from Cohere Data

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

• Getting Started with the CData JDBC Driver for Redshift

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

• Connect to and Visualize Live ShipStation Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live ShipStation.

• Automate Zendesk Tasks in Power Automate Using CData API Server

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

• Manage OnePageCrm Data in DBArtisan as a JDBC Source

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

• DataBind Controls to SAP SuccessFactors Data in C++Builder

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

• How to connect to eBay Analytics Data with Squirrel SQL client

  Connect to eBay Analytics and execute queries in the Squirrel SQL Client.

• Automated Continuous Quickbase Replication to MySQL

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

• Build Pipelines with Live SurveyMonkey Data in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to SurveyMonkey from Google Cloud Data Fusion, enabling the integration of live SurveyMonkey into the building and management of effective data pipelines.

• Automated Continuous SAP ByDesign Replication to MongoDB

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

• Automated Continuous REST Replication to Azure SQL Database

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

• Connect and Query Live Azure Table Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live Azure Table Storage into Databricks

• Build Cloudant-Connected Web Apps in Servoy

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

• Build MVC Applications with Connectivity to Landbot Data

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

• Build Data Flows from Omnisend to SQL Server using SSIS

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

• How to connect PolyBase to SAS xpt

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

• Integrating Claude Code with Highrise Data via CData Connect AI

  Leverage CData Connect AI to enable Claude Code to securely access and act on Highrise CRM within assisted coding and automated development workflows.

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

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

• Build AI/ML Models with Live Salesforce Data 360 Data using Dataiku

  Connect Salesforce Data 360 Data with Dataiku using the CData JDBC Driver for Salesforce Data 360.

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

• Automated Continuous Nethunt Replication to Amazon Redshift

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

• Create Oracle Service Cloud-Connected Business Apps in AppSheet

  Connect to Oracle Service Cloud Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Oracle Service Cloud.

• Bridge Opsgenie Connectivity with Apache NiFi

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

• Automated Continuous SendInBlue Replication to Databricks

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

• Excel Spreadsheet Automation on Tanda Data with the QUERY Formula

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

• Build Dashboards with Brex Data in DBxtra

  Create dynamic dashboards and perform analytics based on Brex in DBxtra.

• Work with Dynamics 365 Business Central Data in FoxPro

  Load Dynamics 365 Business Central into a FoxPro database. This article includes full code and a walk-through of the process.

• Import and Visualize Wave Financial Data in Power View

  Create data visualizations based on Wave Financial in Excel.

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

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

• Integrating Google Contacts Data in Talend Cloud Data Management Platform

  Connect Google Contacts Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Contacts.

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

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

• Connect to Office 365 Data from a Connection Pool in Jetty

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

• How to Work with MailerLite Data in ETL Validator JDBC

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

• Use Databricks Agent Bricks to Talk to Your eBay Data via CData Connect AI

  Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your eBay for you.

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

  Create a simple Workflow for Paddle in Informatica PowerCenter.

• How to Connect to Sugar CRM Data in Using Python: 6 Steps

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

• Analyze Lakebase Data in Looker

  Use CData Connect AI to connect to Lakebase Data from Looker and build custom apps using live Lakebase.

• Integrate with SharePoint Excel Services Data in JReport Designer

  Create charts and reports based on SharePoint Excel Services in JReport Designer.

• Import and Visualize Shopify Data in Power View

  Create data visualizations based on Shopify in Excel.

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

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

• Build Zendesk-Connected ETL Processes in Google Data Fusion

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

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

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

• A PostgreSQL Interface for Avalara AvaTax Data using the CData ODBC Driver

  Use the SQL Gateway and Avalara AvaTax ODBC Driver to create a PostgreSQL entry-point for data access.

• Connect to ChartMogul Data from PowerBuilder via ODBC

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

• How to connect and process Zuora from Azure Databricks

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

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

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

• Build Voice Agents in ElevenLabs with access to Live Facebook Ads Data

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

• How to Import Data from Cloudant into Google Sheets

  Import IBM Cloudant into a Google spreadsheet that is automatically refreshed.

• Use the CData Software ODBC Driver for ZohoInvoice in MicroStrategy Web

  Connect to ZohoInvoice in MicroStrategy Web using the CData Software ODBC Driver for ZohoInvoice.

• Analyze Presto Data in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of Presto and visualize Presto in SAP Analytics Cloud.

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

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

• Automated Continuous Kafka Replication to Apache Cassandra

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

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

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

• Create Presto-Connected Business Apps in AppSheet

  Connect to Presto Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Presto.

• Connect to Tavily Data in CloverDX (formerly CloverETL)

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

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

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

• Build Dashboards with SQL Analysis Services Data in Dundas BI

  Create dynamic dashboards and perform analytics based on SQL Analysis Services in Dundas BI.

• Automated Continuous SAP HANA XS Advanced Replication to SQLite

  Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to SQLite.

• Integrating Claude Code with Salesforce Pardot Data via CData Connect AI

  Leverage CData Connect AI to enable Claude Code to securely access and act on Salesforce Pardot within assisted coding and automated development workflows.

• Use the CData Software ODBC Driver for Databricks in MicroStrategy Web

  Connect to Databricks in MicroStrategy Web using the CData Software ODBC Driver for Databricks.

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

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

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

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

• Integrating Cursor CLI with Salesforce Data 360 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.

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

• Getting Started with the CData ADO.NET Provider for Acumatica

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

• «
• 914
• 915
• 916
• 917
• 918
• 919
• 920
• 921
• 922
• 923
• »