CData Software - Knowledge Base
Recent Articles
-
Automated Continuous SAP SuccessFactors Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to AlloyDB.
-
Use Databricks Agent Bricks to Talk to Your Databricks Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Databricks for you.
-
How to Connect to Jira Assets Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Jira Assets. Leverage the pyodbc module for ODBC in Python.
-
Analyze Hive Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Apache Hive and visualize Apache Hive in SAP Analytics Cloud.
-
Connect to Avalara AvaTax Data in CloverDX (formerly CloverETL)
Transfer Avalara AvaTax using the visual workflow in the CloverDX data integration tool.
-
Build AI/ML Models with Live Cohere Data using Dataiku
Connect Cohere Data with Dataiku using the CData API Driver for JDBC.
-
Connect Highrise Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Highrise CRM using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Apps with Live SAP Ariba Procurement in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP Ariba Procurement into the Adalo platform and build custom mobile and web applications with real-time SAP Ariba Procurement.
-
Build Planio-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Planio.
-
How to Easily Query PostgreSQL Data in OpenOffice Base
Connect to PostgreSQL data in OpenOffice Base using the CData ODBC Driver for PostgreSQL and generate reports with live data insights.
-
Integrate LibreChat with Live Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Exact Online from within the chat interface.
-
Visualize Reckon Accounts Hosted Data in TIBCO Spotfire through OData
Integrate Reckon Accounts Hosted into dashboards in TIBCO Spotfire.
-
Automated HCL Domino Data Replication to Teradata
Use CData Sync to Customize and automate HCL Domino replication to Teradata.
-
How to use SQLAlchemy ORM to access OData Services in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of OData.
-
Deploy the ADO.NET Provider for Qualaroo on an SSRS Report Server
Connect to Qualaroo 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.
-
Add Clio Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Clio with the Informatica Enterprise Data Catalog to classify and organize data.
-
Establish a Live Connection with Sage 300 Data using Tableau Bridge
The CData ODBC Driver for Sage 300 enables you to integrate live Sage 300 into Tableau Cloud dashboards using the Tableau Bridge.
-
Query Gorgias Data in ColdFusion
Write standard ColdFusion data access code to connect to Gorgias.
-
Integrate Quickbase Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Quickbase from Informatica Cloud.
-
How to Connect the Power BI Service to GitHub: Complete Guide
Connect to the CData Software Power BI Connector for GitHub from PowerBI.com to provide real-time GitHub across the organization.
-
Back Up Perplexity 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 Perplexity data.
-
Integrate Onfleet with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Onfleet with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Onfleet.
-
Build Visualizations of ChargeOver Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ChargeOver in Birst.
-
Automated Continuous eBay Analytics Replication to IBM DB2
Use CData Sync for automated, continuous, customizable eBay Analytics replication to IBM DB2.
-
Connect to Hacker News Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Hacker News using standard SQL.
-
Visualize Live Webflow Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Webflow using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Oracle Sales Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Oracle Sales and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating Cursor CLI with Google Calendar 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.
-
How to connect SharePoint with MYOB AccountRight Data through external lists
Provide MYOB AccountRight to SharePoint users as an external list.
-
Explore Geographical Relationships in Guru Data with Power Map
Create data visualizations with Guru in Power Map.
-
How to Query Live Splunk Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Splunk data in natural language using Python.
-
Getting Started with the CData Tableau Connector for ServiceNow
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for ServiceNow.
-
Validate Power BI XMLA Data with QuerySurge
Access and validate Power BI XMLA in QuerySurge using the CData JDBC Driver.
-
Connect to Microsoft OneDrive Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft OneDrive.
-
Prepare, Blend, and Analyze Avro Data in Alteryx Designer (Connect AI)
Build workflows to access live Apache Avro for self-service data analytics.
-
Use ChatGPT to Talk to Your Workday 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 Workday for you.
-
Create Data Visualizations in Cognos BI with LightSpeedRetail Data
Access LightSpeedRetail as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Data Flows from RSS to SQL Server using SSIS
Easily back up RSS Feeds to SQL Server using the SSIS components for RSS.
-
Automate Outlook Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Outlook from PowerShell? This article demonstrates how to utilize the Outlook Cmdlets for tasks like connecting to Outlook, automating operations, downloading data, and more.
-
Visualize Live Freshservice Data in the Power BI Service
Use CData Connect AI to connect to live Freshservice and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import Zendesk Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Zendesk. In this article, you will use the OData format to import Zendesk into Microsoft Power Query.
-
Use Dash to Build to Web Apps on Todoist Data
Create Python applications that use pandas and Dash to build Todoist-connected web apps.
-
Access Live SAP SuccessFactors Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP SuccessFactors into the statistical analysis tools available in SAS JMP. This article shows how to use SAP SuccessFactors in the Graph Builder and Query Builder.
-
Build Dashboards with GitHub Data in Dundas BI
Create dynamic dashboards and perform analytics based on GitHub in Dundas BI.
-
Automate Sybase IQ Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Sybase IQ and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Analyze Cosmos DB Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Azure Cosmos DB and visualize live Azure Cosmos DB in Infragistics Reveal.
-
Build Voice Agents in ElevenLabs with access to Live Greenhouse Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Greenhouse.
-
Replicate Multiple Discord Accounts
Replicate multiple Discord accounts to one or many databases.
-
Establish a Live Connection with Zoho Projects Data using Tableau Bridge
The CData ODBC Driver for Zoho Projects enables you to integrate live Zoho Projects into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous GitHub Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable GitHub replication to Amazon Redshift.
-
Automated Continuous SAP Netweaver Gateway Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Snowflake.
-
Migrating data from Perplexity to Google BigQuery using CData SSIS Components.
Easily push Perplexity to Google BigQuery using the CData SSIS Tasks for Perplexity and Google BigQuery.
-
Create Power BI Reports on Real-Time SAP Netweaver Gateway Data
Use the CData ODBC Driver for SAP Netweaver Gateway to visualize SAP Netweaver Gateway in Power BI Desktop.
-
DataBind Charts to Printify Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Printify 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.
-
Connecting Mastra with SAP Netweaver Gateway 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 SAP Netweaver Gateway, no replication required.
-
Connect to SAP Fieldglass Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP Fieldglass as an External Source in Dremio.
-
Connect to Google Analytics Data from AWS Glue
Use CData Connect AI to gain access to live Google Analytics from your AWS Glue jobs.
-
How to Connect Flowise AI Agents to Live Gmail Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Gmail without replication.
-
Establish a Live Connection with LinkedIn Ads Data using Tableau Bridge
The CData ODBC Driver for LinkedIn Ads enables you to integrate live LinkedIn Ads into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Splunk from Asprova with CData Software ODBC Driver for Splunk
This article shows how to connect faster to Splunk data from Asprova.
-
Create Informatica Mappings From/To an ODBC Data Source for Apify
Create an ODBC connection to Apify in Informatica and browse and transfer Apify.
-
Build Procore-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Procore.
-
Use the CData Software ODBC Driver for SQL Server in MicroStrategy
Connect to Microsoft SQL Server in MicroStrategy Developer using the CData Software ODBC Driver for SQL Server.
-
Operational Reporting on Act CRM Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Act CRM.
-
Migrating data from SageHR to Databricks using CData SSIS Components.
Easily push SageHR to Databricks using the CData SSIS Tasks for SageHR and Databricks.
-
Connect to Humanity Data in HULFT Integrate
Connect to Humanity as a JDBC data source in HULFT Integrate
-
Access LDAP Objects 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 LDAP.
-
Connect to Onfleet Data in JRuby
Create a simple JRuby app with access to live Onfleet.
-
Automated Continuous SingleStore Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SingleStore replication to PostgreSQL.
-
How to update Hive from Excel
This article explains how to transfer data from Excel to Hive using the Excel Add-In for Hive.
-
Use Biml to Build SSIS Tasks to Replicate Epicor Kinetic Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Epicor Kinetic to SQL Server.
-
Provide OData Services of GitLab Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for GitLab by developing a WCF Service Application.
-
How to connect PolyBase to Mistral AI
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Mistral AI.
-
Access Live Google Calendar 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 Google Calendar through MCP integration.
-
Publish Codat-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Codat.
-
Getting Started with the CData Tableau Connector for Cvent
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Cvent.
-
Automated Continuous Teamwork Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Teamwork replication to OneLake in Microsoft Fabric.
-
Automated Continuous Ontraport Replication to SingleStore
Use CData Sync for automated, continuous, customizable Ontraport replication to SingleStore.
-
Connecting GenSpark with Oracle HCM Cloud Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Oracle HCM Cloud without any replication or custom integration required.
-
Query, Visualize, and Share live Pipedrive Data in Redash
Use CData Connect AI to connect to live Pipedrive in Redash for querying, visualizing, and sharing.
-
How to Query Live Google Ad Manager Data in Perplexity MacOS Desktop
Connect to and query live Google Ad Manager Data in Perplexity Desktop using CData MCP Server.
-
Use Microsoft Copilot Studio to talk to your GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your GraphQL for you.
-
How to Access xBase Data Using Entity Framework
This article shows how to access xBase using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Dashboards and Visualize Live MYOB AccountRight Data in Geckoboard
Use CData Connect AI to connect to live MYOB AccountRight and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Cursor with Live Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Zoho Books from within the editor.
-
Use the CData Software ODBC Driver for Dotmailer in MicroStrategy
Connect to Dotmailer in MicroStrategy Developer using the CData Software ODBC Driver for Dotmailer.
-
Analyze Dynamics 365 Business Central Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Dynamics 365 Business Central with the CData JDBC Driver for Dynamics 365 Business Central.
-
Extract, Transform, and Load Lakebase Data in Informatica PowerCenter
Create a simple Workflow for Lakebase in Informatica PowerCenter.
-
How to create an RPA flow for BambooHR Data in UiPath Studio
Use the BambooHR ODBC Driver to create workflows that access real-time BambooHR without any coding.
-
Connect to CampaignMonitor Data in RapidMiner
Integrate CampaignMonitor with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Power BI Reports on Real-Time Mailjet Data
Use the CData ODBC Driver for Mailjet to visualize Mailjet in Power BI Desktop.
-
Migrating data from LightSpeedRetail to Google BigQuery using CData SSIS Components.
Easily push LightSpeedRetail to Google BigQuery using the CData SSIS Tasks for LightSpeedRetail and Google BigQuery.
-
Use Dash to Build Web Apps on Power BI XMLA Data via CData Connect AI
Build interactive Dash web apps on live Power BI XMLA using pandas and the CData Connect AI Python SDK.
-
Create Oracle HCM Cloud Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Oracle HCM Cloud data access from reports, embedded analytics, and more.
-
Excel Spreadsheet Automation on CircleCI Data with the QUERY Formula
Pull data from CircleCI, automate spreadsheets, and more with the QUERY formula.
-
Connect to Mailgun Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Query ServiceDesk Plus Data as a MySQL Database in Node.js
Execute MySQL queries against ServiceDesk Plus from Node.js.
-
Excel Spreadsheet Automation on Attio Data with the QUERY Formula
Pull data from Attio, automate spreadsheets, and more with the QUERY formula.
-
Access Live Microsoft OneDrive Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft OneDrive from your Google Sheets.
-
Connect to PagerDuty from Asprova with CData Software ODBC Driver for PagerDuty
This article shows how to connect faster to PagerDuty data from Asprova.