CData Software - Knowledge Base
Recent Articles
-
How to Access Live OpenWeatherMap Data in Power Automate Desktop via ODBC
The CData ODBC Driver for OpenWeatherMap enables you to integrate OpenWeatherMap into workflows built using Microsoft Power Automate Desktop.
-
Query Google Forms Data in DataGrip
Create a Data Source for Google Forms in DataGrip and use SQL to query live Google Forms.
-
How to connect to xBase Data in DBVisualizer
Integrate xBase with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live GraphQL Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live GraphQL data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build Hive-Connected Apps in Choreo
Use CData Connect AI to connect to Hive Data from Choreo and build custom apps using live Apache Hive.
-
How to create an RPA flow for Wistia Data in UiPath Studio
Use the Wistia ODBC Driver to create workflows that access real-time Wistia without any coding.
-
Establish a Live Connection with Landbot Data using Tableau Bridge
The CData ODBC Driver for Landbot enables you to integrate live Landbot into Tableau Cloud dashboards using the Tableau Bridge.
-
Choosing the Best Method to Connect Pinecone to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Pinecone from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Informatica Mappings From/To an ODBC Data Source for Pinecone
Create an ODBC connection to Pinecone in Informatica and browse and transfer Pinecone.
-
Use ChatGPT to Talk to Your Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Jira Assets for you.
-
Analyze Dropbox Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Dropbox in Microsoft R Open.
-
Create SAP SuccessFactors LMS Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP SuccessFactors LMS data access from reports, embedded analytics, and more.
-
How to Connect DBeaver to Shippo via a JDBC Driver
Manage Shippo with visual tools in DBeaver like the query browser.
-
How to create an RPA flow for HubSpot Data in UiPath Studio
Use the HubSpot ODBC Driver to create workflows that access real-time HubSpot without any coding.
-
Connect to ShipStation Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ShipStation to connect to ShipStation and execute queries in PowerBuilder.
-
Operational Reporting on Stripe Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Stripe.
-
Connect to Foursquare Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Foursquare to connect to Foursquare and execute queries in PowerBuilder.
-
Build MVC Applications with Connectivity to Front Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Front from an ASP.NET MVC application.
-
How to Connect the Power BI Service to LightSpeedRetail: Complete Guide
Connect to the CData Software Power BI Connector for LightSpeedRetail from PowerBI.com to provide real-time LightSpeedRetail across the organization.
-
Integrate with Drip Data in JReport Designer
Create charts and reports based on Drip in JReport Designer.
-
How to Easily Query Reckon Accounts Hosted Data in OpenOffice Base
Connect to Reckon Accounts Hosted data in OpenOffice Base using the CData ODBC Driver for Reckon Accounts Hosted and generate reports with live data insights.
-
Publish Facebook Ads-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Facebook Ads.
-
Build Charts with Opsgenie Data in Clear Analytics
Create dynamic charts and perform analytics based on Opsgenie in Clear Analytics.
-
Connect to and Visualize Live Recurly Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Recurly.
-
Automated Continuous Blackbaud FE NXT Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Amazon S3.
-
Replicate Multiple DocuSign Accounts via the CData Sync CLI
Replicate multiple DocuSign accounts to one or many databases.
-
Connect to Zuora Data in HULFT Integrate
Connect to Zuora as a JDBC data source in HULFT Integrate
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live QuickBooks Online within intelligent workflows.
-
LINQ to Supabase 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 Supabase Data Provider.
-
Connect to MYOB AccountRight from a Connection Pool in WebLogic
Use the CData JDBC Driver for MYOB AccountRight to connect to MYOB AccountRight from Web applications running on WebLogic.
-
Connect to ZohoExpense Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ZohoExpense and the SQL Gateway to access ZohoExpense from Google Apps Script.
-
Visualize Live ZohoPeople Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ZohoPeople.
-
Connect to and Visualize Live Tally Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Tally ERP.
-
Automate Humanity Data Replication to Azure Data Lake
Use CData Sync to customize and automate Humanity replication to Azure Data Lake.
-
Integrate Live BambooHR Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to BambooHR and integrate live BambooHR into apps built in Microsoft Power Apps.
-
Connect to Real-Time PagerDuty Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use PagerDuty in Power Apps.
-
Validate Elasticsearch Data with QuerySurge
Access and validate Elasticsearch in QuerySurge using the CData JDBC Driver.
-
Use CData Connect AI to Access Sage Intacct Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Sage Intacct in the Power Pivot business intelligence tool.
-
How to create an RPA flow for QuickBooks Time Data in UiPath Studio
Use the QuickBooks Time ODBC Driver to create workflows that access real-time QuickBooks Time without any coding.
-
Connect Wrike Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Wrike using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Apps with Live Postmark Data Using the Low-Code Development Platform of Mendix
Connect Postmark with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous HDFS Replication to Databricks
Use CData Sync for automated, continuous, customizable HDFS replication to Databricks.
-
Build a Simple VCL Application for Calendly Data
How to build a simple VCL Application to view Calendly in RAD Studio using the CData ODBC Driver for Calendly.
-
How to Create Power BI Visual Reports with Real-Time Authorize.Net Data
Use CData Power BI Connectors to visualize Authorize.Net in Power BI.
-
How to Connect the Power BI Service to EmailOctopus: Complete Guide
Connect to the CData Software Power BI Connector for EmailOctopus from PowerBI.com to provide real-time EmailOctopus across the organization.
-
How to use SQLAlchemy ORM to access HCL Domino Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of HCL Domino.
-
Access Suadeo Data from MySQL in Amazon QuickSight
Connect to Suadeo and build visualizations of Suadeo using a MySQL Connection in Amazon QuickSight.
-
Integrate Azure Data Catalog with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Azure Data Catalog with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Azure Data Catalog.
-
Access Live Paylocity Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Paylocity through MCP integration.
-
Create Reports from Google Search Results in Looker Studio
Use CData Connect AI to gain access to live Google Search and create custom reports in Looker Studio.
-
Create Informatica Mappings From/To an ODBC Data Source for Pipedrive
Create an ODBC connection to Pipedrive in Informatica and browse and transfer Pipedrive.
-
Getting Started with the CData ODBC Driver for Cloudflare
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Cloudflare.
-
Explore Geographical Relationships in Pipeline CRM Data with Power Map
Create data visualizations with Pipeline CRM in Power Map.
-
Automated Continuous SpaceX Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SpaceX replication to AlloyDB.
-
Create Apps from Snapchat Ads Data in Qlik Sense Cloud
Use CData Connect AI to connect to Snapchat Ads Data and build apps from live Snapchat Ads in Qlik Sense Cloud.
-
Visualize Live Slack Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Slack.
-
Build AI Agents with Lakebase Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Lakebase through CData Connect AI.
-
Integrate MessageBird Data in Pentaho Data Integration
Build ETL pipelines based on MessageBird in the Pentaho Data Integration tool.
-
Automated Continuous Typeform Replication to SQL Server
Use CData Sync for automated, continuous, customizable Typeform replication to SQL Server.
-
Object-Relational Mapping (ORM) with Dynamics 365 Business Central 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 Dynamics 365 Business Central into a Java-based ORM framework, Hibernate.
-
Integrating Claude Code with Google Campaign Manager 360 Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Campaign Manager 360 within assisted coding and automated development workflows.
-
LINQ to RSS Feeds
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 RSS Data Provider.
-
Create Omnisend Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Omnisend from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Semantic Layer Views for Delighted Data in APOS Live Data Gateway
Use the CData Connector for Delighted in APOS Live Data Gateway to build Semantic Layer Views for Delighted.
-
Connect to Google Directory Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Visualize Factorial Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Factorial.
-
How to Connect to Live LinkedIn 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 LinkedIn for you.
-
Model Microsoft Entra ID Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Microsoft Entra ID, enabling the direct import of real-time Microsoft Entra ID.
-
How to import ZohoSubscriptions Data into Apache Solr
Use the CData Software JDBC Driver for ZohoSubscriptions in Data Import Handler and create an automated import of ZohoSubscriptions to Apache Solr Enterprise Search platform.
-
Visualize Live Demio Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Demio using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Publish Crystal Reports on Factorial Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Factorial.
-
Build LinkedIn-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for LinkedIn to explore live LinkedIn Data in Gemini Code Assist to assist with building LinkedIn-powered applications.
-
Prepare, Blend, and Analyze SAP SuccessFactors Data in Alteryx Designer (ODBC)
Build workflows to access live SAP SuccessFactors for self-service data analytics.
-
Access SAP Ariba Procurement Data from MySQL in Amazon QuickSight
Connect to SAP Ariba Procurement and build visualizations of SAP Ariba Procurement using a MySQL Connection in Amazon QuickSight.
-
Build IBM Informix-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live IBM Informix.
-
How to create an RPA flow for Google Translate Data in UiPath Studio
Use the Google Translate ODBC Driver to create workflows that access real-time Google Translate without any coding.
-
Use the CData API Server to Access Authorize.Net Data in Microsoft PowerPivot
Use the CData API Server to connect to live Authorize.Net in the Power Pivot business intelligence tool.
-
Use the CData Software JDBC Driver for Google Spanner in MicroStrategy
Connect to Google Spanner in MicroStrategy Developer using the CData Software JDBC Driver for Google Spanner.
-
How to connect and process Apache Hive from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Apache Hive.
-
Automate Adobe Commerce Data Replication to Couchbase
Use CData Sync to Customize and automate Adobe Commerce replication to Couchbase.
-
Use Claude to Talk to Your PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your PostgreSQL for you.
-
Connect to Reckon Accounts Hosted Data in RazorSQL
Connect to Reckon Accounts Hosted from wizards and query Reckon Accounts Hosted from the GUI in the RazorSQL database management tool.
-
Connect to Confluence Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Confluence as an External Source in Dremio.
-
Automate SAP BusinessObjects BI Data Replication to SAP HANA
Use CData Sync to customize and automate SAP BusinessObjects BI replication to SAP HANA.
-
Choosing the Best Method to Connect Customer.io to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Customer.io from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Operational Reporting on CircleCI Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote CircleCI.
-
Connect to Airtable Data in JRuby
Create a simple JRuby app with access to live Airtable.
-
DataBind Controls to Parallel Data in Delphi
DataBind to Parallel in Delphi with standard data access components and controls.
-
Analyze Sage 200 Data in Looker
Use CData Connect AI to connect to Sage 200 Data from Looker and build custom apps using live Sage 200.
-
Connect Mode Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Mode using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Microsoft OneDrive Data from MySQL in Amazon QuickSight
Connect to Microsoft OneDrive and build visualizations of Microsoft OneDrive using a MySQL Connection in Amazon QuickSight.
-
How to Import Data from SAS xpt into Google Sheets
Import SAS XPORT into a Google spreadsheet that is automatically refreshed.
-
Create Apps from SAP Hybris C4C Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP Hybris C4C Data and build apps from live SAP Hybris C4C in Qlik Sense Cloud.
-
Build SAP Netweaver Gateway-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP Netweaver Gateway.
-
Visualize Campaigner 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 Campaigner into TIBCO Spotfire.
-
Create Reports with DB2 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date IBM DB2.
-
Deploy the ADO.NET Provider for Adobe Commerce on an SSRS Report Server
Connect to Adobe Commerce from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrate SendPulse Data in the Pentaho Report Designer
Publish reports based on SendPulse in the Pentaho BI tool.
-
Build Act CRM-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Act CRM.
-
Use Biml to Build SSIS Tasks to Replicate Gong Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Gong to SQL Server.