CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Sage Cloud Accounting 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 Sage Business Cloud Accounting without replication.
-
Create a Data Access Object for TigerGraph using JDBI
A brief overview of creating a SQL Object API for TigerGraph in JDBI.
-
Provide OData Services of LinkedIn Ads from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for LinkedIn Ads by developing a WCF Service Application.
-
Create Apps from Oracle Eloqua in Qlik Sense Cloud
Use CData Connect AI to connect to Oracle Eloqua and build apps from live Oracle Eloqua in Qlik Sense Cloud.
-
Integrate JSON with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate JSON with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to JSON.
-
Connect to Zendesk as an External Source in Dremio
Use the CData JDBC Driver to connect to Zendesk as an External Source in Dremio.
-
How to create an RPA flow for xBase in UiPath Studio
Use the xBase ODBC Driver to create workflows that access real-time xBase without any coding.
-
Connect to Google Analytics from PowerBuilder via ADO.NET
This article demonstrates how to access Google Analytics from Appeon PowerBuilder using the CData ADO.NET Provider for Google Analytics.
-
WordPress Reporting in OBIEE with the WordPress JDBC Driver
Deploy the WordPress JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build XML-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to XML Files and build web apps with connectivity to live XML Files.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP Business ByDesign using the Model Context Protocol.
-
Connect Azure Synapse to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure Synapse with IBM WebSphere for seamless data integration and connectivity.
-
Replicate Hive from PowerShell
Write a quick PowerShell script to query Apache Hive. Use connectivity to the live data to replicate Apache Hive to SQL Server.
-
Automate Parquet Replication to SAP HANA
Use CData Sync to customize and automate Apache Parquet replication to SAP HANA.
-
Using the CData Software ODBC Driver for Oracle HCM Cloud in PyCharm
Connect to Oracle HCM Cloud as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle HCM Cloud.
-
Create Dynamic SharePoint Excel Services Grids Using the Infragistics XamDataGrid
Learn how you can connect SharePoint Excel Services to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous SAP Business One Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP Business One replication to Oracle.
-
Automated Continuous Square Replication to Databricks
Use CData Sync for automated, continuous, customizable Square replication to Databricks.
-
Automate CSV Replication to Couchbase
Use CData Sync to Customize and automate CSV/TSV Files replication to Couchbase.
-
Trigger Gmail IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Access Live Calendly in AWS Lambda
Connect to live Calendly in AWS Lambda using the CData JDBC Driver.
-
Build Dashboards with Sage 50 UK in Dundas BI
Create dynamic dashboards and perform analytics based on Sage 50 UK in Dundas BI.
-
Feed HBase into FineReport
How to set Apache HBase as a JDBC data source in FineReport.
-
Integrating Gumloop with PostgreSQL via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on PostgreSQL within automated workflows.
-
How to Connect to SQL Server in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft SQL Server. Leverage the pyodbc module for ODBC in Python.
-
Visualize SAP Netweaver Gateway in TIBCO Spotfire through OData
Integrate SAP Netweaver Gateway into dashboards in TIBCO Spotfire.
-
Visualize Live Excel of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Excel using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live ActiveCampaign in AWS Lambda
Connect to live ActiveCampaign in AWS Lambda using the CData JDBC Driver.
-
Automate Spark Replication to SAP HANA
Use CData Sync to customize and automate Apache Spark SQL replication to SAP HANA.
-
Automated Continuous Impala Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Impala replication to Apache Kafka.
-
LINQ to Bitbucket
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 Bitbucket Data Provider.
-
How to Query Live Parquet Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Apache Parquet data in natural language using Python.
-
Build Dashboards with Sage Intacct in Dundas BI
Create dynamic dashboards and perform analytics based on Sage Intacct in Dundas BI.
-
Query Sage Intacct in DataGrip
Create a Data Source for Sage Intacct in DataGrip and use SQL to query live Sage Intacct.
-
Create Data Visualizations in Cognos BI with Oracle
Access Oracle Database as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Import and Visualize Oracle in Power View
Create data visualizations based on Oracle Database in Excel.
-
Visualize SAP ByDesign in Sisense
Create an ElastiCube in Sisense app with access to SAP Business ByDesign.
-
How to Work with Monday.com in AWS Glue Jobs Using JDBC
Connect to Monday.com from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Write a Simple Go Application to work with eBay Analytics on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to eBay Analytics.
-
How to Access SAP Business One Using Entity Framework
This article shows how to access SAP Business One using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Consume SQL Server OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SQL Server feeds that reflect any changes in SAP Lumira.
-
A PostgreSQL Interface for Amazon S3 (MySQL Remoting via JDBC)
Use the Remoting features of the Amazon S3 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Natively Connect to Coinbase in PHP
The CData ODBC driver for Coinbase enables you to create PHP applications with connectivity to Coinbase. Leverage the native support for ODBC in PHP.
-
Connect to Exact Online from HeidiSQL
Use CData Connect AI to connect to and query live Exact Online from HeidiSQL.
-
Replicate Google Spanner from PowerShell
Write a quick PowerShell script to query Google Spanner. Use connectivity to the live data to replicate Google Spanner to SQL Server.
-
Build ActiveCampaign Visualizations in Tableau Cloud
Use CData Connect AI to connect to live ActiveCampaign and build visualizations in Tableau Cloud.
-
Automated Continuous Google Calendar Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Calendar replication to MongoDB.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Epicor Kinetic to Power BI dashboards. Simply drag and drop Epicor Kinetic into data visuals on the Power BI canvas.
-
Write a Simple Go Application to work with Smartsheet on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Smartsheet.
-
Work with Live SAP BusinessObjects BI in Power Query
Use CData Connect AI to connect to SAP BusinessObjects BI and work with live SAP BusinessObjects BI in Microsoft Power Query.
-
Feed Wave Financial into FineReport
How to set Wave Financial as a JDBC data source in FineReport.
-
Access Live eBay in Coginiti Pro
Connect to and query live eBay from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Dynamics CRM in Jaspersoft Studio
Execute SQL to remote Microsoft Dynamics CRM in Jaspersoft Studio.
-
Establish a Live Connection with Twitter using Tableau Bridge
The CData ODBC Driver for Twitter enables you to integrate live Twitter into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to HarperDB Using the Script Function in Claris FileMaker Pro
-