CData Software - Knowledge Base
Recent Articles
-
Visualize Live Salesloft in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Salesloft.
-
Access Live Oracle Sales in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle Sales into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle Sales in the Graph Builder and Query Builder.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Printful
Provide connectivity to Printful through an SAP BusinessObjects universe.
-
Replicate Multiple Smartsheet Accounts
Replicate multiple Smartsheet accounts to one or many databases.
-
How to pipe Elasticsearch to CSV in PowerShell
Use standard PowerShell cmdlets to access Elasticsearch tables.
-
Build Zoho CRM-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Zoho CRM.
-
Integrate DB2 in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live IBM DB2 from Informatica Cloud.
-
Connect Active Directory to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Active Directory using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous ActiveCampaign Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to PostgreSQL.
-
Connecting Agentforce with Reckon Accounts Hosted 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 Reckon Accounts Hosted for you.
-
Query LinkedIn Ads in ColdFusion
Write standard ColdFusion data access code to connect to LinkedIn Ads.
-
Replicate Authorize.Net to Multiple Databases
Replicate Authorize.Net to disparate databases with a point-and-click configuration.
-
Automated Continuous Facebook Ads Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Google BigQuery.
-
Query, Visualize, and Share live MailChimp in Redash
Use CData Connect AI to connect to live MailChimp in Redash for querying, visualizing, and sharing.
-
Automated Continuous Greenplum Replication to SingleStore
Use CData Sync for automated, continuous, customizable Greenplum replication to SingleStore.
-
Rapidly Develop Adobe Analytics-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Connect Act CRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Act CRM using the CData Python MCP Server.
-
How to publish and share FHIR dashboards with Tableau Server
The CData ODBC driver for FHIR enables you integrate FHIR into Tableau dashboards.
-
Connect to Zuora from a Connection Pool in JBoss
Integrate Zuora into Java servlets: Use the Management Console in JBoss to install the Zuora JDBC Driver.
-
Connect and Query Live Airtable Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Airtable into Databricks
-
Connecting Agentforce with Amazon Athena 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 Amazon Athena for you.
-
Create Informatica Mappings From/To an ODBC Data Source for Dynamics NAV
Create an ODBC connection to Dynamics NAV in Informatica and browse and transfer Microsoft Dynamics NAV.
-
How to use SQLAlchemy ORM to access Teradata in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Teradata.
-
Integrating Boomi Agentstudio with Presto via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Presto, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Work with Zendesk in ETL Validator JDBC
Connect to Zendesk from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Facebook Ads in RazorSQL
Connect to Facebook Ads from wizards and query Facebook Ads from the GUI in the RazorSQL database management tool.
-
Query Bing Ads through ODBC in Node.js
Use node-odbc to execute SQL queries against Bing Ads from Node.js.
-
How to Connect to Live Redshift from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Amazon Redshift for you.
-
Build Data Flows from SAP BusinessObjects BI to SQL Server using SSIS
Easily back up SAP BusinessObjects BI to SQL Server using the SSIS components for SAP BusinessObjects BI.
-
Build CouchDB-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache CouchDB.
-
Integrating Dataiku with MongoDB via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live MongoDB.
-
Connect to and Visualize Live TigerGraph in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live TigerGraph.
-
How to create an RPA flow for Amazon Marketplace in UiPath Studio
Use the Amazon Marketplace ODBC Driver to create workflows that access real-time Amazon Marketplace without any coding.
-
Build SingleStore Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SingleStore and build visualizations in Tableau.
-
Integrating LangChain with Tableau CRM Analytics via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Tableau CRM Analytics within automated workflows.
-
Integrate with NetSuite in JReport Designer
Create charts and reports based on NetSuite CRM & ERP in JReport Designer.
-
How to Query Salesloft in MySQL Workbench
Execute MySQL queries against live Salesloft from MySQL Workbench.
-
How to connect PolyBase to Google Directory
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Directory.
-
Create Azure Table-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Azure Table from Klipfolio and build custom visualizations using live Azure Table Storage.
-
Object-Relational Mapping (ORM) with Zoho Books 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 Books into a Java-based ORM framework, Hibernate.
-
How to import Zoho Creator into Apache Solr
Use the CData Software JDBC Driver for Zoho Creator in Data Import Handler and create an automated import of Zoho Creator to Apache Solr Enterprise Search platform.
-
Connecting Agentforce with Asana 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 Asana for you.
-
Build a Simple VCL Application for Reckon Accounts Hosted
How to build a simple VCL Application to view Reckon Accounts Hosted in RAD Studio using the CData ODBC Driver for Reckon Accounts Hosted.
-
Build Charts with Teradata in Clear Analytics
Create dynamic charts and perform analytics based on Teradata in Clear Analytics.
-
Automated Continuous SAP Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP replication to Amazon S3.
-
How to create Kintone federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Kintone in MySQL .
-
Connect to MySQL in RazorSQL
Connect to MySQL from wizards and query MySQL from the GUI in the RazorSQL database management tool.
-
Use the CData Software ODBC Driver for Dynamics 365 Business Central in SAS for Real-Time Reporting and Analytics
Connect to real-time Dynamics 365 Business Central in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Dynamics 365 Business Central.
-
Visualize ShipStation in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load ShipStation into TIBCO Spotfire.
-
Create Reports with Kintone in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Kintone.
-
How to Work with Act-On in ETL Validator JDBC
Connect to Act-On from ETL Validator jobs using the CData Software JDBC Driver.
-
Migrating data from REST to Google BigQuery using CData SSIS Components.
Easily push REST to Google BigQuery using the CData SSIS Tasks for REST and Google BigQuery.
-
Enable the YouTube Analytics JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with YouTube Analytics.
-
Create Reports from Shopify in Looker Studio
Use CData Connect AI to gain access to live Shopify and create custom reports in Looker Studio.
-
Connect to Dynamics CRM in JRuby
Create a simple JRuby app with access to live Microsoft Dynamics CRM.
-
Publish Slack-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Slack.
-
Build Visualizations of IBM Informix in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of IBM Informix in Birst.
-
Connect to Splunk in HULFT Integrate
Connect to Splunk as a JDBC data source in HULFT Integrate
-
Build MVC Applications with Connectivity to BigQuery
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access BigQuery from an ASP.NET MVC application.
-
Natively Connect to Microsoft OneDrive in PHP
The CData ODBC driver for Microsoft OneDrive enables you to create PHP applications with connectivity to Microsoft OneDrive. Leverage the native support for ODBC in PHP.
-
Analyze Google Cloud Storage with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Cloud Storage from Power Pivot. You will use the Table Import Wizard to load Google Cloud Storage. You can visually build the import query or use any SQL supported by the driver.
-
Publish Reports with Coinbase in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Coinbase.
-
Automate Drift Replication to Azure Data Lake
Use CData Sync to customize and automate Drift replication to Azure Data Lake.
-
Load SAP Ariba Procurement to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP Ariba Procurement to a database.
-
Access BigCommerce from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live BigCommerce from HeidiSQL.
-
How to use SQLAlchemy ORM to access PingOne in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of PingOne.
-
Excel Spreadsheet Automation on Zoho CRM with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Connect to Google Drive from Asprova with CData Software ODBC Driver for Google Drive
This article shows how to connect faster to Google Drive data from Asprova.
-
Access QuickBooks from RazorSQL
Connect to QuickBooks company file data through the RazorSQL database query tool.
-
Analyze Facebook in R via JDBC
Use standard R functions and the development environment of your choice to analyze Facebook with the CData JDBC Driver for Facebook.
-
Connect to Microsoft Planner as an External Source in Dremio
Use the CData JDBC Driver to connect to Microsoft Planner as an External Source in Dremio.
-
Work with Live Microsoft Project in Power Query
Use CData Connect AI to connect to Microsoft Project and work with live Microsoft Project in Microsoft Power Query.
-
Excel Spreadsheet Automation on HCL Domino with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Build Visualizations of SAP Ariba Procurement in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Ariba Procurement in Birst.
-
Connect to Okta as an External Source in Dremio
Use the CData JDBC Driver to connect to Okta as an External Source in Dremio.
-
Visualize MongoDB from Tableau
Use the Tableau Desktop business intelligence tool to connect to MongoDB.
-
Analyze PayPal in Infragistics Reveal
Use the CData API Server to create an OData API on top of PayPal and visualize live PayPal in Infragistics Reveal.
-
Build Apps with Live SAP Ariba Source Using the Low-Code Development Platform of Mendix
-