CData Software - Knowledge Base
Recent Articles
-
Integrate with OneNote Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft OneNote in SnapLogic.
-
Integrating Teamgate Data in Talend Cloud Data Management Platform
Connect Teamgate Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate Google Forms with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Forms with External Services.
-
Access Live Amazon Athena 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 Amazon Athena through MCP integration.
-
Connect to Sage 200 Data in RapidMiner
Integrate Sage 200 with standard components and data source configuration wizards in RapidMiner Studio.
-
How to import Teamwork Data into Apache Solr
Use the CData Software JDBC Driver for Teamwork in Data Import Handler and create an automated import of Teamwork to Apache Solr Enterprise Search platform.
-
Create Cosmos DB-Connected Dashboards in Grafana
Connect to Cosmos DB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Azure Cosmos DB.
-
Integrate with live SAP Ariba Procurement Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP Ariba Procurement in Jitterbit.
-
Autopilot Reporting in OBIEE with the Autopilot JDBC Driver
Deploy the Autopilot JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Bidirectional Access to Campaigner Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Campaigner in Filemaker Pro for Mac or Windows.
-
Automated Continuous Aircall Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Aircall replication to Google Cloud SQL.
-
Automated Continuous HCL Domino Replication to IBM DB2
Use CData Sync for automated, continuous, customizable HCL Domino replication to IBM DB2.
-
How to Build an ETL App for Bitbucket Data in Python with CData
Create ETL applications and real-time data pipelines for Bitbucket in Python with petl.
-
Integrate BigQuery with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate BigQuery with External Services.
-
Object-Relational Mapping (ORM) with Front 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 Front into a Java-based ORM framework, Hibernate.
-
Connect to Humanity Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Humanity using standard SQL.
-
How to Access Google Directory Data Using Entity Framework
This article shows how to access Google Directory using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live BigCommerce 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 BigCommerce through MCP integration.
-
How to create Zoho CRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoho CRM in MySQL .
-
Visualize Live GitHub Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live GitHub into custom reports in Power BI.
-
ETL Discourse in Oracle Data Integrator
This article shows how to transfer Discourse into a data warehouse using Oracle Data Integrator.
-
Use Biml to Build SSIS Tasks to Replicate Oracle Sales Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle Sales to SQL Server.
-
Connect to and Visualize Live AfterShip Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live AfterShip.
-
Analyze BenchmarkEmail Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze BenchmarkEmail with the CData JDBC Driver for BenchmarkEmail.
-
Build Apps with Live Snapchat Ads Data Using the Low-Code Development Platform of Mendix
Connect Snapchat Ads with Mendix to build apps using the CData JDBC Driver for Snapchat Ads.
-
Integrate Google Analytics with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Analytics with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Analytics.
-
Integrate Live Mailjet Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Mailjet to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Bitbucket Data in CloverDX (formerly CloverETL)
Transfer Bitbucket using the visual workflow in the CloverDX data integration tool.
-
Replicate Asana Data to Multiple Databases
Replicate Asana to disparate databases with a point-and-click configuration.
-
Bind Live Freshdesk Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Freshdesk data
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zoho CRM
Provide connectivity to Zoho CRM through an SAP BusinessObjects universe.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Exact Online to Power BI dashboards. Simply drag and drop Exact Online into data visuals on the Power BI canvas.
-
Integrate with ConvertAPI Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ConvertAPI to a JSON file on disk.
-
Connect to Exact Online Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Exact Online as an External Source in Dremio.
-
Automated Continuous Amazon Athena Replication to MongoDB
Use CData Sync for automated, continuous, customizable Amazon Athena replication to MongoDB.
-
Bridge Zoho Creator Connectivity with Apache NiFi
Access and process Zoho Creator in Apache NiFi using the CData JDBC Driver.
-
Enable the Cvent JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Cvent.
-
Build Airtable-Connected Apps in Choreo
Use CData Connect AI to connect to Airtable Data from Choreo and build custom apps using live Airtable.
-
Automate SAP SuccessFactors Data Replication to SAP HANA
Use CData Sync to customize and automate SAP SuccessFactors replication to SAP HANA.
-
Integrating Dataiku with Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Ads.
-
Create Reports with Basecamp Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Basecamp.
-
Automated Continuous Smartsheet Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Smartsheet replication to PostgreSQL.
-
Use the CData Software JDBC Driver for Freshservice in MicroStrategy Web
Connect to Freshservice in MicroStrategy Web using the CData Software JDBC Driver for Freshservice.
-
Connect to Gumroad Data in RazorSQL
Connect to Gumroad from wizards and query Gumroad from the GUI in the RazorSQL database management tool.
-
Automated Continuous WordPress Replication to SingleStore
Use CData Sync for automated, continuous, customizable WordPress replication to SingleStore.
-
How to integrate Oracle HCM Cloud with Apache Airflow
Access and process Oracle HCM Cloud in Apache Airflow using the CData JDBC Driver.
-
Visualize GetResponse Data in Tableau
The CData ODBC driver for GetResponse enables you integrate GetResponse into Tableau dashboards.
-
Automated Continuous ClickTime Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ClickTime replication to Apache Cassandra.
-
LINQ to ZarMoney Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the ZarMoney Data Provider.
-
How to Create Power BI Visual Reports with Real-Time Google Campaign Manager 360 Data
Use CData Power BI Connectors to visualize Google Campaign Manager 360 in Power BI.
-
Analyze Greenplum Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Pivotal GreenPlum and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Visualize Lakebase Data in Tableau
The CData ODBC driver for Lakebase enables you integrate Lakebase into Tableau dashboards.
-
Automate DB2 for i Data Replication to Couchbase
Use CData Sync to Customize and automate DB2 for i replication to Couchbase.
-
Connect to Zuora Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Zuora Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Publish Crystal Reports on Google Spanner Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Spanner.
-
Create Informatica Mappings From/To an ODBC Data Source for Excel
Create an ODBC connection to Excel in Informatica and browse and transfer Microsoft Excel.
-
How to Connect to SAP HANA Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP HANA. Leverage the pyodbc module for ODBC in Python.
-
Access Intercom Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Intercom from HeidiSQL.
-
Build MVC Applications with Connectivity to FTP Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access FTP from an ASP.NET MVC application.
-
Integrate Neo4J Data into Power Automate Desktop using CData Connect
CData Connect for Neo4J Data enables you to integrate Neo4J into workflows built using Microsoft Power Automate Desktop.
-
Natively Connect to Lakebase Data in PHP
The CData ODBC driver for Lakebase enables you to create PHP applications with connectivity to Lakebase. Leverage the native support for ODBC in PHP.
-
How to connect to ScrapingBee Data in DBVisualizer
Integrate ScrapingBee with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Mouseflow Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Mouseflow replication to Amazon S3.
-
Getting Started with the CData Power BI Connector for Figshare
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData Python Connector for Egnyte
Learn to install and license the CData Python Connector
-
Replicate SharePoint Data in Heroku for Use in Salesforce Connect
Replicate Microsoft SharePoint to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Gorgias Data in Pentaho Data Integration
Build ETL pipelines based on Gorgias in the Pentaho Data Integration tool.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Pipedrive using the Model Context Protocol.
-
Build Charts with Insightly Data in Clear Analytics
Create dynamic charts and perform analytics based on Insightly in Clear Analytics.
-
A PostgreSQL Interface for Drift Data (MySQL Remoting via JDBC)
Use the Remoting features of the Drift JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Parquet Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Parquet from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating GitHub Copilot CLI with IBM DB2 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.
-
Connect Oracle SCM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Oracle SCM using the CData Python MCP Server.
-
Query Zoho Recruit Data as a MySQL Database in Node.js
Execute MySQL queries against Zoho Recruit from Node.js.
-
Getting Started with the CData Python Connector for Parallel
Learn to install and license the CData Python Connector
-
How to Visualize SFTP Data in Python with pandas
Use pandas and other modules to analyze and visualize live SFTP in Python.
-
Access Live CSV Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live CSV/TSV Files from your Excel spreadsheets.
-
Automate TaxJar Data Replication to Couchbase
Use CData Sync to Customize and automate TaxJar replication to Couchbase.
-
Build Gumroad-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Gumroad and build web apps with connectivity to live Gumroad.
-
Visualize Jumpseller Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Jumpseller.
-
Create Informatica Mappings From/To an ODBC Data Source for Quickbase
Create an ODBC connection to Quickbase in Informatica and browse and transfer Quickbase.
-
Connect Parallel to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Parallel using the CData Python MCP Server.
-
Connect to Scrapfly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Scrapfly in the Denodo Virtual DataPort Administrator.
-
How to Connect to OnePageCrm Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to OnePageCrm. Leverage the pyodbc module for ODBC in Python.
-
Visualize NASA Data in Tableau
The CData ODBC driver for NASA enables you integrate NASA into Tableau dashboards.
-
Create Paylocity-Connected Nintex Workflows
Use CData Connect AI to connect to Paylocity Data from Nintex Workflow Cloud and build custom workflows using live Paylocity.
-
Connect to Anaplan Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Anaplan in the Denodo Virtual DataPort Administrator.
-
Automated Continuous IBM Cloud Object Storage Replication to Vertica
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Vertica.
-
How to Access Live Microsoft Dataverse Data in Visual Studio Code via Cline
Run CData MCP Server for Microsoft Dataverse on Windows Subsytem for Linux (WSL) and connect to live Microsoft Dataverse (CDS) from the Cline extension in Visual Studio Code.
-
Integrate Theia IDE with Live Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to use SQLAlchemy ORM to access LaunchDarkly Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of LaunchDarkly.
-
Use Grok to Talk to Your FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your FreshBooks for you.
-
DataBind Controls to Sybase Data in C++Builder
DataBind to Sybase in C++Builder with standard components and controls.
-
Build Charts with FreshBooks Data in Clear Analytics
Create dynamic charts and perform analytics based on FreshBooks in Clear Analytics.
-
Use the CData Software JDBC Driver for Missive in MicroStrategy
Connect to Missive in MicroStrategy Developer using the CData Software JDBC Driver for Missive.
-
Choosing the Best Method to Connect Certinia to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Certinia from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect to VWO Data from IntelliJ
Integrate connectivity to VWO with wizards in IntelliJ.
-
Access ZohoPeople Data from MySQL in PHP
Connect to ZohoPeople through the standard MySQL libraries in PHP.
-
How to Easily Query Anaplan Data in OpenOffice Base
Connect to Anaplan data in OpenOffice Base using the CData ODBC Driver for Anaplan and generate reports with live data insights.
-
Automate Discord Data Replication to Couchbase
Use CData Sync to Customize and automate Discord replication to Couchbase.