CData Software - Knowledge Base
Recent Articles
-
Integrate with Slack in JReport Designer
Create charts and reports based on Slack in JReport Designer.
-
Building Dynamic Web Pages with Amazon S3 Using AngularJS
Create single-page applications with live connectivity to Amazon S3 using the CData API Server.
-
Query Square from Node.js
Use the OData endpoint of the CData API Server to connect to your Square and perform CRUD operations on Square from Node.js.
-
Object-Relational Mapping (ORM) with Office 365 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 Microsoft Office 365 into a Java-based ORM framework, Hibernate.
-
Load Splunk to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Splunk to a database.
-
How to Import Data from Amazon Athena into Google Sheets
Import Amazon Athena into a Google spreadsheet that is automatically refreshed.
-
Excel Spreadsheet Automation on RSS Feeds with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Act CRM
Provide connectivity to Act CRM through an SAP BusinessObjects universe.
-
Excel Spreadsheet Automation on SAS Data Sets with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Monday.com to Power BI dashboards. Simply drag and drop Monday.com into data visuals on the Power BI canvas.
-
Access Live Sage Intacct in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Sage Intacct from your Excel spreadsheets.
-
Automated Continuous GitHub Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable GitHub replication to Google BigQuery.
-
Query, Visualize, and Share live SAP Business One in Redash
Use CData Connect AI to connect to live SAP Business One in Redash for querying, visualizing, and sharing.
-
How to work with Pipedrive in Apache Spark using SQL
Access and process Pipedrive in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Power BI XMLA Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to OneLake in Microsoft Fabric.
-
Connect to QuickBooks in HULFT Integrate
Connect to QuickBooks as a JDBC data source in HULFT Integrate
-
Build Dashboards with Office 365 in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Office 365 in Dundas BI.
-
Building Dynamic Web Pages with Azure Table Using AngularJS
Create single-page applications with live connectivity to Azure Table using the CData API Server.
-
Write a Simple Go Application to work with SendGrid on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SendGrid.
-
Connect to Adobe Analytics in the Denodo Platform
Use CData driver technologies to create a virtual data source for Adobe Analytics in the Denodo Virtual DataPort Administrator.
-
Integrating LangGraph with Oracle Eloqua via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Oracle Eloqua within automated workflows.
-
Import Real-Time FTP via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use FTP Servers in ColdFusion.
-
Build a PostgreSQL Interface for XML using the CData JDBC Driver
Use the Remoting features of the XML JDBC Driver to create a PostgreSQL entry-point for data access.
-
A Comparison of the CData and Sun JDBC-ODBC Bridges
Performance tests show that the CData JDBC-ODBC Bridge is up to 327% faster than the Sun JDBC-ODBC Bridge.
-
Migrating data from PayPal to Databricks using CData SSIS Components.
Easily push PayPal to Databricks using the CData SSIS Tasks for PayPal and Databricks.
-
Manage CouchDB in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CouchDB.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
PowerShell Scripting to Replicate Microsoft Dataverse to MySQL
Write a simple PowerShell script to replicate Microsoft Dataverse (CDS) to a MySQL database.
-
Create Reports with Google Spanner in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Spanner.
-
Build Automated Workflows with Live Cosmos DB in Workato
Use CData Connect AI to connect to live Azure Cosmos DB and build automated workflows in Workato.
-
Write a Simple Go Application to work with Adobe Analytics on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Adobe Analytics.
-
Migrating data from Active Directory to Google BigQuery using CData SSIS Components.
Easily push Active Directory to Google BigQuery using the CData SSIS Tasks for Active Directory and Google BigQuery.
-
Build Google Calendar-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Calendar.
-
How to integrate ADP with Apache Airflow
Access and process ADP in Apache Airflow using the CData JDBC Driver.
-
Integrate Exact Online into Automated Tasks with Power Automate
Use CData Connect AI to connect to Exact Online and integrate live Exact Online into your Power Automate tasks.
-
Build Semantic Layer Views for Facebook in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Facebook.
-
Automated Continuous NetSuite SuiteAnalytics Replication to IBM DB2
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to IBM DB2.
-
How to Access Live Odoo in Visual Studio Code via Cline
-