CData Software - Knowledge Base
Recent Articles
-
Create Shopify Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Shopify data access from reports, embedded analytics, and more.
-
Automated Continuous Pinterest Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Pinterest replication to Amazon Redshift.
-
Access Live FTP Data in TIBCO Data Virtualization
Use the FTP Tibco DV Adapter to create a FTP Servers data source in TIBCO Data Virtualization Studio and gain access to live FTP Servers from your TDV Server.
-
Automated Continuous Teradata Replication to Oracle
Use CData Sync for automated, continuous, customizable Teradata replication to Oracle.
-
Access CloudConvert Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live CloudConvert from HeidiSQL.
-
Automated Continuous MariaDB Replication to SQLite
Use CData Sync for automated, continuous, customizable MariaDB replication to SQLite.
-
Moving Data from MarkLogic to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live MarkLogic data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Qualaroo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Qualaroo.
-
Model, Search, and Visualize Live QuickBooks Time Data in ThoughtSpot
Use CData Connect AI to connect to live QuickBooks Time for modeling, searching, and visualizing.
-
Connect to SAP ByDesign Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP ByDesign to connect to SAP Business ByDesign and execute queries in PowerBuilder.
-
How to connect and process PabblySubscriptions from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PabblySubscriptions.
-
Use Dash to Build Web Apps on Okta Data via CData Connect AI
Build interactive Dash web apps on live Okta using pandas and the CData Connect AI Python SDK.
-
Moving Data from ZohoPeople to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ZohoPeople data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Publish Crystal Reports on Qualaroo Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Qualaroo.
-
Connect to Oracle Service Cloud Data in JRuby
Create a simple JRuby app with access to live Oracle Service Cloud.
-
Natively Connect to SharePoint Excel Services Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SharePoint Excel Services. Leverage the native support for ODBC in PHP.
-
Automate PostgreSQL Integration Tasks from PowerShell
Are you in search of a quick and easy way to access PostgreSQL from PowerShell? This article demonstrates how to utilize the PostgreSQL Cmdlets for tasks like connecting to PostgreSQL, automating operations, downloading data, and more.
-
Build Apps with Live SAP Ariba Source Data Using the Low-Code Development Platform of Mendix
Connect SAP Ariba Source with Mendix to build apps using the CData JDBC Driver for SAP Ariba Source.
-
Create a Data Access Object for Float Data using JDBI
A brief overview of creating a SQL Object API for Float in JDBI.
-
Automated Continuous Clockify Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Clockify replication to PostgreSQL.
-
Connect PostgreSQL to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect PostgreSQL with IBM WebSphere for seamless data integration and connectivity.
-
Publish Nuclia-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Nuclia.
-
Replicate Sage 300 Data to Multiple Databases via the CData Sync CLI
Replicate Sage 300 to disparate databases with a single configuration.
-
ETL Jira Assets in Oracle Data Integrator
This article shows how to transfer Jira Assets into a data warehouse using Oracle Data Integrator.
-
Access Copper 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 Copper.
-
Access Live NASA Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate NASA into the statistical analysis tools available in SAS JMP. This article shows how to use NASA in the Graph Builder and Query Builder.
-
Integrating LangGraph with OData Services via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on OData within automated workflows.
-
Create Power BI Reports on Real-Time Opsgenie Data
Use the CData ODBC Driver for Opsgenie to visualize Opsgenie in Power BI Desktop.
-
Validate LinkedIn Data with QuerySurge
Access and validate LinkedIn in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Authorize.Net Replication to Snowflake
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Snowflake.
-
DataBind Controls to Accelo Data in Delphi
DataBind to Accelo in Delphi with standard data access components and controls.
-
Access Live Adobe Target Data in Coginiti Pro
Connect to and query live Adobe Target from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Access Mailgun Data Using Entity Framework
This article shows how to access Mailgun using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData ODBC Driver for Bannerbear from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Bannerbear to connect to Bannerbear from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Bannerbear in Excel.
-
Feed Oracle Service Cloud Data into FineReport
How to set Oracle Service Cloud as a JDBC data source in FineReport.
-
Integrate IBM Cloud Object Storage with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate IBM Cloud Object Storage with External Services.
-
Create Informatica Mappings From/To an ODBC Data Source for Bullhorn CRM
Create an ODBC connection to Bullhorn CRM in Informatica and browse and transfer Bullhorn CRM.
-
Connect to AlloyDB Data in Jaspersoft Studio
Execute SQL to remote Google AlloyDB in Jaspersoft Studio.
-
DataBind Controls to Google Directory Data in C++Builder
DataBind to Google Directory in C++Builder with standard components and controls.
-
Automated Continuous Dotmailer Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Dotmailer replication to Amazon S3.
-
Connect to Blackbaud FE NXT Data in CloverDX (formerly CloverETL)
Transfer Blackbaud FE NXT using the visual workflow in the CloverDX data integration tool.
-
ETL Cvent in Oracle Data Integrator
This article shows how to transfer Cvent into a data warehouse using Oracle Data Integrator.
-
Integrating Claude Code with Power BI XMLA Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Power BI XMLA within assisted coding and automated development workflows.
-
Use the CData Software JDBC Driver for ZohoExpense in MicroStrategy Web
Connect to ZohoExpense in MicroStrategy Web using the CData Software JDBC Driver for ZohoExpense.
-
Automated Continuous FreshBooks Replication to SQL Server
Use CData Sync for automated, continuous, customizable FreshBooks replication to SQL Server.
-
Integrate Toggl Data in the Pentaho Report Designer
Publish reports based on Toggl in the Pentaho BI tool.
-
Automated Continuous Keap Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Keap replication to Amazon S3.
-
Build Dashboards with Zoho Books Data in DBxtra
Create dynamic dashboards and perform analytics based on Zoho Books in DBxtra.
-
Create Sybase-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Sybase Data from Klipfolio and build custom visualizations using live Sybase.
-
How to Visualize ShipEngine Data in Python with pandas
Use pandas and other modules to analyze and visualize live ShipEngine in Python.
-
Create NetSuite Dataflows on PowerBI.com
Connect to the CData Power BI Connector for NetSuite from PowerBI.com to create Power BI Dataflows with real-time data.
-
Easily Integrate SQL Analysis Services Data in Lazarus Pascal IDE
Learn how to easily integrate live SQL Analysis Services in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to create an RPA flow for Everhour Data in UiPath Studio
Use the Everhour ODBC Driver to create workflows that access real-time Everhour without any coding.
-
How to Import Data from Amazon DynamoDB into Google Sheets
Import Amazon DynamoDB into a Google spreadsheet that is automatically refreshed.
-
Prepare, Blend, and Analyze Google Translate Data in Alteryx Designer (ODBC)
Build workflows to access live Google Translate for self-service data analytics.
-
Publish Close-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Close.
-
Build Microsoft OneDrive-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Microsoft OneDrive to explore live Microsoft OneDrive Data in Gemini Code Assist to assist with building Microsoft OneDrive-powered applications.
-
Automated Continuous SendPulse Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SendPulse replication to Azure SQL Database.
-
How to create ZohoMarketingHub federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ZohoMarketingHub in MySQL .
-
Use the CData ODBC Driver for GraphQL in Microsoft Power Query
You can use the CData GraphQL ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import GraphQL into Microsoft Power Query.
-
Automated Continuous Keap Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Keap replication to PostgreSQL.
-
Integrating Codex CLI with Oracle HCM Cloud 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.
-
Deploy the ADO.NET Provider for FreeAgent on an SSRS Report Server
Connect to FreeAgent 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.
-
Integrating Claude Code CLI with REST 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.
-
Integrate Cursor with Live Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Zoho Creator from within the editor.
-
Access Monday.com 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 Monday.com.
-
Moving Data from FormSite to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live FormSite data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Data Flows from SQL Server to Email through SSIS
Easily push SQL Server data to Email using the CData SSIS Tasks for Email.
-
How to Connect to Instagram Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Instagram. Leverage the pyodbc module for ODBC in Python.
-
Publish EmailOctopus-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live EmailOctopus.
-
ETL AgileCRM in Oracle Data Integrator
This article shows how to transfer AgileCRM into a data warehouse using Oracle Data Integrator.
-
How to connect and process Sybase from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sybase.
-
Automated Continuous Azure Data Catalog Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to IBM DB2.
-
Connect to SAS xpt Data in CloverDX (formerly CloverETL)
Transfer SAS XPORT using the visual workflow in the CloverDX data integration tool.
-
Consume Raisers Edge NXT OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Raisers Edge NXT feeds that reflect any changes in SAP Lumira.
-
Getting Started with the CData Python Connector for SendInBlue
Learn to install and license the CData Python Connector
-
Automate Salesforce Data Replication to SAP HANA
Use CData Sync to customize and automate Salesforce & Force.com replication to SAP HANA.
-
Query Oracle SCM Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Oracle SCM and perform CRUD operations on Oracle SCM from Node.js.
-
Create Apps from Oracle SCM Data in Qlik Sense Cloud
Use CData Connect AI to connect to Oracle SCM Data and build apps from live Oracle SCM in Qlik Sense Cloud.
-
Analyze Unbounce Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Unbounce in Microsoft R Open.
-
Integrate Close Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Close from Informatica Cloud.
-
Analyze Landbot Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Landbot with the CData JDBC Driver for Landbot.
-
Use the CData Software ODBC Driver for FormSite in MicroStrategy Web
Connect to FormSite in MicroStrategy Web using the CData Software ODBC Driver for FormSite.
-
Automated Continuous Supabase Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Supabase replication to Apache Cassandra.
-
Publish REST-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live REST.
-
How to import Sage 300 Data into Apache Solr
Use the CData Software JDBC Driver for Sage 300 in Data Import Handler and create an automated import of Sage 300 to Apache Solr Enterprise Search platform.
-
Integrate Open WebUI with Live SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAS Data Sets from within the chat interface.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live MarkLogic using the Model Context Protocol.
-
Use the CData Software ODBC Driver for Okta in MicroStrategy Desktop
Connect to Okta in MicroStrategy Desktop using the CData Software ODBC Driver for Okta.
-
Use the CData Software JDBC Driver for Presto in MicroStrategy Desktop
Connect to Presto in MicroStrategy Desktop using the CData Software JDBC Driver for Presto.
-
Connect to CouchDB Data in Aqua Data Studio
Access Apache CouchDB from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to EnterpriseDB Data in DBArtisan
Use wizards in DBArtisan to configure EnterpriseDB as a data source.
-
Bidirectional Access to Qualaroo Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Qualaroo in Filemaker Pro for Mac or Windows.
-
Migrating data from Google Ad Manager to Google BigQuery using CData SSIS Components.
Easily push Google Ad Manager to Google BigQuery using the CData SSIS Tasks for Google Ad Manager and Google BigQuery.
-
Enable the Mouseflow JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Mouseflow.
-
Analyze Oracle Service Cloud Data in Cognos Analytics
Use CData Connect AI to connect to Oracle Service Cloud Data from Cognos Analytics and analyze live Oracle Service Cloud.
-
Getting Started with the CData Connect AI Python SDK for SAS Data Sets
Install the CData Connect AI Python SDK to read and write live SAS Data Sets with standard DB-API 2.0 Python code.
-
Build Visualizations of SAP Netweaver Gateway Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Netweaver Gateway in Birst.
-
Integrate Cassandra Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Apache Cassandra and integrate live Apache Cassandra into your Power Automate tasks.
-
Use the CData SSIS Components to Insert New or Update Existing Zendesk Records from SQL Server
Easily push SQL Server data to Zendesk using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Zendesk or update existing records with data from a SQL Server database.