CData Software - Knowledge Base
Recent Articles
-
Import SharePoint Data Using Azure Data Factory
Use CData Connect AI to connect to SharePoint Data from Azure Data Factory and import live Microsoft SharePoint.
-
Analyze Sybase IQ Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Sybase IQ and visualize Sybase IQ in SAP Analytics Cloud.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed QuickBooks Time to Power BI dashboards. Simply drag and drop QuickBooks Time into data visuals on the Power BI canvas.
-
Build Dashboards with Retently Data in Dundas BI
Create dynamic dashboards and perform analytics based on Retently in Dundas BI.
-
Connect to Microsoft Planner Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Microsoft Planner Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connecting GenSpark with SAP Fieldglass Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP Fieldglass without any replication or custom integration required.
-
Integrating OpenCode Terminal with SendGrid Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Replicate Multiple Sendwithus Accounts via the CData Sync CLI
Replicate multiple Sendwithus accounts to one or many databases.
-
ElevenLabs Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ElevenLabs facts in real time.
-
Integrating Codex CLI with DocuSign via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Use the CData Software JDBC Driver for Mailjet in MicroStrategy Web
Connect to Mailjet in MicroStrategy Web using the CData Software JDBC Driver for Mailjet.
-
Migrating data from Intercom to Databricks using CData SSIS Components.
Easily push Intercom to Databricks using the CData SSIS Tasks for Intercom and Databricks.
-
Build a Simple VCL Application for Moosend Data
How to build a simple VCL Application to view Moosend in RAD Studio using the CData ODBC Driver for Moosend.
-
Build Twitter Ads-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Twitter Ads Data and create custom apps in Mendix.
-
Analyze CampaignMonitor Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze CampaignMonitor in Microsoft R Open.
-
Access Live SAP Business One Data in AWS Lambda
Connect to live SAP Business One in AWS Lambda using the CData JDBC Driver.
-
Replicate Spotify Data from PowerShell
Write a quick PowerShell script to query Spotify. Use connectivity to the live data to replicate Spotify to SQL Server.
-
Build Charts with Printful Data in Clear Analytics
Create dynamic charts and perform analytics based on Printful in Clear Analytics.
-
Integrate Live Phoenix Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Visualize Jodoo Data in TIBCO Spotfire through ADO.NET
Integrate Jodoo into dashboards in TIBCO Spotfire.
-
How to integrate Splunk with Apache Airflow
Access and process Splunk in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for Campaigner
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Excel Spreadsheet Automation on Zuora Data with the QUERY Formula
Pull data from Zuora, automate spreadsheets, and more with the QUERY formula.
-
Load AfterShip Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load AfterShip to a database.
-
Object-Relational Mapping (ORM) with Testmonitor Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Testmonitor into a Java-based ORM framework, Hibernate.
-
Connect to Testmonitor Data in RapidMiner
Integrate Testmonitor with standard components and data source configuration wizards in RapidMiner Studio.
-
Provide OData Services of CampaignMonitor Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for CampaignMonitor by developing a WCF Service Application.
-
Visualize Live ShipStation Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ShipStation.
-
Replicate OneNote Data in Heroku for Use in Salesforce Connect
Replicate Microsoft OneNote to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect Brex to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Brex with IBM WebSphere for seamless data integration and connectivity.
-
Import and Visualize Certinia Data in Power View
Create data visualizations based on Certinia in Excel.
-
Use Claude to Talk to Your Google Directory Data 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 Directory for you.
-
Viewing PivotalTracker Data in RAD Studio Data Explorer
How to view PivotalTracker in RAD Studio Data Explorer using the CData ODBC Driver for PivotalTracker.
-
Create SSAS Tabular Models from ShipEngine Data
How to build a SQL Server Analysis Service Tabular Model from ShipEngine using CData drivers.
-
Add Confluence Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Confluence with the Informatica Enterprise Data Catalog to classify and organize data.
-
A PostgreSQL Interface for Beeminder Data (MySQL Remoting via JDBC)
Use the Remoting features of the Beeminder JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SuiteCRM Data in NetBeans
Connect to SuiteCRM in NetBeans with the data source configuration wizard.
-
Viewing Paylocity Data in RAD Studio Data Explorer
How to view Paylocity in RAD Studio Data Explorer using the CData ODBC Driver for Paylocity.
-
Validate Google Spanner Data with QuerySurge
Access and validate Google Spanner in QuerySurge using the CData JDBC Driver.
-
Establish a Live Connection with Auth0 Data using Tableau Bridge
The CData ODBC Driver for Auth0 enables you to integrate live Auth0 into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Semantic Layer Views for Google Campaign Manager 360 Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Campaign Manager 360.
-
How to Connect to Everhour Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Everhour. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData SSIS Components for Quickbase
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Quickbase.
-
Write a Simple Go Application to work with Workday Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Workday.
-
Integrate OneNote Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft OneNote from Informatica Cloud.
-
Natively Connect to HBase Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Apache HBase. Leverage the native support for ODBC in PHP.
-
Visualize NASA Data in TIBCO Spotfire through ADO.NET
Integrate NASA into dashboards in TIBCO Spotfire.
-
How to Query Live Okta Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Okta data in natural language using Python.
-
Nuclia Reporting in OBIEE with the Nuclia JDBC Driver
Deploy the Nuclia JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Twitter Ads Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Twitter Ads in the Denodo Virtual DataPort Administrator.
-
How to Seamlessly Import Salesforce Data 360 Data into IBM SPSS Modeler
Integrate Salesforce Data 360 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Azure DevOps-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Azure DevOps.
-
How to Connect DBeaver to Spotify via a JDBC Driver
Manage Spotify with visual tools in DBeaver like the query browser.
-
Connect to Twitter Ads Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Twitter Ads and the SQL Gateway to access Twitter Ads from Google Apps Script.
-
How to Seamlessly Import ActiveCampaign Data into IBM SPSS Modeler
Integrate ActiveCampaign data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to connect PolyBase to WooCommerce
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live WooCommerce.
-
Query PostgreSQL Data in ColdFusion
Write standard ColdFusion data access code to connect to PostgreSQL.
-
Use the CData Software JDBC Driver for Gmail in MicroStrategy
Connect to Gmail in MicroStrategy Developer using the CData Software JDBC Driver for Gmail.
-
How to integrate Planio with Apache Airflow
Access and process Planio in Apache Airflow using the CData JDBC Driver.
-
Access Live Salesforce Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Salesforce & Force.com from your Excel spreadsheets.
-
Automated Continuous Excel Online Replication to MySQL
Use CData Sync for automated, continuous, customizable Excel Online replication to MySQL.
-
Create Exa Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Exa data access from reports, embedded analytics, and more.
-
Automated Continuous SAP SuccessFactors Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to SQL Server.
-
Operational Reporting on Landbot Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Landbot.
-
Visualize Live Okta Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Okta into custom reports in Power BI.
-
Publish Dropbox-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Dropbox.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for LionDesk
Provide connectivity to LionDesk through an SAP BusinessObjects universe.
-
Access Omnisend Data from MySQL in Amazon QuickSight
Connect to Omnisend and build visualizations of Omnisend using a MySQL Connection in Amazon QuickSight.
-
Integrating LlamaIndex with Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Azure Synapse in real time.
-
Automated Continuous Pipeliner CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to MySQL.
-
How to Build an ETL App for Redis Data in Python with CData Connect AI
Build ETL pipelines that read and write live Redis in Python with petl and the CData Connect AI Python SDK.
-
Connecting GenSpark with Confluence Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Atlassian Confluence without any replication or custom integration required.
-
Create Datasets from Delighted in Domo Workbench and Build Visualizations of Delighted Data in Domo
Use the CData Software ODBC Driver for Delighted to create datasets from Delighted in Domo Workbench and then build visualizations in the Domo service.
-
Power BI XMLA Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Power BI XMLA through CData Connect AI using different applications and tools.
-
Use the CData Software ODBC Driver for LinkedIn in MicroStrategy
Connect to LinkedIn in MicroStrategy Developer using the CData Software ODBC Driver for LinkedIn.
-
Use the CData Software ODBC Driver for Suadeo in MicroStrategy Desktop
Connect to Suadeo in MicroStrategy Desktop using the CData Software ODBC Driver for Suadeo.
-
How to Query Live Adobe Target Data in Perplexity MacOS Desktop
Connect to and query live Adobe Target Data in Perplexity Desktop using CData MCP Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Stripe
Provide connectivity to Stripe through an SAP BusinessObjects universe.
-
Getting Started with the CData Tableau Connector for Opsgenie
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate Live Jira Assets Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Jira Assets and integrate live Jira Assets into apps built in Microsoft Power Apps.
-
Create Google Contacts-Connected Nintex Workflows
Use CData Connect AI to connect to Google Contacts Data from Nintex Workflow Cloud and build custom workflows using live Google Contacts.
-
Model Act CRM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Act CRM, enabling the direct import of real-time Act CRM.
-
Getting Started with the CData ODBC Driver for Cassandra
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Cassandra.
-
Natively Connect to Todoist Data in PHP
The CData ODBC driver for Todoist enables you to create PHP applications with connectivity to Todoist. Leverage the native support for ODBC in PHP.
-
Bridge CircleCI Connectivity with Apache NiFi
Access and process CircleCI in Apache NiFi using the CData JDBC Driver.
-
Use the CData API Server to Access LDAP Objects in Microsoft PowerPivot
Use the CData API Server to connect to live LDAP in the Power Pivot business intelligence tool.
-
Use the CData Software JDBC Driver for SFTP in MicroStrategy
Connect to SFTP in MicroStrategy Developer using the CData Software JDBC Driver for SFTP.
-
Access Live SAP Hybris C4C Data in AWS Lambda
Connect to live SAP Hybris C4C in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous SAP ByDesign Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to SQLite.
-
Automate SAP Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP ERP/NetWeaver from PowerShell? This article demonstrates how to utilize the SAP Cmdlets for tasks like connecting to SAP ERP/NetWeaver, automating operations, downloading data, and more.
-
How to integrate Everhour with Apache Airflow
Access and process Everhour in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData Tableau Connector for Mailgun
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Excel Spreadsheet Automation on Teradata Data with the QUERY Formula
Pull data from Teradata, automate spreadsheets, and more with the QUERY formula.
-
Migrating data from Cloudant to Snowflake using CData SSIS Components.
Easily push IBM Cloudant to Snowflake using the CData SSIS Tasks for Cloudant and Snowflake.
-
Easily Integrate Snowflake Data in Lazarus Pascal IDE
Learn how to easily integrate live Snowflake in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData Software JDBC Driver for SparkPost in MicroStrategy Web
Connect to SparkPost in MicroStrategy Web using the CData Software JDBC Driver for SparkPost.
-
How to create an RPA flow for FTP Data in UiPath Studio
Use the FTP ODBC Driver to create workflows that access real-time FTP Servers without any coding.
-
Connect to Facebook Ads Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Facebook Ads Data and connect to Facebook Ads in Akorbi Digital RunMyProcess.
-
How to Build an ETL App for Sybase IQ Data in Python with CData
Create ETL applications and real-time data pipelines for Sybase IQ in Python with petl.
-
Feed Hive Data into FineReport
How to set Apache Hive as a JDBC data source in FineReport.