CData Software - Knowledge Base
Recent Articles
-
Import Impala Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache Impala. In this article, you will use the OData format to import Apache Impala into Microsoft Power Query.
-
Connect to Parquet Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Parquet and the SQL Gateway to access Apache Parquet from Google Apps Script.
-
Automated Continuous SAP Business One Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Business One replication to Snowflake.
-
Use ChatGPT to Talk to Your Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Snapchat Ads for you.
-
How to Query Live ConstantContact Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ConstantContact data in natural language using Python.
-
Getting Started with the CData Power BI Connector for Facebook Ads
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Facebook Ads.
-
Automated Continuous Helpscout Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Helpscout replication to delimited files (CSV/TSV).
-
Analyze Live Oracle Eloqua Data in SAS Viya
Use CData Connect AI to connect to Oracle Eloqua from SAS Viya and deploy self-service analytics using live Oracle Eloqua.
-
View Reports on Real-Time Shortcut Data in Power BI Report Server
Use the CData ODBC Driver for Shortcut to visualize Shortcut in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Active Directory Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Active Directory and the Script function in FileMaker Pro to connect to Active Directory and work with Active Directory in your FileMaker application.
-
Integrating Dataiku with Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Asana.
-
Model, Search, and Visualize Live SAP BusinessObjects BI Data in ThoughtSpot
Use CData Connect AI to connect to live SAP BusinessObjects BI for modeling, searching, and visualizing.
-
Create ActiveCampaign-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ActiveCampaign Data from Klipfolio and build custom visualizations using live ActiveCampaign.
-
Connect and Query Live eBay Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live eBay into Databricks
-
How to connect and process Facebook from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Facebook.
-
Connect Recurly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Recurly with IBM WebSphere for seamless data integration and connectivity.
-
How to use SQLAlchemy ORM to access Neo4J Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Neo4J.
-
Provide OData Services of Front Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Front by developing a WCF Service Application.
-
Moving Data from BenchmarkEmail to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live BenchmarkEmail data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Write a Simple Go Application to work with Cosmos DB Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Cosmos DB.
-
How to Visualize GitLab Data in Python with pandas
Use pandas and other modules to analyze and visualize live GitLab in Python.
-
How to connect to Apify Data with Squirrel SQL client
Connect to Apify and execute queries in the Squirrel SQL Client.
-
Consume Google Drive OData Feeds in PowerBuilder
This article demonstrates how to consume Google Drive as OData feeds from PowerBuilder using the API Server.
-
Connect to Factorial Data in Jaspersoft Studio
Execute SQL to remote Factorial in Jaspersoft Studio.
-
Build a Singer.io Tap for SendPulse With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SendPulse data using
-
Create a Data Access Object for Delighted Data using JDBI
A brief overview of creating a SQL Object API for Delighted in JDBI.
-
Getting Started with the CData Excel Add-In for Freshservice
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Freshservice.
-
How to integrate PDFMonkey with Apache Airflow
Access and process PDFMonkey in Apache Airflow using the CData JDBC Driver.
-
Access Live Mocean Data in AWS Lambda
Connect to live Mocean in AWS Lambda using the CData JDBC Driver.
-
Query HCL Domino Data as a SQL Server Database in Node.js
Execute SQL Server queries against HCL Domino from Node.js.
-
Use the CData Software JDBC Driver for SageHR in MicroStrategy
Connect to SageHR in MicroStrategy Developer using the CData Software JDBC Driver for SageHR.
-
Use Manus AI to Talk to Your GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on GitHub.
-
Connecting Agentforce with OData Services via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your OData for you.
-
Getting Started with the CData ODBC Driver for Shippo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Shippo.
-
How to connect to Couchbase Data with Squirrel SQL client
Connect to Couchbase and execute queries in the Squirrel SQL Client.
-
How to connect to MongoDB Data with Squirrel SQL client
Connect to MongoDB and execute queries in the Squirrel SQL Client.
-
Replicate Basecamp Data in Heroku for Use in Salesforce Connect
Replicate Basecamp to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Redshift Data in JRuby
Create a simple JRuby app with access to live Amazon Redshift.
-
Manage Timely Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Timely.
-
How to Access Live Dynamics 365 Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Dynamics 365 enables you to integrate Microsoft Dynamics 365 into workflows built using Microsoft Power Automate Desktop.
-
Establish a Live Connection with Pingdom Data using Tableau Bridge
The CData ODBC Driver for Pingdom enables you to integrate live Pingdom into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to ZendeskSell Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to ZendeskSell and work with ZendeskSell in your FileMaker application.
-
How to connect to SAP BusinessObjects BI Data with Squirrel SQL client
Connect to SAP BusinessObjects BI and execute queries in the Squirrel SQL Client.
-
How to Query Mouseflow Data in MySQL Workbench
Execute MySQL queries against live Mouseflow from MySQL Workbench.
-
Access LinkedIn Data from MySQL in PHP
Connect to LinkedIn through the standard MySQL libraries in PHP.
-
Migrating data from ScrapingBee to Snowflake using CData SSIS Components.
Easily push ScrapingBee to Snowflake using the CData SSIS Tasks for ScrapingBee and Snowflake.
-
Build a Singer.io Tap for SAP Business One With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP Business One data using
-
Integrate Ontraport with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Ontraport with External Services.
-
Connect to Google Tasks Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Tasks using standard SQL.
-
Analyze Live SingleStore Data in SAS Viya
Use CData Connect AI to connect to SingleStore from SAS Viya and deploy self-service analytics using live SingleStore.
-
How to Visualize Harvest Data in Python with pandas
Use pandas and other modules to analyze and visualize live Harvest in Python.
-
Build QuickBooks Time-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for QuickBooks Time Data and create custom apps in Bubble.
-
Replicate Multiple Figshare Accounts via the CData Sync CLI
Replicate multiple Figshare accounts to one or many databases.
-
Use the CData ODBC Driver for BenchmarkEmail in Microsoft Power Query
You can use the CData BenchmarkEmail ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import BenchmarkEmail into Microsoft Power Query.
-
Connecting Agentforce with Okta Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Okta for you.
-
Configure the CData JDBC Driver for SAP Hybris C4C in a Connection Pool in Tomcat
Connect to SAP Hybris C4C from a connection pool in Tomcat.
-
Build Agents in Relevance AI with Access to Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP Business ByDesign within intelligent agent workflows.
-
Connect to QuickBooks Data in RapidMiner
Integrate QuickBooks Desktop with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Databricks Data in Jaspersoft Studio
Execute SQL to remote Databricks in Jaspersoft Studio.
-
Easily Integrate Zuora Data in Lazarus Pascal IDE
Learn how to easily integrate live Zuora in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Back Up Aha! to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Aha! data.
-
Access Azure Table Data from MySQL in PHP
Connect to Azure Table through the standard MySQL libraries in PHP.
-
Create AlloyDB-Connected Nintex Workflows
Use CData Connect AI to connect to AlloyDB Data from Nintex Workflow Cloud and build custom workflows using live Google AlloyDB.
-
Access Live Dropbox Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Dropbox data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrate Live Tanda Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Tanda to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Amazon DynamoDB Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Amazon DynamoDB from Filemaker Pro on Mac.
-
How to Connect DBeaver to Salesloft via a JDBC Driver
Manage Salesloft with visual tools in DBeaver like the query browser.
-
Query TaxJar Data in ColdFusion
Write standard ColdFusion data access code to connect to TaxJar.
-
Build AI Agents with Adobe Commerce 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 Adobe Commerce through CData Connect AI.
-
Query Suadeo Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Suadeo entities in PHP by modeling them as objects.
-
Explore Geographical Relationships in JotForm Data with Power Map
Create data visualizations with JotForm in Power Map.
-
Publish JotForm-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live JotForm.
-
Replicate Samanage Data to Multiple Databases
Replicate Samanage to disparate databases with a point-and-click configuration.
-
Replicate VWO Data in Heroku for Use in Salesforce Connect
Replicate VWO to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Publish PolarTeamPro-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live PolarTeamPro.
-
Connect to Moosend Data from a Connection Pool in Jetty
The Moosend JDBC Driver supports connection pooling: This article shows how to connect faster to Moosend from Web apps in Jetty.
-
How to Create Power BI Visual Reports with Real-Time Salesforce Data
Use CData Power BI Connectors to visualize Salesforce & Force.com in Power BI.
-
Using the CData Software ODBC Driver for Shortcut in PyCharm
Connect to Shortcut as an ODBC data source in PyCharm using the CData Software ODBC Driver for Shortcut.
-
Creating Avro-Connected Applications in Unqork
You can use CData Connect AI to feed Apache Avro to Unqork and build custom business apps.
-
Build an OLAP Cube in SSAS from OneNote Data
Establish a connection to Microsoft OneNote data from SQL Server Analysis Services, and use the OneNote Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Google Cloud Storage-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Cloud Storage Data from Klipfolio and build custom visualizations using live Google Cloud Storage.
-
Create Delighted Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Delighted data access from reports, embedded analytics, and more.
-
Working with Nethunt Data in LINQPad
Execute LINQ queries to Nethunt in LINQPad.
-
How to connect and process SAP Ariba Procurement from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP Ariba Procurement.
-
Connect to Avro Data from PowerBuilder via ADO.NET
This article demonstrates how to access Apache Avro from Appeon PowerBuilder using the CData ADO.NET Provider for Avro.
-
Connect to Snapchat Ads Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Snapchat Ads.
-
Integrate with Zoho CRM Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zoho CRM to a JSON file on disk.
-
Build API-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for API Data and create custom apps in Mendix.
-
Write a Simple Go Application to work with Outreach.io Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Outreach.io.
-
How to Visualize Elasticsearch Data in Python with pandas
Use pandas and other modules to analyze and visualize live Elasticsearch in Python.
-
Automated Continuous Datadog Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Datadog replication to Amazon S3.
-
Automated Continuous Printful Replication to Vertica
Use CData Sync for automated, continuous, customizable Printful replication to Vertica.
-
Connect to Microsoft Teams Data in JRuby
Create a simple JRuby app with access to live Microsoft Teams.
-
Integrating Pingdom Data in Talend Cloud Data Management Platform
Connect Pingdom Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to use SQLAlchemy ORM to access IBM Informix Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of IBM Informix.
-
Integrating Dataiku with FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live FTP Servers.
-
Connect to Browserless in SpagoBI
Create reports featuring live Browserless in SpagoBI Studio. Host Browserless reports on SpagoBI Server.
-
Operational Reporting on Box Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Box.
-
Access Live Act-On Data in TIBCO Data Virtualization
Use the Act-On Tibco DV Adapter to create a Act-On data source in TIBCO Data Virtualization Studio and gain access to live Act-On from your TDV Server.
-
How to connect to PingOne Data from IntelliJ
Integrate connectivity to PingOne with wizards in IntelliJ.