CData Software - Knowledge Base

Recent Articles

---

• «
• 831
• 832
• 833
• 834
• 835
• 836
• 837
• 838
• 839
• 840
• »

• Access Live Excel Online Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Microsoft Excel Online from your Excel spreadsheets.

• Automated Continuous Trello Replication to Vertica

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

• Explore Geographical Relationships in DocuSign Data with Power Map

  Create data visualizations with DocuSign in Power Map.

• Connect to Aha! Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Integrating Kiro CLI with Azure Synapse 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.

• Integrating HubDB Data in Talend Cloud Data Management Platform

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

• Connect to Anaplan Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Anaplan from Appeon PowerBuilder using the CData ADO.NET Provider for Anaplan.

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

• Explore Geographical Relationships in Strava Data with Power Map

  Create data visualizations with Strava in Power Map.

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

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

• Integrate with Codat Data in JReport Designer

  Create charts and reports based on Codat in JReport Designer.

• Query Microsoft Planner Data from Node.js

  Use the OData endpoint of the CData API Server to connect to your Microsoft Planner and perform CRUD operations on Microsoft Planner from Node.js.

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

• Getting Started with the CData Tableau Connector for Webflow

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

• Connect to Freshdesk Data in RapidMiner

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

• Feed Bullhorn CRM Data into FineReport

  How to set Bullhorn CRM as a JDBC data source in FineReport.

• Use the CData Software JDBC Driver for Bitbucket in MicroStrategy Desktop

  Connect to Bitbucket in MicroStrategy Desktop using the CData Software JDBC Driver for Bitbucket.

• Connect to Zoho Inventory Data from PowerBuilder via JDBC

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

• Integrate Google

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

• How to connect to Smartsheet Data from Spring Boot

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

• Integrating Antigravity CLI with Apache Kafka via CData CLI

  Connect Apache Kafka to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• Automate Salesforce Marketing Tasks in Power Automate Using CData API Server

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

• Connect to Bannerbear in SpagoBI

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

• How to Connect DBeaver to ClickTime via a JDBC Driver

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

• How to use SQLAlchemy ORM to access Power BI XMLA Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Power BI XMLA.

• How to Connect the Power BI Service to SAP ByDesign: Complete Guide

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

• Create Power BI Reports on Real-Time Unbounce Data

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

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

  Replicate Paymo to disparate databases with a single configuration.

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

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

• Write a Simple Go Application to work with Act-On Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Act-On.

• Create Facebook Ads-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to Facebook Ads Data from OutSystems and build custom enterprise apps using live Facebook Ads.

• Replicate Multiple Microsoft OneLake Accounts

  Replicate multiple Microsoft OneLake accounts to one or many databases.

• Connect Oracle Eloqua Reporting to AI Assistants With the CData Python MCP Server

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

• Integrate IBM Informix Data in Pentaho Data Integration

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

• Integrate GetResponse Data in Pentaho Data Integration

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

• Automated Continuous Coinbase Replication to SQLite

  Use CData Sync for automated, continuous, customizable Coinbase replication to SQLite.

• Connect to Freshsales Data in Ruby

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

• DataBind Controls to Raisers Edge NXT Data in Delphi

  DataBind to Raisers Edge NXT in Delphi with standard data access components and controls.

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

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

• How to load Notion data into Elasticsearch via Logstash

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

• Analyze Tanda Data with Power Pivot

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

• Connect to Dropbox Data in HULFT Integrate

  Connect to Dropbox as a JDBC data source in HULFT Integrate

• How to connect to Tavily Data from IntelliJ

  Integrate connectivity to Tavily with wizards in IntelliJ.

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

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

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

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

• Access Databricks Data from MySQL in Amazon QuickSight

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

• Build Dashboards with Optimizely Data in DBxtra

  Create dynamic dashboards and perform analytics based on Optimizely in DBxtra.

• Edit and Search Jira External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of Atlassian Jira to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Jira objects that you can access from apps and the dashboard.

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

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

• How to Connect the Power BI Service to Active Directory: Complete Guide

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

• Connect to Oracle Financials Cloud Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Oracle Financials Cloud from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle Financials Cloud.

• HubDB Reporting in OBIEE with the HubDB JDBC Driver

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

• How to Design BigCommerce Power Apps with Database-Like Connectivity

  Gain real-time, database-like connectivity to BigCommerce from mobile and tablet Power Apps.

• Connect to and Query LionDesk Data in QlikView over ODBC

  Create data visualizations with LionDesk in QlikView.

• Automate Dynamics 365 Business Central Integration Tasks from PowerShell

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

• Integrate Live QuickBooks Time Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live QuickBooks Time to Blue Prism using the CData ODBC Driver for QuickBooks Time to create automated workflows for repetitive business tasks.

• Integrate Teamgate Data in the Pentaho Report Designer

  Publish reports based on Teamgate in the Pentaho BI tool.

• Visualize Live Couchbase Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Couchbase.

• Back Up Sugar CRM to SQL Server through SSIS

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

• Excel Spreadsheet Automation on Freshdesk Data with the QUERY Formula

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

• Edit and Search Outreach.io External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of Outreach.io to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Outreach.io objects that you can access from apps and the dashboard.

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

  Use CData JDBC drivers to import and use Sugar CRM in ColdFusion.

• Integrate Klaviyo Data into Automated Tasks with Power Automate

  Use CData Connect AI to connect to Klaviyo and integrate live Klaviyo into your Power Automate tasks.

• Automate Tasks in Power Automate Using the CData API Server

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

• Automated Continuous Sage Cloud Accounting Replication to Oracle

  Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Oracle.

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

• How to Work with eBay Data in ETL Validator JDBC

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

• Creating ShipStation-Connected Applications in Unqork

  You can use CData Connect AI to feed ShipStation to Unqork and build custom business apps.

• Build Visualizations of Asana Data in Birst

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

• How to import Zoho Books Data into Apache Solr

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

• Build Pipelines with Live SAP SuccessFactors LMS Data in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to SAP SuccessFactors LMS from Google Cloud Data Fusion, enabling the integration of live SAP SuccessFactors LMS into the building and management of effective data pipelines.

• Feed MYOB AccountRight Data into FineReport

  How to set MYOB AccountRight as a JDBC data source in FineReport.

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

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

• How to connect PolyBase to Zoho Recruit

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zoho Recruit.

• How to Import Data from Zoho Creator into Google Sheets

  Import Zoho Creator into a Google spreadsheet that is automatically refreshed.

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

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

  Connect to Couchbase 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.

• Query Live MarkLogic 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 MarkLogic directly from the development environment.

• Migrating data from Twitter Ads to Google BigQuery using CData SSIS Components.

  Easily push Twitter Ads to Google BigQuery using the CData SSIS Tasks for Twitter Ads and Google BigQuery.

• Connect to Pipeline CRM Data in Jaspersoft Studio

  Execute SQL to remote Pipeline CRM in Jaspersoft Studio.

• Publish Printful-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Printful.

• Connect to Aircall Data from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Aircall using standard SQL.

• Extract, Transform, and Load Amazon DynamoDB Data in Informatica PowerCenter

  Create a simple Workflow for Amazon DynamoDB in Informatica PowerCenter.

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

  Connect to Email from a connection pool in Tomcat.

• Analyze Oracle Data in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of Oracle Database and visualize Oracle Database in SAP Analytics Cloud.

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

  Connect to Apache HDFS 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.

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

• Connect to Facebook Ads Data from a Connection Pool in JBoss

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

• Pinterest Reporting in OBIEE with the Pinterest JDBC Driver

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

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

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

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

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

• Integrate Google Tasks Data in Your Informatica Cloud Instance

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

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

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

• Build Dashboards with Procore Data in Dundas BI

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

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

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

• How to Seamlessly Import Pipeline CRM Data into IBM SPSS Modeler

  Integrate Pipeline CRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• How to Connect to Grafana Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Grafana. Leverage the pyodbc module for ODBC in Python.

• Query SageHR Data in ColdFusion

  Write standard ColdFusion data access code to connect to SageHR.

• Automated Continuous REST Replication to Amazon Redshift

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

• Create a Data Access Object for Demio Data using JDBI

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

• «
• 831
• 832
• 833
• 834
• 835
• 836
• 837
• 838
• 839
• 840
• »