CData Software - Knowledge Base

Recent Articles

---

• «
• 762
• 763
• 764
• 765
• 766
• 767
• 768
• 769
• 770
• 771
• »

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

  Use CData JDBC drivers to import and use PabblySubscriptions data in ColdFusion.

• Integrate Live Campaigner Data into Custom Business Apps Built in Power Apps

  Use CData Connect AI to connect to Campaigner data and integrate live Campaigner data into apps built in Microsoft Power Apps.

• Create DocuSign-Connected Visualizations in Klipfolio

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

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

  Create an ODBC connection to Paylocity in Informatica and browse and transfer Paylocity data.

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

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

• How to Connect to & Open Google Campaign Manager 360 Data in Microsoft Excel

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

• ETL Raisers Edge NXT in Oracle Data Integrator

  This article shows how to transfer Raisers Edge NXT data into a data warehouse using Oracle Data Integrator.

• Analyze Adobe Analytics Data with Power Pivot

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

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

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

• Build Google Drive Visualizations in Tableau Desktop

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

• Replicate Clio Data from PowerShell

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

• Connect to Zoho CRM Data in ACL Analytics

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

• Use the CData Software JDBC Driver for Google Campaign Manager 360 in MicroStrategy Desktop

  Connect to Google Campaign Manager 360 data in MicroStrategy Desktop using the CData Software JDBC Driver for Google Campaign Manager 360.

• Using the CData Software ODBC Driver for Certinia in PyCharm

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

• Automated Continuous Harvest Replication to AlloyDB

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

• Viewing Oracle HCM Cloud Data in RAD Studio Data Explorer

  How to view Oracle HCM Cloud data in RAD Studio Data Explorer using the CData ODBC Driver for Oracle HCM Cloud.

• Create SSAS Tabular Models from Pingdom Data

  How to build a SQL Server Analysis Service Tabular Model from Pingdom data using CData drivers.

• How to Create Power BI Visual Reports with Real-Time Cvent Data

  Use CData Power BI Connectors to visualize Cvent data in Power BI.

• How to load SendGrid data into Elasticsearch via Logstash

  Introducing a simple method to load SendGrid data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

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

• How to Build an ETL App for DB2 Data in Python with CData Connect AI

  Build ETL pipelines that read and write live DB2 data in Python with petl and the CData Connect AI Python SDK.

• Use Manus AI to Talk to Your Box Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Box data.

• Add Azure DevOps Data to Informatica Enterprise Data Catalog

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

• Access Live API Data in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live API data from your Google Sheets.

• Automated Continuous Microsoft Teams Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Microsoft Teams data replication to OneLake in Microsoft Fabric.

• Integrating Antigravity CLI with SAP Fieldglass data via CData CLI

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

• Create Vertica-Connected Business Apps in AppSheet

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

• Access Live Placid Data in AWS Lambda

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

• Integrate with live Bannerbear Data in Jitterbit

  Use CData Connect AI to connect to and integrate live Bannerbear data in Jitterbit.

• Visualize Freshdesk Data in TIBCO Spotfire through ADO.NET

  Integrate Freshdesk data into dashboards in TIBCO Spotfire.

• Automated Continuous Hugging Face Replication to MySQL

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

• Automated Continuous Spark Replication to MySQL

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

• Use CData Connect AI to Access BambooHR Data in Microsoft Power Pivot

  Use CData Connect AI to connect to live BambooHR data in the Power Pivot business intelligence tool.

• Connecting Mastra with Facebook Ads 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 Facebook Ads data, no replication required.

• Create Data Visualizations in Cognos BI with Outreach.io Data

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

• Interact with Live Freshservice Data in Meta Muse via CData Connect AI

  Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Freshservice data.

• Automated Continuous Foursquare Replication to Local Delimited Files

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

• Build SendGrid-Connected Apps in Choreo

  Use CData Connect AI to connect to SendGrid Data from Choreo and build custom apps using live SendGrid data.

• Build Dashboards with Attio Data in Dundas BI

  Create dynamic dashboards and perform analytics based on Attio data in Dundas BI.

• Azure DevOps Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Azure DevOps facts in real time.

• Integrate Pinecone Data in the Pentaho Report Designer

  Publish reports based on Pinecone data in the Pentaho BI tool.

• Automated Continuous Snapchat Ads Replication to AlloyDB

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

• Access Live IBM Cloud Object Storage Data in Excel 365 Online (Excel for the web)

  Connect to IBM Cloud Object Storage data from Excel 365 Online (Excel for the web) with CData Connect AI.

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

  Connect Dynamics NAV data with Mendix to build apps using the CData JDBC Driver for Dynamics NAV.

• ETL VWO in Oracle Data Integrator

  This article shows how to transfer VWO data into a data warehouse using Oracle Data Integrator.

• Work with Live Shortcut Data in Power Query

  Use CData Connect AI to connect to Shortcut data and work with live Shortcut data in Microsoft Power Query.

• Access REST Data from MySQL in HeidiSQL

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

• Getting Started with the CData SSIS Components for Freshteam

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for Freshteam.

• Integrating GitHub Copilot with Salesforce CRM Analytics 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 ClickUp Data using Apache Camel2

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

• Query Live SAS xpt Data in Zed Editor via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live SAS xpt data directly from the development environment.

• Query Apify Data in DataGrip

  Create a Data Source for Apify in DataGrip and use SQL to query live Apify data.

• Interact with Live JSON Data in Meta Muse via CData Connect AI

  Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live JSON services.

• How to Visualize TaxJar Data in Python with pandas

  Use pandas and other modules to analyze and visualize live TaxJar data in Python.

• Build Data Flows from Anaplan to SQL Server using SSIS

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

• Create Hugging Face Dataflows on PowerBI.com

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

• How to connect to SAP Netweaver Gateway Data from Spring Boot

  Connect to SAP Netweaver Gateway in a Spring Boot Application using the CData JDBC Driver for SAP Netweaver Gateway

• Access Live Front Data in Coginiti Pro

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

• Automated Continuous HCL Domino Replication to Oracle

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

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

• How to import Perplexity Data into Apache Solr

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

• Connect to Bitbucket Data from Filemaker Pro (Mac)

  Use CData Connect AI to connect to and query live Bitbucket data from Filemaker Pro on Mac.

• Connect to SAP Business Warehouse Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to SAP Business Warehouse as an External Source in Dremio.

• Back Up Jodoo data to SQL Server through SSIS

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

• Automated Continuous Amazon S3 Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Amazon S3 replication to SQL Server.

• Publish ClickUp-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live ClickUp data.

• How to connect and process Perigon data from Azure Databricks

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

• Connect to Azure Analysis Services Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Azure Analysis Services to connect to Azure Analysis Services data and execute queries in PowerBuilder.

• Connect to Square Data Using the Script Function in Claris FileMaker Pro

  Use the CData ODBC Driver for Square and the Script function in FileMaker Pro to connect to Square and work with Square data in your FileMaker application.

• Rapidly Develop Egnyte-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 Egnyte.

• Use Azure AI Foundry to Talk to Your Act CRM 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 Act CRM data for you.

• Integrate Goose with Live Redshift Data via CData Connect AI

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

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

  Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Azure Synapse data.

• Analyze Moosend Data with Power Pivot

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

• Rapidly Develop Azure DevOps-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 Azure DevOps.

• Configure the CData JDBC Driver for Reckon Accounts Hosted in a Connection Pool in Tomcat

  Connect to Reckon Accounts Hosted data from a connection pool in Tomcat.

• Excel Spreadsheet Automation on FHIR Data with the QUERY Formula

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

• Bidirectional Access to JSON Services from FileMaker Pro

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

• DataBind MongoDB Data to the DevExpress Data Grid

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

• Build MVC Applications with Connectivity to ChartMogul Data

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

• How to Visualize EnterpriseDB Data in Python with pandas

  Use pandas and other modules to analyze and visualize live EnterpriseDB data in Python.

• Automated Continuous SQL Server Replication to Apache Cassandra

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

• Integrate with CapsuleCRM Data in JReport Designer

  Create charts and reports based on CapsuleCRM data in JReport Designer.

• Back Up Zendesk data to SQL Server through SSIS

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

• Configure the CData JDBC Driver for Google Directory in a Connection Pool in Tomcat

  Connect to Google Directory data from a connection pool in Tomcat.

• Bridge FormSite Connectivity with Apache NiFi

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

• How to connect to Reckon Accounts Hosted Data from IntelliJ

  Integrate connectivity to Reckon Accounts Hosted data with wizards in IntelliJ.

• Build Agents in Relevance AI with Access to Live OneNote Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on OneNote data within intelligent agent workflows.

• How to update JSON from Excel

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

• Use Azure AI Foundry to Talk to Your Zoom 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 Zoom data for you.

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

  Create a simple Workflow for Auth0 data in Informatica PowerCenter.

• Working with QuickBooks Time Data in LINQPad

  Execute LINQ queries to QuickBooks Time data in LINQPad.

• Access Live Pipeline CRM Data in SAS JMP via ODBC

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

• How to integrate Google Forms with Apache Airflow

  Access and process Google Forms data in Apache Airflow using the CData JDBC Driver.

• How to connect and process ClickTime data from Azure Databricks

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

• Build Automated Workflows with Live Exact Online Data in Workato

  Use CData Connect AI to connect to live Exact Online data and build automated workflows in Workato.

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

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

• Access ADP Data in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for ADP data.

• Integrate SAP Business One with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate SAP Business One with External Services.

• Build Sage Intacct-Connected Apps in Bubble

  Use CData Connect AI to create an OData feed for Sage Intacct Data and create custom apps in Bubble.

• «
• 762
• 763
• 764
• 765
• 766
• 767
• 768
• 769
• 770
• 771
• »