CData Software - Knowledge Base
Recent Articles
-
Work with Live Google Ads Data in Power Query
Use CData Connect AI to connect to Google Ads and work with live Google Ads in Microsoft Power Query.
-
Connect to Pipeline CRM Data from PowerBuilder via JDBC
This article demonstrates how to access Pipeline CRM from PowerBuilder using the Pipeline CRM JDBC Driver.
-
Connect to Certinia Data from PowerBuilder via JDBC
This article demonstrates how to access Certinia from PowerBuilder using the Certinia JDBC Driver.
-
How to Visualize FHIR Data in Python with pandas
Use pandas and other modules to analyze and visualize live FHIR in Python.
-
Import and Visualize Zoho Creator Data in Power View
Create data visualizations based on Zoho Creator in Excel.
-
Connect to SAP Hybris C4C Data in NetBeans
Connect to SAP Hybris C4C in NetBeans with the data source configuration wizard.
-
Integrating Gumloop with Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Sugar CRM within automated workflows.
-
Analyze Productboard Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Productboard from Power Pivot. You will use the Table Import Wizard to load Productboard. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Salesforce Data in the Pentaho Report Designer
Publish reports based on Salesforce & Force.com in the Pentaho BI tool.
-
How to connect to Hive Data from Spring Boot
Connect to Hive in a Spring Boot Application using the CData JDBC Driver for Hive
-
Provide OData Services of Amazon S3 Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Amazon S3 by developing a WCF Service Application.
-
Create Informatica Mappings From/To an ODBC Data Source for BigQuery
Create an ODBC connection to BigQuery in Informatica and browse and transfer Google BigQuery.
-
Create Dashboards and Visualize Live Smartsheet Data in Geckoboard
Use CData Connect AI to connect to live Smartsheet and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Edit and Search External Vault CRM Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Veeva Vault & Vault CRM to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Vault CRM Data objects that you can access from apps and the dashboard.
-
Build Data Flows from SAP SuccessFactors LMS to SQL Server using SSIS
Easily back up SAP SuccessFactors LMS to SQL Server using the SSIS components for SAP SuccessFactors LMS.
-
Seamlessly Bring Adobe Analytics Data into Retool Using CData Connect AI
Integrate Adobe Analytics data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous SAP ByDesign Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Google BigQuery.
-
Connecting Moonlit Workflow with Dynamics 365 Business Central Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Dynamics 365 Business Central in real time.
-
Analyze Active Directory Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Active Directory and visualize Active Directory in SAP Analytics Cloud.
-
Build Charts with Demio Data in Clear Analytics
Create dynamic charts and perform analytics based on Demio in Clear Analytics.
-
Connect to Amazon S3 Data from a Connection Pool in JBoss
Integrate Amazon S3 into Java servlets: Use the Management Console in JBoss to install the Amazon S3 JDBC Driver.
-
Automated Continuous XML Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable XML replication to delimited files (CSV/TSV).
-
Use the CData Software ODBC Driver for ZendeskSell in MicroStrategy Web
Connect to ZendeskSell in MicroStrategy Web using the CData Software ODBC Driver for ZendeskSell.
-
Automated Continuous Printful Replication to Oracle
Use CData Sync for automated, continuous, customizable Printful replication to Oracle.
-
SAP Fieldglass Reporting in OBIEE with the SAP Fieldglass JDBC Driver
Deploy the SAP Fieldglass JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Excel Spreadsheet Automation on Telegram Data with the QUERY Formula
Pull data from Telegram, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software ODBC Driver for Google Analytics in MicroStrategy Web
Connect to Google Analytics in MicroStrategy Web using the CData Software ODBC Driver for Google Analytics.
-
Automated Continuous Xero Replication to SingleStore
Use CData Sync for automated, continuous, customizable Xero replication to SingleStore.
-
How to connect and process Freshdesk from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Freshdesk.
-
Natively Connect to Browserless Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Browserless. Leverage the native support for ODBC in PHP.
-
Analyze Sage 200 Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Sage 200 and visualize live Sage 200 in Infragistics Reveal.
-
How to Connect to Live FTP Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live FTP Servers securely in real time.
-
Use the CData ODBC Driver for Perigon from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Perigon to connect to Perigon from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Perigon in Excel.
-
Access Onfleet 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 Onfleet.
-
Visualize Live RSS Feeds in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live RSS Feeds.
-
How to publish and share Slack Data dashboards with Tableau Server
The CData ODBC driver for Slack enables you integrate Slack into Tableau dashboards.
-
Automated Continuous Quaderno Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Quaderno replication to delimited files (CSV/TSV).
-
Explore Geographical Relationships in eBay Analytics Data with Power Map
Create data visualizations with eBay Analytics in Power Map.
-
How to Work with Microsoft Planner Data in ETL Validator JDBC
Connect to Microsoft Planner from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Splunk Data in TIBCO Spotfire through ADO.NET
Integrate Splunk into dashboards in TIBCO Spotfire.
-
Create Reports with Pinterest Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pinterest.
-
Getting Started with the CData Python Connector for Pinecone
Learn to install and license the CData Python Connector
-
Validate Microsoft Entra ID Data with QuerySurge
Access and validate Microsoft Entra ID in QuerySurge using the CData JDBC Driver.
-
Use the CData API Server to Access Sage Intacct Data in Microsoft PowerPivot
Use the CData API Server to connect to live Sage Intacct in the Power Pivot business intelligence tool.
-
Integrate Live WordPress Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to WordPress and integrate live WordPress into apps built in Microsoft Power Apps.
-
Replicate SuiteCRM Data to Multiple Databases via the CData Sync CLI
Replicate SuiteCRM to disparate databases with a single configuration.
-
Visualize Unbounce Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Unbounce.
-
Access SpaceX Data from MySQL in PHP
Connect to SpaceX through the standard MySQL libraries in PHP.
-
How to connect and process Calendly from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Calendly.
-
Query MYOB AccountRight Data through ODBC in Node.js
Use node-odbc to execute SQL queries against MYOB AccountRight from Node.js.
-
Use the CData Software ODBC Driver for Dynamics CRM in MicroStrategy
Connect to Microsoft Dynamics CRM in MicroStrategy Developer using the CData Software ODBC Driver for Dynamics CRM.
-
Integrate Live Salesforce Marketing Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Salesforce Marketing Cloud to Blue Prism using the CData ODBC Driver for Salesforce Marketing to create automated workflows for repetitive business tasks.
-
Working with Microsoft Exchange Data in LINQPad
Execute LINQ queries to Microsoft Exchange in LINQPad.
-
Moving Data from AfterShip to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live AfterShip data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Model, Search, and Visualize Live EnterpriseDB Data in ThoughtSpot
Use CData Connect AI to connect to live EnterpriseDB for modeling, searching, and visualizing.
-
Use CData Connect AI to Access Oracle Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle Database in the Power Pivot business intelligence tool.
-
Use the CData ODBC Driver for Stack Exchange in Microsoft Power Query
You can use the CData Stack Exchange ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Stack Exchange into Microsoft Power Query.
-
Access Live Neo4J Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Neo4J through MCP integration.
-
Automated Continuous Humanity Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Humanity replication to AlloyDB.
-
Analyze Dynamics CRM Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Dynamics CRM and visualize Microsoft Dynamics CRM in SAP Analytics Cloud.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Miro
Provide connectivity to Miro through an SAP BusinessObjects universe.
-
Query Live Microsoft Planner Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Microsoft Planner directly from the development environment.
-
Connect to Oracle Sales Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating Kiro CLI with Float 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 Sage Cloud Accounting Accounts
Replicate multiple Sage Cloud Accounting accounts to one or many databases.
-
Build Campaigner-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Campaigner and build web apps with connectivity to live Campaigner.
-
Easily Integrate Landbot Data in Lazarus Pascal IDE
Learn how to easily integrate live Landbot in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Cassandra with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Cassandra with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apache Cassandra.
-
Visualize ClickUp Data in TIBCO Spotfire through ADO.NET
Integrate ClickUp into dashboards in TIBCO Spotfire.
-
Access Ontraport Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Ontraport from HeidiSQL.
-
Integrate with live Sybase Data in Jitterbit
Use CData Connect AI to connect to and integrate live Sybase in Jitterbit.
-
Integrate IBM Cloud Object Storage Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to IBM Cloud Object Storage and integrate live IBM Cloud Object Storage into your Power Automate tasks.
-
Automated Continuous QuickBooks Time Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to delimited files (CSV/TSV).
-
Visualize ADP Data in Sisense
Create an ElastiCube in Sisense app with access to ADP.
-
Extract, Transform, and Load Okta Data in Informatica PowerCenter
Create a simple Workflow for Okta in Informatica PowerCenter.
-
How to Build an ETL App for Microsoft Teams Data in Python with CData Connect AI
Build ETL pipelines that read and write live Microsoft Teams in Python with petl and the CData Connect AI Python SDK.
-
Migrating data from ShipStation to Google BigQuery using CData SSIS Components.
Easily push ShipStation to Google BigQuery using the CData SSIS Tasks for ShipStation and Google BigQuery.
-
Bind Live LinkedIn Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live LinkedIn data
-
How to Query Sybase IQ Data in MySQL Workbench
Execute MySQL queries against live Sybase IQ from MySQL Workbench.
-
Build Dashboards with REST Data in Dundas BI
Create dynamic dashboards and perform analytics based on REST in Dundas BI.
-
Integrate Marketo with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Marketo with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Marketo.
-
Access Live Snapchat Ads Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Snapchat Ads through MCP integration.
-
Connect to Paymo Data in DBeaver
Use the CData ODBC Driver to connect to Paymo in DBeaver.
-
Access Live BambooHR Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate BambooHR into the statistical analysis tools available in SAS JMP. This article shows how to use BambooHR in the Graph Builder and Query Builder.
-
Extract, Transform, and Load GitHub Data in Informatica PowerCenter
Create a simple Workflow for GitHub in Informatica PowerCenter.
-
How to create Visio diagrams from BigCommerce Data
Automatically update BigCommerce with the changes you make to Visio master shapes.
-
Build MVC Applications with Connectivity to Eventbrite Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Eventbrite from an ASP.NET MVC application.
-
Access Live ShipEngine Data in Coginiti Pro
Connect to and query live ShipEngine from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build AI/ML Models with Live Facebook Data using Dataiku
Connect Facebook Data with Dataiku using the CData JDBC Driver for Facebook.
-
Process & Analyze Suadeo Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Suadeo Data.
-
Use JayDeBeApi to access CapsuleCRM Data in Python
Use standard Python scripting and the development environment of your choice to access live CapsuleCRM.
-
How to Connect to Live Stripe Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Stripe for you.
-
Replicate Multiple Tanda Accounts via the CData Sync CLI
Replicate multiple Tanda accounts to one or many databases.
-
Perform Batch Operations with Kintone Data in Apache NiFi
Connect to Kintone and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to MailChimp Data from PowerBuilder via ADO.NET
This article demonstrates how to access MailChimp from Appeon PowerBuilder using the CData ADO.NET Provider for MailChimp.
-
Migrating data from Calendly to Databricks using CData SSIS Components.
Easily push Calendly to Databricks using the CData SSIS Tasks for Calendly and Databricks.
-
How to create an RPA flow for Zoho Recruit Data in UiPath Studio
Use the Zoho Recruit ODBC Driver to create workflows that access real-time Zoho Recruit without any coding.
-
Write a Simple Go Application to work with Azure Synapse Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Synapse.
-
Build a Singer.io Tap for Zoho Inventory With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Zoho Inventory data using
-
Automated Continuous Timely Replication to SingleStore
Use CData Sync for automated, continuous, customizable Timely replication to SingleStore.