Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Articles

Migrating data from Cassandra to Databricks using CData SSIS Components.

Easily push Apache Cassandra to Databricks using the CData SSIS Tasks for Cassandra and Databricks.
Automate Sage 300 Tasks in Power Automate Using CData API Server

With CData API Server, easily create OData endpoints for live Sage 300 and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
How to connect to Google Ads from Spring Boot

Connect to Google Ads in a Spring Boot Application using CData JDBC Google Ads Driver
How to Build an ETL App for HubSpot in Python with CData

Create ETL applications and real-time data pipelines for HubSpot in Python with petl.
Access Live Greenplum in AWS Lambda

Connect to live Pivotal GreenPlum in AWS Lambda using the CData JDBC Driver.
How to Create Power BI Visual Reports with Real-Time HubSpot

Use CData Power BI Connectors to visualize HubSpot in Power BI.
Build Semantic Layer Views for Google Sheets in APOS Live Data Gateway

Use the CData Connector for Google Sheets in APOS Live Data Gateway to build Semantic Layer Views for Google Sheets.
Connect to Google Campaign Manager 360 in SpagoBI

Create reports featuring live Google Campaign Manager 360 in SpagoBI Studio. Host Google Campaign Manager 360 reports on SpagoBI Server.
Trigger Hive IFTTT Flows in Azure App Service

This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
Visualize Sugar CRM in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Sugar CRM into TIBCO Spotfire.
Automated Continuous Power BI XMLA Replication to Azure SQL Database

Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Azure SQL Database.
Automated Continuous SAP Business One Replication to MongoDB

Use CData Sync for automated, continuous, customizable SAP Business One replication to MongoDB.
How to Seamlessly Import Google Calendar Data into IBM SPSS Modeler

Integrate Google Calendar data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
Automated Continuous Raisers Edge NXT Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to delimited files (CSV/TSV).
Analyze Jira in R via ODBC

Create data visualizations and use high-performance statistical functions to analyze Atlassian Jira in Microsoft R Open.
Replicate BambooHR to Multiple Databases

Replicate BambooHR to disparate databases with a point-and-click configuration.
How to Visualize OData Data in Python with pandas

Use pandas and other modules to analyze and visualize live OData in Python.
Viewing Google Directory in RAD Studio Data Explorer

How to view Google Directory in RAD Studio Data Explorer using the CData ODBC Driver for Google Directory.
Automated Continuous Sage Intacct Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable Sage Intacct replication to Apache Kafka.
How to pipe Phoenix to CSV in PowerShell

Use standard PowerShell cmdlets to access Phoenix tables.
Explore Geographical Relationships in Oracle with Power Map

Create data visualizations with Oracle Database in Power Map.
Object-Relational Mapping (ORM) with EnterpriseDB 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 EnterpriseDB into a Java-based ORM framework, Hibernate.
Connect to SAP Ariba Procurement from PowerBuilder via JDBC

This article demonstrates how to access SAP Ariba Procurement from PowerBuilder using the SAP Ariba Procurement JDBC Driver.
DataBind Charts to SingleStore

Use the standard ADO.NET procedures for databinding to provide bidirectional access to SingleStore 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.
Connect to Impala from PowerBuilder via JDBC

This article demonstrates how to access Apache Impala from PowerBuilder using the Impala JDBC Driver.
Build Dashboards with MariaDB in DBxtra

Create dynamic dashboards and perform analytics based on MariaDB in DBxtra.
Use JayDeBeApi to access Reckon in Python

Use standard Python scripting and the development environment of your choice to access live Reckon.
How to connect to Act-On in DBVisualizer

Integrate Act-On with visual data analysis tools and data connection wizards in DBVisualizer
Create Informatica Mappings From/To a JDBC Data Source for Klipfolio

Create Klipfolio data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
Use Claude to Talk to Your Power BI XMLA via CData Connect Cloud

Leverage CData Connect Cloud Remote MCP to enable Claude to securely answer questions and take actions on your Power BI XMLA for you.
Analyze YouTube Analytics in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of YouTube Analytics and visualize YouTube Analytics in SAP Analytics Cloud.
Visualize Live SharePoint in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Microsoft SharePoint into custom reports in Power BI.
Migrating data from Amazon DynamoDB to Databricks using CData SSIS Components.

Easily push Amazon DynamoDB to Databricks using the CData SSIS Tasks for Amazon DynamoDB and Databricks.
DataBind Azure Analysis Services to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Azure Analysis Services with the DevExpress Windows Forms and Web controls to provide Azure Analysis Services to a chart.
Explore Geographical Relationships in Zoom with Power Map

Create data visualizations with Zoom in Power Map.
Access Live SAP Ariba Procurement in Coginiti Pro

Connect to and query live SAP Ariba Procurement from the GUI in the Coginiti Pro: SQL Analytics Tool.
Connect to Google Drive in HULFT Integrate

Connect to Google Drive as a JDBC data source in HULFT Integrate
Create Reports with XML in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date XML Files.
How to Import Data from Azure Table into Google Sheets

Import Azure Table Storage into a Google spreadsheet that is automatically refreshed.
Visualize SAP in TIBCO Spotfire through OData

Integrate SAP ERP/NetWeaver into dashboards in TIBCO Spotfire.
Build Visualizations of Zoho Projects in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho Projects in Birst.
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SharePoint Excel Services

Provide connectivity to SharePoint Excel Services through an SAP BusinessObjects universe.
Visualize Live Microsoft Dataverse in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Dataverse (CDS).
Analyze Act-On in Slingshot with CData API Server

Use the CData API Server to build an OData API on top of Act-On and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
How to pipe Snapchat Ads to CSV in PowerShell

Use standard PowerShell cmdlets to access Snapchat Ads tables.
How to create an RPA flow for Access in UiPath Studio

Use the Access ODBC Driver to create workflows that access real-time Microsoft Access without any coding.
Natively Connect to SQL Analysis Services in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to SQL Analysis Services. Leverage the native support for ODBC in PHP.
Use Biml to Build SSIS Tasks to Replicate Todoist to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Todoist to SQL Server.
Build Apps with Live Google Directory Using the Low-Code Development Platform of Mendix