CData Software - Knowledge Base
Recent Articles
-
Import SAP BusinessObjects BI into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP BusinessObjects BI. In this article, you will use the OData format to import SAP BusinessObjects BI into Microsoft Power Query.
-
Automated Continuous Google Sheets Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Sheets replication to Amazon Redshift.
-
Automated Continuous Google Ads Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Ads replication to delimited files (CSV/TSV).
-
How to import Cosmos DB into Apache Solr
Use the CData Software JDBC Driver for Cosmos DB in Data Import Handler and create an automated import of Azure Cosmos DB to Apache Solr Enterprise Search platform.
-
How to Work with Procore in ETL Validator JDBC
Connect to Procore from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Zoom in DBArtisan
Use wizards in DBArtisan to configure Zoom as a data source.
-
Create Reports with Typeform in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Typeform.
-
Viewing CSV in RAD Studio Data Explorer
How to view CSV/TSV Files in RAD Studio Data Explorer using the CData ODBC Driver for CSV.
-
Automated Continuous NetSuite Replication to Amazon S3
Use CData Sync for automated, continuous, customizable NetSuite replication to Amazon S3.
-
Automated Continuous Odoo Replication to Snowflake
Use CData Sync for automated, continuous, customizable Odoo replication to Snowflake.
-
Use Claude to Talk to Your Elasticsearch via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Elasticsearch for you.
-
Getting Started with the CData SSIS Components for ADP
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ADP.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Contacts
Provide connectivity to Google Contacts through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for Google Ad Manager in MicroStrategy
Connect to Google Ad Manager in MicroStrategy Developer using the CData Software ODBC Driver for Google Ad Manager.
-
Create Azure Active Directory Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Replicate Azure Table from PowerShell
Write a quick PowerShell script to query Azure Table Storage. Use connectivity to the live data to replicate Azure Table Storage to SQL Server.
-
How to connect to HarperDB from Spring Boot
Connect to HarperDB in a Spring Boot Application using CData JDBC HarperDB Driver
-
How to Connect the Power BI Service to Dynamics 365: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Create Adobe Analytics Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Cursor with Live Microsoft Project Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Microsoft Project from within the editor.
-
Use the CData ODBC Driver for Azure Table from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Azure Table to connect to Azure Table Storage from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure Table Storage in Excel.
-
Connect to XML from PowerBuilder via ADO.NET
This article demonstrates how to access XML Files from Appeon PowerBuilder using the CData ADO.NET Provider for XML.
-
Design BIRT Reports on Aha
Provide current Aha! to your embedded analytics.
-
How to create an RPA flow for Act-On in UiPath Studio
Use the Act-On ODBC Driver to create workflows that access real-time Act-On without any coding.
-
Add Google Search Results to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Search with the Informatica Enterprise Data Catalog to classify and organize data.
-
Extend Google Sheets with Certinia
Make calls to the API Server from Google Apps Script.
-
How to integrate Zoho Creator with Apache Airflow
Access and process Zoho Creator in Apache Airflow using the CData JDBC Driver.
-
Publish Hive-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Apache Hive.
-
Connect to LinkedIn Ads in DBeaver
Use the CData ODBC Driver to connect to LinkedIn Ads in DBeaver.
-
Use the CData Software JDBC Driver for NetSuite in MicroStrategy Web
Connect to NetSuite CRM & ERP in MicroStrategy Web using the CData Software JDBC Driver for NetSuite.
-
Consume SAP Netweaver Gateway OData Feeds in PowerBuilder
This article demonstrates how to consume SAP Netweaver Gateway as OData feeds from PowerBuilder using the API Server.
-
Use Claude to Talk to Your Google Sheets via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Google Sheets for you.
-
Build OData-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live OData.
-
Automated Continuous SAP Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP replication to Oracle.
-
Using the CData Software ODBC Driver for Adobe Target in PyCharm
Connect to Adobe Target as an ODBC data source in PyCharm using the CData Software ODBC Driver for Adobe Target.
-
Work with Live SurveyMonkey in Power Query
Use CData Connect AI to connect to SurveyMonkey and work with live SurveyMonkey in Microsoft Power Query.
-
Build Excel Online-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Excel Online and build Excel Online-connected web apps with Axios.
-
Connect and Visualize Live Facebook Ads Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Facebook Ads into the Databricks platform and create visualization dashboards with real-time Facebook Ads.
-
Consume Tableau CRM Analytics OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Tableau CRM Analytics feeds that reflect any changes in SAP Lumira.
-
ETL Acumatica in Oracle Data Integrator
This article shows how to transfer Acumatica ERP into a data warehouse using Oracle Data Integrator.
-
Automated Continuous IBM Cloud Object Storage Replication to IBM DB2
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to IBM DB2.
-
Automated Continuous PayPal Replication to Vertica
Use CData Sync for automated, continuous, customizable PayPal replication to Vertica.
-
How to Connect Flowise AI Agents to Live Monday.com via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Automated Continuous Excel Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Excel replication to Apache Cassandra.
-
How to Connect to Live Odoo in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Odoo ERP without replication.
-
Replicate Multiple LinkedIn Ads Accounts via the CData Sync CLI
Replicate multiple LinkedIn Ads accounts to one or many databases.
-
PostgreSQL Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on PostgreSQL facts in real time.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for OData
Provide connectivity to OData through an SAP BusinessObjects universe.
-
View Reports on Real-Time Salesforce Pardot in Power BI Report Server
Use the CData ODBC Driver for Salesforce Pardot to visualize Salesforce Pardot in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Power BI Connector for Dropbox
-