CData Software - Knowledge Base
Recent Articles
-
Integrate SAP HANA in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP HANA from Informatica Cloud.
-
Automate Active Directory Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Active Directory from PowerShell? This article demonstrates how to utilize the Active Directory Cmdlets for tasks like connecting to Active Directory, automating operations, downloading data, and more.
-
Build Semantic Layer Views for MongoDB in APOS Live Data Gateway
Use the CData Connector for MongoDB in APOS Live Data Gateway to build Semantic Layer Views for MongoDB.
-
Connect to Square as an External Source in Dremio
Use the CData JDBC Driver to connect to Square as an External Source in Dremio.
-
ETL CouchDB in Oracle Data Integrator
This article shows how to transfer Apache CouchDB into a data warehouse using Oracle Data Integrator.
-
Use the CData Software JDBC Driver for OData in MicroStrategy
Connect to OData in MicroStrategy Developer using the CData Software JDBC Driver for OData.
-
Connect to Bullhorn CRM from PowerBuilder via ADO.NET
This article demonstrates how to access Bullhorn CRM from Appeon PowerBuilder using the CData ADO.NET Provider for Bullhorn CRM.
-
Integrating LangChain with ActiveCampaign via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on ActiveCampaign within automated workflows.
-
Connect to SQL Analysis Services in Jaspersoft Studio
Execute SQL to remote SQL Analysis Services in Jaspersoft Studio.
-
Connecting Mastra with Xero via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.
-
Query Xero in DataGrip
Create a Data Source for Xero in DataGrip and use SQL to query live Xero Accounting.
-
Getting Started with the CData ODBC Driver for Salesloft
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Salesloft.
-
Build a PostgreSQL Interface for SAP Ariba Source using the CData JDBC Driver
Use the Remoting features of the SAP Ariba Source JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData JDBC Driver for MailChimp
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MailChimp.
-
Easily Integrate CockroachDB in Lazarus Pascal IDE
Learn how to easily integrate live CockroachDB in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Live Outreach.io in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Outreach.io.
-
DataBind Charts to FTP
Use the standard ADO.NET procedures for databinding to provide bidirectional access to FTP Servers 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.
-
Create Informatica Mappings From/To a JDBC Data Source for FHIR
Create FHIR data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Active Directory in ACL Analytics
Connect to Active Directory via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Active Directory.
-
Automated Continuous SAP Ariba Source Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Apache Cassandra.
-
Enable the Avro JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Apache Avro.
-
Create a Data Access Object for Coinbase using JDBI
A brief overview of creating a SQL Object API for Coinbase in JDBI.
-
How to connect to Clio in DBVisualizer
Integrate Clio with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect to Live Impala from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Apache Impala for you.
-
How to connect to Amazon Marketplace from Spring Boot
Connect to Amazon Marketplace in a Spring Boot Application using CData JDBC Amazon Marketplace Driver
-
How to Connect to Live Oracle Financials Cloud from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Oracle Financials Cloud through natural language.
-
Build an OLAP Cube in SSAS from Adobe Analytics
Establish a connection to Adobe Analytics data from SQL Server Analysis Services, and use the Adobe Analytics Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live Amazon Marketplace in Excel 365 Online (Excel for the web)
Connect to Amazon Marketplace from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Salesforce Data Cloud in the Pentaho Report Designer
Publish reports based on Salesforce Data Cloud in the Pentaho BI tool.
-
Integrate Google Ad Manager in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Ad Manager from Informatica Cloud.
-
Connect to Drift in RapidMiner
Integrate Drift with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Lakebase from a Connection Pool in Jetty
The Lakebase JDBC Driver supports connection pooling: This article shows how to connect faster to Lakebase from Web apps in Jetty.
-
Access Live Oracle HCM Cloud in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle HCM Cloud from your Google Sheets.
-
Use the CData Software JDBC Driver for PingOne in MicroStrategy Web
Connect to PingOne in MicroStrategy Web using the CData Software JDBC Driver for PingOne.
-
Build Sage Intacct-Connected Apps in Choreo
Use CData Connect AI to connect to Sage Intacct from Choreo and build custom apps using live Sage Intacct.
-
Automated Continuous Phoenix Replication to SQL Server
Use CData Sync for automated, continuous, customizable Phoenix replication to SQL Server.
-
A PostgreSQL Interface for Microsoft OneDrive (MySQL Remoting via JDBC)
Use the Remoting features of the Microsoft OneDrive JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Google Analytics to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Google Analytics with the DevExpress Windows Forms and Web controls to provide Google Analytics to a chart.
-
Create Power BI Reports on Real-Time MYOB AccountRight
Use the CData ODBC Driver for MYOB AccountRight to visualize MYOB AccountRight in Power BI Desktop.
-
Connect to SuiteCRM in Jaspersoft Studio
Execute SQL to remote SuiteCRM in Jaspersoft Studio.
-
DataBind Controls to Redis in C++Builder
DataBind to Redis in C++Builder with standard components and controls.
-
Migrating data from HubDB to Databricks using CData SSIS Components.
Easily push HubDB to Databricks using the CData SSIS Tasks for HubDB and Databricks.
-
Analyze Salesforce in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Salesforce & Force.com and visualize Salesforce & Force.com in SAP Analytics Cloud.
-
Visualize Live Asana in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Asana.
-
Import Zoho Inventory into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Zoho Inventory. In this article, you will use the OData format to import Zoho Inventory into Microsoft Power Query.
-
Replicate Highrise in Heroku for Use in Salesforce Connect
Replicate Highrise CRM to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Operational Reporting on NetSuite from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote NetSuite CRM & ERP.
-
How to use SQLAlchemy ORM to access Amazon Athena in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Amazon Athena.
-
Use Claude to Talk to Your Instagram via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Instagram for you.
-
Automate Certinia Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Certinia from PowerShell? This article demonstrates how to utilize the Certinia Cmdlets for tasks like connecting to Certinia, automating operations, downloading data, and more.
-
How to Query Live BigQuery Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google BigQuery data in natural language using Python.
-
Connect to Oracle Eloqua Reporting from PowerBuilder via JDBC
This article demonstrates how to access Oracle Eloqua Reporting from PowerBuilder using the Oracle Eloqua Reporting JDBC Driver.
-
Access Live Redis Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Redis data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Edit and Search External Asana Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Asana to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Asana objects that you can access from apps and the dashboard.
-
Work with RSS Feeds in FoxPro
Load RSS Feeds into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Zoho Inventory as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zoho Inventory from your Oracle system.
-
Getting Started with the CData ADO.NET Provider for Oracle Eloqua Reporting
-