CData Software - Knowledge Base
Recent Articles
-
Connect to Office 365 in Jaspersoft Studio
Execute SQL to remote Microsoft Office 365 in Jaspersoft Studio.
-
Build Visualizations of Zoho CRM in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho CRM in Birst.
-
How to connect to Office 365 from Spring Boot
Connect to Office 365 in a Spring Boot Application using CData JDBC Office 365 Driver
-
Automated Continuous QuickBooks Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable QuickBooks replication to Apache Cassandra.
-
Connect to GraphQL in HULFT Integrate
Connect to GraphQL as a JDBC data source in HULFT Integrate
-
Automated Continuous Parquet Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Parquet replication to Amazon S3.
-
Access SAP HANA XS Advanced as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP HANA XS Advanced from your Oracle system.
-
Automate Amazon DynamoDB Replication to Azure Synapse
Use CData Sync to customize and automate Amazon DynamoDB replication to Azure Synapse.
-
How to Connect to Live SAP Hybris C4C from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SAP Hybris C4C for you.
-
A PostgreSQL Interface for IBM Cloud Object Storage (MySQL Remoting via JDBC)
Use the Remoting features of the IBM Cloud Object Storage JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to create Oracle SCM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Oracle SCM in MySQL .
-
Access Gmail from MySQL in Amazon QuickSight
Connect to Gmail and build visualizations of Gmail using a MySQL Connection in Amazon QuickSight.
-
Connect to MySQL from HeidiSQL
Use CData Connect AI to connect to and query live MySQL from HeidiSQL.
-
Publish Crystal Reports on FTP
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date FTP Servers.
-
Build Automated Workflows with Live Tableau CRM Analytics in Workato
Use CData Connect AI to connect to live Tableau CRM Analytics and build automated workflows in Workato.
-
Automated Continuous Greenplum Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Greenplum replication to Amazon Redshift.
-
How to Connect to Reckon Accounts Hosted in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Reckon Accounts Hosted. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Procore Replication to MySQL
Use CData Sync for automated, continuous, customizable Procore replication to MySQL.
-
Work with Coinbase in FoxPro
Load Coinbase into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Dashboards with Todoist in DBxtra
Create dynamic dashboards and perform analytics based on Todoist in DBxtra.
-
LINQ to Azure Analysis Services
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Azure Analysis Services Data Provider.
-
How to Work with Acumatica in ETL Validator JDBC
Connect to Acumatica from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live MariaDB in AWS Lambda
Connect to live MariaDB in AWS Lambda using the CData JDBC Driver.
-
Visualize Live Confluence of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Atlassian Confluence using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with live Hive in Jitterbit
Use CData Connect AI to connect to and integrate live Apache Hive in Jitterbit.
-
Integrate SAP Ariba Procurement in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Ariba Procurement from Informatica Cloud.
-
Use the CData ODBC Driver for Coinbase from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Coinbase to connect to Coinbase from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Coinbase in Excel.
-
Automated Continuous Active Directory Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Active Directory replication to Azure SQL Database.
-
How to pipe SAS Data Sets to CSV in PowerShell
Use standard PowerShell cmdlets to access SAS Data Sets tables.
-
Use Biml to Build SSIS Tasks to Replicate Google Cloud Storage to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Cloud Storage to SQL Server.
-
Replicate Multiple Clio Accounts via the CData Sync CLI
Replicate multiple Clio accounts to one or many databases.
-
Automated Continuous HubSpot Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable HubSpot replication to Google Cloud SQL.
-
How to Design SAP HANA Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Integrate DocuSign into Power Automate Desktop using CData Connect
CData Connect for DocuSign enables you to integrate DocuSign into workflows built using Microsoft Power Automate Desktop.
-
Work with Amazon S3 in FoxPro
Load Amazon S3 into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Visualize Azure DevOps Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure DevOps in Python.
-
Access Splunk 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 Splunk.
-
Connect to Avro in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Prepare, Blend, and Analyze TigerGraph in Alteryx Designer (ODBC)
Build workflows to access live TigerGraph for self-service data analytics.
-
Import Real-Time Asana via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Asana in ColdFusion.
-
How to publish and share Spark dashboards with Tableau Server
The CData ODBC driver for Spark enables you integrate Apache Spark SQL into Tableau dashboards.
-
Write a Simple Go Application to work with PayPal on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to PayPal.
-
Analyze AlloyDB in Cognos Analytics
Use CData Connect AI to connect to AlloyDB from Cognos Analytics and analyze live Google AlloyDB.
-
How to Connect the Power BI Service to Adobe Analytics: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Connect to LDAP Objects in CloverDX (formerly CloverETL)
Transfer LDAP using the visual workflow in the CloverDX data integration tool.
-
Use Microsoft Copilot Studio to talk to your Act-On via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Act-On for you.
-
Deploy the ADO.NET Provider for Oracle Sales on an SSRS Report Server
Connect to Oracle Sales 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.
-
Integrate Live Azure Synapse into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Azure Synapse from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Azure Synapse.
-
Connect to SAP SuccessFactors in RazorSQL
Connect to SAP SuccessFactors from wizards and query SAP SuccessFactors from the GUI in the RazorSQL database management tool.
-
Analyze TaxJar in R via JDBC
Use standard R functions and the development environment of your choice to analyze TaxJar with the CData JDBC Driver for TaxJar.
-
How to Create Power BI Visual Reports with Real-Time Pipedrive
Use CData Power BI Connectors to visualize Pipedrive in Power BI.
-
Create Harvest Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Harvest data access from reports, embedded analytics, and more.
-
Getting Started with the CData Power BI Connector for Gmail
-