CData Software - Knowledge Base

Recent Articles

---

• «
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• 51
• »

• Excel Spreadsheet Automation on PostgreSQL Data with the QUERY Formula

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

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

• Use the CData API Server in Microsoft Power BI

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

• Connecting GenSpark with GitLab Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to GitLab without any replication or custom integration required.

• Transfer Google Contacts to Dynamics CRM

  Never manually copy your Google contacts into CRM again! With the CData SSIS components, you can automatically synchronize Dynamics CRM with your customer and lead information no matter where it resides, without manually copying data.

• Use the CData ODBC Driver for Amazon Athena from SharePoint Excel Services

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

• Connect to OData Services in ACL Analytics

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

• Use the CData Software ODBC Driver for ServiceDesk Plus in MicroStrategy

  Connect to ServiceDesk Plus in MicroStrategy Developer using the CData Software ODBC Driver for ServiceDesk Plus.

• Integrate Webex with JetBrains RubyMine using CData JDBC Drivers

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

• How to update SendGrid from Excel

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

• How to Query Live Rebilly Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Rebilly data in natural language using Python.

• Create Reports with Webex Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Webex.

• Build a PostgreSQL Interface for Drift Data using the CData JDBC Driver

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

• Visualize Live Facebook Data in the Power BI Service

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

• DataBind Controls to Harvest Data in Delphi

  DataBind to Harvest in Delphi with standard data access components and controls.

• Access Live MarkLogic Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to MarkLogic from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Connect to JotForm Data in DBeaver

  Use the CData ODBC Driver to connect to JotForm in DBeaver.

• Build a PostgreSQL Interface for Access Data using the CData JDBC Driver

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

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

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

• Import and Visualize PostgreSQL Data in Power View

  Create data visualizations based on PostgreSQL in Excel.

• Build Dashboards with Oracle SCM Data in Dundas BI

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

• Automated Continuous Perplexity Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Perplexity replication to PostgreSQL.

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

• Access Workday Data from MySQL in Amazon QuickSight

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

• Connect to Azure Table Data from HeidiSQL

  Use CData Connect AI to connect to and query live Azure Table Storage from HeidiSQL.

• Build a Simple VCL Application for Sage 200 Data

  How to build a simple VCL Application to view Sage 200 in RAD Studio using the CData ODBC Driver for Sage 200.

• How to import HCL Domino Data into Apache Solr

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

• Build Automated Workflows with Live FTP Data in Workato

  Use CData Connect AI to connect to live FTP Servers and build automated workflows in Workato.

• Bridge Grafana Connectivity with Apache NiFi

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

• Manage ZohoDesk Data in DBArtisan as a JDBC Source

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

• Connect to SAP Ariba Source Data in DBeaver

  Use the CData ODBC Driver to connect to SAP Ariba Source in DBeaver.

• Create Power BI Reports on Real-Time DocuSign Data

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

• Build Dashboards with Workable Data in DBxtra

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

• Connect to ChargeOver Data in JRuby

  Create a simple JRuby app with access to live ChargeOver.

• Access Live Shippo Data in Coginiti Pro

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

• Provide OData Services of Yelp Data from a WCF Application

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

• Automate ConvertAPI Tasks in Power Automate Using CData API Server

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

• Connect to and Visualize Live Snapchat Ads Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Snapchat Ads.

• Automate Tasks in Power Automate Using the CData API Server

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

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

  Create an ODBC connection to Microsoft Planner in Informatica and browse and transfer Microsoft Planner.

• Connect to Salesforce Data 360 Data from a Connection Pool in Jetty

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

• Getting Started with the CData Python Connector for Sage Intacct

  Learn to install and license the CData Python Connector

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

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

• Natively Connect to PagerDuty Data in PHP

  The CData ODBC driver for PagerDuty enables you to create PHP applications with connectivity to PagerDuty. Leverage the native support for ODBC in PHP.

• Create Power BI Reports on Real-Time Highrise Data

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

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

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

• Object-Relational Mapping (ORM) with Mode 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 Mode into a Java-based ORM framework, Hibernate.

• Use the CData Software ODBC Driver for MailerLite in MicroStrategy Desktop

  Connect to MailerLite in MicroStrategy Desktop using the CData Software ODBC Driver for MailerLite.

• How to connect Amazon QuickSight to Phoenix Data

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

• Access ServiceDesk Plus 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 ServiceDesk Plus.

• Build Airtable-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for Airtable Data and create custom apps in Mendix.

• Connect to Google Contacts Data in CloverDX (formerly CloverETL)

  Transfer Google Contacts using the visual workflow in the CloverDX data integration tool.

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

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

• Connect to DB2 Data in Airbyte ELT Pipelines

  Use CData Connect AI to build ELT pipelines for IBM DB2 in Airbyte.

• A PostgreSQL Interface for Sugar CRM Data using the CData ODBC Driver

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

• Visualize Zoho Inventory 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 Zoho Inventory into TIBCO Spotfire.

• ETL Email in Oracle Data Integrator

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

• Connect to Attio Data in DBeaver

  Use the CData ODBC Driver to connect to Attio in DBeaver.

• Getting Started with the CData Python Connector for Cloudant

  Learn to install and license the CData Python Connector

• Automated Continuous SAP Business One Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable SAP Business One replication to Apache Cassandra.

• Process & Analyze Figshare Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Figshare Data.

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

• Freshteam Reporting and Star Schemas in OBIEE

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

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Avalara AvaTax within intelligent workflows.

• Connect Azure Data Lake Storage to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Azure Data Lake Storage using the CData Python MCP Server.

• Validate Zoho Creator Data with QuerySurge

  Access and validate Zoho Creator in QuerySurge using the CData JDBC Driver.

• Integrate Cursor with Live MongoDB Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live MongoDB from within the editor.

• How to connect to Bitbucket Data with Squirrel SQL client

  Connect to Bitbucket and execute queries in the Squirrel SQL Client.

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

  Replicate Mode to disparate databases with a single configuration.

• Back Up Adobe Commerce to SQL Server through SSIS

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

• Explore Geographical Relationships in Google Calendar Data with Power Map

  Create data visualizations with Google Calendar in Power Map.

• Connect to SendInBlue Data from PowerBuilder via JDBC

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

• Replicate Confluence Data to Multiple Databases

  Replicate Atlassian Confluence to disparate databases with a point-and-click configuration.

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

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

• Integrate MarkLogic Data in Pentaho Data Integration

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

• Provide OData Services of Kafka Data from a WCF Application

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

• Automated Epicor Kinetic Data Replication to Teradata

  Use CData Sync to Customize and automate Epicor Kinetic replication to Teradata.

• Process & Analyze Greenhouse Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Greenhouse Data.

• Visualize Salesforce Data 360 Data in TIBCO Spotfire through ADO.NET

  Integrate Salesforce Data 360 into dashboards in TIBCO Spotfire.

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

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

• Build an OLAP Cube in SSAS from Omnisend Data

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

• Automated Continuous Sage Intacct Data Replication to OneLake in Microsoft Fabric

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

• Bidirectional Access to Microsoft OneDrive Data from FileMaker Pro

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

• Connect to Amplitude Data in RazorSQL

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

• Connect to Zoho Recruit Data in Ruby

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

• Create Twitter Ads-Connected Visualizations in Klipfolio

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

• How to use SQLAlchemy ORM to access Zoho Creator Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zoho Creator.

• Connect to ZohoDesk Data in CloverDX (formerly CloverETL)

  Transfer ZohoDesk using the visual workflow in the CloverDX data integration tool.

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

• Visualize Avaza Data in Sisense

  Create an ElastiCube in Sisense app with access to Avaza.

• Query Pipedrive Data from Node.js

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

• Publish Sage Cloud Accounting-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Sage Business Cloud Accounting.

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

  Provide connectivity to SendGrid through an SAP BusinessObjects universe.

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

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

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

  Replicate Bugsnag to disparate databases with a single configuration.

• Access Live Jira Assets Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Jira Assets from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Visualize Workable Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Workable.

• Automated Continuous Supabase Replication to MySQL

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

• Query Monday.com Data using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Monday.com entities in PHP by modeling them as objects.

• Connect to Nuclia Data in Aqua Data Studio

  Access Nuclia from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• «
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• 51
• »