CData Software - Knowledge Base
Recent Articles
-
Extract, Transform, and Load Supabase Data in Informatica PowerCenter
Create a simple Workflow for Supabase in Informatica PowerCenter.
-
Build a Singer.io Tap for Opsgenie With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Opsgenie data using
-
Integrate with PolarTeamPro Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy PolarTeamPro to a JSON file on disk.
-
Connect to SAP Netweaver Gateway Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Netweaver Gateway to connect to SAP Netweaver Gateway and execute queries in PowerBuilder.
-
Setup Routines Could not be Loaded Error Code 126
This error signifies that certain Visual C++ runtimes are missing on your machine.
-
Replicate Coinbase Data to Multiple Databases via the CData Sync CLI
Replicate Coinbase to disparate databases with a single configuration.
-
Access Files in Box Accounts with Nested Folders
A step-by-step guide on retrieving data files within sub-folders of a Box account using CData Box Drivers for seamless data access and integration.
-
Connect to SuiteCRM Data from PowerBuilder via JDBC
This article demonstrates how to access SuiteCRM from PowerBuilder using the SuiteCRM JDBC Driver.
-
Moving Data from OpenWeatherMap to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live OpenWeatherMap data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to SparkPost Data in NetBeans
Connect to SparkPost in NetBeans with the data source configuration wizard.
-
Automated Continuous Amplitude Replication to Vertica
Use CData Sync for automated, continuous, customizable Amplitude replication to Vertica.
-
Use Biml to Build SSIS Tasks to Replicate IBM Informix Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate IBM Informix to SQL Server.
-
How to Connect to Live Neo4J Data 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 Neo4J without replication.
-
Query Redshift Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Amazon Redshift from Node.js.
-
Access Live Amazon S3 Data in Coginiti Pro
Connect to and query live Amazon S3 from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Enable the Mailjet JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Mailjet.
-
Seamlessly Bring API Data into Retool Using CData Connect AI
Integrate API data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to update Exact Online from Excel
This article explains how to transfer data from Excel to Exact Online using the Excel Add-In for Exact Online.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle Financials Cloud
Provide connectivity to Oracle Financials Cloud through an SAP BusinessObjects universe.
-
Integrate Pushbullet Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Pushbullet from Informatica Cloud.
-
Use the CData Software ODBC Driver for Dropbox in MicroStrategy Web
Connect to Dropbox in MicroStrategy Web using the CData Software ODBC Driver for Dropbox.
-
Enable the Salesloft JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Salesloft.
-
Build EnterpriseDB-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to EnterpriseDB Data from Zoho Analytics and import live EnterpriseDB.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Jira Assets within intelligent workflows.
-
Replicate Multiple Coinbase Accounts
Replicate multiple Coinbase accounts to one or many databases.
-
Getting Started with the CData JDBC Driver for Zoho Inventory
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Zoho Inventory.
-
Getting Started with the CData SSIS Components for Jira
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Jira.
-
Create WordPress-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to WordPress Data from Klipfolio and build custom visualizations using live WordPress.
-
Getting Started with the CData JDBC Driver for Qualaroo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Qualaroo.
-
ETL Adobe Analytics in Oracle Data Integrator
This article shows how to transfer Adobe Analytics into a data warehouse using Oracle Data Integrator.
-
Access Live Bitly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Bitly into the statistical analysis tools available in SAS JMP. This article shows how to use Bitly in the Graph Builder and Query Builder.
-
Use the CData Software ODBC Driver for Eventbrite in MicroStrategy
Connect to Eventbrite in MicroStrategy Developer using the CData Software ODBC Driver for Eventbrite.
-
Connect to Browserless Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Browserless and the SQL Gateway to access Browserless from Google Apps Script.
-
Automated Zoho Inventory Data Replication to Teradata
Use CData Sync to Customize and automate Zoho Inventory replication to Teradata.
-
How to Create Power BI Visual Reports with Real-Time Aha! Data
Use CData Power BI Connectors to visualize Aha! in Power BI.
-
Prepare, Blend, and Analyze Jira Data in Alteryx Designer (ODBC)
Build workflows to access live Atlassian Jira for self-service data analytics.
-
Analyze Dynamics 365 Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Dynamics 365 from Power Pivot. You will use the Table Import Wizard to load Microsoft Dynamics 365. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Scrapfly Data from PowerBuilder via ADO.NET
This article demonstrates how to access Scrapfly from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Object-Relational Mapping (ORM) with Act-On 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 Act-On into a Java-based ORM framework, Hibernate.
-
Connect to ClickTime Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ClickTime and work with ClickTime in your FileMaker applications.
-
Create Dynamic EmailOctopus Grids Using the Infragistics XamDataGrid
Learn how you can connect EmailOctopus to Infragistics XamDataGrid to build dynamic grids.
-
Create SSAS Tabular Models from SQL Analysis Services Data
How to build a SQL Server Analysis Service Tabular Model from SQL Analysis Services using CData drivers.
-
Use Databricks Agent Bricks to Talk to Your Dynamics 365 Business Central Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Dynamics 365 Business Central for you.
-
DataBind Controls to JSON Services in C++Builder
DataBind to JSON in C++Builder with standard components and controls.
-
Natively Connect to Dynamics CRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Dynamics CRM. Leverage the native support for ODBC in PHP.
-
Dynamics NAV Reporting in OBIEE with the Dynamics NAV JDBC Driver
Deploy the Dynamics NAV JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build a PostgreSQL Interface for Google Ad Manager Data using the CData JDBC Driver
Use the Remoting features of the Google Ad Manager JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to Jumpseller Data with Squirrel SQL client
Connect to Jumpseller and execute queries in the Squirrel SQL Client.
-
Build Jira Assets-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Jira Assets to explore live Jira Assets Data in GitHub Copilot to assist with building Jira Assets-powered applications.
-
Connect to Presto Data in RazorSQL
Connect to Presto from wizards and query Presto from the GUI in the RazorSQL database management tool.
-
Use Dash to Build to Web Apps on HelloSign Data
Create Python applications that use pandas and Dash to build HelloSign-connected web apps.
-
Connect to Planio Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Planio using standard SQL.
-
Build Semantic Layer Views for MailChimp Data in APOS Live Data Gateway
Use the CData Connector for MailChimp in APOS Live Data Gateway to build Semantic Layer Views for MailChimp.
-
Use Dash to Build to Web Apps on AlloyDB Data
Create Python applications that use pandas and Dash to build AlloyDB-connected web apps.
-
Build a Singer.io Tap for SparkPost With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SparkPost data using
-
Integrating Codex CLI with Sage Intacct 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 Build an ETL App for Tally Data in Python with CData Connect AI
Build ETL pipelines that read and write live Tally ERP in Python with petl and the CData Connect AI Python SDK.
-
Enable the Vercel JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Vercel.
-
Integrate Wrike Data in the Pentaho Report Designer
Publish reports based on Wrike in the Pentaho BI tool.
-
Build AI/ML Models with Live Email Data using Dataiku
Connect Email Data with Dataiku using the CData JDBC Driver for Email.
-
How to Access Discord Data Using Entity Framework
This article shows how to access Discord using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zendesk
Provide connectivity to Zendesk through an SAP BusinessObjects universe.
-
Access Live Redshift 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 Amazon Redshift through MCP integration.
-
How to load Oracle SCM data into Elasticsearch via Logstash
Introducing a simple method to load Oracle SCM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Live Tickspot Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Tickspot to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Email Data from PowerBuilder via ADO.NET
This article demonstrates how to access Email from Appeon PowerBuilder using the CData ADO.NET Provider for Email.
-
Getting Started with the CData Excel Add-In for OnePageCrm
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for OnePageCrm.
-
Connect to Oracle SCM Data in DBeaver
Use the CData ODBC Driver to connect to Oracle SCM in DBeaver.
-
Connect to Oracle Data in JRuby
Create a simple JRuby app with access to live Oracle Database.
-
Build a PostgreSQL Interface for Dynamics CRM Data using the CData JDBC Driver
Use the Remoting features of the Dynamics CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to LinkedIn Ads Data from PowerBuilder via JDBC
This article demonstrates how to access LinkedIn Ads from PowerBuilder using the LinkedIn Ads JDBC Driver.
-
Connect to TigerGraph Data in DBArtisan
Use wizards in DBArtisan to configure TigerGraph as a data source.
-
Connect and Query Live Freshservice Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Freshservice into Databricks
-
Use the CData ODBC Driver for Discourse in Microsoft Power Query
You can use the CData Discourse ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Discourse into Microsoft Power Query.
-
Use the CData Software JDBC Driver for Aweber in MicroStrategy
Connect to Aweber in MicroStrategy Developer using the CData Software JDBC Driver for Aweber.
-
How to work with Zendesk Data in Apache Spark using SQL
Access and process Zendesk Data in Apache Spark using the CData Software JDBC Driver.
-
Prepare, Blend, and Analyze Outlook Data in Alteryx Designer (ODBC)
Build workflows to access live Outlook for self-service data analytics.
-
Moving Data from RSS to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live RSS data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Analyze Live SAP HANA Data in SAS Viya
Use CData Connect AI to connect to SAP HANA from SAS Viya and deploy self-service analytics using live SAP HANA.
-
DataBind Timely Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Timely to a chart.
-
Build Charts with Cloudant Data in Clear Analytics
Create dynamic charts and perform analytics based on IBM Cloudant in Clear Analytics.
-
Connect to ZohoMarketingHub Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ZohoMarketingHub using standard SQL.
-
Build Basecamp-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Basecamp and build web apps with connectivity to live Basecamp.
-
Connect to Square Data in DBeaver
Use the CData ODBC Driver to connect to Square in DBeaver.
-
Getting Started with the CData SSIS Components for Campaigner
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Campaigner.
-
Create Reports with DocuSign Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date DocuSign.
-
Build Dashboards with Sage 200 Data in Dundas BI
Create dynamic dashboards and perform analytics based on Sage 200 in Dundas BI.
-
Connect to Sugar CRM Data in JRuby
Create a simple JRuby app with access to live Sugar CRM.
-
Explore Geographical Relationships in Parquet Data with Power Map
Create data visualizations with Apache Parquet in Power Map.
-
How to connect and process Timely from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Timely.
-
Natively Connect to Printify Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Printify. Leverage the native support for ODBC in PHP.
-
Automate Facebook Ads Data Replication to SAP HANA
Use CData Sync to customize and automate Facebook Ads replication to SAP HANA.
-
Replicate Tally Data to Multiple Databases
Replicate Tally ERP to disparate databases with a point-and-click configuration.
-
How to Connect Flowise AI Agents to Live Smartsheet 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 Smartsheet without replication.
-
Use the CData ODBC Driver for SAS Data Sets from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAS Data Sets to connect to SAS Data Sets from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAS Data Sets in Excel.
-
Bridge Salesloft Connectivity with Apache NiFi
Access and process Salesloft in Apache NiFi using the CData JDBC Driver.
-
Replicate Keap Data from PowerShell
Write a quick PowerShell script to query Keap. Use connectivity to the live data to replicate Keap to SQL Server.
-
Build Apps with Live Exact Online Data Using the Low-Code Development Platform of Mendix
Connect Exact Online with Mendix to build apps using the CData JDBC Driver for Exact Online.
-
Automated Continuous PivotalTracker Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable PivotalTracker replication to Apache Kafka.
-
Connect to Zoho Books Data in RapidMiner
Integrate Zoho Books with standard components and data source configuration wizards in RapidMiner Studio.