CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for CouchDB in MicroStrategy
Connect to CouchDB data in MicroStrategy Developer using the CData Software ODBC Driver for CouchDB.
-
Connect to Templated Data in NetBeans
Connect to Templated data in NetBeans with the data source configuration wizard.
-
Object-Relational Mapping (ORM) with Gmail 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 Gmail data into a Java-based ORM framework, Hibernate.
-
Replicate Recurly Data in Heroku for Use in Salesforce Connect
Replicate Recurly data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Dynamic Dynamics 365 Grids Using the Infragistics XamDataGrid
Learn how you can connect Dynamics 365 to Infragistics XamDataGrid to build dynamic grids.
-
Create Sybase IQ Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Sybase IQ from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to import Gong Data into Apache Solr
Use the CData Software JDBC Driver for Gong in Data Import Handler and create an automated import of Gong data to Apache Solr Enterprise Search platform.
-
Use the CData ODBC Driver for Basecamp in Microsoft Power Query
You can use the CData Basecamp ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Basecamp data into Microsoft Power Query.
-
Visualize Gorgias Data in Sisense
Create an ElastiCube in Sisense app with access to Gorgias data.
-
How to use SQLAlchemy ORM to access Stack Exchange Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Stack Exchange data.
-
Use the CData Software ODBC Driver for Highrise in MicroStrategy Desktop
Connect to Highrise data in MicroStrategy Desktop using the CData Software ODBC Driver for Highrise.
-
How to Connect to Live ADP Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your ADP data for you.
-
Connect to Wave Financial Data in RapidMiner
Integrate Wave Financial data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect to Azure Synapse Data in DBVisualizer
Integrate Azure Synapse data with visual data analysis tools and data connection wizards in DBVisualizer
-
Visualize Live Highrise Data in the Power BI Service
Use CData Connect AI to connect to live Highrise data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Live Procore 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 Procore data for you.
-
Publish Cloudant-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Cloudant data.
-
Connect to Simplesat Data in RapidMiner
Integrate Simplesat data with standard components and data source configuration wizards in RapidMiner Studio.
-
Working with Bitbucket Data in LINQPad
Execute LINQ queries to Bitbucket data in LINQPad.
-
A PostgreSQL Interface for NetSuite Data (MySQL Remoting via JDBC)
Use the Remoting features of the NetSuite JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated SharePoint Excel Services Data Replication to Teradata
Use CData Sync to Customize and automate SharePoint Excel Services data replication to Teradata.
-
Integrating Kiro with Copper 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.
-
LINQ to Pinterest 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 Pinterest Data Provider.
-
Stream SingleStore Data into Apache Kafka Topics
Access and stream SingleStore data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use Biml to Build SSIS Tasks to Replicate Sage Intacct Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sage Intacct data to SQL Server.
-
How to Connect the Power BI Service to Insightly: Complete Guide
Connect to the CData Software Power BI Connector for Insightly from PowerBI.com to provide real-time Insightly data across the organization.
-
Integrating Kiro with Apollo 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.
-
Build Pipelines with Live Hive Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Hive from Google Cloud Data Fusion, enabling the integration of live Hive data into the building and management of effective data pipelines.
-
Automated Continuous Printful Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Printful replication to IBM DB2.
-
Automated Continuous Instantly Replication to MySQL
Use CData Sync for automated, continuous, customizable Instantly replication to MySQL.
-
How to Create Power BI Visual Reports with Real-Time Zoho Books Data
Use CData Power BI Connectors to visualize Zoho Books data in Power BI.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Basecamp
Provide connectivity to Basecamp data through an SAP BusinessObjects universe.
-
Build a PostgreSQL Interface for Superchat Data using the CData JDBC Driver
Use the Remoting features of the Superchat JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Jumpseller Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Jumpseller replication to Google BigQuery.
-
Integrate with Live Guru Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Guru from the MuleSoft Anypoint Platform to integrate live Guru data into custom reports and dashboards.
-
Connect to Cosmos DB Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Cosmos DB data.
-
Integrating Oracle Service Cloud Data in Talend Cloud Data Management Platform
Connect Oracle Service Cloud Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle Service Cloud.
-
Connect to Box Data in NetBeans
Connect to Box data in NetBeans with the data source configuration wizard.
-
Create Gmail-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Gmail Data from Klipfolio and build custom visualizations using live Gmail data.
-
Connect to Datadog Data in HULFT Integrate
Connect to Datadog as a JDBC data source in HULFT Integrate
-
Use the CData Software ODBC Driver for Placid in MicroStrategy
Connect to Placid data in MicroStrategy Developer using the CData Software ODBC Driver for Placid.
-
Connect to FHIR Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live FHIR data.
-
A PostgreSQL Interface for VWO Data using the CData ODBC Driver
Use the SQL Gateway and VWO ODBC Driver to create a PostgreSQL entry-point for data access.
-
Amazon S3 Reporting in OBIEE with the Amazon S3 JDBC Driver
Deploy the Amazon S3 JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Back Up NetSuite data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for NetSuite. In this article, we will employ an SSIS workflow to populate a database with NetSuite data data.
-
Automated Continuous Workable Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Workable replication to Amazon S3.
-
Integrate Devin with Live Splunk Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Splunk data.
-
Build AI/ML Models with Live Auth0 Data using Dataiku
Connect Auth0 Data with Dataiku using the CData API Driver for JDBC.
-
Building Dynamic Web Pages with Snapchat Ads Data Using AngularJS
Create single-page applications with live connectivity to Snapchat Ads using the CData API Server.
-
Load MYOB AccountRight Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MYOB AccountRight data to a database.
-
Replicate SAP SuccessFactors Data from PowerShell
Write a quick PowerShell script to query SAP SuccessFactors data. Use connectivity to the live data to replicate SAP SuccessFactors data to SQL Server.
-
Integrating LangGraph with Cosmos DB Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Cosmos DB data within automated workflows.
-
Getting Started with the CData Python Connector for Oracle Sales
Learn to install and license the CData Python Connector and configure a connection to live Oracle Sales data.
-
Automated Continuous Auth0 Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Auth0 replication to IBM DB2.
-
Simplesat Reporting in OBIEE with the Simplesat JDBC Driver
Deploy the Simplesat JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Visualizations of HelloSign Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of HelloSign data in Birst.
-
Feed Todoist Data into FineReport
How to set Todoist data as a JDBC data source in FineReport.
-
Access Elorus Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Elorus data from HeidiSQL.
-
Getting Started with the CData ADO.NET Provider for Tickspot
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect Google Drive to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Drive data using the CData Python MCP Server.
-
Getting Started with the CData SSIS Components for AfterShip
Complete guide to installing, licensing, and connecting with the CData SSIS Components for AfterShip.
-
Use Dash to Build Web Apps on Adobe Commerce Data via CData Connect AI
Build interactive Dash web apps on live Adobe Commerce data using pandas and the CData Connect AI Python SDK.
-
DataBind AgileCRM Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide AgileCRM data to a chart.
-
How to work with TigerGraph Data in Apache Spark using SQL
Access and process TigerGraph Data in Apache Spark using the CData Software JDBC Driver.
-
Create Data Visualizations in Cognos BI with ZarMoney Data
Access ZarMoney data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automate Vertica Data Replication to Azure Synapse
Use CData Sync to customize and automate Vertica data replication to Azure Synapse.
-
Connect to Slack Data in Claris FileMaker Pro
Use the CData ODBC Driver for Slack in FileMaker Pro to connect to Slack and work with Slack data in your FileMaker applications.
-
Automated Continuous Coinbase Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Coinbase replication to AlloyDB.
-
Connect to and Query Perigon Data in QlikView over ODBC
Create data visualizations with Perigon data in QlikView.
-
Automate Figshare Data Replication to Azure Data Lake
Use CData Sync to customize and automate Figshare data replication to Azure Data Lake.
-
Stream Unbounce Data into Apache Kafka Topics
Access and stream Unbounce data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use the CData Software JDBC Driver for Brex in MicroStrategy Desktop
Connect to Brex data in MicroStrategy Desktop using the CData Software JDBC Driver for Brex.
-
Automated Continuous CampaignMonitor Replication to SingleStore
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to SingleStore.
-
Access Live Samanage Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Samanage data from your Excel spreadsheets.
-
Access Adobe Target Data from MySQL in Amazon QuickSight
Connect to Adobe Target and build visualizations of Adobe Target data using a MySQL Connection in Amazon QuickSight.
-
How to Create Power BI Visual Reports with Real-Time SendInBlue Data
Use CData Power BI Connectors to visualize SendInBlue data in Power BI.
-
Connect and Visualize Live Neo4J Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Neo4J data into the Databricks platform and create visualization dashboards with real-time Neo4J data.
-
Integrate Theia IDE with Live Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Dynamics 365 Business Central data from within the development environment.
-
Automate ZohoMarketingHub Data Replication to Azure Synapse
Use CData Sync to customize and automate ZohoMarketingHub data replication to Azure Synapse.
-
Easily Integrate Salesforce Pardot Data in Lazarus Pascal IDE
Learn how to easily integrate live Salesforce Pardot data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Apps from Excel Online Data in Qlik Sense Cloud
Use CData Connect AI to connect to Excel Online Data and build apps from live Excel Online data in Qlik Sense Cloud.
-
Analyze Pingdom Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Pingdom data with the CData JDBC Driver for Pingdom.
-
Access Live AgileCRM 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 AgileCRM data through MCP integration.
-
Integrate Trae with Live xBase Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live xBase data from within the AI-powered IDE.
-
Build Agents in Relevance AI with Access to Live ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ADP data within intelligent agent workflows.
-
Connect to and Visualize Live Stripe Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Stripe data.
-
Create a Data Access Object for Pipedrive Data using JDBI
A brief overview of creating a SQL Object API for Pipedrive data in JDBI.
-
Use the CData ODBC Driver for ElevenLabs from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ElevenLabs to connect to ElevenLabs data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ElevenLabs data in Excel.
-
Automated Continuous Wrike Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Wrike replication to Apache Kafka.
-
Access Excel Online Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Excel Online data from your Oracle system.
-
Integrate Trae with Live Amazon Marketplace Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Amazon Marketplace data from within the AI-powered IDE.
-
How to Create Power BI Visual Reports with Real-Time Mailgun Data
Use CData Power BI Connectors to visualize Mailgun data in Power BI.
-
Building Dynamic D3.js Apps with Database Data
Use the API Server and D3.js to Build Dynamic Web Apps with Live Database Data.
-
Establish a Live Connection with Bright Data Data using Tableau Bridge
The CData ODBC Driver for Bright Data enables you to integrate live Bright Data data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Epicor Kinetic Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Epicor Kinetic data from Filemaker Pro on Mac.
-
Build Email-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Email data.
-
How to load FreeAgent data into Elasticsearch via Logstash
Introducing a simple method to load FreeAgent data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live SendGrid Data in Coginiti Pro
Connect to and query live SendGrid data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Seamlessly Import SAP BusinessObjects BI Data into IBM SPSS Modeler
Integrate SAP BusinessObjects BI data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Using the CData Software ODBC Driver for ADP in PyCharm
Connect to ADP as an ODBC data source in PyCharm using the CData Software ODBC Driver for ADP.