CData Software - Knowledge Base

Recent Articles

---

• «
• 802
• 803
• 804
• 805
• 806
• 807
• 808
• 809
• 810
• 811
• »

• Visualize Google Analytics Data in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Google Analytics into TIBCO Spotfire.

• Create a Data Access Object for JotForm Data using JDBI

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

• Access Live Google Ad Manager Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Google Ad Manager into the statistical analysis tools available in SAS JMP. This article shows how to use Google Ad Manager in the Graph Builder and Query Builder.

• Getting Started with the CData Python Connector for Freshdesk

  Learn to install and license the CData Python Connector

• Provide OData Services of SAP BusinessObjects BI Data from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for SAP BusinessObjects BI by developing a WCF Service Application.

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

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

• Automate PostgreSQL Tasks in Power Automate Using CData API Server

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

• Integrate with live Power BI XMLA Data in Jitterbit

  Use CData Connect AI to connect to and integrate live Power BI XMLA in Jitterbit.

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

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

• How to Connect MariaDB Data to Gemini Enterprise via CData Connect AI

  Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live MariaDB data in real time using natural language.

• Build MVC Applications with Connectivity to Avalara AvaTax Data

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

• Automated Continuous LinkedIn Ads Replication to Google BigQuery

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

• Bridge SAP Concur Connectivity with Apache NiFi

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

• Create Elasticsearch Dataflows on PowerBI.com

  Connect to the CData Power BI Connector for Elasticsearch from PowerBI.com to create Power BI Dataflows with real-time data.

• How to connect to Campaigner Data from IntelliJ

  Integrate connectivity to Campaigner with wizards in IntelliJ.

• Manage WordPress Data in DBArtisan as a JDBC Source

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

• Integrating Codex CLI with ActiveCampaign 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 Live SQL Server Data from Google ADK Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Microsoft SQL Server for you.

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

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

• Automate Google Ad Manager Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Google Ad Manager from PowerShell? This article demonstrates how to utilize the Google Ad Manager Cmdlets for tasks like connecting to Google Ad Manager, automating operations, downloading data, and more.

• Connect to Google Ad Manager Data in RapidMiner

  Integrate Google Ad Manager with standard components and data source configuration wizards in RapidMiner Studio.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed Square to Power BI dashboards. Simply drag and drop Square into data visuals on the Power BI canvas.

• Connect to BambooHR Data in the Denodo Platform

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

• How to create Intercom federated tables in MySQL

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

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

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

• Integrate LibreChat with Live Raisers Edge NXT Data via CData Connect AI

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

• Automated Continuous Parquet Replication to MongoDB

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

• Integrate Live Google Cloud Storage Data into Custom Business Apps Built in Power Apps

  Use CData Connect AI to connect to Google Cloud Storage and integrate live Google Cloud Storage into apps built in Microsoft Power Apps.

• Build MVC Applications with Connectivity to MailChimp Data

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

• Connect to HubDB Data in the Denodo Platform

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

• Publish Crystal Reports on Workable Data

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

• Use Databricks Agent Bricks to Talk to Your Act-On Data via CData Connect AI

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

• How to integrate Omnisend with Apache Airflow

  Access and process Omnisend in Apache Airflow using the CData JDBC Driver.

• Bridge Rebilly Connectivity with Apache NiFi

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

• Configure the CData JDBC Driver for SAP BusinessObjects BI in a Connection Pool in Tomcat

  Connect to SAP BusinessObjects BI from a connection pool in Tomcat.

• Connect to PayPal Data as an External Source in Dremio

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

• Connect and Visualize Live NetSuite Data in Databricks Lakehouse Federation with CData Connect AI

  Use CData Connect AI to integrate live NetSuite CRM & ERP into the Databricks platform and create visualization dashboards with real-time NetSuite CRM & ERP.

• Visualize Rootly Data in Tableau

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

• Access Live SAP Ariba Source Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate SAP Ariba Source into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Ariba Source in the Graph Builder and Query Builder.

• Analyze Live SAS xpt Data in SAS Viya

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

• Connect to PostgreSQL Data in ACL Analytics

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

• Automated Continuous Intercom Replication to MySQL

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

• How to Work with Hacker News Data in ETL Validator JDBC

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

• How to connect to Coda Data from Spring Boot

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

• Integrating OpenCode Terminal with Float 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.

• Integrate with Live Sage Intacct Data in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to Sage Intacct from the MuleSoft Anypoint Platform to integrate live Sage Intacct into custom reports and dashboards.

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

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

• Integrating LangGraph with Microsoft Entra ID Data via CData Connect AI

  Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Entra ID within automated workflows.

• Visualize Live Salesforce CRM Analytics Data in the Power BI Service

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

• Access Live SharePoint Data in Excel 365 Online (Excel for the web)

  Connect to Microsoft SharePoint from Excel 365 Online (Excel for the web) with CData Connect AI.

• Automated Continuous Facebook Ads Replication to IBM DB2

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

• Bidirectional Access to Salesforce Data from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Salesforce & Force.com in Filemaker Pro for Mac or Windows.

• Connect to ZohoInvoice Data in Ruby

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

• Connect to Unbounce Data as an External Source in Dremio

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

• How to connect to Pingdom Data from Spring Boot

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

• Deploy the ADO.NET Provider for Quickbase on an SSRS Report Server

  Connect to Quickbase from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Connect to Guru from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Guru to connect to Guru from Web applications running on WebLogic.

• Query, Visualize, and Share live Microsoft Entra ID Data in Redash

  Use CData Connect AI to connect to live Microsoft Entra ID in Redash for querying, visualizing, and sharing.

• Getting Started with the CData JDBC Driver for Microsoft Ads

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

• Automate Zoho CRM Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Zoho CRM from PowerShell? This article demonstrates how to utilize the Zoho CRM Cmdlets for tasks like connecting to Zoho CRM, automating operations, downloading data, and more.

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

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

• Integrate with Gong Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live Gong in SnapLogic.

• How to update Box from Excel

  This article explains how to transfer data from Excel to Box using the Excel Add-In for Box.

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

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

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

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

• Connect to Rootly Data in Ruby

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

• Perform Batch Operations with Google Calendar Data in Apache NiFi

  Connect to Google Calendar and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

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

  Create an ODBC connection to Google Drive in Informatica and browse and transfer Google Drive.

• Query Microsoft Exchange Data as a MySQL Database in Node.js

  Execute MySQL queries against Microsoft Exchange from Node.js.

• Model, Search, and Visualize Live Zoho Creator Data in ThoughtSpot

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

• Analyze Google Sheets Data in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Google Sheets and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.

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

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

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

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

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

• Back Up Google AlloyDB to SQL Server through SSIS

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

• Automated Continuous Vertica Replication to Databricks

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

• How to connect to Reckon Accounts Hosted Data from Spring Boot

  Connect to Reckon Accounts Hosted in a Spring Boot Application using the CData JDBC Driver for Reckon Accounts Hosted

• Object-Relational Mapping (ORM) with Gong Data Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Gong into a Java-based ORM framework, Hibernate.

• Integrating Codex CLI with Mistral AI 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 CSV Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate CSV/TSV Files to SQL Server.

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

• Connecting Mastra with Google Sheets Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Google Sheets, no replication required.

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

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

• Rapidly Develop FreeAgent-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by FreeAgent.

• How to Connect to Live IBM Cloud Object Storage Data from OpenAI Python Applications (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your IBM Cloud Object Storage through natural language.

• Connect to Coda Data from PowerBuilder via ODBC

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

• Integrating LangGraph with OneNote Data via CData Connect AI

  Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft OneNote within automated workflows.

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

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

• Integrate Goose with Live HCL Domino Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live HCL Domino from within the local AI agent.

• How to create Exa federated tables in MySQL

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

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

  Execute MySQL queries against Avaza from Node.js.

• Create Zendesk Dataflows on PowerBI.com

  Connect to the CData Power BI Connector for Zendesk from PowerBI.com to create Power BI Dataflows with real-time data.

• Build Visualizations of Salesforce Pardot Data in Birst

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

• Integrate Paymo Data in Pentaho Data Integration

  Build ETL pipelines based on Paymo in the Pentaho Data Integration tool.

• Create Data Visualizations in Cognos BI with OnePageCrm Data

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

• Integrating Antigravity CLI with NetSuite CRM & ERP via CData CLI

  Connect NetSuite CRM & ERP to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• Build an OLAP Cube in SSAS from Exact Online Data

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

• Excel Spreadsheet Automation on WooCommerce Data with the QUERY Formula

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

• Import Oracle SCM Data Using Azure Data Factory

  Use CData Connect AI to connect to Oracle SCM Data from Azure Data Factory and import live Oracle SCM.

• Import Amazon S3 Data into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Amazon S3. In this article, you will use the OData format to import Amazon S3 into Microsoft Power Query.

• «
• 802
• 803
• 804
• 805
• 806
• 807
• 808
• 809
• 810
• 811
• »