CData Software - Knowledge Base
Recent Articles
-
Connect to Presto from a Connection Pool in WebLogic
Use the CData JDBC Driver for Presto to connect to Presto from Web applications running on WebLogic.
-
YouTube Analytics Reporting in OBIEE with the YouTube Analytics JDBC Driver
Deploy the YouTube Analytics JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Analyze Zoho CRM in R via JDBC
Use standard R functions and the development environment of your choice to analyze Zoho CRM with the CData JDBC Driver for Zoho CRM.
-
Integrating Claude Code with SingleStore via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SingleStore within assisted coding and automated development workflows.
-
Easily Integrate Oracle Financials Cloud in Lazarus Pascal IDE
Learn how to easily integrate live Oracle Financials Cloud in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData Software JDBC Driver for Zuora in MicroStrategy
Connect to Zuora in MicroStrategy Developer using the CData Software JDBC Driver for Zuora.
-
Connect to QuickBooks in SpagoBI
Create reports featuring live QuickBooks Desktop in SpagoBI Studio. Host QuickBooks reports on SpagoBI Server.
-
Connect to Okta in Ruby
Connect to Okta in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData Software ODBC Driver for Gmail in SAS for Real-Time Reporting and Analytics
Connect to real-time Gmail in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Gmail.
-
Connect to Sage 300 from PowerBuilder via JDBC
This article demonstrates how to access Sage 300 from PowerBuilder using the Sage 300 JDBC Driver.
-
Create a Data Access Object for Redshift using JDBI
A brief overview of creating a SQL Object API for Amazon Redshift in JDBI.
-
Query Sage 300 through ODBC in Node.js
Use node-odbc to execute SQL queries against Sage 300 from Node.js.
-
Analyze SingleStore in R via JDBC
Use standard R functions and the development environment of your choice to analyze SingleStore with the CData JDBC Driver for SingleStore.
-
Access FHIR from MySQL in PHP
Connect to FHIR through the standard MySQL libraries in PHP.
-
Integrate with WordPress in JReport Designer
Create charts and reports based on WordPress in JReport Designer.
-
Connect to Google Cloud Storage from PowerBuilder via JDBC
This article demonstrates how to access Google Cloud Storage from PowerBuilder using the Google Cloud Storage JDBC Driver.
-
Publish Microsoft Dataverse-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Dataverse (CDS).
-
DataBind Controls to Amazon Marketplace in C++Builder
DataBind to Amazon Marketplace in C++Builder with standard components and controls.
-
Integrate Live Google Search Results into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Search and integrate live Google Search into apps built in Microsoft Power Apps.
-
Automated Continuous Salesforce Marketing Replication to Oracle
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Oracle.
-
How to load Exact Online data into Elasticsearch via Logstash
Introducing a simple method to load Exact Online data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Elasticsearch in Jaspersoft Studio
Execute SQL to remote Elasticsearch in Jaspersoft Studio.
-
Create Data Visualizations Based On MailChimp in Mode
Use CData Connect AI to connect to MailChimp from Mode and build visualizations using live
-
Integrate Redshift into Automated Tasks with Power Automate
Use CData Connect AI to connect to Amazon Redshift and integrate live Amazon Redshift into your Power Automate tasks.
-
Visualize Zoho Projects in Tableau
The CData ODBC driver for Zoho Projects enables you integrate Zoho Projects into Tableau dashboards.
-
Automated Continuous Hive Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Hive replication to PostgreSQL.
-
Connect to Live Confluence in PostGresSQL Interface through CData Connect AI
Create a live connection to Confluence in CData Connect AI and connect to your Atlassian Confluence from PostgreSQL.
-
Build GraphQL Visualizations in Tableau Cloud
Use CData Connect AI to connect to live GraphQL and build visualizations in Tableau Cloud.
-
How to Connect to & Open Raisers Edge NXT in Microsoft Excel
This article uses the CData ODBC driver for Raisers Edge NXT to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated DocuSign Replication to Teradata
Use CData Sync to Customize and automate DocuSign replication to Teradata.
-
Build Databricks-Connected Apps in Choreo
Use CData Connect AI to connect to Databricks from Choreo and build custom apps using live Databricks.
-
Integrate Elasticsearch into Automated Tasks with Power Automate
Use CData Connect AI to connect to Elasticsearch and integrate live Elasticsearch into your Power Automate tasks.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Google Calendar to Power BI dashboards. Simply drag and drop Google Calendar into data visuals on the Power BI canvas.
-
How to connect to SAP SuccessFactors LMS with Squirrel SQL client
Connect to SAP SuccessFactors LMS and execute queries in the Squirrel SQL Client.
-
Build Semantic Layer Views for Dynamics 365 Business Central in APOS Live Data Gateway
Use the CData Connector for Dynamics 365 Business Central in APOS Live Data Gateway to build Semantic Layer Views for Dynamics 365 Business Central.
-
Publish Dropbox-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Dropbox.
-
Create Dynamic Cloudant Grids Using the Infragistics XamDataGrid
Learn how you can connect Cloudant to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Live Active Directory in MicroStrategy through CData Connect AI
Create a live connection to Active Directory in CData Connect AI and connect to your Active Directory from MicroStrategy.
-
Build Semantic Layer Views for WordPress in APOS Live Data Gateway
Use the CData Connector for WordPress in APOS Live Data Gateway to build Semantic Layer Views for WordPress.
-
Smartsheet Reporting in OBIEE with the Smartsheet JDBC Driver
Deploy the Smartsheet JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Analyze Act CRM in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Act CRM and visualize live Act CRM in Infragistics Reveal.
-
Analyze Azure DevOps in R via JDBC
Use standard R functions and the development environment of your choice to analyze Azure DevOps with the CData JDBC Driver for Azure DevOps.
-
Bridge Parquet Connectivity with Apache NiFi
Access and process Apache Parquet in Apache NiFi using the CData JDBC Driver.
-
Connect to Google Analytics as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Analytics.
-
Build Apps with Live Redis in Adalo using CData Connect AI
Use CData Connect AI to integrate live Redis into the Adalo platform and build custom mobile and web applications with real-time Redis.
-
Automated Continuous Workday Replication to Snowflake
Use CData Sync for automated, continuous, customizable Workday replication to Snowflake.
-
Create Jira-Connected Nintex Workflows
Use CData Connect AI to connect to Jira from Nintex Workflow Cloud and build custom workflows using live Atlassian Jira.
-
How to connect to eBay Analytics from IntelliJ
Integrate connectivity to eBay Analytics with wizards in IntelliJ.
-
Amazon Marketplace Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Amazon Marketplace through CData Connect AI using different applications and tools.
-
Build a PostgreSQL Interface for Oracle using the CData JDBC Driver
Use the Remoting features of the Oracle JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Controls to Bitbucket in Delphi
DataBind to Bitbucket in Delphi with standard data access components and controls.
-
Connect and Query Live Azure Analysis Services Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Azure Analysis Services into Databricks
-
Automated Continuous Oracle HCM Cloud Replication to MySQL
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to MySQL.
-
Automated Continuous Azure Blob Storage Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Google BigQuery.
-
Create Apps from Amazon DynamoDB in Qlik Sense Cloud
Use CData Connect AI to connect to Amazon DynamoDB and build apps from live Amazon DynamoDB in Qlik Sense Cloud.
-
Create Reports with Reckon in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Reckon.
-
Build Automated Workflows with Live Oracle in Workato
Use CData Connect AI to connect to live Oracle Database and build automated workflows in Workato.
-
How to integrate Kafka with Apache Airflow
Access and process Apache Kafka in Apache Airflow using the CData JDBC Driver.
-
Build Bing Ads-Connected Apps in Choreo
Use CData Connect AI to connect to Bing Ads from Choreo and build custom apps using live Bing Ads.
-
Automated Continuous MailChimp Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable MailChimp replication to Apache Kafka.
-
Visualize Cvent in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Cvent into TIBCO Spotfire.
-
Getting Started with the CData JDBC Driver for Amazon Marketplace
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Amazon Marketplace.
-
Integrate with SurveyMonkey using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SurveyMonkey to a JSON file on disk.
-
DataBind Charts to Oracle HCM Cloud
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle HCM Cloud 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.
-
Operational Reporting on Eventbrite from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Eventbrite.
-
Rapidly Develop Cvent-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.
-
Model Google Campaign Manager 360 Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Campaign Manager 360, enabling the direct import of real-time Google Campaign Manager 360.
-
Connect to Harvest from a Connection Pool in Jetty
The Harvest JDBC Driver supports connection pooling: This article shows how to connect faster to Harvest from Web apps in Jetty.
-
Connect to Live SAP Business One in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP Business One in CData Connect AI and connect to your SAP Business One from PostgreSQL.
-
How to Create Power BI Visual Reports with Real-Time Neo4J
Use CData Power BI Connectors to visualize Neo4J in Power BI.
-
Model SAP SuccessFactors Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP SuccessFactors, enabling the direct import of real-time SAP SuccessFactors.
-
Replicate Microsoft Dataverse in Heroku for Use in Salesforce Connect
Replicate Microsoft Dataverse (CDS) to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build SingleStore-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SingleStore and create custom apps in Bubble.
-
Visualize Act-On in Sisense
Create an ElastiCube in Sisense app with access to Act-On.
-
Connect to Twitter Ads in JRuby
Create a simple JRuby app with access to live Twitter Ads.
-
Analyze Google Spanner in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google Spanner and visualize live Google Spanner in Infragistics Reveal.
-
Automated Continuous SAP BusinessObjects BI Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Microsoft Access.
-
Create Oracle Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build SAP HANA-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP HANA and create custom apps in Bubble.
-
Connect to Twitter Ads from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Twitter Ads from Filemaker Pro on Mac.
-
Build a Singer.io Tap for HBase With the CData Python Connector
Learn how to easily build a Singer.io Tap for live HBase data using
-
Create BigCommerce-Connected Business Apps in AppSheet
Connect to BigCommerce via CData Connect AI in Google AppSheet and create custom business applications with real-time access to BigCommerce.
-
Automate Box Replication to Azure Data Lake
Use CData Sync to customize and automate Box replication to Azure Data Lake.
-
Connect to Zendesk in CloverDX (formerly CloverETL)
Transfer Zendesk using the visual workflow in the CloverDX data integration tool.
-
How to integrate Metabase with FHIR
Use CData Connect AI to connect to live FHIR and create an interactive dashboard in Metabase from FHIR.
-
How to load Zuora data into Elasticsearch via Logstash
Introducing a simple method to load Zuora data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build ServiceNow-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live ServiceNow and build ServiceNow-connected web apps with Axios.
-
Connect to Pipedrive in Aqua Data Studio
Access Pipedrive from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Import AlloyDB Using Azure Data Factory
Use CData Connect AI to connect to AlloyDB from Azure Data Factory and import live Google AlloyDB.
-
Migrating data from Google Ads to Google BigQuery using CData SSIS Components.
Easily push Google Ads to Google BigQuery using the CData SSIS Tasks for Google Ads and Google BigQuery.
-
Connecting GenSpark with Stripe via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across hundreds of systems without any replication or custom integration required.
-
Integrating Boomi Agentstudio with Power BI XMLA via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Power BI XMLA, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Validate Salesforce with QuerySurge
Access and validate Salesforce & Force.com in QuerySurge using the CData JDBC Driver.
-
Getting Started with the CData SSIS Components for Bitbucket
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Bitbucket.
-
Connect to Dynamics CRM from Asprova with CData Software ODBC Driver for Dynamics CRM
This article shows how to connect faster to Dynamics CRM data from Asprova.
-
Analyze Azure Analysis Services in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure Analysis Services and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Xero as an External Source in Dremio
Use the CData JDBC Driver to connect to Xero as an External Source in Dremio.
-
How to connect to Klaviyo from Spring Boot
Connect to Klaviyo in a Spring Boot Application using CData JDBC Klaviyo Driver
-
Analyze Google Spanner in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Spanner in Microsoft R Open.
-
Connect to Dynamics 365 Business Central in Google Apps Script via SQL Gateway
Use the ODBC Driver for Dynamics 365 Business Central and the SQL Gateway to access Dynamics 365 Business Central from Google Apps Script.