CData Software - Knowledge Base

Recent Articles

---

• «
• 439
• 440
• 441
• 442
• 443
• 444
• 445
• 446
• 447
• 448
• »

• Integrating Cursor CLI with SQL Analysis Services 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.

• Build a Singer.io Tap for Google Spanner With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Google Spanner data using

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

  Use the CData API Server to connect to live Salesforce & Force.com in the Power Pivot business intelligence tool.

• Access Live BigQuery Data in SAS JMP via ODBC

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

• Build Automated Workflows with Live SharePoint Data in Workato

  Use CData Connect AI to connect to live Microsoft SharePoint and build automated workflows in Workato.

• Validate Salesforce Data 360 Data with QuerySurge

  Access and validate Salesforce Data 360 in QuerySurge using the CData JDBC Driver.

• Create SSAS Tabular Models from Rebilly Data

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

• A PostgreSQL Interface for Google Search Results (MySQL Remoting via JDBC)

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

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

• Use Dash to Build Web Apps on Couchbase Data via CData Connect AI

  Build interactive Dash web apps on live Couchbase using pandas and the CData Connect AI Python SDK.

• Connect to Perigon Data in Aqua Data Studio

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

• How to Connect DBeaver to Aha! via a JDBC Driver

  Manage Aha! with visual tools in DBeaver like the query browser.

• Integrating Codex CLI with Freshdesk 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 Paymo Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Paymo replication to Azure SQL Database.

• Integrate Zoho Creator Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zoho Creator from Informatica Cloud.

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

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

• Integrating Bugsnag Data in Talend Cloud Data Management Platform

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

• Build Visualizations of Codat Data in Birst

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

• Connect to SAP Netweaver Gateway Data from PowerBuilder via ADO.NET

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

• Extend Google Sheets with Salesforce CRM Analytics Data

  Make calls to Salesforce CRM Analytics from Google Apps Script via the API Server.

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

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

• Configuring ODBC Connections in Informatica on Linux

  To connect to CData ODBC Drivers from Informatica on Linux, set the Driver Manager for Linux to unixODBC 2.3.x

• Use the CData Software JDBC Driver for eBay Analytics in MicroStrategy

  Connect to eBay Analytics in MicroStrategy Developer using the CData Software JDBC Driver for eBay Analytics.

• How to Visualize ChartMogul Data in Python with pandas

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

• Connect and Visualize Live Excel Online Data in Databricks Lakehouse Federation with CData Connect AI

  Use CData Connect AI to integrate live Microsoft Excel Online into the Databricks platform and create visualization dashboards with real-time Microsoft Excel Online.

• Connect to ZeroBounce Data in Ruby

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

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

• Use the CData API Server in Microsoft Power BI

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

• Consume Adobe Commerce OData Feeds in PowerBuilder

  This article demonstrates how to consume Adobe Commerce as OData feeds from PowerBuilder using the API Server.

• Create Nuclia Reports on JasperReports Server

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

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

• Build Facebook-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to Facebook Data from Zoho Analytics and import live Facebook.

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

  Connect to Pingdom from a connection pool in Tomcat.

• Analyze PostgreSQL Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze PostgreSQL in Microsoft R Open.

• Build MVC Applications with Connectivity to Sage 200 Data

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

• Query MessageBird Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against MessageBird from Node.js.

• Integrating Gumloop with WooCommerce Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on WooCommerce within automated workflows.

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

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

• How to Connect DBeaver to Clio via a JDBC Driver

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

• Getting Started with the CData Power BI Connector for HDFS

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

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

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

• Automated Continuous Oracle Sales Replication to Google Cloud SQL

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

• Automated Continuous Zoho Books Replication to PostgreSQL

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

• How to connect and process Raisers Edge NXT from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Raisers Edge NXT.

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

• Validate Asana Data with QuerySurge

  Access and validate Asana in QuerySurge using the CData JDBC Driver.

• Automated Continuous Box Replication to Amazon Redshift

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

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

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

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

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

• Access Jumpseller Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Jumpseller from your Oracle system.

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

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

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

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

• Viewing SharePoint Data in RAD Studio Data Explorer

  How to view Microsoft SharePoint in RAD Studio Data Explorer using the CData ODBC Driver for SharePoint.

• Integrating Antigravity CLI with Databricks via CData CLI

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

• Model Azure Synapse Data Using Azure Analysis Services

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

• Connect to Outreach.io Data from PowerBuilder via ADO.NET

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

• Build a Simple VCL Application for Paddle Data

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

• Use the CData Software JDBC Driver for Clio in MicroStrategy Web

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

• HCL Domino REST API Part 1: How to set up the environment

  The first article in an article series that goes over the HCL Domino REST API. This article is a guide for how to get started with and setup the Domino REST API.

• Build Charts with WordPress Data in Clear Analytics

  Create dynamic charts and perform analytics based on WordPress in Clear Analytics.

• Visualize Tally Data in TIBCO Spotfire through ADO.NET

  Integrate Tally ERP into dashboards in TIBCO Spotfire.

• Visualize Rebilly Data in Tableau

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

• Query SAP BusinessObjects BI Data as a MySQL Database in Node.js

  Execute MySQL queries against SAP BusinessObjects BI from Node.js.

• Create Informatica Mappings From/To a JDBC Data Source for Bugsnag

  Create Bugsnag data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Create Twilio-Connected Applications in Appsmith

  Connect to Twilio Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Twilio.

• How to Work with Front Data in AWS Glue Jobs Using JDBC

  Connect to Front from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Build Charts with Amazon DynamoDB Data in Clear Analytics

  Create dynamic charts and perform analytics based on Amazon DynamoDB in Clear Analytics.

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

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

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

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

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

  Connect Apache Parquet with Mendix to build apps using the CData JDBC Driver for Parquet.

• Use Microsoft Copilot Studio to talk to your Microsoft Planner Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Microsoft Planner for you.

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

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

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

  Use CData Power BI Connectors to visualize Act CRM in Power BI.

• Use the CData Software ODBC Driver for ZohoPeople in MicroStrategy

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

• Analyze Square Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Square in Microsoft R Open.

• Integrate Live Cvent Data into Amazon SageMaker Canvas with RDS

  Use CData Connect AI to connect to Cvent from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Cvent.

• Build a Singer.io Tap for ADP With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live ADP data using

• Access Live Sugar CRM Data in Excel 365 Online (Excel for the web)

  Connect to Sugar CRM from Excel 365 Online (Excel for the web) with CData Connect AI.

• Stream Facebook Data into Apache Kafka Topics

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

• Load Stripe Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Stripe to a database.

• Connect to Jira Assets Data from AWS Glue

  Use CData Connect AI to gain access to live Jira Assets from your AWS Glue jobs.

• Build Oracle Service Cloud Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live Oracle Service Cloud and build visualizations in Tableau.

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

  Use CData API Driver for Power BI and Dataflow to import and use Miro in Power Apps.

• Create Informatica Mappings From/To a JDBC Data Source for SAP Netweaver Gateway

  Create SAP Netweaver Gateway data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Query Sage Cloud Accounting Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against Sage Business Cloud Accounting from Node.js.

• A PostgreSQL Interface for Reckon Accounts Hosted Data (MySQL Remoting via JDBC)

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

• Consume Amazon DynamoDB OData Feeds in PowerBuilder

  This article demonstrates how to consume Amazon DynamoDB as OData feeds from PowerBuilder using the API Server.

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

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

• Connect to SageHR Data from Blazor Apps

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

• Visualize SAP Business One Data in Sisense

  Create an ElastiCube in Sisense app with access to SAP Business One.

• Build a Singer.io Tap for Avro With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Avro data using

• Integrate Postmark Data in the Pentaho Report Designer

  Publish reports based on Postmark in the Pentaho BI tool.

• Connect to and Visualize Live Google Calendar Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Calendar.

• Extend Google Sheets with Teradata Data

  Make calls to Teradata from Google Apps Script via the API Server.

• Work with Guru Data in FoxPro

  Load Guru into a FoxPro database. This article includes full code and a walk-through of the process.

• Integrating Wistia Data in Talend Cloud Data Management Platform

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

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

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

• Bidirectional Access to Rebilly Data from FileMaker Pro

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

• Getting Started with the CData Connect AI Python SDK for Sugar CRM

  Install the CData Connect AI Python SDK to read and write live Sugar CRM with standard DB-API 2.0 Python code.

• Replicate Jumpseller Data to Multiple Databases

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

• «
• 439
• 440
• 441
• 442
• 443
• 444
• 445
• 446
• 447
• 448
• »