CData Software - Knowledge Base
Recent Articles
-
Create Data Visualizations in Cognos BI with Todoist
Access Todoist as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Visualize Unbounce in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Unbounce into TIBCO Spotfire.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for LDAP
Provide connectivity to LDAP through an SAP BusinessObjects universe.
-
Visualize OData Services in Tableau
The CData ODBC driver for OData enables you integrate OData into Tableau dashboards.
-
How to create an RPA flow for SAP SuccessFactors in UiPath Studio
Use the SAP SuccessFactors ODBC Driver to create workflows that access real-time SAP SuccessFactors without any coding.
-
Process & Analyze Twitter in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Twitter .
-
Building Dynamic Web Pages with ClickUp Using AngularJS
Create single-page applications with live connectivity to ClickUp using the CData API Server.
-
Access Certinia 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 Certinia.
-
Visualize Live Salesforce of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Salesforce & Force.com using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Live Snapchat Ads into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Snapchat Ads and integrate live Snapchat Ads into apps built in Microsoft Power Apps.
-
Connect to Pinterest in NetBeans
Connect to Pinterest in NetBeans with the data source configuration wizard.
-
Analyze MySQL in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of MySQL and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Automate Google Contacts Replication to Couchbase
Use CData Sync to Customize and automate Google Contacts replication to Couchbase.
-
Build a Singer.io Tap for Oracle Sales With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Oracle Sales data using
-
Integrate Live Cloudant into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to IBM Cloudant and integrate live IBM Cloudant into apps built in Microsoft Power Apps.
-
Connect and Query Live SAP SuccessFactors Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP SuccessFactors into Databricks
-
Build Instagram-Connected Apps in Choreo
Use CData Connect AI to connect to Instagram from Choreo and build custom apps using live Instagram.
-
Connect to Power BI XMLA from a Connection Pool in JBoss
Integrate Power BI XMLA into Java servlets: Use the Management Console in JBoss to install the Power BI XMLA JDBC Driver.
-
Use the CData Software JDBC Driver for Vault CRM in MicroStrategy
Connect to Veeva Vault & Vault CRM in MicroStrategy Developer using the CData Software JDBC Driver for Vault CRM.
-
Use Dash to Build to Web Apps on Redis
Create Python applications that use pandas and Dash to build Redis-connected web apps.
-
Create Data Visualizations Based On Salesforce in Mode
Use CData Connect AI to connect to Salesforce from Mode and build visualizations using live
-
Automated Continuous Jira Service Management Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Jira Service Management replication to Google Cloud SQL.
-
Rapidly Develop SAP Fieldglass-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Access Live Zoho Projects in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zoho Projects into the statistical analysis tools available in SAS JMP. This article shows how to use Zoho Projects in the Graph Builder and Query Builder.
-
Trigger Adobe Commerce IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Cvent
Provide connectivity to Cvent through an SAP BusinessObjects universe.
-
Access Live DocuSign in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to DocuSign from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Agents in Relevance AI with Access to Live Facebook Ads via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Facebook Ads within intelligent agent workflows.
-
How to Design Instagram Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Automated Continuous Zendesk Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zendesk replication to Azure SQL Database.
-
Use the CData Software ODBC Driver for Greenplum in MicroStrategy Desktop
Connect to Pivotal GreenPlum in MicroStrategy Desktop using the CData Software ODBC Driver for Greenplum.
-
How to Access SendGrid Using Entity Framework
This article shows how to access SendGrid using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build NetSuite-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to NetSuite CRM & ERP and build web apps with connectivity to live NetSuite CRM & ERP.
-
Import and Visualize Adobe Analytics in Power View
Create data visualizations based on Adobe Analytics in Excel.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
How to load Kintone data into Elasticsearch via Logstash
Introducing a simple method to load Kintone data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Work with SAP Business One in ETL Validator JDBC
Connect to SAP Business One from ETL Validator jobs using the CData Software JDBC Driver.
-
View Reports on Real-Time Workday in Power BI Report Server
Use the CData ODBC Driver for Workday to visualize Workday in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Agents in Relevance AI with Access to Live Couchbase via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Couchbase within intelligent agent workflows.
-
Consume Sage 300 OData Feeds in PowerBuilder
This article demonstrates how to consume Sage 300 as OData feeds from PowerBuilder using the API Server.
-
Create Dynamic Blackbaud FE NXT Grids Using the Infragistics XamDataGrid
Learn how you can connect Blackbaud FE NXT to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Microsoft Project from Crystal Reports
Use CData Connect AI to connect to and report on live Microsoft Project from Crystal Reports.
-
How to Access Live Oracle Sales in Power Automate Desktop via ODBC
The CData ODBC Driver for Oracle Sales enables you to integrate Oracle Sales into workflows built using Microsoft Power Automate Desktop.
-
DataBind Controls to Outreach.io in C++Builder
DataBind to Outreach.io in C++Builder with standard components and controls.
-
A PostgreSQL Interface for HubSpot (MySQL Remoting via JDBC)
Use the Remoting features of the HubSpot JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Live SAP ByDesign in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP ByDesign in CData Connect AI and connect to your SAP Business ByDesign from PostgreSQL.
-
Connect Twitter Ads to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Twitter Ads using the CData Python MCP Server.
-
Back Up Shopify to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Shopify. In this article, we will employ an SSIS workflow to populate a database with Shopify data.
-
Automated Continuous Hive Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Hive replication to PostgreSQL.
-
Integrating Boomi Agentstudio with Sage 200 via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Sage 200, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to pipe GitHub to CSV in PowerShell
Use standard PowerShell cmdlets to access GitHub tables.
-
Automated Continuous eBay Analytics Replication to Oracle
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Oracle.
-
Query Adobe Target in ColdFusion
Write standard ColdFusion data access code to connect to Adobe Target.
-
Analyze Drift with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Drift from Power Pivot. You will use the Table Import Wizard to load Drift. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect to Live Presto in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Presto without replication.
-
Trigger Salesforce Pardot IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Integrating LangGraph with Workday via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Workday within automated workflows.
-
Write a Simple Go Application to work with Google Campaign Manager 360 on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Campaign Manager 360.
-
Connect to Xero from AWS Glue
Use CData Connect AI to gain access to live Xero Accounting from your AWS Glue jobs.
-
Connect and Visualize Live Outreach.io Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Outreach.io into the Databricks platform and create visualization dashboards with real-time Outreach.io.
-
Integrating Claude Code with BigQuery via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google BigQuery within assisted coding and automated development workflows.
-
Query QuickBooks Time as a MySQL Database in Node.js
Execute MySQL queries against QuickBooks Time from Node.js.
-
Provide OData Services of SAP ByDesign from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Business ByDesign by developing a WCF Service Application.
-
Publish IBM Informix-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live IBM Informix.
-
Model Zoho CRM Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zoho CRM, enabling the direct import of real-time Zoho CRM.
-
Automated Continuous Kintone Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Kintone replication to OneLake in Microsoft Fabric.
-
How to Connect to Live Twitter Ads from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Twitter Ads through natural language.
-
Query Greenhouse in ColdFusion
Write standard ColdFusion data access code to connect to Greenhouse.
-
Create Datasets from Office 365 in Domo Workbench and Build Visualizations of Office 365 in Domo
Use the CData Software ODBC Driver for Office 365 to create datasets from Microsoft Office 365 in Domo Workbench and then build visualizations in the Domo service.
-
Design BIRT Reports on SharePoint Excel Services
Provide current SharePoint Excel Services to your embedded analytics.
-
Working with SAP Hybris C4C in LINQPad
Execute LINQ queries to SAP Hybris C4C in LINQPad.
-
Visualize TaxJar in Tableau
The CData ODBC driver for TaxJar enables you integrate TaxJar into Tableau dashboards.
-
Integrate Cvent with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Cvent with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Cvent.
-
Automate Twitter Ads Replication to Couchbase
Use CData Sync to Customize and automate Twitter Ads replication to Couchbase.
-
Connect to SAP Hybris C4C in Jaspersoft Studio
Execute SQL to remote SAP Hybris C4C in Jaspersoft Studio.
-
Connect to MariaDB in SpagoBI
Create reports featuring live MariaDB in SpagoBI Studio. Host MariaDB reports on SpagoBI Server.
-
How to Access Live PayPal in Power Automate Desktop via ODBC
The CData ODBC Driver for PayPal enables you to integrate PayPal into workflows built using Microsoft Power Automate Desktop.
-
Visualize Live HubDB of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live HubDB using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize OData Services in TIBCO Spotfire through ADO.NET
Integrate OData into dashboards in TIBCO Spotfire.
-
DataBind Controls to EventBrite in C++Builder
DataBind to Eventbrite in C++Builder with standard components and controls.
-
Import and Visualize MYOB AccountRight in Power View
Create data visualizations based on MYOB AccountRight in Excel.
-
Access Reckon Accounts Hosted 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 Reckon Accounts Hosted.
-
Migrating data from Zendesk to Google BigQuery using CData SSIS Components.
Easily push Zendesk to Google BigQuery using the CData SSIS Tasks for Zendesk and Google BigQuery.
-
How to Design Airtable Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
How to Import Data from Google Analytics into Google Sheets
Import Google Analytics into a Google spreadsheet that is automatically refreshed.
-
Automated Continuous SAP Netweaver Gateway Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Amazon Redshift.
-
Build Salesforce Pardot-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Salesforce Pardot and create custom apps in Bubble.
-
Create Azure Table-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Azure Table from OutSystems and build custom enterprise apps using live Azure Table Storage.
-
Automated Continuous JotForm Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable JotForm replication to OneLake in Microsoft Fabric.
-
Replicate Multiple Kintone Accounts via the CData Sync CLI
Replicate multiple Kintone accounts to one or many databases.
-
Rapidly Develop Cassandra-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Enable the Salesloft JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Salesloft.
-
Connect to ShipStation in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for ShipStation and connect to ShipStation in Akorbi Digital RunMyProcess.
-
Integrate Live Azure DevOps into Blue Prism for Intelligent Robotic Process Automation (RPA)
-