CData Software - Knowledge Base
Recent Articles
-
Automated Continuous SAP ByDesign Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to IBM DB2.
-
Build an OLAP Cube in SSAS from HelloSign Data
Establish a connection to HelloSign data from SQL Server Analysis Services, and use the HelloSign Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Google Spanner-Connected Nintex Workflows
Use CData Connect AI to connect to Google Spanner Data from Nintex Workflow Cloud and build custom workflows using live Google Spanner.
-
Build Oracle SCM Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Oracle SCM and build visualizations in Tableau Cloud.
-
Use the CData ODBC Driver for Billsby from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Billsby to connect to Billsby from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Billsby in Excel.
-
Create SSAS Tabular Models from CapsuleCRM Data
How to build a SQL Server Analysis Service Tabular Model from CapsuleCRM using CData drivers.
-
Connect to WooCommerce Data from HeidiSQL
Use CData Connect AI to connect to and query live WooCommerce from HeidiSQL.
-
Create Copper Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Copper data access from reports, embedded analytics, and more.
-
Access Recurly Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Recurly from HeidiSQL.
-
Feed Tanda Data into FineReport
How to set Tanda as a JDBC data source in FineReport.
-
Migrating data from Demio to Snowflake using CData SSIS Components.
Easily push Demio to Snowflake using the CData SSIS Tasks for Demio and Snowflake.
-
Connect to LDAP Objects in Google Apps Script via SQL Gateway
Use the ODBC Driver for LDAP and the SQL Gateway to access LDAP from Google Apps Script.
-
Build Dashboards with WooCommerce Data in Dundas BI
Create dynamic dashboards and perform analytics based on WooCommerce in Dundas BI.
-
Connect to Google Cloud Storage Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Cloud Storage to connect to Google Cloud Storage and execute queries in PowerBuilder.
-
How to Connect to Live Oracle SCM Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Oracle SCM securely in real time.
-
How to work with LionDesk Data in Apache Spark using SQL
Access and process LionDesk Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous MariaDB Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable MariaDB replication to Apache Cassandra.
-
Access Drift Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Drift.
-
Use the CData Software ODBC Driver for Deel in MicroStrategy Web
Connect to Deel in MicroStrategy Web using the CData Software ODBC Driver for Deel.
-
Integrate Cohere with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Cohere with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Cohere.
-
Bind Live SendGrid Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SendGrid data
-
DataBind Controls to Google Analytics Data in Delphi
DataBind to Google Analytics in Delphi with standard data access components and controls.
-
Connect to PabblySubscriptions Data from a Connection Pool in JBoss
Integrate PabblySubscriptions into Java servlets: Use the Management Console in JBoss to install the PabblySubscriptions JDBC Driver.
-
Feed Moosend Data into FineReport
How to set Moosend as a JDBC data source in FineReport.
-
Build Automated Workflows with Live Cosmos DB Data in Workato
Use CData Connect AI to connect to live Azure Cosmos DB and build automated workflows in Workato.
-
Build Apps with Live Sage 200 Data Using the Low-Code Development Platform of Mendix
Connect Sage 200 with Mendix to build apps using the CData JDBC Driver for Sage 200.
-
Model Highrise Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Highrise, enabling the direct import of real-time Highrise CRM.
-
Replicate Timely Data in Heroku for Use in Salesforce Connect
Replicate Timely to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Notion Data from PowerBuilder via ADO.NET
This article demonstrates how to access Notion from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Beeminder Data in HULFT Integrate
Connect to Beeminder as a JDBC data source in HULFT Integrate
-
Connect to Real-Time Box Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Box and Dataflow to import and use Box in Power Apps.
-
Connect to Insightly Data in RazorSQL
Connect to Insightly from wizards and query Insightly from the GUI in the RazorSQL database management tool.
-
Integrate Cline with Live Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Directory from within your IDE.
-
Webex Reporting in OBIEE with the Webex JDBC Driver
Deploy the Webex JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to create an RPA flow for Certinia Data in UiPath Studio
Use the Certinia ODBC Driver to create workflows that access real-time Certinia without any coding.
-
Build an OLAP Cube in SSAS from NetSuite Data
Establish a connection to NetSuite CRM & ERP data from SQL Server Analysis Services, and use the NetSuite Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to work with Anaplan Data in Apache Spark using SQL
Access and process Anaplan Data in Apache Spark using the CData Software JDBC Driver.
-
Provide OData Services of SAS xpt Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAS XPORT by developing a WCF Service Application.
-
Query Unbounce Data in ColdFusion
Write standard ColdFusion data access code to connect to Unbounce.
-
Create Informatica Mappings From/To an ODBC Data Source for Clio
Create an ODBC connection to Clio in Informatica and browse and transfer Clio.
-
A PostgreSQL Interface for SFTP Data using the CData ODBC Driver
Use the SQL Gateway and SFTP ODBC Driver to create a PostgreSQL entry-point for data access.
-
Deploy the ADO.NET Provider for SQL Analysis Services on an SSRS Report Server
Connect to SQL Analysis Services from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrating OpenCode Terminal with Hive 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.
-
Use JayDeBeApi to access Office 365 Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Office 365.
-
Automate Google Contacts Data Replication to Azure Synapse
Use CData Sync to customize and automate Google Contacts replication to Azure Synapse.
-
How to connect to SAP HANA XS Advanced Data from Spring Boot
Connect to SAP HANA XS Advanced in a Spring Boot Application using the CData JDBC Driver for SAP HANA XS Advanced
-
Migrating data from Cohere to Databricks using CData SSIS Components.
Easily push Cohere to Databricks using the CData SSIS Tasks for Cohere and Databricks.
-
Migrating data from ElevenLabs to Google BigQuery using CData SSIS Components.
Easily push ElevenLabs to Google BigQuery using the CData SSIS Tasks for ElevenLabs and Google BigQuery.
-
Integrate Live Adobe Analytics Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Build Agents in Relevance AI with Access to Live Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Amazon S3 within intelligent agent workflows.
-
Connect to Outlook Data in HULFT Integrate
Connect to Outlook as a JDBC data source in HULFT Integrate
-
Highrise Reporting in OBIEE with the Highrise JDBC Driver
Deploy the Highrise JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to OpenWeatherMap Data from a Connection Pool in JBoss
Integrate OpenWeatherMap into Java servlets: Use the Management Console in JBoss to install the OpenWeatherMap JDBC Driver.
-
Visualize ZohoSubscriptions Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZohoSubscriptions.
-
Connect to Apollo Data from PowerBuilder via ADO.NET
This article demonstrates how to access Apollo from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Getting Started with the CData Python Connector for SAP
Learn to install and license the CData Python Connector
-
Visualize Instagram Data in Tableau
The CData ODBC driver for Instagram enables you integrate Instagram into Tableau dashboards.
-
Access Mouseflow Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Mouseflow.
-
How to work with Microsoft OneDrive Data in Apache Spark using SQL
Access and process Microsoft OneDrive Data in Apache Spark using the CData Software JDBC Driver.
-
A PostgreSQL Interface for Kintone Data (MySQL Remoting via JDBC)
Use the Remoting features of the Kintone JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Codex CLI with Brex 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.
-
Integrate SageHR Data in Pentaho Data Integration
Build ETL pipelines based on SageHR in the Pentaho Data Integration tool.
-
Integrating OpenCode Terminal with Google Analytics 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.
-
Automated Continuous CouchDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable CouchDB replication to Azure SQL Database.
-
Freshdesk Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Freshdesk facts in real time.
-
How to Connect to Sentry Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Sentry. Leverage the pyodbc module for ODBC in Python.
-
Integrate LibreChat with Live QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live QuickBooks Time from within the chat interface.
-
Load Box Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Box to a database.
-
Replicate Multiple NetSuite Accounts
Replicate multiple NetSuite accounts to one or many databases.
-
Connect to Front Data in RazorSQL
Connect to Front from wizards and query Front from the GUI in the RazorSQL database management tool.
-
Connect to Paymo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous ShipEngine Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ShipEngine replication to Google BigQuery.
-
Build a Simple VCL Application for Twilio Data
How to build a simple VCL Application to view Twilio in RAD Studio using the CData ODBC Driver for Twilio.
-
Create a Data Access Object for Pipeline CRM Data using JDBI
A brief overview of creating a SQL Object API for Pipeline CRM in JDBI.
-
Create SAP Fieldglass-Connected Applications in Appsmith
Connect to SAP Fieldglass Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Fieldglass.
-
Use the CData ODBC Driver for Sugar CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Sugar CRM to connect to Sugar CRM from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sugar CRM in Excel.
-
Analyze Gorgias Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Gorgias in Microsoft R Open.
-
Import Real-Time Apify Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Apify in ColdFusion.
-
Bridge Webex Connectivity with Apache NiFi
Access and process Webex in Apache NiFi using the CData JDBC Driver.
-
Analyze Mode Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Mode with the CData JDBC Driver for Mode.
-
Access Live WooCommerce Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate WooCommerce into the statistical analysis tools available in SAS JMP. This article shows how to use WooCommerce in the Graph Builder and Query Builder.
-
Model, Search, and Visualize Live Microsoft Entra ID Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft Entra ID for modeling, searching, and visualizing.
-
Build Semantic Layer Views for BigQuery Data in APOS Live Data Gateway
Use the CData Connector for BigQuery in APOS Live Data Gateway to build Semantic Layer Views for Google BigQuery.
-
Integrate Chargebee Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Chargebee from Informatica Cloud.
-
ETL Azure Data Lake Storage in Oracle Data Integrator
This article shows how to transfer Azure Data Lake Storage into a data warehouse using Oracle Data Integrator.
-
Query SAP Business One Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP Business One.
-
Use Biml to Build SSIS Tasks to Replicate Facebook Ads Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Facebook Ads to SQL Server.
-
Create Reports with Oracle HCM Cloud Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle HCM Cloud.
-
Access Live SAP Data in Coginiti Pro
Connect to and query live SAP ERP/NetWeaver from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Moving Data from Acumatica to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Acumatica data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Agno to Talk to Your Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Apache Phoenix for you.
-
How to work with Microsoft Exchange Data in Apache Spark using SQL
Access and process Microsoft Exchange Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData SSIS Components for HCL Domino
Complete guide to installing, licensing, and connecting with the CData SSIS Components for HCL Domino.
-
Build SAP Ariba Source-Connected Apps in Choreo
Use CData Connect AI to connect to SAP Ariba Source Data from Choreo and build custom apps using live SAP Ariba Source.
-
How to Work with HBase Data in ETL Validator JDBC
Connect to HBase from ETL Validator jobs using the CData Software JDBC Driver.
-
Analyze Live Dynamics 365 Business Central Data in SAS Viya
Use CData Connect AI to connect to Dynamics 365 Business Central from SAS Viya and deploy self-service analytics using live Dynamics 365 Business Central.
-
Connect to SageHR Data in CloverDX (formerly CloverETL)
Transfer SageHR using the visual workflow in the CloverDX data integration tool.
-
Publish Reports with Zendesk Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zendesk.
-
Access Live Microsoft Teams Data in Coginiti Pro
Connect to and query live Microsoft Teams from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to XML in SpagoBI
Create reports featuring live XML Files in SpagoBI Studio. Host XML reports on SpagoBI Server.