CData Software - Knowledge Base

Recent Articles

---

• «
• 774
• 775
• 776
• 777
• 778
• 779
• 780
• 781
• 782
• 783
• »

• How to connect to Access Data in DBVisualizer

  Integrate Microsoft Access with visual data analysis tools and data connection wizards in DBVisualizer

• Back Up GitHub to SQL Server through SSIS

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

• Connect Cohere to IBM WebSphere Using the CData JDBC Driver

  Use the CData JDBC Driver to connect Cohere with IBM WebSphere for seamless data integration and connectivity.

• How to create Asana federated tables in MySQL

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

• Analyze Slack Data in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Slack and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.

• Access Live FormSite Data in SAS JMP via ODBC

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

• Use CData Connect AI to Access Facebook Ads Data in Microsoft Power Pivot

  Use CData Connect AI to connect to live Facebook Ads in the Power Pivot business intelligence tool.

• Query Contentful Data through ODBC in Node.js

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

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

• Analyze Missive Data in R via ODBC

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

• Bridge Avro Connectivity with Apache NiFi

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

• Replicate ClickUp Data to Multiple Databases

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

• Analyze Blackbaud FE NXT Data in R via ODBC

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

• How to Import Data from Authorize.Net into Google Sheets

  Import Authorize.Net into a Google spreadsheet that is automatically refreshed.

• Create a Data Access Object for Facebook Ads Data using JDBI

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

• Connect to SharePoint Data in HULFT Integrate

  Connect to SharePoint as a JDBC data source in HULFT Integrate

• Connect to GraphQL Data in Jaspersoft Studio

  Execute SQL to remote GraphQL in Jaspersoft Studio.

• Natively Connect to Blackbaud FE NXT Data in PHP

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

• Automated Continuous Clio Data Replication to OneLake in Microsoft Fabric

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

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

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

• DataBind Charts to SendInBlue Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to SendInBlue from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Integrate Wave Financial Data in Pentaho Data Integration

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

• Connect to CampaignMonitor Data from PowerBuilder via JDBC

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

• Extend Google Sheets with IBM Informix Data

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

• Automated Continuous Azure Blob Storage Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to OneLake in Microsoft Fabric.

• Feed Power BI XMLA Data into FineReport

  How to set Power BI XMLA as a JDBC data source in FineReport.

• Connect to MySQL in SpagoBI

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

• Getting Started with the CData Connect AI Python SDK for Zoom

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

• Automated Continuous Amazon S3 Data Replication to OneLake in Microsoft Fabric

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

• Getting Started with the CData Power BI Connector for SAP ByDesign

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

• Access Live Office 365 Data in AWS Lambda

  Connect to live Microsoft Office 365 in AWS Lambda using the CData JDBC Driver.

• Automated Continuous Google Sheets Replication to Azure SQL Database

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

• Extract, Transform, and Load Demio Data in Informatica PowerCenter

  Create a simple Workflow for Demio in Informatica PowerCenter.

• Integrate Reckon Accounts Hosted with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Reckon Accounts Hosted with External Services.

• Read SSL Certificates in Amazon S3 with the CData AWS Glue Connector

  Learn how to access SSL certificates stored in Amazon S3 using the CData AWS Glue Connector for secure data integration.

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

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

• Build FTP-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live FTP Servers.

• Automated Continuous ZohoDesk Replication to MySQL

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

• Automated Continuous SAP HANA XS Advanced Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to AlloyDB.

• Connect to Keap Data in Claris FileMaker Pro

  Use the CData API Driver for ODBC in FileMaker Pro to connect to Keap and work with Keap in your FileMaker applications.

• Integrate with Live Amazon S3 Data in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to Amazon S3 from the MuleSoft Anypoint Platform to integrate live Amazon S3 into custom reports and dashboards.

• Back Up eBay to SQL Server through SSIS

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

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

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

• Integrate JSON Services into Automated Tasks with Power Automate

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

• Integrate Real-Time Access to Reckon Accounts Hosted in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Reckon Accounts Hosted in real time.

• How to connect PolyBase to SAP Business One

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Business One.

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

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

• Working with ZohoInvoice Data in LINQPad

  Execute LINQ queries to ZohoInvoice in LINQPad.

• Create Data Visualizations in Cognos BI with ClickUp Data

  Access ClickUp as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Build Phoenix-Connected Apps in Mendix

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

• Connect to SAP Netweaver Gateway Data in CloverDX (formerly CloverETL)

  Transfer SAP Netweaver Gateway using the visual workflow in the CloverDX data integration tool.

• Build Apps with Live Oracle Financials Cloud Data Using the Low-Code Development Platform of Mendix

  Connect Oracle Financials Cloud with Mendix to build apps using the CData JDBC Driver for Oracle Financials Cloud.

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

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

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

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

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

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

• How to connect Amazon QuickSight to Odoo Data

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

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

• Access Invoiced 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 Invoiced.

• Access Adobe Target 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 Adobe Target.

• How to create Rootly federated tables in MySQL

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

• Automate Tasks in Power Automate Using the CData API Server

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

• How to Import Data from Office 365 into Google Sheets

  Import Microsoft Office 365 into a Google spreadsheet that is automatically refreshed.

• Create Power BI Reports on Real-Time Eventbrite Data

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

• Automate Pingdom Data Replication to Couchbase

  Use CData Sync to Customize and automate Pingdom replication to Couchbase.

• Integrate with Live CockroachDB Data in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to CockroachDB from the MuleSoft Anypoint Platform to integrate live CockroachDB into custom reports and dashboards.

• How to Connect the Power BI Service to Salesforce CRM Analytics: Complete Guide

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

• Connect to Kafka Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Apache Kafka in the Denodo Virtual DataPort Administrator.

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

  Use the CData API Server to connect to live Dropbox in the Power Pivot business intelligence tool.

• Freshservice Data Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Freshservice through CData Connect AI using different applications and tools.

• Integrating LlamaIndex with Zoho CRM Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Zoho CRM in real time.

• Connect to Gmail from a Connection Pool in WebLogic

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

• Automate Reckon Accounts Hosted Tasks in Power Automate Using CData API Server

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

• Integrate Cline with Live ServiceNow Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live ServiceNow from within your IDE.

• Integrating Claude Code CLI with Discourse 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.

• Access Live Zoho Books Data in AWS Lambda (with IntelliJ IDEA)

  Connect to live Zoho Books in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Easily Integrate OData Services in Lazarus Pascal IDE

  Learn how to easily integrate live OData in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Automated Continuous Paylocity Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Paylocity replication to Google BigQuery.

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

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

• How to publish and share ZarMoney Data dashboards with Tableau Server

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

• Use the CData Software ODBC Driver for Strava in MicroStrategy

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

• Feed Parquet Data into FineReport

  How to set Apache Parquet as a JDBC data source in FineReport.

• Integrating Cursor CLI with GitHub 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 Facebook Data with QuerySurge

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

• Use JayDeBeApi to access JotForm Data in Python

  Use standard Python scripting and the development environment of your choice to access live JotForm.

• Getting Started with the CData ODBC Driver for Dynamics 365

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

• Automated Continuous Klaviyo Replication to Apache Kafka

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

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

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

• How to publish and share Dynamics CRM Data dashboards with Tableau Server

  The CData ODBC driver for Dynamics CRM enables you integrate Microsoft Dynamics CRM into Tableau dashboards.

• Query, Visualize, and Share live Office 365 Data in Redash

  Use CData Connect AI to connect to live Microsoft Office 365 in Redash for querying, visualizing, and sharing.

• Manage Google Cloud Storage Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Google Cloud Storage.

• Integrate with Vercel Data in JReport Designer

  Create charts and reports based on Vercel in JReport Designer.

• How to Work with ShipStation Data in ETL Validator JDBC

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

• Access Live GitLab Data in Coginiti Pro

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

• Create Informatica Mappings From/To a JDBC Data Source for Blackbaud FE NXT

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

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

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

• Build Pipelines with Live JSON Services in Google Cloud Data Fusion (via CData Connect AI)

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

• Integrating Codex CLI with Customer.io 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.

• Create Data Visualizations in Cognos BI with Wistia Data

  Access Wistia as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

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

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

• Feed Autopilot Data into FineReport

  How to set Autopilot as a JDBC data source in FineReport.

• «
• 774
• 775
• 776
• 777
• 778
• 779
• 780
• 781
• 782
• 783
• »