CData Software - Knowledge Base
Recent Articles
-
Connect to ZohoInvoice Data in JRuby
Create a simple JRuby app with access to live ZohoInvoice.
-
Automated Continuous Discord Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Discord replication to Amazon S3.
-
Connect to Printify from Asprova with CData Software ODBC Driver for Printify
This article shows how to connect faster to Printify data from Asprova.
-
Connect to and Visualize Live ADP Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ADP.
-
Connect to Accelo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Accelo.
-
Provide OData Services of ActiveCampaign Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ActiveCampaign by developing a WCF Service Application.
-
Connecting Moonlit Workflow with Microsoft Planner 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 Microsoft Planner in real time.
-
Automated Continuous Oracle Eloqua Replication to SQLite
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to SQLite.
-
Connect to Egnyte Data in HULFT Integrate
Connect to Egnyte as a JDBC data source in HULFT Integrate
-
Feed TaxJar Data into FineReport
How to set TaxJar as a JDBC data source in FineReport.
-
Prepare, Blend, and Analyze ZohoPeople Data in Alteryx Designer (ODBC)
Build workflows to access live ZohoPeople for self-service data analytics.
-
Access PingOne Data from MySQL in Amazon QuickSight
Connect to PingOne and build visualizations of PingOne using a MySQL Connection in Amazon QuickSight.
-
Access Live FreshBooks Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live FreshBooks from your Google Sheets.
-
Automated Continuous Vault CRM Replication to Vertica
Use CData Sync for automated, continuous, customizable Vault CRM replication to Vertica.
-
Validate CapsuleCRM Data with QuerySurge
Access and validate CapsuleCRM in QuerySurge using the CData JDBC Driver.
-
Consume HubDB OData Feeds in PowerBuilder
This article demonstrates how to consume HubDB as OData feeds from PowerBuilder using the API Server.
-
Connect to MessageBird Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for MessageBird in the Denodo Virtual DataPort Administrator.
-
Automated Continuous ZendeskSell Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Azure SQL Database.
-
Mailgun Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Mailgun facts in real time.
-
Build a Simple VCL Application for Tickspot Data
How to build a simple VCL Application to view Tickspot in RAD Studio using the CData ODBC Driver for Tickspot.
-
DataBind Charts to Avro Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Avro 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.
-
Load Front Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Front to a database.
-
Create Reports with Gumroad Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Gumroad.
-
Access Live Zuora Data in Coginiti Pro
Connect to and query live Zuora from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
DataBind Charts to Harvest Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Harvest 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.
-
Create Reports from Apollo Data in Looker Studio
Use CData Connect AI to gain access to live Apollo and create custom reports in Looker Studio.
-
How to connect to Bannerbear Data with Squirrel SQL client
Connect to Bannerbear and execute queries in the Squirrel SQL Client.
-
LINQ to IBM Cloud Object Storage 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 IBM Cloud Object Storage Data Provider.
-
Choosing the Best Method to Connect Hacker News to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Hacker News from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
ETL Sybase in Oracle Data Integrator
This article shows how to transfer Sybase into a data warehouse using Oracle Data Integrator.
-
Analyze Codat Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Codat from Power Pivot. You will use the Table Import Wizard to load Codat. You can visually build the import query or use any SQL supported by the driver.
-
Natively Connect to Zoho Creator Data in PHP
The CData ODBC driver for Zoho Creator enables you to create PHP applications with connectivity to Zoho Creator. Leverage the native support for ODBC in PHP.
-
Create Power BI Reports on Real-Time JobNimbus Data
Use the CData ODBC Driver for JobNimbus to visualize JobNimbus in Power BI Desktop.
-
Use the CData Software ODBC Driver for Google Directory in MicroStrategy Desktop
Connect to Google Directory in MicroStrategy Desktop using the CData Software ODBC Driver for Google Directory.
-
Connect Snowflake Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Snowflake using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Charts with Notion Data in Clear Analytics
Create dynamic charts and perform analytics based on Notion in Clear Analytics.
-
Replicate Hacker News Data from PowerShell
Write a quick PowerShell script to query Hacker News. Use connectivity to the live data to replicate Hacker News to SQL Server.
-
Automated Continuous Couchbase Replication to MongoDB
Use CData Sync for automated, continuous, customizable Couchbase replication to MongoDB.
-
Connect to Optimizely Data in RapidMiner
Integrate Optimizely with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect YouTube Analytics to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live YouTube Analytics using the CData Python MCP Server.
-
Integrate with JDBC-ODBC Bridge Data in JReport Designer
Create charts and reports based on JDBC-ODBC Bridge in JReport Designer.
-
Connect to Confluence Data in Jaspersoft Studio
Execute SQL to remote Atlassian Confluence in Jaspersoft Studio.
-
Getting Started with the CData Power BI Connector for Azure Table
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Azure Table.
-
Use the CData API Server to Access Reckon Accounts Hosted Data in Microsoft PowerPivot
Use the CData API Server to connect to live Reckon Accounts Hosted in the Power Pivot business intelligence tool.
-
Connect to LionDesk Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to LionDesk and work with LionDesk in your FileMaker applications.
-
Connect to ClickUp Data from PowerBuilder via JDBC
This article demonstrates how to access ClickUp from PowerBuilder using the ClickUp JDBC Driver.
-
Integrate Open WebUI with Live SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP HANA from within the chat interface.
-
Salesforce Pardot Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Salesforce Pardot facts in real time.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Basecamp actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Use the CData ODBC Driver for Stack Exchange from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Stack Exchange to connect to Stack Exchange from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Stack Exchange in Excel.
-
Work with Live Amazon S3 Data in Power Query
Use CData Connect AI to connect to Amazon S3 and work with live Amazon S3 in Microsoft Power Query.
-
Automated Continuous Yelp Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Yelp replication to Azure SQL Database.
-
Visualize Live Dynamics CRM Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Dynamics CRM and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect and process Workable from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Workable.
-
Getting Started with the CData Python Connector for Perplexity
Learn to install and license the CData Python Connector
-
Integrating Gumloop with Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Apache Avro within automated workflows.
-
Connect to Epicor Kinetic Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Epicor Kinetic to connect to Epicor Kinetic and execute queries in PowerBuilder.
-
Connecting Pipedream with Trello Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Trello data in real time.
-
Build PivotalTracker-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to PivotalTracker and build web apps with connectivity to live PivotalTracker.
-
Create a Data Access Object for REST Data using JDBI
A brief overview of creating a SQL Object API for REST in JDBI.
-
Create Dynamic ZohoMarketingHub Grids Using the Infragistics XamDataGrid
Learn how you can connect ZohoMarketingHub to Infragistics XamDataGrid to build dynamic grids.
-
Build Office 365-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Office 365 Data and create custom apps in Bubble.
-
Migrating data from Moosend to Snowflake using CData SSIS Components.
Easily push Moosend to Snowflake using the CData SSIS Tasks for Moosend and Snowflake.
-
Bridge Microsoft Dataverse Connectivity with Apache NiFi
Access and process Microsoft Dataverse (CDS) in Apache NiFi using the CData JDBC Driver.
-
Integrate with Live Cloudant Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Cloudant from the MuleSoft Anypoint Platform to integrate live IBM Cloudant into custom reports and dashboards.
-
Build Agents in Relevance AI with Access to Live Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Instagram within intelligent agent workflows.
-
Perform Batch Operations with Dynamics 365 Data in Apache NiFi
Connect to Microsoft Dynamics 365 and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Live Salesforce Pardot Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Salesforce Pardot from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Analyze BigQuery Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google BigQuery and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Apps from Dynamics 365 Data in Qlik Sense Cloud
Use CData Connect AI to connect to Dynamics 365 Data and build apps from live Microsoft Dynamics 365 in Qlik Sense Cloud.
-
Connect to Smartsheet Data in RazorSQL
Connect to Smartsheet from wizards and query Smartsheet from the GUI in the RazorSQL database management tool.
-
Build Dynamics 365-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Dynamics 365.
-
Migrating data from ActiveCampaign to Snowflake using CData SSIS Components.
Easily push ActiveCampaign to Snowflake using the CData SSIS Tasks for ActiveCampaign and Snowflake.
-
How to Work with Gumroad Data in AWS Glue Jobs Using JDBC
Connect to Gumroad from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Data Visualizations Based On SAP Fieldglass Data in Mode
Use CData Connect AI to connect to SAP Fieldglass Data from Mode and build visualizations using live
-
Automate Gumroad Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Gumroad from PowerShell? This article demonstrates how to utilize the Gumroad Cmdlets for tasks like connecting to Gumroad, automating operations, downloading data, and more.
-
Integrate Cursor with Live Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Contacts from within the editor.
-
Access Live Planio Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Planio in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData ODBC Driver for SendGrid in Microsoft Power Query
You can use the CData SendGrid ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SendGrid into Microsoft Power Query.
-
Extract, Transform, and Load PhantomBuster Data in Informatica PowerCenter
Create a simple Workflow for PhantomBuster in Informatica PowerCenter.
-
Connect to Productboard Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Productboard as an External Source in Dremio.
-
Connect to SendPulse Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SendPulse using standard SQL.
-
Integrating LlamaIndex with Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Adobe Commerce in real time.
-
Integrate with Mode Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Mode to a JSON file on disk.
-
Build Azure Data Lake Storage-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Azure Data Lake Storage Data from Zoho Analytics and import live Azure Data Lake Storage.
-
Build Workday-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Workday to explore live Workday Data in GitHub Copilot to assist with building Workday-powered applications.
-
How to Connect to Live Gmail Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Gmail securely in real time.
-
Build BigQuery-Connected Apps in Choreo
Use CData Connect AI to connect to BigQuery Data from Choreo and build custom apps using live Google BigQuery.
-
Build Agents in Relevance AI with Access to Live Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zoho Projects within intelligent agent workflows.
-
How to connect to Reply.io Data in DBVisualizer
Integrate Reply.io with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Dynamic Google Directory Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Directory to Infragistics XamDataGrid to build dynamic grids.
-
Build SendGrid-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SendGrid Data and create custom apps in Bubble.
-
Automated Continuous Klipfolio Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Klipfolio replication to AlloyDB.
-
How to import ZohoDesk Data into Apache Solr
Use the CData Software JDBC Driver for ZohoDesk in Data Import Handler and create an automated import of ZohoDesk to Apache Solr Enterprise Search platform.
-
Replicate Multiple Quaderno Accounts
Replicate multiple Quaderno accounts to one or many databases.
-
Load GraphQL Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load GraphQL to a database.
-
Shippo Reporting in OBIEE with the Shippo JDBC Driver
Deploy the Shippo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Charts with Exact Online Data in Clear Analytics
Create dynamic charts and perform analytics based on Exact Online in Clear Analytics.
-
Automated Continuous Gorgias Replication to SQL Server
Use CData Sync for automated, continuous, customizable Gorgias replication to SQL Server.
-
Visualize Live Google Ads Data in the Power BI Service
Use CData Connect AI to connect to live Google Ads and create custom reports in the Power BI Service through the On-Premises Gateway.