CData Software - Knowledge Base
Recent Articles
-
Build Data Flows from Couchbase to SQL Server using SSIS
Easily back up Couchbase to SQL Server using the SSIS components for Couchbase.
-
Connect to Paymo Data in JRuby
Create a simple JRuby app with access to live Paymo.
-
Validate Brex Data with QuerySurge
Access and validate Brex in QuerySurge using the CData JDBC Driver.
-
Automated Pipedrive Data Replication to Teradata
Use CData Sync to Customize and automate Pipedrive replication to Teradata.
-
Analyze Cloudant Data in Cognos Analytics
Use CData Connect AI to connect to Cloudant Data from Cognos Analytics and analyze live IBM Cloudant.
-
How to import Oracle SCM Data into Apache Solr
Use the CData Software JDBC Driver for Oracle SCM in Data Import Handler and create an automated import of Oracle SCM to Apache Solr Enterprise Search platform.
-
Migrating data from QuickBooks Online to Google BigQuery using CData SSIS Components.
Easily push QuickBooks Online to Google BigQuery using the CData SSIS Tasks for QuickBooks Online and Google BigQuery.
-
Connect to Parallel Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Parallel and work with Parallel in your FileMaker applications.
-
Build a Singer.io Tap for Dynamics CRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Dynamics CRM data using
-
Replicate Sendwithus Data from PowerShell
Write a quick PowerShell script to query Sendwithus. Use connectivity to the live data to replicate Sendwithus to SQL Server.
-
Connect to IBM Informix Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live IBM Informix from Filemaker Pro on Mac.
-
Connecting GenSpark with Act-On Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Act-On without any replication or custom integration required.
-
Getting Started with the CData Python Connector for Mistral AI
Learn to install and license the CData Python Connector
-
Moving Data from SAP Business One to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP Business One data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect to Live Google Ads Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Ads securely in real time.
-
Connect to Teamwork Data in RazorSQL
Connect to Teamwork from wizards and query Teamwork from the GUI in the RazorSQL database management tool.
-
How to connect to Tanda Data in DBVisualizer
Integrate Tanda with visual data analysis tools and data connection wizards in DBVisualizer
-
Import Zoho Projects Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Zoho Projects Data and provide access to live Zoho Projects for custom reports in the Power BI Service.
-
Build AI Agents with HBase Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Apache HBase through CData Connect AI.
-
Integrate Live Azure Table Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Azure Table Storage and integrate live Azure Table Storage into apps built in Microsoft Power Apps.
-
Access Live Excel Online Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Excel Online from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to and Visualize Live Cohere Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Cohere.
-
Visualize OpenWeatherMap Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load OpenWeatherMap into TIBCO Spotfire.
-
Access Live Zoho Creator Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Zoho Creator in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to use SQLAlchemy ORM to access Gong Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Gong.
-
Connecting Pipedream with Cvent Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Cvent data in real time.
-
How to create Visio diagrams from Teradata Data
Automatically update Teradata with the changes you make to Visio master shapes.
-
Edit and Search External MariaDB Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of MariaDB to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create MariaDB Data objects that you can access from apps and the dashboard.
-
Connecting Agentforce with SharePoint Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Microsoft SharePoint for you.
-
Connect to Aircall from Asprova with CData Software ODBC Driver for Aircall
This article shows how to connect faster to Aircall data from Asprova.
-
Feed Coda Data into FineReport
How to set Coda as a JDBC data source in FineReport.
-
Build an OLAP Cube in SSAS from SAS Data Sets Data
Establish a connection to SAS Data Sets data from SQL Server Analysis Services, and use the SAS Data Sets Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData JDBC Driver for RSS
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for RSS.
-
Connect Aircall Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Aircall using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to and Query Azure Data Catalog Data in QlikView over ODBC
Create data visualizations with Azure Data Catalog in QlikView.
-
Visualize Live Monday.com Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Monday.com into custom reports in Power BI.
-
Publish Salesforce Marketing-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Salesforce Marketing Cloud.
-
Back Up BigCommerce to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for BigCommerce. In this article, we will employ an SSIS workflow to populate a database with BigCommerce data.
-
Integrate Salesforce with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Salesforce with External Services.
-
Automated Continuous Reckon Accounts Hosted Replication to Oracle
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Oracle.
-
Automated Continuous GitLab Replication to MySQL
Use CData Sync for automated, continuous, customizable GitLab replication to MySQL.
-
Connect Printify to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Printify with IBM WebSphere for seamless data integration and connectivity.
-
Build SAP-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP ERP/NetWeaver and build web apps with connectivity to live SAP ERP/NetWeaver.
-
Integrating LlamaIndex with Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Sheets in real time.
-
Getting Started with the CData Excel Add-In for SAS xpt
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAS xpt.
-
Create Power BI Reports on Real-Time Sentry Data
Use the CData ODBC Driver for Sentry to visualize Sentry in Power BI Desktop.
-
A PostgreSQL Interface for Salesforce Data (MySQL Remoting via JDBC)
Use the Remoting features of the Salesforce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to HCL Domino from a Connection Pool in WebLogic
Use the CData JDBC Driver for HCL Domino to connect to HCL Domino from Web applications running on WebLogic.
-
ETL SAS Data Sets in Oracle Data Integrator
This article shows how to transfer SAS Data Sets into a data warehouse using Oracle Data Integrator.
-
Visualize SAP Hybris C4C Data in TIBCO Spotfire through OData
Integrate SAP Hybris C4C into dashboards in TIBCO Spotfire.
-
Integrating GitHub Copilot CLI with Vimeo 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 Use a Microsoft Access Database to Update Dynamics NAV Data in Real Time
Update Dynamics NAV data by creating a linked table in Microsoft Access with the CData Dynamics NAV ODBC Driver.
-
Build Square-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Square.
-
Connect to Delighted 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 Delighted and work with Delighted in your FileMaker application.
-
Natively Connect to BigQuery Data in PHP
The CData ODBC driver for BigQuery enables you to create PHP applications with connectivity to Google BigQuery. Leverage the native support for ODBC in PHP.
-
Replicate ShipStation Data to Multiple Databases via the CData Sync CLI
Replicate ShipStation to disparate databases with a single configuration.
-
Integrate Databricks with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Databricks with External Services.
-
Connect to Redis Data from a Connection Pool in JBoss
Integrate Redis into Java servlets: Use the Management Console in JBoss to install the Redis JDBC Driver.
-
Load Monday.com Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Monday.com to a database.
-
Connect to Perigon Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Perigon.
-
How to create Visio diagrams from Email Data
Automatically update Email with the changes you make to Visio master shapes.
-
Connect to Wistia Data in RapidMiner
Integrate Wistia with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Omnisend 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 Omnisend and work with Omnisend in your FileMaker application.
-
Databind Wijmo Grid to Salesforce.com Data
Use the CData API Server to add a Wijmo grid containing live Salesforce.com data to your website. The same process to access live data can be followed with any of the 80+ other supported sources.
-
ETL Aha! in Oracle Data Integrator
This article shows how to transfer Aha! into a data warehouse using Oracle Data Integrator.
-
Use Dash to Build Web Apps on Freshservice Data via CData Connect AI
Build interactive Dash web apps on live Freshservice using pandas and the CData Connect AI Python SDK.
-
Integrate Cline with Live Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Snowflake from within your IDE.
-
Back Up Salesforce CRM Analytics to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Salesforce CRM Analytics. In this article, we will employ an SSIS workflow to populate a database with Salesforce CRM Analytics data.
-
Create Active Directory-Connected Business Apps in AppSheet
Connect to Active Directory Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Active Directory.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Apache Impala to Power BI dashboards. Simply drag and drop Apache Impala into data visuals on the Power BI canvas.
-
How to connect to Reckon Accounts Hosted Data with Squirrel SQL client
Connect to Reckon Accounts Hosted and execute queries in the Squirrel SQL Client.
-
Use Biml to Build SSIS Tasks to Replicate QuickBooks Online Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate QuickBooks Online to SQL Server.
-
Import MailChimp Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access MailChimp. In this article, you will use the OData format to import MailChimp into Microsoft Power Query.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Couchbase using the Model Context Protocol.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Airtable within intelligent workflows.
-
Connect to Oracle Financials Cloud in SpagoBI
Create reports featuring live Oracle Financials Cloud in SpagoBI Studio. Host Oracle Financials Cloud reports on SpagoBI Server.
-
How to load Egnyte data into Elasticsearch via Logstash
Introducing a simple method to load Egnyte data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Apps with Live Splunk in Adalo using CData Connect AI
Use CData Connect AI to integrate live Splunk into the Adalo platform and build custom mobile and web applications with real-time Splunk.
-
How to Visualize Tanda Data in Python with pandas
Use pandas and other modules to analyze and visualize live Tanda in Python.
-
Use Databricks Agent Bricks to Talk to Your Freshdesk Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Freshdesk for you.
-
Automate QuickBooks Time Integration Tasks from PowerShell
Are you in search of a quick and easy way to access QuickBooks Time from PowerShell? This article demonstrates how to utilize the QuickBooks Time Cmdlets for tasks like connecting to QuickBooks Time, automating operations, downloading data, and more.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle Sales
Provide connectivity to Oracle Sales through an SAP BusinessObjects universe.
-
Access Live ActiveCampaign Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ActiveCampaign in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to connect and process Oracle Eloqua Reporting from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle Eloqua Reporting.
-
Build Voice Agents in ElevenLabs with access to Live Redshift Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Amazon Redshift.
-
Use the CData Software JDBC Driver for Perigon in MicroStrategy
Connect to Perigon in MicroStrategy Developer using the CData Software JDBC Driver for Perigon.
-
Create SAP Hybris C4C-Connected Applications in Appsmith
Connect to SAP Hybris C4C Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Hybris C4C.
-
Connect to Front Data in DBeaver
Use the CData ODBC Driver to connect to Front in DBeaver.
-
Replicate Multiple Asana Accounts
Replicate multiple Asana accounts to one or many databases.
-
Getting Started with the CData Tableau Connector for OnePageCrm
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Visualize Jira Assets Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Jira Assets.
-
Replicate eBay Analytics Data to Multiple Databases via the CData Sync CLI
Replicate eBay Analytics to disparate databases with a single configuration.
-
Seamlessly Bring Microsoft Teams Data into Retool Using CData Connect AI
Integrate Microsoft Teams data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Bidirectional Access to IBM Cloud Object Storage Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate IBM Cloud Object Storage in Filemaker Pro for Mac or Windows.
-
Analyze Avro Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apache Avro with the CData JDBC Driver for Avro.
-
How to work with Ontraport Data in Apache Spark using SQL
Access and process Ontraport Data in Apache Spark using the CData Software JDBC Driver.
-
Create SAP Ariba Procurement Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Ariba Procurement data access from reports, embedded analytics, and more.
-
Visualize LinkedIn Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to LinkedIn.
-
How to update NetSuite from Excel
This article explains how to transfer data from Excel to NetSuite using the Excel Add-In for NetSuite.
-
Connect to Accelo Data in DBeaver
Use the CData ODBC Driver to connect to Accelo in DBeaver.