CData Software - Knowledge Base

Recent Articles

---

• «
• 1337
• 1338
• 1339
• 1340
• 1341
• 1342
• 1343
• 1344
• 1345
• 1346
• »

• How to load Odoo data into Elasticsearch via Logstash

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

• Build FTP-Connected Apps in Choreo

  Use CData Connect AI to connect to FTP Data from Choreo and build custom apps using live FTP Servers.

• Visualize Live SAP Concur Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live SAP Concur using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Import Act-On Data into Microsoft Power Query

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

• How to Access Billsby Data Using Entity Framework

  This article shows how to access Billsby using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Getting Started with the CData Connect AI Python SDK for Cosmos DB

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

• Visualize Live Amazon Marketplace Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Amazon Marketplace.

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

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

• Query EmailOctopus Data in DataGrip

  Create a Data Source for EmailOctopus in DataGrip and use SQL to query live EmailOctopus.

• How to integrate Metabase with Facebook Ads Data

  Use CData Connect AI to connect to live Facebook Ads and create an interactive dashboard in Metabase from Facebook Ads.

• How to Access Live MongoDB Data in Visual Studio Code via Cline

  Run CData MCP Server for MongoDB on Windows Subsytem for Linux (WSL) and connect to live MongoDB from the Cline extension in Visual Studio Code.

• Query Access Data in ColdFusion

  Write standard ColdFusion data access code to connect to Microsoft Access.

• Access Retently Data as a Remote Oracle Database

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

• Getting Started with the CData Tableau Connector for Flowlu

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

• Create Power BI Reports on Real-Time SAP HANA Data

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

• How to load Salesforce CRM Analytics data into Elasticsearch via Logstash

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

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

  Provide connectivity to Delighted through an SAP BusinessObjects universe.

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

• How to create SAP Business One federated tables in MySQL

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

• Integrate AlloyDB Data in the Pentaho Report Designer

  Publish reports based on Google AlloyDB in the Pentaho BI tool.

• Create Oracle Financials Cloud-Connected Business Apps in AppSheet

  Connect to Oracle Financials Cloud Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Oracle Financials Cloud.

• How to Connect to Live Impala Data from OpenAI Python Applications (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Apache Impala through natural language.

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

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

• Perform Batch Operations with Lakebase Data in Apache NiFi

  Connect to Lakebase and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Connect to Microsoft Ads from Asprova with CData Software ODBC Driver for Microsoft Ads

  This article shows how to connect faster to Microsoft Ads data from Asprova.

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

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

• Create Clio Dataflows on PowerBI.com

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

• Connect to Live Google Drive Data in MicroStrategy through CData Connect AI

  Create a live connection to Google Drive Data in CData Connect AI and connect to your Google Drive from MicroStrategy.

• Publish Crystal Reports on Discord Data

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

• Model Vault CRM Data Using Azure Analysis Services

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

• Create Power BI Reports on Real-Time Adobe Commerce Data

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

• Getting Started with the CData ODBC Driver for BenchmarkEmail

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

• A PostgreSQL Interface for Freshdesk Data using the CData ODBC Driver

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

• Validate Certinia Data with QuerySurge

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

• Integrate Live Microsoft Planner Data into Amazon SageMaker Canvas with RDS

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

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

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

• Visualize Zoho Recruit Data in Sisense

  Create an ElastiCube in Sisense app with access to Zoho Recruit.

• Integrate Jira Data into Power Automate Desktop using CData Connect

  CData Connect for Jira Data enables you to integrate Atlassian Jira into workflows built using Microsoft Power Automate Desktop.

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

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

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

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

• Back Up Kintone to SQL Server through SSIS

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

• Connect to Blackbaud FE NXT Data through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with Blackbaud FE NXT Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

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

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

• Build ChartMogul-Connected ETL Processes in Google Data Fusion

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

• Build Semantic Layer Views for Raisers Edge NXT Data in APOS Live Data Gateway

  Use the CData Connector for Raisers Edge NXT in APOS Live Data Gateway to build Semantic Layer Views for Raisers Edge NXT.

• Build Dashboards with Clari Data in Dundas BI

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

• Analyze SAP Fieldglass Data in Cognos Analytics

  Use CData Connect AI to connect to SAP Fieldglass Data from Cognos Analytics and analyze live SAP Fieldglass.

• Extend Google Sheets with Hive Data

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

• Build Charts with Freshdesk Data in Clear Analytics

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

• Publish Crystal Reports on JobNimbus Data

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

• Integrate Google Calendar with External Services using SnapLogic

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

• Integrate Moosend Data in Pentaho Data Integration

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

• A PostgreSQL Interface for Power BI XMLA Data (MySQL Remoting via JDBC)

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

• Create OneNote-Connected Enterprise Applications in OutSystems

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

• Analyze CockroachDB Data in R via ODBC

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

• Connect to Jira Assets Data from a Connection Pool in JBoss

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

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

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

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

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

• Automated Continuous Egnyte Replication to AlloyDB

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

• Connect to Notion from a Connection Pool in WebLogic

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

• Create AlloyDB Reports on JasperReports Server

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

• Natively Connect to CapsuleCRM Data in PHP

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

• Automated Continuous Tickspot Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Tickspot replication to SQL Server.

• Query Bullhorn CRM Data as a MySQL Database in Node.js

  Execute MySQL queries against Bullhorn CRM from Node.js.

• Query iContact Data through ODBC in Node.js

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

• Getting Started with the CData ODBC Driver for ZohoDesk

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

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

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

• Connect to Stack Exchange Data in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Stack Exchange and the SQL Gateway to access Stack Exchange from Google Apps Script.

• Integrate Excel with JetBrains RubyMine using CData JDBC Drivers

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

• Connect to Recurly Data from PowerBuilder via JDBC

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

• Integrate with live Spark Data in Jitterbit

  Use CData Connect AI to connect to and integrate live Apache Spark SQL in Jitterbit.

• Build SAP Business Warehouse-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP Business Warehouse.

• How to Connect to Live Google Campaign Manager 360 Data from Claude Agent SDK (via CData Connect AI)

  Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Google Campaign Manager 360 for you.

• Edit and Search External Databricks Objects in Salesforce Connect

  Use CData Connect AI to securely provide OData feeds of Databricks to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Databricks Data objects that you can access from apps and the dashboard.

• Import Jira Assets Data Using Azure Data Factory

  Use CData Connect AI to connect to Jira Assets Data from Azure Data Factory and import live Jira Assets.

• Excel Spreadsheet Automation on Wistia Data with the QUERY Formula

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

• Connect to Impala Data from Crystal Reports

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

• DataBind SAP Ariba Source Data to the DevExpress Data Grid

  Use the CData ADO.NET Provider for SAP Ariba Source with the DevExpress Windows Forms and Web controls to provide SAP Ariba Source to a chart.

• Build BambooHR-Connected Dashboards Using Zoho Analytics

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

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

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

• Build Semantic Layer Views for Freshservice Data in APOS Live Data Gateway

  Use the CData Connector for Freshservice in APOS Live Data Gateway to build Semantic Layer Views for Freshservice.

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

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

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

• How to import Auth0 Data into Apache Solr

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

• How to Access Discourse Data Using Entity Framework

  This article shows how to access Discourse using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Connect to Quaderno from a Connection Pool in WebLogic

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

• Visualize Salesforce Marketing 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 Salesforce Marketing Cloud into TIBCO Spotfire.

• Integrating Stack Exchange Data in Talend Cloud Data Management Platform

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

• Use the CData API Server in Microsoft Power BI

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

• Use Biml to Build SSIS Tasks to Replicate PagerDuty Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate PagerDuty to SQL Server.

• Back Up Apollo to SQL Server through SSIS

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

• Query ZohoMarketingHub Data as a MySQL Database in Node.js

  Execute MySQL queries against ZohoMarketingHub from Node.js.

• Integrating GitHub Copilot CLI with CloudConvert 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 LDAP Objects in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

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

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

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

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

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

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

• Build Voice Agents in ElevenLabs with access to Live Act CRM Data

  Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Act CRM.

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

• Integrate Open WebUI with Live IBM Informix Data via CData Connect AI

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

• «
• 1337
• 1338
• 1339
• 1340
• 1341
• 1342
• 1343
• 1344
• 1345
• 1346
• »