CData Software - Knowledge Base

Recent Articles

---

• «
• 755
• 756
• 757
• 758
• 759
• 760
• 761
• 762
• 763
• 764
• »

• Analyze Amazon S3 Data with Power Pivot

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

• Query Acumatica Data in ColdFusion

  Write standard ColdFusion data access code to connect to Acumatica ERP.

• Query RabbitMQ Data in DataGrip

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

• Connect to MYOB AccountRight Data from a Connection Pool in Jetty

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

• Visualize Reckon Data in Tableau

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

• Create Reports from SAP HANA Data in Looker Studio

  Use CData Connect AI to gain access to live SAP HANA and create custom reports in Looker Studio.

• Connect to Microsoft Exchange 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 Microsoft Exchange.

• Automated Continuous TaxJar Replication to Google BigQuery

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

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

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

• Prepare, Blend, and Analyze Monday.com Data in Alteryx Designer (Connect AI)

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

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

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

• Extract, Transform, and Load OData Services in Informatica PowerCenter

  Create a simple Workflow for OData in Informatica PowerCenter.

• How to Work with Typeform Data in ETL Validator JDBC

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

• Build Dashboards with Miro Data in Dundas BI

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

• Access Live Greenhouse Data in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live Greenhouse from your Excel spreadsheets.

• Automate Templated Integration Tasks from PowerShell

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

• How to Connect to Live Oracle Financials Cloud Data from crewAI Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Oracle Financials Cloud for you.

• Connect and Query Live SAP Business One Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live SAP Business One into Databricks

• Connect to and Visualize Live Stack Exchange Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Stack Exchange.

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

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

• How to Visualize Phoenix Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Apache Phoenix in Python.

• Natively Connect to Zendesk Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Zendesk. Leverage the native support for ODBC in PHP.

• Connect to and Visualize Live ZohoInvoice Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live ZohoInvoice.

• Prepare, Blend, and Analyze Freshservice Data in Alteryx Designer (Connect AI)

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

• Feed IBM Cloud Object Storage Data into FineReport

  How to set IBM Cloud Object Storage as a JDBC data source in FineReport.

• How to create PingOne federated tables in MySQL

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

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

• Publish Autopilot-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Autopilot.

• Work with Live WordPress Data in Power Query

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

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

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

• Visualize Live ServiceDesk Plus Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live ServiceDesk Plus.

• How to Connect DBeaver to Nuclia via a JDBC Driver

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

• Use Agno to Talk to Your Jira Assets Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Jira Assets for you.

• Explore Geographical Relationships in Humanity Data with Power Map

  Create data visualizations with Humanity in Power Map.

• Publish Crystal Reports on Active Directory Data

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

• Integrating LlamaIndex with ActiveCampaign Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on ActiveCampaign in real time.

• Connect to Strava Data in RazorSQL

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

• DataBind Charts to ChartMogul Data

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

• Analyze Live OData Services in SAS Viya

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Spotify

  Provide connectivity to Spotify through an SAP BusinessObjects universe.

• Connect to Aircall Data in HULFT Integrate

  Connect to Aircall as a JDBC data source in HULFT Integrate

• Query, Visualize, and Share live Cvent Data in Redash

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

• Trigger SendGrid IFTTT Flows in Azure App Service

  Automate IFTTT (if-this-then-that) workflows for SendGrid with standard wizards in Logic Apps.

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

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

• Replicate Workday Data in Heroku for Use in Salesforce Connect

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

• Create SSAS Tabular Models from FormSite Data

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

• Access Redis Data from MySQL in HeidiSQL

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

• Automated Continuous Copper Data Replication to OneLake in Microsoft Fabric

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

• Access Humanity Data from MySQL in HeidiSQL

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

• How to Access Live Bugsnag Data in Power Automate Desktop via ODBC

  The CData ODBC Driver for Bugsnag enables you to integrate Bugsnag into workflows built using Microsoft Power Automate Desktop.

• Trigger REST IFTTT Flows in Azure App Service

  Automate IFTTT (if-this-then-that) workflows for REST with standard wizards in Logic Apps.

• Provide OData Services of FreeAgent Data from a WCF Application

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

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

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

• Automated Continuous Oracle Sales Replication to Oracle

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

• Build Voice Agents in ElevenLabs with access to Live Monday.com Data

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

• Getting Started with the CData ADO.NET Provider for CloudConvert

  Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.

• Replicate OneNote Data to Multiple Databases via the CData Sync CLI

  Replicate Microsoft OneNote to disparate databases with a single configuration.

• Automated Continuous Dynamics NAV Replication to Amazon Redshift

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

• Getting Started with the CData ODBC Driver for SuiteCRM

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

• Create Sage Intacct Reports on JasperReports Server

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

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

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

• Connect to Paylocity Data in Claris FileMaker Pro

  Use the CData ODBC Driver for Paylocity in FileMaker Pro to connect to Paylocity and work with Paylocity in your FileMaker applications.

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

  Use CData Power BI Connectors to visualize Flowlu in Power BI.

• Connect to iContact Data in Claris FileMaker Pro

  Use the CData API Driver for ODBC in FileMaker Pro to connect to iContact and work with iContact in your FileMaker applications.

• Automate Dynamics NAV Integration Tasks from PowerShell

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

• Build Google Cloud Storage Visualizations in Tableau Desktop

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

• Replicate Exact Online Data from PowerShell

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

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

  Create a simple Workflow for Ontraport in Informatica PowerCenter.

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

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

• Connect to Adobe Analytics Data from Crystal Reports

  Use CData Connect AI to connect to and report on live Adobe Analytics from Crystal Reports.

• Access Testmonitor Data from MySQL in HeidiSQL

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

• How to Connect to Live ActiveCampaign Data in n8n Workflows and Agents (via CData Connect AI)

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

• Automated Continuous GetResponse Replication to Amazon Redshift

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

• Integrate Goose with Live Snapchat Ads Data via CData Connect AI

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

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

  Connect MySQL Data with Dataiku using the CData JDBC Driver for MySQL.

• Create Data Visualizations Based On Databricks Data in Mode

  Use CData Connect AI to connect to Databricks Data from Mode and build visualizations using live

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

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

• How to Visualize Contentful Data in Python with pandas

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

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

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

• How to Work with Customer.io Data in ETL Validator JDBC

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

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

  Use CData JDBC drivers to import and use Brex in ColdFusion.

• Use the CData ODBC Driver for Notion from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Notion to connect to Notion from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Notion in Excel.

• Automated Continuous Tally Replication to Oracle

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

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

  Provide connectivity to MailerSend through an SAP BusinessObjects universe.

• How to connect to Demio Data from IntelliJ

  Integrate connectivity to Demio with wizards in IntelliJ.

• Automated Continuous WooCommerce Replication to Snowflake

  Use CData Sync for automated, continuous, customizable WooCommerce replication to Snowflake.

• Build Data Flows from Zoho Projects to SQL Server using SSIS

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

• Use Grok to Talk to Your Twitter Ads Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Twitter Ads for you.

• Connect to MessageBird Data from PowerBuilder via JDBC

  This article demonstrates how to access MessageBird from PowerBuilder using the MessageBird JDBC Driver.

• Getting Started with the CData Excel Add-In for Toggl

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Toggl.

• Model, Search, and Visualize Live Adobe Analytics Data in ThoughtSpot

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

• Integrate with Oracle Data using Apache Camel2

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

• How to Connect to Live Pipedrive 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 Pipedrive through natural language.

• Seamlessly Bring CSV Data into Retool Using CData Connect AI

  Integrate CSV data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.

• Model Google Search Results Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Search, enabling the direct import of real-time Google Search.

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

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

• Build an OLAP Cube in SSAS from Freshteam Data

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

• Write a Simple Go Application to work with Google Directory Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Directory.

• Replicate Reckon Accounts Hosted Data from PowerShell

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

• How to connect to Marketo Data in DBVisualizer

  Integrate Marketo with visual data analysis tools and data connection wizards in DBVisualizer

• «
• 755
• 756
• 757
• 758
• 759
• 760
• 761
• 762
• 763
• 764
• »