CData Software - Knowledge Base
Recent Articles
-
Back Up Box data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Box. In this article, we will employ an SSIS workflow to populate a database with Box data data.
-
Integrate Live Hacker News Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Hacker News data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Visualize LinkedIn Data in TIBCO Spotfire through OData
Integrate LinkedIn data into dashboards in TIBCO Spotfire.
-
Integrate Cline with Live Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Contacts data from within your IDE.
-
Build Automated Workflows with Live SAP Ariba Procurement Data in Workato
Use CData Connect AI to connect to live SAP Ariba Procurement data and build automated workflows in Workato.
-
How to Connect to ClickUp Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ClickUp data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Ontraport Data from a Connection Pool in JBoss
Integrate Ontraport data into Java servlets: Use the Management Console in JBoss to install the Ontraport JDBC Driver.
-
Create Data Visualizations Based On Epicor Kinetic Data in Mode
Use CData Connect AI to connect to Epicor Kinetic Data from Mode and build visualizations using live Epicor Kinetic data.
-
Analyze CouchDB Data in Cognos Analytics
Use CData Connect AI to connect to CouchDB Data from Cognos Analytics and analyze live CouchDB data.
-
Automated Continuous Freshservice Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Freshservice replication to Google BigQuery.
-
Establish a Live Connection with Azure Data Lake Storage Data using Tableau Bridge
The CData ODBC Driver for Azure Data Lake Storage enables you to integrate live Azure Data Lake Storage data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Mailgun Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Mailgun to connect to Mailgun data and execute queries in PowerBuilder.
-
Connect to Phoenix Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Phoenix data.
-
Build Agents in Relevance AI with Access to Live TaxJar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on TaxJar data within intelligent agent workflows.
-
Access Live Hugging Face Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Hugging Face data into the statistical analysis tools available in SAS JMP. This article shows how to use Hugging Face data in the Graph Builder and Query Builder.
-
Integrate with live ZohoInvoice Data in Jitterbit
Use CData Connect AI to connect to and integrate live ZohoInvoice data in Jitterbit.
-
Automated Continuous Shippo Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Shippo replication to Apache Kafka.
-
Visualize Live Amazon Marketplace Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Amazon Marketplace data into custom reports in Power BI.
-
Publish Crystal Reports on Notion Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Notion data.
-
Extract, Transform, and Load JotForm Data in Informatica PowerCenter
Create a simple Workflow for JotForm data in Informatica PowerCenter.
-
Integrate LibreChat with Live Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Zoho Books data from within the chat interface.
-
Integrate with Neo4J Data in JReport Designer
Create charts and reports based on Neo4J data in JReport Designer.
-
Rapidly Develop Airtable-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Airtable.
-
Object-Relational Mapping (ORM) with Box 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 Box data into a Java-based ORM framework, Hibernate.
-
Bridge Zoho Projects Connectivity with Apache NiFi
Access and process Zoho Projects data in Apache NiFi using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Stripe in MicroStrategy Desktop
Connect to Stripe data in MicroStrategy Desktop using the CData Software ODBC Driver for Stripe.
-
Prepare, Blend, and Analyze Salesloft Data in Alteryx Designer (Connect AI)
Build workflows to access live Salesloft data for self-service data analytics.
-
Choosing the Best Method to Connect Zoho Creator to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zoho Creator data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Bind Live WooCommerce Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live WooCommerce data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to connect to eBay Analytics Data from Spring Boot
Connect to eBay Analytics in a Spring Boot Application using the CData JDBC Driver for eBay Analytics
-
Rapidly Develop MailerLite-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by MailerLite.
-
Connect to Elorus Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Elorus and work with Elorus data in your FileMaker applications.
-
Connect to Attio Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Attio Data and connect to Attio data in Akorbi Digital RunMyProcess.
-
Integrate with MailerSend Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MailerSend data to a JSON file on disk.
-
Integrate Bitly Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Bitly data and integrate live Bitly data into your Power Automate tasks.
-
ETL Zoho Projects in Oracle Data Integrator
This article shows how to transfer Zoho Projects data into a data warehouse using Oracle Data Integrator.
-
Moving Data from Amazon DynamoDB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Amazon DynamoDB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Analyze Highrise Data in Looker
Use CData Connect AI to connect to Highrise Data from Looker and build custom apps using live Highrise data.
-
Integrate Cline with Live Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Zoom data from within your IDE.
-
How to connect to Amazon Athena Data from Spring Boot
Connect to Amazon Athena in a Spring Boot Application using the CData JDBC Driver for Amazon Athena
-
Connect to Freshteam Data in Aqua Data Studio
Access Freshteam data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData Excel Add-In for CampaignMonitor
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for CampaignMonitor.
-
Publish Crystal Reports on Zoho CRM Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoho CRM data.
-
How to Connect to PagerDuty Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to PagerDuty data. Leverage the pyodbc module for ODBC in Python.
-
Build Data Flows from Printful to SQL Server using SSIS
Easily back up Printful data to SQL Server using the SSIS components for Printful.
-
Build SageHR Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SageHR data and build visualizations in Tableau Cloud.
-
How to Query Live Landbot Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Landbot data data in natural language using Python.
-
Integrate Theia IDE with Live SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live SendGrid data from within the development environment.
-
Bridge Google Cloud Storage Connectivity with Apache NiFi
Access and process Google Cloud Storage data in Apache NiFi using the CData JDBC Driver.
-
How to Connect to Live Wave Financial Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Wave Financial data for you.
-
Access Live Reckon Accounts Hosted Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Reckon Accounts Hosted data through MCP integration.
-
Analyze Smartsheet Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Smartsheet from Power Pivot. You will use the Table Import Wizard to load Smartsheet data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Outlook Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Outlook and work with Outlook data in your FileMaker application.
-
Visualize SAP BusinessObjects BI Data in TIBCO Spotfire through OData
Integrate SAP BusinessObjects BI data into dashboards in TIBCO Spotfire.
-
Analyze Mode Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Mode data and visualize live Mode data in Infragistics Reveal.
-
Feed SAP Ariba Procurement Data into FineReport
How to set SAP Ariba Procurement data as a JDBC data source in FineReport.
-
Explore Geographical Relationships in Microsoft Teams Data with Power Map
Create data visualizations with Microsoft Teams data in Power Map.
-
Analyze Wistia Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Wistia from Power Pivot. You will use the Table Import Wizard to load Wistia data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous ADP Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ADP replication to Amazon S3.
-
Connect to xBase Data in ACL Analytics
Connect to xBase data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to xBase data.
-
Connect to Sentry Data from PowerBuilder via JDBC
This article demonstrates how to access Sentry data from PowerBuilder using the Sentry JDBC Driver.
-
Connecting Mastra with xBase 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 xBase data, no replication required.
-
Access Hacker News 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 Hacker News data.
-
Build an OLAP Cube in SSAS from Zoho Projects Data
Establish a connection to Zoho Projects data data from SQL Server Analysis Services, and use the Zoho Projects Data Provider to build OLAP cubes for use in analytics and reporting.
-
Using the CData Software ODBC Driver for Reply.io in PyCharm
Connect to Reply.io as an ODBC data source in PyCharm using the CData Software ODBC Driver for Reply.io.
-
Connect to Telegram Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Telegram and work with Telegram data in your FileMaker application.
-
Connect to Aircall from a Connection Pool in WebLogic
Use the CData JDBC Driver for Aircall to connect to Aircall data from Web applications running on WebLogic.
-
Replicate Multiple Parquet Accounts
Replicate multiple Parquet accounts to one or many databases.
-
Build Dashboards with Everhour Data in Dundas BI
Create dynamic dashboards and perform analytics based on Everhour data in Dundas BI.
-
Connect to Todoist Data in Ruby
Connect to Todoist data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous MailerLite Replication to Oracle
Use CData Sync for automated, continuous, customizable MailerLite replication to Oracle.
-
Create Data Visualizations Based On Acumatica Data in Mode
Use CData Connect AI to connect to Acumatica Data from Mode and build visualizations using live Acumatica data.
-
Integrate MailerLite with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate MailerLite with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MailerLite data.
-
Automated Continuous Bitly Replication to SQL Server
Use CData Sync for automated, continuous, customizable Bitly replication to SQL Server.
-
Rapidly Develop Spark-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Spark.
-
Create Attio-Connected Applications in Appsmith
Connect to Attio Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Attio data.
-
Write a Simple Go Application to work with RSS Feeds on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to RSS feeds.
-
Integrating Gumloop with Jumpseller Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Jumpseller data within automated workflows.
-
How to connect Amazon QuickSight to SAP Concur Data
Create a connection to SAP Concur data in CData Connect AI and insert SAP Concur data into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Semantic Layer Views for xBase Data in APOS Live Data Gateway
Use the CData Connector for xBase in APOS Live Data Gateway to build Semantic Layer Views for xBase data.
-
Access Live Hacker News Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Hacker News data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Voice Agents in ElevenLabs with access to Live SageHR Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SageHR data.
-
Use Grok to Talk to Your SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SurveyMonkey data for you.
-
Connecting Moonlit Workflow with MarkLogic Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your MarkLogic data in real time.
-
Replicate ConstantContact Data in Heroku for Use in Salesforce Connect
Replicate ConstantContact data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Easily Integrate CircleCI Data in Lazarus Pascal IDE
Learn how to easily integrate live CircleCI data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live Gmail Data in TIBCO Data Virtualization
Use the Gmail Tibco DV Adapter to create a Gmail data data source in TIBCO Data Virtualization Studio and gain access to live Gmail data from your TDV Server.
-
Oracle SCM Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle SCM data through CData Connect AI using different applications and tools.
-
Use the CData ODBC Driver for Google Cloud Storage from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Cloud Storage to connect to Google Cloud Storage data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Cloud Storage data in Excel.
-
Connect to Acumatica Data in Google Apps Script via Connect AI
Use CData Connect AI to access Acumatica data in Google Apps Script.
-
Publish FormSite-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live FormSite data.
-
Create Data Visualizations in Cognos BI with Stack Exchange Data
Access Stack Exchange data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Bidirectional Access to SAP HANA Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP HANA data in Filemaker Pro for Mac or Windows.
-
Connect to Act-On Data from PowerBuilder via ADO.NET
This article demonstrates how to access Act-On data from Appeon PowerBuilder using the CData ADO.NET Provider for Act-On.
-
How to connect to TigerGraph Data from IntelliJ
Integrate connectivity to TigerGraph data with wizards in IntelliJ.
-
Access Live Wave Financial Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Wave Financial data into the statistical analysis tools available in SAS JMP. This article shows how to use Wave Financial data in the Graph Builder and Query Builder.
-
Connect to Azure Analysis Services Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Azure Analysis Services data using standard SQL.
-
Stream Google Translate Data into Apache Kafka Topics
Access and stream Google Translate data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Import Moosend Data Using Azure Data Factory
Use CData Connect AI to connect to Moosend Data from Azure Data Factory and import live Moosend data.
-
Create FHIR-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to FHIR Data from Klipfolio and build custom visualizations using live FHIR data.