CData Software - Knowledge Base
Recent Articles
-
Connect to eBay Data from HeidiSQL
Use CData Connect AI to connect to and query live eBay from HeidiSQL.
-
How to Visualize SAP Hybris C4C Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP Hybris C4C in Python.
-
DataBind Controls to ZohoDesk Data in Delphi
DataBind to ZohoDesk in Delphi with standard data access components and controls.
-
How to Access Live Exact Online Data in Visual Studio Code via Cline
Run CData MCP Server for Exact Online on Windows Subsytem for Linux (WSL) and connect to live Exact Online from the Cline extension in Visual Studio Code.
-
Back Up Shippo 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 Shippo data.
-
Getting Started with the CData Excel Add-In for Salesforce
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Salesforce.
-
Automated MariaDB Data Replication to Teradata
Use CData Sync to Customize and automate MariaDB replication to Teradata.
-
How to create Tickspot federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Tickspot in MySQL .
-
Build AI/ML Models with Live Sage 200 Data using Dataiku
Connect Sage 200 Data with Dataiku using the CData JDBC Driver for Sage 200.
-
Connect to Impala Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Apache Impala from Filemaker Pro on Mac.
-
Connect Act-On to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Act-On with IBM WebSphere for seamless data integration and connectivity.
-
Build GraphQL-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for GraphQL to explore live GraphQL Data in GitHub Copilot to assist with building GraphQL-powered applications.
-
Connect to Twilio Data in ACL Analytics
Connect to Twilio via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Twilio.
-
Replicate PayPal Data from PowerShell
Write a quick PowerShell script to query PayPal. Use connectivity to the live data to replicate PayPal to SQL Server.
-
How to Connect MongoDB Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live MongoDB data in real time using natural language.
-
Connect to Sybase Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Sybase in the Denodo Virtual DataPort Administrator.
-
Build Bugsnag-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Bugsnag and build web apps with connectivity to live Bugsnag.
-
Build Apps with Live Vertica in Adalo using CData Connect AI
Use CData Connect AI to integrate live Vertica into the Adalo platform and build custom mobile and web applications with real-time Vertica.
-
Automated Continuous EnterpriseDB Replication to MongoDB
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to MongoDB.
-
How to work with FormSite Data in Apache Spark using SQL
Access and process FormSite Data in Apache Spark using the CData Software JDBC Driver.
-
Create Dynamic Parquet Grids Using the Infragistics XamDataGrid
Learn how you can connect Parquet to Infragistics XamDataGrid to build dynamic grids.
-
Access Live SAS xpt Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAS XPORT from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Getting Started with the CData Connect AI Python SDK for Shopify
Install the CData Connect AI Python SDK to read and write live Shopify with standard DB-API 2.0 Python code.
-
Analyze PivotalTracker Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PivotalTracker with the CData JDBC Driver for PivotalTracker.
-
How to Connect DBeaver to QuickBooks Online via a JDBC Driver
Manage QuickBooks Online with visual tools in DBeaver like the query browser.
-
Stream Perigon Data into Apache Kafka Topics
Access and stream Perigon in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live Email Data in TIBCO Data Virtualization
Use the Email Tibco DV Adapter to create a Email data source in TIBCO Data Virtualization Studio and gain access to live Email from your TDV Server.
-
Use the CData Software JDBC Driver for Zoho Creator in MicroStrategy
Connect to Zoho Creator in MicroStrategy Developer using the CData Software JDBC Driver for Zoho Creator.
-
Query ADP Data as a SQL Server Database in Node.js
Execute SQL Server queries against ADP from Node.js.
-
Access Live Outreach.io 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 Outreach.io through MCP integration.
-
Query Templated Data as a MySQL Database in Node.js
Execute MySQL queries against Templated from Node.js.
-
Build CampaignMonitor-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live CampaignMonitor.
-
Extract, Transform, and Load Dropbox Data in Informatica PowerCenter
Create a simple Workflow for Dropbox in Informatica PowerCenter.
-
Back Up ZendeskSell 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 ZendeskSell data.
-
DataBind Controls to Close Data in C++Builder
DataBind to Close in C++Builder with standard components and controls.
-
Replicate Pinterest Data to Multiple Databases
Replicate Pinterest to disparate databases with a point-and-click configuration.
-
Build Semantic Layer Views for Tickspot Data in APOS Live Data Gateway
Use the CData Connector for Tickspot in APOS Live Data Gateway to build Semantic Layer Views for Tickspot.
-
Provide OData Services of Salesforce Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Salesforce & Force.com by developing a WCF Service Application.
-
Integrate Close Data in Pentaho Data Integration
Build ETL pipelines based on Close in the Pentaho Data Integration tool.
-
Build Reckon Accounts Hosted-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Reckon Accounts Hosted.
-
How to Build an ETL App for Adobe Experience Manager Data in Python with CData
Create ETL applications and real-time data pipelines for Adobe Experience Manager in Python with petl.
-
Connect eBay Analytics to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect eBay Analytics with IBM WebSphere for seamless data integration and connectivity.
-
Build a Singer.io Tap for PhantomBuster With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PhantomBuster data using
-
Object-Relational Mapping (ORM) with Zoho CRM 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 Zoho CRM into a Java-based ORM framework, Hibernate.
-
SAP Netweaver Gateway Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP Netweaver Gateway through CData Connect AI using different applications and tools.
-
Publish Mistral AI-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Mistral AI.
-
Build a Singer.io Tap for GitHub With the CData Python Connector
Learn how to easily build a Singer.io Tap for live GitHub data using
-
Access Amazon Athena Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Amazon Athena from your Oracle system.
-
Integrating Codex CLI with Datadog 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.
-
Load Everhour Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Everhour to a database.
-
Integrate with Float Data in JReport Designer
Create charts and reports based on Float in JReport Designer.
-
Excel Spreadsheet Automation on Stack Exchange Data with the QUERY Formula
Pull data from Stack Exchange, automate spreadsheets, and more with the QUERY formula.
-
Build a Singer.io Tap for Browserless With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Browserless data using
-
How to connect to LDAP Objects with Squirrel SQL client
Connect to LDAP and execute queries in the Squirrel SQL Client.
-
DataBind Charts to Onfleet Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Onfleet 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.
-
DataBind Controls to VWO Data in C++Builder
DataBind to VWO in C++Builder with standard components and controls.
-
How to Build an ETL App for Discourse Data in Python with CData
Create ETL applications and real-time data pipelines for Discourse in Python with petl.
-
Integrate Cosmos DB Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Azure Cosmos DB from Informatica Cloud.
-
Use the CData Software ODBC Driver for ClickTime in MicroStrategy
Connect to ClickTime in MicroStrategy Developer using the CData Software ODBC Driver for ClickTime.
-
Avaza Reporting in OBIEE with the Avaza JDBC Driver
Deploy the Avaza JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Analyze PostgreSQL Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of PostgreSQL and visualize live PostgreSQL in Infragistics Reveal.
-
Connect to Impala from Asprova with CData Software ODBC Driver for Impala
This article shows how to connect faster to Impala data from Asprova.
-
Connect to Zoho CRM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho CRM and the Script function in FileMaker Pro to connect to Zoho CRM and work with Zoho CRM in your FileMaker application.
-
Connect to Sage 200 Data from HeidiSQL
Use CData Connect AI to connect to and query live Sage 200 from HeidiSQL.
-
How to connect PolyBase to Reckon
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Reckon.
-
How to integrate OData with Apache Airflow
Access and process OData in Apache Airflow using the CData JDBC Driver.
-
Connect to Discord in SpagoBI
Create reports featuring live Discord in SpagoBI Studio. Host Discord reports on SpagoBI Server.
-
Use Biml to Build SSIS Tasks to Replicate SAP Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP ERP/NetWeaver to SQL Server.
-
Replicate Slack Data to Multiple Databases via the CData Sync CLI
Replicate Slack to disparate databases with a single configuration.
-
Access Amazon Marketplace Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Amazon Marketplace from HeidiSQL.
-
Getting Started with the CData Python Connector for Bannerbear
Learn to install and license the CData Python Connector
-
How to use SQLAlchemy ORM to access Rebilly Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Rebilly.
-
How to Connect to Live Microsoft Ads Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Microsoft Ads securely in real time.
-
How to connect to Todoist Data from IntelliJ
Integrate connectivity to Todoist with wizards in IntelliJ.
-
Create Power BI Reports on Real-Time eBay Data
Use the CData ODBC Driver for eBay to visualize eBay in Power BI Desktop.
-
ETL Notion in Oracle Data Integrator
This article shows how to transfer Notion into a data warehouse using Oracle Data Integrator.
-
Enable the Asana JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Asana.
-
Automated Continuous HelloSign Replication to SingleStore
Use CData Sync for automated, continuous, customizable HelloSign replication to SingleStore.
-
Connecting Moonlit Workflow with Procore Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Procore in real time.
-
Create Harvest Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Harvest data access from reports, embedded analytics, and more.
-
Query Zoho Projects Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zoho Projects from Node.js.
-
Connect to Reply.io Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Reply.io and work with Reply.io in your FileMaker applications.
-
Integrate Microsoft Ads Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Ads from Informatica Cloud.
-
Automated Continuous LightSpeedRetail Replication to Databricks
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Databricks.
-
Automated Slack Data Replication to Teradata
Use CData Sync to Customize and automate Slack replication to Teradata.
-
Work with Live MariaDB Data in Power Query
Use CData Connect AI to connect to MariaDB and work with live MariaDB in Microsoft Power Query.
-
How to Easily Query Campaigner Data in OpenOffice Base
Connect to Campaigner data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Mailgun Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Mailgun and work with Mailgun in your FileMaker application.
-
Visualize Phoenix Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Apache Phoenix.
-
Replicate Miro Data from PowerShell
Write a quick PowerShell script to query Miro. Use connectivity to the live data to replicate Miro to SQL Server.
-
Viewing HCL Domino Data in RAD Studio Data Explorer
How to view HCL Domino in RAD Studio Data Explorer using the CData ODBC Driver for HCL Domino.
-
How to publish and share Spark Data dashboards with Tableau Server
The CData ODBC driver for Spark enables you integrate Apache Spark SQL into Tableau dashboards.
-
Access Live CircleCI Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate CircleCI into the statistical analysis tools available in SAS JMP. This article shows how to use CircleCI in the Graph Builder and Query Builder.
-
Build Data Flows from Lakebase to SQL Server using SSIS
Easily back up Lakebase to SQL Server using the SSIS components for Lakebase.
-
How to integrate Metabase with Sage Intacct Data
Use CData Connect AI to connect to live Sage Intacct and create an interactive dashboard in Metabase from Sage Intacct.
-
Work with Asana Data in FoxPro
Load Asana into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Visualize AdRoll Data in Python with pandas
Use pandas and other modules to analyze and visualize live AdRoll in Python.
-
How to Seamlessly Import Redshift Data into IBM SPSS Modeler
Integrate Redshift data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate with Live GitLab Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to GitLab from the MuleSoft Anypoint Platform to integrate live GitLab into custom reports and dashboards.
-
Launch the API Server AMI on Amazon Web Services
Host the Java edition of an API Server on Amazon Web Services using the API Server Amazon Machine Instance.