CData Software - Knowledge Base

Recent Articles

---

• «
• 822
• 823
• 824
• 825
• 826
• 827
• 828
• 829
• 830
• 831
• »

• Analyze Suadeo Data in Infragistics Reveal

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

• Load Airtable Data to a Database Using Embulk

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

• How to Connect to Azure Analysis Services Data in Using Python: 6 Steps

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

• How to connect Amazon QuickSight to QuickBooks Time Data

  Create a connection to QuickBooks Time in CData Connect AI and insert QuickBooks Time into Amazon QuickSight SPICE to build interactive dashboards.

• Use the CData Software ODBC Driver for Microsoft Planner in MicroStrategy Web

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

• Work with SpaceX Data in FoxPro

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

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

  Use CData JDBC drivers to import and use Adobe Commerce in ColdFusion.

• Add Onfleet Data to Informatica Enterprise Data Catalog

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

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

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

• Access Live LinkedIn Data in TIBCO Data Virtualization

  Use the LinkedIn Tibco DV Adapter to create a LinkedIn data source in TIBCO Data Virtualization Studio and gain access to live LinkedIn from your TDV Server.

• Automated Continuous Front Replication to Azure SQL Database

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

• Analyze Beeminder Data in R via ODBC

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

• Build MVC Applications with Connectivity to Onfleet Data

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

• Analyze Microsoft Dataverse Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Microsoft Dataverse from Power Pivot. You will use the Table Import Wizard to load Microsoft Dataverse (CDS). You can visually build the import query or use any SQL supported by the driver.

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

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

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

  Connect Google Ad Manager with Mendix to build apps using the CData JDBC Driver for Google Ad Manager.

• How to connect to Clio Data with Squirrel SQL client

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

• Publish HCL Domino-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live HCL Domino.

• Automated Continuous SAS xpt Replication to Amazon Redshift

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

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Azure Table Storage within intelligent workflows.

• How to Query Live Adobe Analytics Data in Claude Desktop

  Connect to and query live Adobe Analytics Data in Claude Desktop using CData MCP Server.

• How to Work with JDBC-ODBC Bridge Data in ETL Validator JDBC

  Connect to JDBC-ODBC Bridge from ETL Validator jobs using the CData Software JDBC Driver.

• Query, Visualize, and Share live Google Ad Manager Data in Redash

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

• Connect to Retently Data from Blazor Apps

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

• Build Trello-Powered Applications in Claude Code with CData MCP Server

  Use the CData MCP Server for Trello to explore live Trello Data in Claude Code to assist with building Trello-powered applications.

• Connect to Email Data in RapidMiner

  Integrate Email with standard components and data source configuration wizards in RapidMiner Studio.

• Automate Tally Data Replication to SAP HANA

  Use CData Sync to customize and automate Tally ERP replication to SAP HANA.

• Operational Reporting on Printful Data from Spotfire Server

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

• How to connect to Aweber Data from Spring Boot

  Connect to Aweber in a Spring Boot Application using the CData API Driver for JDBC

• Use the CData Software JDBC Driver for Tally in MicroStrategy

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

• How to Easily Query Mistral AI Data in OpenOffice Base

  Connect to Mistral AI data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.

• Excel Spreadsheet Automation on Quickbase Data with the QUERY Formula

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

• Integrating Gumloop with Oracle Service Cloud Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Oracle Service Cloud within automated workflows.

• Replicate Google Search Results from PowerShell

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

• Connect to JDBC-ODBC Bridge Data in HULFT Integrate

  Connect to JDBC-ODBC Bridge as a JDBC data source in HULFT Integrate

• Connect to Simplesat Data as an External Source in Dremio

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

• Replicate Multiple MongoDB Accounts

  Replicate multiple MongoDB accounts to one or many databases.

• Automated Continuous Acumatica Replication to SingleStore

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

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

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

• Getting Started with the CData Power BI Connector for Supabase

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

• How to import Snapchat Ads Data into Apache Solr

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

• How to Work with Klipfolio Data in ETL Validator JDBC

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

• Analyze LightSpeedRetail Data in R via JDBC

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

• How to Connect the Power BI Service to JotForm: Complete Guide

  Connect to the CData Software Power BI Connector for JotForm from PowerBI.com to provide real-time JotForm across the organization.

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

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

• Access Live Act CRM Data in Coginiti Pro

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

• Integrate TigerGraph Data in Your Informatica Cloud Instance

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

• Viewing Hacker News Data in RAD Studio Data Explorer

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

• Automated Continuous Square Replication to IBM DB2

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

• How to create IBM Cloud Object Storage federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for IBM Cloud Object Storage in MySQL .

• How to Query Live IBM Cloud Object Storage Data in Claude Desktop

  Connect to and query live IBM Cloud Object Storage Data in Claude Desktop using CData MCP Server.

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

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

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

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

• How to connect and process Sage 200 from Azure Databricks

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

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

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

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

• Create Dashboards and Visualize Live Amazon DynamoDB Data in Geckoboard

  Use CData Connect AI to connect to live Amazon DynamoDB and create dashboards for real-time monitoring and visualization in Geckoboard.

• Integrate Auth0 with External Services using SnapLogic

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

• Klaviyo Data Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Klaviyo through CData Connect AI using different applications and tools.

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

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

• Enable the Copper JDBC Driver in KNIME

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

• Integrate with Azure Table Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live Azure Table Storage in SnapLogic.

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

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

• How to Connect the Power BI Service to Workday: Complete Guide

  Connect to the CData Software Power BI Connector for Workday from PowerBI.com to provide real-time Workday across the organization.

• Create Sentry Reports on JasperReports Server

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

• How to Connect to Excel Online Data in Using Python: 6 Steps

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

• Automated Continuous Calendly Replication to Apache Kafka

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

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

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

• Create a Data Access Object for Paymo Data using JDBI

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

• Explore Geographical Relationships in Vimeo Data with Power Map

  Create data visualizations with Vimeo in Power Map.

• How to connect Amazon QuickSight to Oracle Data

  Create a connection to Oracle Database in CData Connect AI and insert Oracle Database into Amazon QuickSight SPICE to build interactive dashboards.

• Back Up Act-On to SQL Server through SSIS

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

• Using the CData Software ODBC Driver for Scrapfly in PyCharm

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

• Use the CData ODBC Driver for Google Ad Manager in Microsoft Power Query

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

• How to Query PostgreSQL Data in MySQL Workbench

  Execute MySQL queries against live PostgreSQL from MySQL Workbench.

• Automated Continuous CSV Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable CSV replication to PostgreSQL.

• Access Live Microsoft OneDrive Data in TIBCO Data Virtualization

  Use the Microsoft OneDrive Tibco DV Adapter to create a Microsoft OneDrive data source in TIBCO Data Virtualization Studio and gain access to live Microsoft OneDrive from your TDV Server.

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

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

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

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

• Publish Crystal Reports on Greenhouse Data

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

• Integrating Dataiku with Zoom Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zoom.

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

• Connect to ChartMogul Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for ChartMogul.

• Getting Started with the CData Power BI Connector for Redis

  Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Redis.

• Validate Strava Data with QuerySurge

  Access and validate Strava in QuerySurge using the CData JDBC Driver.

• How to connect PolyBase to Quaderno

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

• Getting Started with the CData ODBC Driver for DB2

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

• Connect to MYOB AccountRight Data from HeidiSQL

  Use CData Connect AI to connect to and query live MYOB AccountRight from HeidiSQL.

• Build Charts with Zoho Inventory Data in Clear Analytics

  Create dynamic charts and perform analytics based on Zoho Inventory in Clear Analytics.

• Automated Continuous Discord Replication to SingleStore

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

• Connect to Amazon S3 Data from Blazor Apps

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

• DataBind AlloyDB Data to the DevExpress Data Grid

  Use the CData ADO.NET Provider for AlloyDB with the DevExpress Windows Forms and Web controls to provide Google AlloyDB to a chart.

• Visualize Chargebee Data in Tableau

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

• Integrating Boomi Agentstudio with Google Sheets Data via CData Connect AI

  Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Sheets, enabling AI agents to act on live enterprise data within your integration and automation workflows.

• Bridge Insightly Connectivity with Apache NiFi

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

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

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

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

  Create an ODBC connection to SAP Concur in Informatica and browse and transfer SAP Concur.

• Connect to SAP Business Warehouse Data in RapidMiner

  Integrate SAP Business Warehouse with standard components and data source configuration wizards in RapidMiner Studio.

• Bridge SAP Netweaver Gateway Connectivity with Apache NiFi

  Access and process SAP Netweaver Gateway in Apache NiFi using the CData JDBC Driver.

• Extract, Transform, and Load HCL Domino Data in Informatica PowerCenter

  Create a simple Workflow for HCL Domino in Informatica PowerCenter.

• «
• 822
• 823
• 824
• 825
• 826
• 827
• 828
• 829
• 830
• 831
• »