CData Software - Knowledge Base

Recent Articles

---

• «
• 422
• 423
• 424
• 425
• 426
• 427
• 428
• 429
• 430
• 431
• »

• How to Work with SAP Business Warehouse Data in AWS Glue Jobs Using JDBC

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

• Connect to Figshare Data in RazorSQL

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

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

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

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

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

• Connecting Agentforce with Amazon Marketplace Data via CData Connect AI MCP Server

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

• Visualize Ontraport Data in Sisense

  Create an ElastiCube in Sisense app with access to Ontraport.

• Integrate Amazon Marketplace Data into Automated Tasks with Power Automate

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

• Automated Continuous Cvent Replication to Apache Kafka

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

• How to Easily Query Excel Online Data in OpenOffice Base

  Connect to Excel Online data in OpenOffice Base using the CData ODBC Driver for Excel Online and generate reports with live data insights.

• Connect to Testmonitor Data in JRuby

  Create a simple JRuby app with access to live Testmonitor.

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

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

• Access Live Google Search Results in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

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

• Load Microsoft Teams Data to a Database Using Embulk

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

• Connect to SAP BusinessObjects BI Data in Claris FileMaker Pro

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

• Build Dashboards with Box Data in DBxtra

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

• Connect to Zoho Creator Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Zoho Creator.

• Connect to HubSpot Data in CloverDX (formerly CloverETL)

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

• Integrating GitHub Copilot CLI with Smartsheet 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 connect to BenchmarkEmail Data with Squirrel SQL client

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

• Explore Geographical Relationships in LDAP Objects with Power Map

  Create data visualizations with LDAP in Power Map.

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

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

• How to Access Live Authorize.Net Data in Power Automate Desktop via ODBC

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

• Migrating data from SAP Ariba Procurement to Snowflake using CData SSIS Components.

  Easily push SAP Ariba Procurement to Snowflake using the CData SSIS Tasks for SAP Ariba Procurement and Snowflake.

• Access Live Monday.com Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Monday.com from your Excel spreadsheets.

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

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

• Build Data Flows from Timely to SQL Server using SSIS

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

• Stream Kintone Data into Apache Kafka Topics

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

• Access Live Avalara AvaTax Data in SAS JMP via ODBC

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

• Getting Started with the CData JDBC Driver for GetResponse

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

• Automated Continuous Freshdesk Replication to Vertica

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

• Connect to Dropbox Data from a Connection Pool in Jetty

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

• Integrate with Presto Data using Apache Camel2

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

• Connect to and Visualize Live HubSpot Data in Tableau Prep

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

• Use the CData Software JDBC Driver for Pipeliner CRM in MicroStrategy Desktop

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

• Connect to SAP Hybris C4C from Asprova with CData Software ODBC Driver for SAP Hybris C4C

  This article shows how to connect faster to SAP Hybris C4C data from Asprova.

• Automated Continuous Testmonitor Replication to Google Cloud SQL

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

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

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

• Integrate with live Oracle Data in Jitterbit

  Use CData Connect AI to connect to and integrate live Oracle Database in Jitterbit.

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

• Import Salesforce CRM Analytics Data into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Salesforce CRM Analytics. In this article, you will use the OData format to import Salesforce CRM Analytics into Microsoft Power Query.

• Build Visualizations of CampaignMonitor Data in Birst

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

• Connect to Auth0 Data in Ruby

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

• Getting Started with the CData ODBC Driver for JobNimbus

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

• Visualize Cassandra Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Apache Cassandra.

• How to Easily Query MailerLite Data in OpenOffice Base

  Connect to MailerLite data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.

• How to Query Live SAP Ariba Source Data in Perplexity MacOS Desktop

  Connect to and query live SAP Ariba Source Data in Perplexity Desktop using CData MCP Server.

• How to Connect Oracle SCM Data to Gemini Enterprise via CData Connect AI

  Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Oracle SCM data in real time using natural language.

• Visualize Everhour Data from Tableau

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

• Visualize Webflow Data from Tableau

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

• Analyze Snapchat Ads Data in Cognos Analytics

  Use CData Connect AI to connect to Snapchat Ads Data from Cognos Analytics and analyze live Snapchat Ads.

• Build Dashboards with PostgreSQL Data in DBxtra

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

• Integrate Live SAP SuccessFactors LMS Data into Custom Business Apps Built in Power Apps

  Use CData Connect AI to connect to SAP SuccessFactors LMS and integrate live SAP SuccessFactors LMS into apps built in Microsoft Power Apps.

• Validate Hacker News Data with QuerySurge

  Access and validate Hacker News in QuerySurge using the CData JDBC Driver.

• Build Azure Analysis Services-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Azure Analysis Services.

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

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

• Automated Continuous Sage 300 Replication to Apache Cassandra

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

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

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

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

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

• Build Oracle HCM Cloud-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle HCM Cloud.

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

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

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

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

• Connect to LeadDesk in SpagoBI

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

• Connect to SurveyMonkey Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to SurveyMonkey as an External Source in Dremio.

• Integrate Goose with Live Authorize.Net Data via CData Connect AI

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

• Build Dashboards with SAS Data Sets Data in DBxtra

  Create dynamic dashboards and perform analytics based on SAS Data Sets in DBxtra.

• Replicate Testmonitor Data in Heroku for Use in Salesforce Connect

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

• Build an OLAP Cube in SSAS from Shippo Data

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

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

  Connect to Apache Spark SQL from Excel 365 Online (Excel for the web) with CData Connect AI.

• Create Kintone Reports on JasperReports Server

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

• Connect to Lakebase Data from a Connection Pool in Jetty

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

• Use the CData Software JDBC Driver for Amplitude in MicroStrategy

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

• Validate FHIR Data with QuerySurge

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

• Integrate Live Avalara AvaTax Data into Amazon SageMaker Canvas with RDS

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

• Query Oracle Sales Data in ColdFusion

  Write standard ColdFusion data access code to connect to Oracle Sales.

• How to load Templated data into Elasticsearch via Logstash

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

• Connect to MongoDB Data from Crystal Reports

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

• Automated Continuous Highrise Replication to Azure SQL Database

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

• How to connect and process Elasticsearch from Azure Databricks

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

• Operational Reporting on Microsoft Dataverse Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Dataverse (CDS).

• How to create Visio diagrams from SAP Business One Data

  Automatically update SAP Business One with the changes you make to Visio master shapes.

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

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

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

• Replicate MailerLite Data from PowerShell

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

• Creating Trello-Connected Applications in Unqork

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

• Connect to Pipedrive Data from Blazor Apps

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

• Connect to NetSuite Data as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live NetSuite CRM & ERP.

• Automated Continuous Apify Data Replication to OneLake in Microsoft Fabric

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

• Validate ClickUp Data with QuerySurge

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

• Use the CData Software ODBC Driver for Dynamics NAV in MicroStrategy Desktop

  Connect to Microsoft Dynamics NAV in MicroStrategy Desktop using the CData Software ODBC Driver for Dynamics NAV.

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

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

• Analyze Couchbase Data in R via ODBC

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

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

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

• Connect to Clari from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Clari to connect to Clari from Web applications running on WebLogic.

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

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

• Build Charts with Oracle Data in Clear Analytics

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

• Build Charts with LionDesk Data in Clear Analytics

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

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

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

• Use Agno to Talk to Your Act CRM 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 Act CRM for you.

• Connect to MariaDB Data Using the Script Function in Claris FileMaker Pro

  Use the CData ODBC Driver for MariaDB and the Script function in FileMaker Pro to connect to MariaDB and work with MariaDB in your FileMaker application.

• DataBind Controls to Freshservice Data in C++Builder

  DataBind to Freshservice in C++Builder with standard components and controls.

• «
• 422
• 423
• 424
• 425
• 426
• 427
• 428
• 429
• 430
• 431
• »