CData Software - Knowledge Base
Recent Articles
-
Integrate Pinterest with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Pinterest with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Pinterest.
-
Build Dashboards with REST in Dundas BI
Create dynamic dashboards and perform analytics based on REST in Dundas BI.
-
Natively Connect to Oracle SCM in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Oracle SCM. Leverage the native support for ODBC in PHP.
-
Provide OData Services of Sybase from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sybase by developing a WCF Service Application.
-
Use the CData Software ODBC Driver for MYOB AccountRight in SAS for Real-Time Reporting and Analytics
Connect to real-time MYOB AccountRight in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MYOB AccountRight.
-
Automate Confluence Replication to Azure Synapse
Use CData Sync to customize and automate Atlassian Confluence replication to Azure Synapse.
-
Prepare, Blend, and Analyze SAP Concur in Alteryx Designer (ODBC)
Build workflows to access live SAP Concur for self-service data analytics.
-
Create Dynamics 365 Business Central Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Dynamics 365 Business Central data access from reports, embedded analytics, and more.
-
Build an OLAP Cube in SSAS from Microsoft OneDrive
Establish a connection to Microsoft OneDrive data from SQL Server Analysis Services, and use the Microsoft OneDrive Data Provider to build OLAP cubes for use in analytics and reporting.
-
Analyze OData Services in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of OData and visualize the live Services in Slingshot (formerly Reveal BI) for seamless insights.
-
Visualize Office 365 from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Office 365.
-
Seamlessly Bring Trello into Retool Using CData Connect AI
Integrate Trello data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use the CData SSIS Components to Insert New or Update Existing EnterpriseDB Records from SQL Server
Easily push SQL Server data to EnterpriseDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into EnterpriseDB or update existing records with data from a SQL Server database.
-
How to create an RPA flow for Phoenix in UiPath Studio
Use the Phoenix ODBC Driver to create workflows that access real-time Apache Phoenix without any coding.
-
Import Real-Time Bitbucket via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Bitbucket in ColdFusion.
-
Analyze Dynamics 365 in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Dynamics 365 and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Publish Access-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Access.
-
Query ConstantContact from Node.js
Use the OData endpoint of the CData API Server to connect to your ConstantContact and perform CRUD operations on ConstantContact from Node.js.
-
Replicate Klaviyo in Heroku for Use in Salesforce Connect
Replicate Klaviyo to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Stripe Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Stripe replication to Apache Cassandra.
-
Automated Continuous Redis Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Redis replication to Azure SQL Database.
-
How to Connect to & Open Exact Online in Microsoft Excel
This article uses the CData ODBC driver for Exact Online to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Access Live SQL Analysis Services in Power Automate Desktop via ODBC
The CData ODBC Driver for SQL Analysis Services enables you to integrate SQL Analysis Services into workflows built using Microsoft Power Automate Desktop.
-
Connect to Google Directory in Jaspersoft Studio
Execute SQL to remote Google Directory in Jaspersoft Studio.
-
How to Connect Flowise AI Agents to Live SingleStore 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.
-
Connect to SAP Ariba Procurement as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP Ariba Procurement as an External Source in Dremio.
-
Use CData Connect AI to Access DocuSign in Microsoft Power Pivot
Use CData Connect AI to connect to live DocuSign in the Power Pivot business intelligence tool.
-
Build Dynamics CRM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Dynamics CRM and create custom apps in Mendix.
-
Integrate with SAP Business One in JReport Designer
Create charts and reports based on SAP Business One in JReport Designer.
-
Automate SuiteCRM Replication to SAP HANA
Use CData Sync to customize and automate SuiteCRM replication to SAP HANA.
-
Easily Integrate XML in Lazarus Pascal IDE
Learn how to easily integrate live XML Files in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Dynamics CRM-Connected Business Apps in AppSheet
Connect to Dynamics CRM via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Dynamics CRM.
-
Build Semantic Layer Views for SAP Hybris C4C in APOS Live Data Gateway
Use the CData Connector for SAP Hybris C4C in APOS Live Data Gateway to build Semantic Layer Views for SAP Hybris C4C.
-
How to Design AlloyDB Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Getting Started with the CData ADO.NET Provider for Google Search
-