CData Software - Knowledge Base
Recent Articles
-
Excel Spreadsheet Automation on Amazon DynamoDB with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Connect to Outreach.io in RapidMiner
Integrate Outreach.io with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Dashboards with HBase in Dundas BI
Create dynamic dashboards and perform analytics based on Apache HBase in Dundas BI.
-
DataBind Charts to SAP SuccessFactors LMS
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP SuccessFactors LMS 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.
-
PowerShell Scripting to Replicate HubSpot to MySQL
Write a simple PowerShell script to replicate HubSpot to a MySQL database.
-
Connect to Excel from a Connection Pool in WebLogic
Use the CData JDBC Driver for Excel to connect to Microsoft Excel from Web applications running on WebLogic.
-
Create Dynamic Sage Intacct Grids Using the Infragistics XamDataGrid
Learn how you can connect Sage Intacct to Infragistics XamDataGrid to build dynamic grids.
-
How to Design Act CRM Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Natively Connect to Phoenix in PHP
The CData ODBC driver for Phoenix enables you to create PHP applications with connectivity to Apache Phoenix. Leverage the native support for ODBC in PHP.
-
Automated Continuous Odoo Replication to Databricks
Use CData Sync for automated, continuous, customizable Odoo replication to Databricks.
-
Natively Connect to Dynamics 365 in PHP
The CData ODBC driver for Dynamics 365 enables you to create PHP applications with connectivity to Microsoft Dynamics 365. Leverage the native support for ODBC in PHP.
-
Connect SAP Ariba Source to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Ariba Source using the CData Python MCP Server.
-
Access Live Certinia Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Certinia data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Create Power BI Visual Reports with Real-Time LDAP Objects
Use CData Power BI Connectors to visualize LDAP in Power BI.
-
Getting Started with the CData Excel Add-In for Wave Financial
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Wave Financial.
-
Connecting GenSpark with SAP SuccessFactors 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.
-
Build Avalara AvaTax-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Avalara AvaTax.
-
Publish Crystal Reports on CockroachDB
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date CockroachDB.
-
How to Work with Sage Intacct in AWS Glue Jobs Using JDBC
Connect to Sage Intacct from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Dashboards and Visualize Live Asana in Geckoboard
Use CData Connect AI to connect to live Asana and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate SuiteCRM in Pentaho Data Integration
Build ETL pipelines based on SuiteCRM in the Pentaho Data Integration tool.
-
Build Apps with Live Apache Spark SQL in Adalo using CData Connect AI
Use CData Connect AI to integrate live Apache Spark SQL into the Adalo platform and build custom mobile and web applications with real-time Apache Spark SQL.
-
Build Automated Spark-Connected Workflows in Zapier
Use CData Connect AI to connect to live Apache Spark SQL and build automated workflows in Zapier.
-
How to integrate Metabase with Act-On
Use CData Connect AI to connect to live Act-On and create an interactive dashboard in Metabase from Act-On.
-
Greenhouse Reporting in OBIEE with the Greenhouse JDBC Driver
Deploy the Greenhouse JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect Zuora to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Zuora data in real time using natural language.
-
How to Work with Google Directory in AWS Glue Jobs Using JDBC
Connect to Google Directory from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Easily Integrate Oracle HCM Cloud in Lazarus Pascal IDE
Learn how to easily integrate live Oracle HCM Cloud in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Work with Zendesk in FoxPro
Load Zendesk into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize Parquet in TIBCO Spotfire through OData
Integrate Apache Parquet into dashboards in TIBCO Spotfire.
-
Build a Singer.io Tap for Google Cloud Storage With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Cloud Storage data using
-
Automate Raisers Edge NXT Replication to Azure Synapse
Use CData Sync to customize and automate Raisers Edge NXT replication to Azure Synapse.
-
Connect to Power BI XMLA in Aqua Data Studio
Access Power BI XMLA from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Migrating data from Greenplum to Google BigQuery using CData SSIS Components.
Easily push Pivotal GreenPlum to Google BigQuery using the CData SSIS Tasks for Greenplum and Google BigQuery.
-
Automated Continuous ShipStation Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ShipStation replication to Azure SQL Database.
-
LINQ to QuickBooks
LINQ provides general-purpose query facilities in .NET Framework 3.0 and above and provides one easy way to programmatically access data through from CData Data Providers for ADO.NET. This example uses LINQ to access information from the QuickBooks Data Provider.
-
Using the CData Software ODBC Driver for Parquet in PyCharm
Connect to Parquet as an ODBC data source in PyCharm using the CData Software ODBC Driver for Parquet.
-
Use Azure AI Foundry to Talk to Your QuickBooks Online via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your QuickBooks Online for you.
-
Connect to Elasticsearch from AWS Glue
Use CData Connect AI to gain access to live Elasticsearch from your AWS Glue jobs.
-
Getting Started with the CData Tableau Connector for Redis
-