CData Software - Knowledge Base

Recent Articles

---

• «
• 601
• 602
• 603
• 604
• 605
• 606
• 607
• 608
• 609
• 610
• »

• Integrating Claude Code CLI with Gorgias 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.

• Moving Data from Google Ad Manager to SQL Server Using Toad Data Point and CData ODBC Driver

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

• DataBind Charts to Azure Data Catalog Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Azure Data Catalog 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.

• Automated Continuous Airtable Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Airtable replication to IBM DB2.

• Use Biml to Build SSIS Tasks to Replicate Zoom Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoom to SQL Server.

• Integrating Antigravity CLI with Demio via CData CLI

  Connect Demio to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• Load Basecamp Data to a Database Using Embulk

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

• Easily Integrate Beeminder Data in Lazarus Pascal IDE

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

• Use the CData Software ODBC Driver for Marketo in MicroStrategy

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

• Connect to MYOB AccountRight 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 MYOB AccountRight.

• Create Reports from Dynamics 365 Business Central Data in Looker Studio

  Use CData Connect AI to gain access to live Dynamics 365 Business Central and create custom reports in Looker Studio.

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

  Create an ODBC connection to Certinia in Informatica and browse and transfer Certinia.

• Access Live Oracle Eloqua Data in AWS Lambda

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

• Integrate Open WebUI with Live SAP BusinessObjects BI Data via CData Connect AI

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

• How to create SAP ByDesign federated tables in MySQL

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

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

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

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

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

• Automated Continuous SAP SuccessFactors Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to IBM DB2.

• Stream Google Campaign Manager 360 Data into Apache Kafka Topics

  Access and stream Google Campaign Manager 360 in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

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

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

• Integrate with Okta Data in JReport Designer

  Create charts and reports based on Okta in JReport Designer.

• Build an OLAP Cube in SSAS from Amazon Marketplace Data

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

• Connect to Spotify Data in RazorSQL

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

• Integrating Telegram Data in Talend Cloud Data Management Platform

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

• Integrate Open WebUI with Live SQL Analysis Services Data via CData Connect AI

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

• Query Mode Data in ColdFusion

  Write standard ColdFusion data access code to connect to Mode.

• How to Access PivotalTracker Data Using Entity Framework

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

• Visualize Dynamics 365 Business Central Data in Tableau

  The CData ODBC driver for Dynamics 365 Business Central enables you integrate Dynamics 365 Business Central into Tableau dashboards.

• A PostgreSQL Interface for SendPulse Data using the CData ODBC Driver

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

• Stream Quickbase Data into Apache Kafka Topics

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

• Build MVC Applications with Connectivity to Delighted Data

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

• Migrating data from Exa to Databricks using CData SSIS Components.

  Easily push Exa to Databricks using the CData SSIS Tasks for Exa and Databricks.

• Excel Spreadsheet Automation on Sybase Data with the QUERY Formula

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

• Process & Analyze GraphQL Data in Databricks (AWS)

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

• Connect to Authorize.Net Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to Authorize.Net as an External Source in Dremio.

• Bridge BigCommerce Connectivity with Apache NiFi

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

• Viewing Square Data in RAD Studio Data Explorer

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

• Bidirectional Access to SAS xpt Data from FileMaker Pro

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

• Work with Live Oracle Eloqua Data in Power Query

  Use CData Connect AI to connect to Oracle Eloqua and work with live Oracle Eloqua in Microsoft Power Query.

• Automated Continuous Microsoft Exchange Replication to Local Delimited Files

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

• Visualize Live Blackbaud FE NXT Data in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live Blackbaud FE NXT into custom reports in Power BI.

• Build Dashboards with Google Tasks Data in DBxtra

  Create dynamic dashboards and perform analytics based on Google Tasks in DBxtra.

• Connect to Pipeline CRM Data in Ruby

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

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

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

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

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

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

  Execute MySQL queries against BambooHR from Node.js.

• Integrate MySQL with JetBrains RubyMine using CData JDBC Drivers

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

• Prepare, Blend, and Analyze Sage Cloud Accounting Data in Alteryx Designer (Connect AI)

  Build workflows to access live Sage Business Cloud Accounting for self-service data analytics.

• Analyze Live GitLab Data in SAS Viya

  Use CData Connect AI to connect to GitLab from SAS Viya and deploy self-service analytics using live GitLab.

• Analyze Calendly Data in R via JDBC

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

• Migrating data from Rootly to Snowflake using CData SSIS Components.

  Easily push Rootly to Snowflake using the CData SSIS Tasks for Rootly and Snowflake.

• Analyze Act CRM Data in R via JDBC

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

• Create Data Visualizations in Cognos BI with Greenplum Data

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

• Process & Analyze SharePoint Excel Services Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live SharePoint Excel Services Data.

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

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

• Query xBase Data through ODBC in Node.js

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

• How to publish and share Harvest Data dashboards with Tableau Server

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

• Working with Spotify Data in LINQPad

  Execute LINQ queries to Spotify in LINQPad.

• How to connect and process Productboard from Azure Databricks

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

• Visualize Rootly Data in Sisense

  Create an ElastiCube in Sisense app with access to Rootly.

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

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

• Bind Live Office 365 Data in Wijmo FlexGrid with CData API Server

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

• Build Automated Workflows with Live Highrise Data in Workato

  Use CData Connect AI to connect to live Highrise CRM and build automated workflows in Workato.

• Visualize Live Trello Data in the Power BI Service

  Use CData Connect AI to connect to live Trello and create custom reports in the Power BI Service through the On-Premises Gateway.

• How to connect to Dropbox Data from IntelliJ

  Integrate connectivity to Dropbox with wizards in IntelliJ.

• Automated Continuous Harvest Replication to Oracle

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Qualaroo

  Provide connectivity to Qualaroo through an SAP BusinessObjects universe.

• Replicate Multiple PostgreSQL Accounts

  Replicate multiple PostgreSQL accounts to one or many databases.

• Work with JotForm Data in FoxPro

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

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

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

• Bridge Power BI XMLA Connectivity with Apache NiFi

  Access and process Power BI XMLA in Apache NiFi using the CData JDBC Driver.

• Back Up Klaviyo to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Klaviyo. In this article, we will employ an SSIS workflow to populate a database with Klaviyo data.

• Build Voice Agents in ElevenLabs with access to Live HubSpot Data

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

• DataBind Charts to IBM Informix Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to IBM Informix 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.

• Integrate Sage Cloud Accounting Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Sage Business Cloud Accounting from Informatica Cloud.

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

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

• Natively Connect to Jira Assets Data in PHP

  The CData ODBC driver for Jira Assets enables you to create PHP applications with connectivity to Jira Assets. Leverage the native support for ODBC in PHP.

• How to Connect DBeaver to Eventbrite via a JDBC Driver

  Manage Eventbrite with visual tools in DBeaver like the query browser.

• Integrating OpenCode Terminal with Google Directory 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 ClickTime Replication to Databricks

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

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

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

• Working with ZohoMarketingHub Data in LINQPad

  Execute LINQ queries to ZohoMarketingHub in LINQPad.

• Create SAS Data Sets-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to SAS Data Sets Data from Klipfolio and build custom visualizations using live SAS Data Sets.

• Access ZohoInvoice Data from MySQL in HeidiSQL

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

• Connect to Couchbase Data in ACL Analytics

  Connect to Couchbase via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Couchbase.

• Choosing the Best Method to Connect SendInBlue to SQL Server: 5 Options Explained

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

• Automated Continuous Asana Replication to SingleStore

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

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

  Use CData Power BI Connector for Klaviyo and Dataflow to import and use Klaviyo in Power Apps.

• Build Data Flows from Microsoft Exchange to SQL Server using SSIS

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

• Connect to CSV Data from a Connection Pool in Jetty

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

• Integrating Antigravity CLI with Azure Analysis Services via CData CLI

  Connect Azure Analysis Services to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• Connect to Teamgate Data from a Connection Pool in Jetty

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

• Build Email-Powered Applications in GitHub Copilot with CData MCP Server

  Use the CData MCP Server for Email to explore live Email Data in GitHub Copilot to assist with building Email-powered applications.

• Connect to Everhour Data in HULFT Integrate

  Connect to Everhour as a JDBC data source in HULFT Integrate

• Integrate Bannerbear Data in Your Informatica Cloud Instance

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

• Build Apps with Live LDAP Objects Using the Low-Code Development Platform of Mendix

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

• Connect to and Visualize Live Google Ads Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Ads.

• Bidirectional Access to Avro Data from FileMaker Pro

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

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

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

• DataBind Controls to Zoom Data in Delphi

  DataBind to Zoom in Delphi with standard data access components and controls.

• «
• 601
• 602
• 603
• 604
• 605
• 606
• 607
• 608
• 609
• 610
• »