CData Software - Knowledge Base
Recent Articles
-
Connect to CapsuleCRM Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for CapsuleCRM to connect to CapsuleCRM and execute queries in PowerBuilder.
-
Build Dashboards with Short.io Data in Dundas BI
Create dynamic dashboards and perform analytics based on Short.io in Dundas BI.
-
Create SAS xpt Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAS xpt data access from reports, embedded analytics, and more.
-
Access Dotmailer Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Dotmailer from your Oracle system.
-
Drip Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Drip facts in real time.
-
Use Dash to Build Web Apps on Shopify Data via CData Connect AI
Build interactive Dash web apps on live Shopify using pandas and the CData Connect AI Python SDK.
-
Integrate with Zendesk Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Zendesk in SnapLogic.
-
Viewing ServiceNow Data in RAD Studio Data Explorer
How to view ServiceNow in RAD Studio Data Explorer using the CData ODBC Driver for ServiceNow.
-
Provide OData Services of Tally Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Tally ERP by developing a WCF Service Application.
-
Integrate with PivotalTracker Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy PivotalTracker to a JSON file on disk.
-
Connect Apify to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Apify with IBM WebSphere for seamless data integration and connectivity.
-
Publish Microsoft Ads-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Ads.
-
Create a Data Access Object for IBM Cloud Object Storage Data using JDBI
A brief overview of creating a SQL Object API for IBM Cloud Object Storage in JDBI.
-
Automated Continuous OData Replication to Snowflake
Use CData Sync for automated, continuous, customizable OData replication to Snowflake.
-
Getting Started with the CData ODBC Driver for OneNote
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for OneNote.
-
Connect to Live Sugar CRM Data in MicroStrategy through CData Connect AI
Create a live connection to Sugar CRM Data in CData Connect AI and connect to your Sugar CRM from MicroStrategy.
-
SendPulse Reporting in OBIEE with the SendPulse JDBC Driver
Deploy the SendPulse JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Easily Query LinkedIn Ads Data in OpenOffice Base
Connect to LinkedIn Ads data in OpenOffice Base using the CData ODBC Driver for LinkedIn Ads and generate reports with live data insights.
-
Moving Data from Epicor Kinetic to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Epicor Kinetic data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate EnterpriseDB Data in Pentaho Data Integration
Build ETL pipelines based on EnterpriseDB in the Pentaho Data Integration tool.
-
Getting Started with the CData Connect AI Python SDK for Xero
Install the CData Connect AI Python SDK to read and write live Xero Accounting with standard DB-API 2.0 Python code.
-
Automated Continuous Amazon DynamoDB Replication to MongoDB
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to MongoDB.
-
Operational Reporting on PayPal Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PayPal.
-
Automated Continuous Hubstaff Replication to Databricks
Use CData Sync for automated, continuous, customizable Hubstaff replication to Databricks.
-
How to Connect the Power BI Service to Simplesat: Complete Guide
Connect to the CData Software Power BI Connector for Simplesat from PowerBI.com to provide real-time Simplesat across the organization.
-
How to connect to SAP Fieldglass Data from Spring Boot
Connect to SAP Fieldglass in a Spring Boot Application using the CData JDBC Driver for SAP Fieldglass
-
Explore Geographical Relationships in Gumroad Data with Power Map
Create data visualizations with Gumroad in Power Map.
-
Visualize Microsoft OneDrive Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft OneDrive.
-
Query, Visualize, and Share live MariaDB Data in Redash
Use CData Connect AI to connect to live MariaDB in Redash for querying, visualizing, and sharing.
-
Add DocuSign Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for DocuSign with the Informatica Enterprise Data Catalog to classify and organize data.
-
Replicate xBase Data in Heroku for Use in Salesforce Connect
Replicate xBase to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Spark Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Spark data access from reports, embedded analytics, and more.
-
Establish a Live Connection with Typeform Data using Tableau Bridge
The CData ODBC Driver for Typeform enables you to integrate live Typeform into Tableau Cloud dashboards using the Tableau Bridge.
-
Working with JobNimbus Data in LINQPad
Execute LINQ queries to JobNimbus in LINQPad.
-
Integrate with Amazon DynamoDB Data in JReport Designer
Create charts and reports based on Amazon DynamoDB in JReport Designer.
-
Configure the CData JDBC Driver for LionDesk in a Connection Pool in Tomcat
Connect to LionDesk from a connection pool in Tomcat.
-
Connect to Greenplum from a Connection Pool in WebLogic
Use the CData JDBC Driver for Greenplum to connect to Pivotal GreenPlum from Web applications running on WebLogic.
-
Replicate Multiple Eventbrite Accounts
Replicate multiple Eventbrite accounts to one or many databases.
-
Integrating LlamaIndex with Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Salesforce CRM Analytics in real time.
-
Connect to Wrike Data in DBArtisan
Use wizards in DBArtisan to configure Wrike as a data source.
-
Analyze Amazon Marketplace Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Amazon Marketplace and visualize Amazon Marketplace in SAP Analytics Cloud.
-
Edit and Search Square External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Square to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Square objects that you can access from apps and the dashboard.
-
Connect to Bright Data Data in Jaspersoft Studio
Execute SQL to remote Bright Data in Jaspersoft Studio.
-
Automated Continuous SAP HANA XS Advanced Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to IBM DB2.
-
Integrate Cline with Live SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP HANA from within your IDE.
-
Rapidly Develop Demio-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Demio.
-
Use the CData Software JDBC Driver for Certinia in MicroStrategy Desktop
Connect to Certinia in MicroStrategy Desktop using the CData Software JDBC Driver for Certinia.
-
Access Live Microsoft OneDrive Data in Coginiti Pro
Connect to and query live Microsoft OneDrive from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoho CRM
Provide connectivity to Zoho CRM through an SAP BusinessObjects universe.
-
Shortcut Reporting in OBIEE with the Shortcut JDBC Driver
Deploy the Shortcut JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Extract, Transform, and Load EmailOctopus Data in Informatica PowerCenter
Create a simple Workflow for EmailOctopus in Informatica PowerCenter.
-
Use JayDeBeApi to access Certinia Data in Python
Use standard Python scripting and the development environment of your choice to access live Certinia.
-
Access Live Oracle Eloqua Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle Eloqua in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate with Live IBM Cloud Object Storage Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to IBM Cloud Object Storage from the MuleSoft Anypoint Platform to integrate live IBM Cloud Object Storage into custom reports and dashboards.
-
Getting Started with the CData Tableau Connector for WooCommerce
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for WooCommerce.
-
Build Pipelines with Live Oracle SCM Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Oracle SCM from Google Cloud Data Fusion, enabling the integration of live Oracle SCM into the building and management of effective data pipelines.
-
Connect to SuiteCRM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SuiteCRM and the Script function in FileMaker Pro to connect to SuiteCRM and work with SuiteCRM in your FileMaker application.
-
DataBind Charts to Zoho Creator Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Creator 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.
-
Query, Visualize, and Share live MarkLogic Data in Redash
Use CData Connect AI to connect to live MarkLogic in Redash for querying, visualizing, and sharing.
-
Build a Simple VCL Application for HelloSign Data
How to build a simple VCL Application to view HelloSign in RAD Studio using the CData ODBC Driver for HelloSign.
-
Publish Email-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Email.
-
Access Live Drip Data in AWS Lambda
Connect to live Drip in AWS Lambda using the CData JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Microsoft Ads Data
Use CData Power BI Connectors to visualize Microsoft Ads in Power BI.
-
Analyze SharePoint Excel Services Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SharePoint Excel Services and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Natively Connect to Power BI XMLA Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Power BI XMLA. Leverage the native support for ODBC in PHP.
-
Build Instantly-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Instantly and build web apps with connectivity to live Instantly.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Sybase IQ actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
How to Connect to & Open Azure DevOps Data in Microsoft Excel
This article uses the CData ODBC driver for Azure DevOps to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Monday.com Data in TIBCO Spotfire through OData
Integrate Monday.com into dashboards in TIBCO Spotfire.
-
Connect to Dynamics 365 Business Central Data in RapidMiner
Integrate Dynamics 365 Business Central with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Excel Add-In for Egnyte
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Egnyte.
-
Automate Zuora Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Zuora and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Visualize Bannerbear Data in TIBCO Spotfire through ADO.NET
Integrate Bannerbear into dashboards in TIBCO Spotfire.
-
Integrating Boomi Agentstudio with Paylocity Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Paylocity, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Replicate Apify Data from PowerShell
Write a quick PowerShell script to query Apify. Use connectivity to the live data to replicate Apify to SQL Server.
-
Build Semantic Layer Views for Zoho Books Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Zoho Books.
-
Automated Continuous HBase Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable HBase replication to Google Cloud SQL.
-
How to create an RPA flow for Box Data in UiPath Studio
Use the Box ODBC Driver to create workflows that access real-time Box without any coding.
-
Access SAP Concur Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for SAP Concur.
-
Connect to HDFS Data in DBeaver
Use the CData ODBC Driver to connect to Apache HDFS in DBeaver.
-
Connect to Airtable Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Airtable Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Bridge Spotify Connectivity with Apache NiFi
Access and process Spotify in Apache NiFi using the CData JDBC Driver.
-
How to Connect to Live Slack Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Slack for you.
-
Validate ConvertAPI Data with QuerySurge
Access and validate ConvertAPI in QuerySurge using the CData JDBC Driver.
-
Getting Started with the CData Excel Add-In for Invoiced
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Invoiced.
-
Integrate Contentful Data in Pentaho Data Integration
Build ETL pipelines based on Contentful in the Pentaho Data Integration tool.
-
Query Vercel Data in ColdFusion
Write standard ColdFusion data access code to connect to Vercel.
-
Build AI Agents with Slack Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Slack through CData Connect AI.
-
Integrate Theia IDE with Live Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Act-On within intelligent workflows.
-
Use the CData ODBC Driver for LionDesk from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for LionDesk to connect to LionDesk from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring LionDesk in Excel.
-
Use the CData Software JDBC Driver for Gumroad in MicroStrategy Web
Connect to Gumroad in MicroStrategy Web using the CData Software JDBC Driver for Gumroad.
-
Visualize Excel Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Excel.
-
Integrating Antigravity CLI with SharePoint Excel Services via CData CLI
Connect SharePoint Excel Services to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Marketo Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Marketo as an External Source in Dremio.
-
Build Agents in Relevance AI with Access to Live DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on DocuSign within intelligent agent workflows.
-
Connect to Spotify Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Spotify to connect to Spotify and execute queries in PowerBuilder.
-
Integrate LibreChat with Live CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live CockroachDB from within the chat interface.
-
Access Live ServiceNow Data in TIBCO Data Virtualization
Use the ServiceNow Tibco DV Adapter to create a ServiceNow data source in TIBCO Data Virtualization Studio and gain access to live ServiceNow from your TDV Server.
-
Enable the Exact Online JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Exact Online.