CData Software - Knowledge Base
Recent Articles
-
Integrate with BigCommerce Data in SnapLogic
Use CData Connect AI to connect to and integrate with live BigCommerce in SnapLogic.
-
A PostgreSQL Interface for Paddle Data using the CData ODBC Driver
Use the SQL Gateway and Paddle ODBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Optimizely Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Optimizely with the CData JDBC Driver for Optimizely.
-
Query ChartMogul Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ChartMogul from Node.js.
-
Build Apps with Live Coinbase Data Using the Low-Code Development Platform of Mendix
Connect Coinbase with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Teamwork Replication to Snowflake
Use CData Sync for automated, continuous, customizable Teamwork replication to Snowflake.
-
Build CampaignMonitor-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to CampaignMonitor and build web apps with connectivity to live CampaignMonitor.
-
Object-Relational Mapping (ORM) with Exact Online 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 Exact Online into a Java-based ORM framework, Hibernate.
-
Publish Reports with Teamwork Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Teamwork.
-
Integrating LangChain with Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Adobe Analytics within automated workflows.
-
JotForm Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on JotForm facts in real time.
-
Connect and Visualize Live SAS xpt Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAS XPORT into the Databricks platform and create visualization dashboards with real-time SAS XPORT.
-
Create Informatica Mappings From/To an ODBC Data Source for Epicor Kinetic
Create an ODBC connection to Epicor Kinetic in Informatica and browse and transfer Epicor Kinetic.
-
Getting Started with the CData SSIS Components for Telegram
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Telegram.
-
Connect to Twitter Ads from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Twitter Ads, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Work with ZeroBounce Data in FoxPro
Load ZeroBounce into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Access PayPal Data Using Entity Framework
This article shows how to access PayPal using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Natively Connect to GitHub Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to GitHub. Leverage the native support for ODBC in PHP.
-
Build Data Flows from CouchDB to SQL Server using SSIS
Easily back up Apache CouchDB to SQL Server using the SSIS components for CouchDB.
-
Configure the CData JDBC Driver for ElevenLabs in a Connection Pool in Tomcat
Connect to ElevenLabs from a connection pool in Tomcat.
-
Create Dynamic JSON Grids Using the Infragistics XamDataGrid
Learn how you can connect JSON to Infragistics XamDataGrid to build dynamic grids.
-
Rapidly Develop OnePageCrm-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 OnePageCrm.
-
Use the CData Software JDBC Driver for Coinbase in MicroStrategy Desktop
Connect to Coinbase in MicroStrategy Desktop using the CData Software JDBC Driver for Coinbase.
-
Connect to Dynamics 365 Data in CloverDX (formerly CloverETL)
Transfer Microsoft Dynamics 365 using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous SAP BusinessObjects BI Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to OneLake in Microsoft Fabric.
-
Access Coinbase Data from MySQL in Amazon QuickSight
Connect to Coinbase and build visualizations of Coinbase using a MySQL Connection in Amazon QuickSight.
-
Build Automated Workflows with Live Freshservice Data in Workato
Use CData Connect AI to connect to live Freshservice and build automated workflows in Workato.
-
How to integrate Codat with Apache Airflow
Access and process Codat in Apache Airflow using the CData JDBC Driver.
-
Integrate with Live Azure Table Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Azure Table from the MuleSoft Anypoint Platform to integrate live Azure Table Storage into custom reports and dashboards.
-
Migrating data from Ontraport to Databricks using CData SSIS Components.
Easily push Ontraport to Databricks using the CData SSIS Tasks for Ontraport and Databricks.
-
Replicate Multiple IBM Cloud Object Storage Accounts
Replicate multiple IBM Cloud Object Storage accounts to one or many databases.
-
Analyze Onfleet Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Onfleet from Power Pivot. You will use the Table Import Wizard to load Onfleet. You can visually build the import query or use any SQL supported by the driver.
-
Write a Simple Go Application to work with Pingdom Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Pingdom.
-
Automated Continuous ConvertKit Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ConvertKit replication to Amazon S3.
-
Replicate Outlook Data from PowerShell
Write a quick PowerShell script to query Outlook. Use connectivity to the live data to replicate Outlook to SQL Server.
-
How to Connect to Live Outreach.io Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Outreach.io for you.
-
Build AI/ML Models with Live Okta Data using Dataiku
Connect Okta Data with Dataiku using the CData JDBC Driver for Okta.
-
How to connect PolyBase to Outreach.io
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Outreach.io.
-
Build Data Flows from SQL Server to Dynamics NAV through SSIS
Easily push SQL Server data to Dynamics NAV using the CData SSIS Tasks for Dynamics NAV.
-
How to Connect to Live Salesforce CRM Analytics Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Salesforce CRM Analytics securely in real time.
-
Visualize Live Freshdesk Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Freshdesk using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Build an ETL App for SAP Netweaver Gateway Data in Python with CData Connect AI
Build ETL pipelines that read and write live SAP Netweaver Gateway in Python with petl and the CData Connect AI Python SDK.
-
Validate Flowlu Data with QuerySurge
Access and validate Flowlu in QuerySurge using the CData JDBC Driver.
-
Create Data Visualizations in Cognos BI with SAP Business One Data
Access SAP Business One as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SAP Business One to Power BI dashboards. Simply drag and drop SAP Business One into data visuals on the Power BI canvas.
-
How to use SQLAlchemy ORM to access Delighted Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Delighted.
-
Establish a Live Connection with Simplesat Data using Tableau Bridge
The CData ODBC Driver for Simplesat enables you to integrate live Simplesat into Tableau Cloud dashboards using the Tableau Bridge.
-
Use Claude to Talk to Your Shopify 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 Shopify for you.
-
Use ChatGPT to Talk to Your Quickbase 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 Quickbase for you.
-
Bind Live Elasticsearch Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Elasticsearch data
-
Excel Spreadsheet Automation on Sage Cloud Accounting Data with the QUERY Formula
Pull data from Sage Cloud Accounting, automate spreadsheets, and more with the QUERY formula.
-
Stream BigQuery Data into Apache Kafka Topics
Access and stream Google BigQuery in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use ChatGPT to Talk to Your Twilio 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 Twilio for you.
-
Connecting Agentforce with Snowflake Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Snowflake for you.
-
Extract, Transform, and Load Sybase IQ Data in Informatica PowerCenter
Create a simple Workflow for Sybase IQ in Informatica PowerCenter.
-
Build Apps with Live SAP Fieldglass Data Using the Low-Code Development Platform of Mendix
Connect SAP Fieldglass with Mendix to build apps using the CData JDBC Driver for SAP Fieldglass.
-
Publish Crystal Reports on PingOne Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PingOne.
-
Integrate Live CampaignMonitor Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live CampaignMonitor to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Zuora Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Trigger Impala IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Impala with standard wizards in Logic Apps.
-
How to connect Amazon QuickSight to Microsoft Entra ID Data
Create a connection to Microsoft Entra ID in CData Connect AI and insert Microsoft Entra ID into Amazon QuickSight SPICE to build interactive dashboards.
-
Access Amazon DynamoDB 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 Amazon DynamoDB.
-
Query, Visualize, and Share live Oracle Service Cloud Data in Redash
Use CData Connect AI to connect to live Oracle Service Cloud in Redash for querying, visualizing, and sharing.
-
Migrating data from Pipedrive to Snowflake using CData SSIS Components.
Easily push Pipedrive to Snowflake using the CData SSIS Tasks for Pipedrive and Snowflake.
-
Create Datasets from Everhour in Domo Workbench and Build Visualizations of Everhour Data in Domo
Use the CData Software ODBC Driver for Everhour to create datasets from Everhour in Domo Workbench and then build visualizations in the Domo service.
-
Rapidly Develop Google Contacts-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 Google Contacts.
-
Connect to Tally Data from a Connection Pool in Jetty
The Tally JDBC Driver supports connection pooling: This article shows how to connect faster to Tally ERP from Web apps in Jetty.
-
How to Query Live Lakebase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Lakebase data in natural language using Python.
-
Query TigerGraph Data in ColdFusion
Write standard ColdFusion data access code to connect to TigerGraph.
-
Replicate Odoo Data to Multiple Databases via the CData Sync CLI
Replicate Odoo ERP to disparate databases with a single configuration.
-
Analyze Odoo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Odoo ERP with the CData JDBC Driver for Odoo.
-
Consume Azure Analysis Services OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Azure Analysis Services feeds that reflect any changes in SAP Lumira.
-
How to Query Live Avro Data in Perplexity MacOS Desktop
Connect to and query live Avro Data in Perplexity Desktop using CData MCP Server.
-
Build Data Flows from Paylocity to SQL Server using SSIS
Easily back up Paylocity to SQL Server using the SSIS components for Paylocity.
-
Add Stripe Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Stripe with the Informatica Enterprise Data Catalog to classify and organize data.
-
Migrating data from ZendeskSell to Snowflake using CData SSIS Components.
Easily push ZendeskSell to Snowflake using the CData SSIS Tasks for ZendeskSell and Snowflake.
-
Migrating data from Planio to Snowflake using CData SSIS Components.
Easily push Planio to Snowflake using the CData SSIS Tasks for Planio and Snowflake.
-
Integrating OpenCode Terminal with SAP BusinessObjects BI 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.
-
ETL ScrapingBee in Oracle Data Integrator
This article shows how to transfer ScrapingBee into a data warehouse using Oracle Data Integrator.
-
Visualize Live Mailgun Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Mailgun.
-
View Reports on Real-Time RabbitMQ Data in Power BI Report Server
Use the CData ODBC Driver for RabbitMQ to visualize RabbitMQ in Power BI Desktop and then publish them to Power BI Report Server.
-
Create HubSpot-Connected Nintex Workflows
Use CData Connect AI to connect to HubSpot Data from Nintex Workflow Cloud and build custom workflows using live HubSpot.
-
Visualize Oracle Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Oracle Database.
-
Integrating LangChain with Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Amazon Athena within automated workflows.
-
DataBind Charts to Zoom Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoom 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.
-
Integrate Google Search with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Search with External Services.
-
How to create an RPA flow for HubDB Data in UiPath Studio
Use the HubDB ODBC Driver to create workflows that access real-time HubDB without any coding.
-
Build Dashboards with Microsoft Exchange Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Exchange in Dundas BI.
-
Connect to NetSuite Data in RapidMiner
Integrate NetSuite CRM & ERP with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software ODBC Driver for ShipStation in MicroStrategy Web
Connect to ShipStation in MicroStrategy Web using the CData Software ODBC Driver for ShipStation.
-
Access JotForm Data from MySQL in Amazon QuickSight
Connect to JotForm and build visualizations of JotForm using a MySQL Connection in Amazon QuickSight.
-
Migrating data from Google Campaign Manager 360 to Snowflake using CData SSIS Components.
Easily push Google Campaign Manager 360 to Snowflake using the CData SSIS Tasks for Google Campaign Manager 360 and Snowflake.
-
Connect to ZohoMarketingHub Data in NetBeans
Connect to ZohoMarketingHub in NetBeans with the data source configuration wizard.
-
Integrate Amplitude with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Amplitude with External Services.
-
Automated Continuous SpaceX Replication to SQL Server
Use CData Sync for automated, continuous, customizable SpaceX replication to SQL Server.
-
Create Elorus Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Elorus from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Authorize.Net 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 Authorize.Net into TIBCO Spotfire.
-
Create Power BI Reports on Real-Time Splunk Data
Use the CData ODBC Driver for Splunk to visualize Splunk in Power BI Desktop.
-
Build an OLAP Cube in SSAS from RabbitMQ Data
Establish a connection to RabbitMQ data from SQL Server Analysis Services, and use the RabbitMQ Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Sugar CRM Data in Sisense
Create an ElastiCube in Sisense app with access to Sugar CRM.