CData Software - Knowledge Base

Recent Articles

---

• «
• 792
• 793
• 794
• 795
• 796
• 797
• 798
• 799
• 800
• 801
• »

• Connect to CockroachDB Data in ACL Analytics

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

• Visualize Paymo Data in TIBCO Spotfire through ADO.NET

  Integrate Paymo into dashboards in TIBCO Spotfire.

• Connect Todoist Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Todoist using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

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

  Provide connectivity to Zoho Projects through an SAP BusinessObjects universe.

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

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

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

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

• Access Live SAP Netweaver Gateway Data in AWS Lambda (with IntelliJ IDEA)

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

• Build Apps with Live WordPress in Adalo using CData Connect AI

  Use CData Connect AI to integrate live WordPress into the Adalo platform and build custom mobile and web applications with real-time WordPress.

• How to create Simplesat federated tables in MySQL

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

• Getting Started with the CData Power BI Connector for Mailgun

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

• Automated Continuous Vertica Replication to Apache Cassandra

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

• How to Connect to & Open Microsoft Entra ID Data in Microsoft Excel

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

• Visualize Live Oracle Service Cloud Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Oracle Service Cloud.

• Access MYOB AccountRight Data from MySQL in Amazon QuickSight

  Connect to MYOB AccountRight and build visualizations of MYOB AccountRight using a MySQL Connection in Amazon QuickSight.

• How to Connect to Live Google Search Results 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 Google Search for you.

• Automated Continuous SageHR Replication to AlloyDB

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

• How to connect and process Dropbox from Azure Databricks

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

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

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

• Getting Started with the CData Power BI Connector for HBase

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

• Getting Started with the CData Tableau Connector for BambooHR

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

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

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

• Getting Started with the CData JDBC Driver for Oracle Eloqua Reporting

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Oracle Eloqua Reporting.

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

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

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

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

• Excel Spreadsheet Automation on REST Data with the QUERY Formula

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

• How to create FormSite federated tables in MySQL

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

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

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

• Automated Continuous Basecamp Replication to Databricks

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

• Integrate LibreChat with Live SAP Fieldglass Data via CData Connect AI

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

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

• Publish SAP Business One-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live SAP Business One.

• Automated Continuous Google Tasks Data Replication to OneLake in Microsoft Fabric

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

• DataBind Datadog Data to the DevExpress Data Grid

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

• Use ChatGPT to Talk to Your SAP Netweaver Gateway Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SAP Netweaver Gateway for you.

• Integrate Autopilot with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate Autopilot with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Autopilot.

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

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

• Automated Continuous AdRoll Replication to AlloyDB

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

• Build an OLAP Cube in SSAS from Ontraport Data

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

• How to integrate Billsby with Apache Airflow

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

• Use the CData API Server to Access JSON Services in Microsoft PowerPivot

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

• Automated Continuous Cloudant Replication to Apache Kafka

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

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

  Leverage the CData Connect AI Remote MCP Server to enable Windsurf

• Publish Crystal Reports on Oracle Eloqua Data

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

• Build Zoho Books-Connected Apps in Bubble

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

• Automated Continuous ClickUp Replication to MongoDB

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

• Integrate Notion with External Services using SnapLogic

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

• Use the CData Software JDBC Driver for Zoho Creator in MicroStrategy Web

  Connect to Zoho Creator in MicroStrategy Web using the CData Software JDBC Driver for Zoho Creator.

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

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

• Feed Oracle Sales Data into FineReport

  How to set Oracle Sales as a JDBC data source in FineReport.

• Getting Started with the CData JDBC Driver for LinkedIn

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

• Build Azure Table-Connected Apps in Bubble

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

• Replicate Bullhorn CRM Data to Multiple Databases via the CData Sync CLI

  Replicate Bullhorn CRM to disparate databases with a single configuration.

• Publish SAS xpt-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live SAS XPORT.

• Using the CData Software ODBC Driver for Factorial in PyCharm

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

• Using the CData Software ODBC Driver for ShipStation in PyCharm

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

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

• Automated Continuous Bugsnag Replication to SingleStore

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

• Integrating LangChain with Google Calendar Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Calendar within automated workflows.

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

  Use CData Power BI Connectors to visualize Avalara AvaTax in Power BI.

• Connect to LionDesk in SpagoBI

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

• How to work with Pipeliner CRM Data in Apache Spark using SQL

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

• How to Connect to Live Zoho Books 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 Zoho Books for you.

• Integrate Open WebUI with Live MarkLogic Data via CData Connect AI

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

• Connect to FHIR Data from PowerBuilder via JDBC

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

• Getting Started with the CData Excel Add-In for Sage Cloud Accounting

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

• Integrating Claude Code CLI with Marketo 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 SAP HANA XS Advanced Data in Jaspersoft Studio

  Execute SQL to remote SAP HANA XS Advanced in Jaspersoft Studio.

• How to Visualize Amazon DynamoDB 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 Amazon DynamoDB in Python.

• How to Work with Paylocity Data in ETL Validator JDBC

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

• Create Miro Dataflows on PowerBI.com

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

• Automate Google Tasks Data Replication to SAP HANA

  Use CData Sync to customize and automate Google Tasks replication to SAP HANA.

• Create Datasets from Okta in Domo Workbench and Build Visualizations of Okta Data in Domo

  Use the CData Software ODBC Driver for Okta to create datasets from Okta in Domo Workbench and then build visualizations in the Domo service.

• Model Oracle Data Using Azure Analysis Services

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

• Create Power BI Reports on Real-Time Omnisend Data

  Use the CData ODBC Driver for Omnisend to visualize Omnisend in Power BI Desktop.

• How to connect to xBase Data from IntelliJ

  Integrate connectivity to xBase with wizards in IntelliJ.

• Integrate LibreChat with Live Sage Cloud Accounting Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Sage Business Cloud Accounting from within the chat interface.

• Connect to Cloudant Data in NetBeans

  Connect to IBM Cloudant in NetBeans with the data source configuration wizard.

• Create Reports from Amazon Athena Data in Looker Studio

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

• Use the CData Software ODBC Driver for Typeform in SAS for Real-Time Reporting and Analytics

  Connect to real-time Typeform in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Typeform.

• Automated Continuous SAP Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable SAP replication to Google Cloud SQL.

• Integrate Clockify Data in the Pentaho Report Designer

  Publish reports based on Clockify in the Pentaho BI tool.

• Automate Google Spanner Data Replication to Azure Synapse

  Use CData Sync to customize and automate Google Spanner replication to Azure Synapse.

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

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

• Create Dynamic RSS Grids Using the Infragistics XamDataGrid

  Learn how you can connect RSS to Infragistics XamDataGrid to build dynamic grids.

• Integrate LibreChat with Live SendGrid Data via CData Connect AI

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

• Connect to Live SingleStore Data in PostGresSQL Interface through CData Connect AI

  Create a live connection to SingleStore in CData Connect AI and connect to your SingleStore from PostgreSQL.

• Stream Helpscout Data into Apache Kafka Topics

  Access and stream Helpscout in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Connect to Salesforce Marketing Data in RapidMiner

  Integrate Salesforce Marketing Cloud with standard components and data source configuration wizards in RapidMiner Studio.

• Provide OData Services of Oracle Service Cloud Data from a WCF Application

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

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

  Connect to Acumatica ERP 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.

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

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

• Feed SparkPost Data into FineReport

  How to set SparkPost as a JDBC data source in FineReport.

• Automate Excel Online Integration Tasks from PowerShell

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

• Visualize ZohoPeople Data in Sisense

  Create an ElastiCube in Sisense app with access to ZohoPeople.

• How to connect Amazon QuickSight to Amazon Marketplace Data

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

• Create Data Visualizations in Cognos BI with OneNote Data

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

• Integrating Cursor CLI with PDFMonkey 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.

• Create Google Campaign Manager 360-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to Google Campaign Manager 360 Data from Klipfolio and build custom visualizations using live Google Campaign Manager 360.

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

  Provide connectivity to Zoho Recruit through an SAP BusinessObjects universe.

• How to Work with Excel Data in ETL Validator JDBC

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

• «
• 792
• 793
• 794
• 795
• 796
• 797
• 798
• 799
• 800
• 801
• »