CData Software - Knowledge Base

Recent Articles

---

• «
• 616
• 617
• 618
• 619
• 620
• 621
• 622
• 623
• 624
• 625
• »

• Excel Spreadsheet Automation on HDFS Data with the QUERY Formula

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

• Automate Tasks in Power Automate Using the CData API Server

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

• Access Live Coda Data in AWS Lambda

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

• Load TigerGraph Data to a Database Using Embulk

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

• Connect to REST in SpagoBI

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

• Build Data Flows from GraphQL to SQL Server using SSIS

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

• Create Data Visualizations in Cognos BI with Gorgias Data

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

• How to Work with Retently Data in ETL Validator JDBC

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

• Automated Continuous Marketo Replication to Amazon Redshift

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

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

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

• Automated Continuous ConstantContact Replication to Apache Cassandra

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

• Connect to Instagram Data from a Connection Pool in JBoss

  Integrate Instagram into Java servlets: Use the Management Console in JBoss to install the Instagram JDBC Driver.

• Design BIRT Reports on JDBC-ODBC Bridge Data

  Provide current JDBC-ODBC Bridge to your embedded analytics.

• Zoho Creator Reporting in OBIEE with the Zoho Creator JDBC Driver

  Deploy the Zoho Creator JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• LINQ to Airtable 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 Airtable Data Provider.

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

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

• Connect to ClickUp Data as an External Source in Dremio

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

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

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

• Automate SharePoint Excel Services Tasks in Power Automate Using CData API Server

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

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

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

• Connecting Agentforce with Zoho CRM Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Zoho CRM for you.

• Integrate Google

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

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

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

• Build AI/ML Models with Live Jumpseller Data using Dataiku

  Connect Jumpseller Data with Dataiku using the CData API Driver for JDBC.

• Use Dash to Build Web Apps on Excel Online Data via CData Connect AI

  Build interactive Dash web apps on live Microsoft Excel Online using pandas and the CData Connect AI Python SDK.

• Query Pingdom Data in ColdFusion

  Write standard ColdFusion data access code to connect to Pingdom.

• Automated Continuous Front Replication to Amazon Redshift

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

• Integrating Oracle SCM Data in Talend Cloud Data Management Platform

  Connect Oracle SCM Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle SCM.

• Automated Continuous Facebook Ads Replication to AlloyDB

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

• Automated Continuous Nethunt Replication to Databricks

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

• Build Teradata-Powered Applications in Cursor with CData MCP Server

  Use the CData MCP Server for Teradata to explore live Teradata Data in Cursor to assist with building Teradata-powered applications.

• Build WordPress-Connected Web Apps in Servoy

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

• Build Google Calendar Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live Google Calendar and build visualizations in Tableau.

• Connect to PDFMonkey Data from PowerBuilder via ADO.NET

  This article demonstrates how to access PDFMonkey from Appeon PowerBuilder using the CData API Driver for ADO.NET.

• Integrate LibreChat with Live SAS Data Sets Data via CData Connect AI

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

• Connect to Reckon Accounts Hosted from Asprova with CData Software ODBC Driver for Reckon Accounts Hosted

  This article shows how to connect faster to Reckon Accounts Hosted data from Asprova.

• How to Easily Query Okta Data in OpenOffice Base

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

• Integrating QuickBooks Time Data in Talend Cloud Data Management Platform

  Connect QuickBooks Time Data with Talend Cloud Data Management Platform using the CData JDBC Driver for QuickBooks Time.

• Automated Notion Data Replication to Teradata

  Use CData Sync to Customize and automate Notion replication to Teradata.

• DataBind Charts to Vimeo Data

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

• Excel Spreadsheet Automation on Recurly Data with the QUERY Formula

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

• Use Azure AI Foundry to Talk to Your Azure Synapse Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Azure Synapse for you.

• Integrate Microsoft Teams Data in Your Informatica Cloud Instance

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

• Getting Started with the CData ADO.NET Provider for SAP Hybris C4C

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

• How to connect and process Microsoft Teams from Azure Databricks

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

• Integrate with HelloSign Data using Apache Camel2

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

• Create Data Visualizations in Cognos BI with AgileCRM Data

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

• Integrating GitHub Copilot CLI with Clockify 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 connect to Vimeo Data from IntelliJ

  Integrate connectivity to Vimeo with wizards in IntelliJ.

• Use the CData Software ODBC Driver for CouchDB in MicroStrategy

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

• Replicate Pinterest Data in Heroku for Use in Salesforce Connect

  Replicate Pinterest to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Integrate Live CouchDB Data in the Windsurf IDE via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Windsurf

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

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

• Build an OLAP Cube in SSAS from Attio Data

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

• How to Work with Quickbase Data in ETL Validator JDBC

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

• Use Dash to Build to Web Apps on Keap Data

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

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

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

• Automated Continuous Omnisend Replication to Apache Kafka

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

• Integrate Qualaroo Data in Your Informatica Cloud Instance

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

• How to Visualize Reckon Accounts Hosted 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 Reckon Accounts Hosted in Python.

• How to connect to Monday.com Data with Squirrel SQL client

  Connect to Monday.com and execute queries in the Squirrel SQL Client.

• Connecting GenSpark with Acumatica Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Acumatica ERP without any replication or custom integration required.

• Access Live WordPress Data in TIBCO Data Virtualization

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

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

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

• Connect to Aweber Data in RapidMiner

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

• How to Create Power BI Visual Reports with Real-Time Reply.io Data

  Use CData Power BI Connectors to visualize Reply.io in Power BI.

• DataBind Controls to Instantly Data in C++Builder

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

• Create Apps from SAP Fieldglass Data in Qlik Sense Cloud

  Use CData Connect AI to connect to SAP Fieldglass Data and build apps from live SAP Fieldglass in Qlik Sense Cloud.

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

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

• Connect to Gumroad Data in Jaspersoft Studio

  Execute SQL to remote Gumroad in Jaspersoft Studio.

• Create Klaviyo Reports on JasperReports Server

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

• Extract, Transform, and Load Zoho Creator Data in Informatica PowerCenter

  Create a simple Workflow for Zoho Creator in Informatica PowerCenter.

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

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

• Build a Simple VCL Application for CapsuleCRM Data

  How to build a simple VCL Application to view CapsuleCRM in RAD Studio using the CData ODBC Driver for CapsuleCRM.

• Connect to Placid Data in DBeaver

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

• Automated Continuous Printful Replication to IBM DB2

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

• How to integrate Metabase with Microsoft OneDrive Data

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

• Integrating Salesforce Data in Talend Cloud Data Management Platform

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

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

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

• Access Live Raisers Edge NXT Data in Excel 365 Online (Excel for the web)

  Connect to Raisers Edge NXT from Excel 365 Online (Excel for the web) with CData Connect AI.

• Build Charts with Teamwork Data in Clear Analytics

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

• Build Visualizations of NASA Data in Birst

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

• DataBind Charts to Egnyte Data

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

• DataBind ConvertAPI Data to the DevExpress Data Grid

  Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ConvertAPI to a chart.

• Analyze Customer.io Data in R via ODBC

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

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

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

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

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

• How to connect to ZendeskSell Data from Spring Boot

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

• How to Connect to Live Zoho CRM Data from Sourcegraph Amp (via CData Connect AI)

  Integrate Sourcegraph Amp with CData Connect AI to query and manage live Zoho CRM securely in real time.

• Use the CData Software JDBC Driver for Short.io in MicroStrategy

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

• Import Presto Data into the Power BI Service for Visualizations

  Use CData Connect AI to connect to Presto Data and provide access to live Presto for custom reports in the Power BI Service.

• Build Data Flows from SQL Server to Microsoft Dataverse through SSIS

  Easily push SQL Server data to Microsoft Dataverse using the CData SSIS Tasks for Microsoft Dataverse.

• Model, Search, and Visualize Live DocuSign Data in ThoughtSpot

  Use CData Connect AI to connect to live DocuSign for modeling, searching, and visualizing.

• How to Query Scrapfly Data in MySQL Workbench

  Execute MySQL queries against live Scrapfly from MySQL Workbench.

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

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

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

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

• Load MYOB AccountRight Data to a Database Using Embulk

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

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

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

• How to create Visio diagrams from TaxJar Data

  Automatically update TaxJar with the changes you make to Visio master shapes.

• Integrating LangGraph with Cosmos DB Data via CData Connect AI

  Leverage CData Connect AI to enable LangGraph agents to securely access and act on Azure Cosmos DB within automated workflows.

• «
• 616
• 617
• 618
• 619
• 620
• 621
• 622
• 623
• 624
• 625
• »