CData Software - Knowledge Base
Recent Articles
-
How to Connect to xBase in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to xBase. Leverage the pyodbc module for ODBC in Python.
-
Build Cloudant-Connected Apps in Choreo
Use CData Connect AI to connect to Cloudant from Choreo and build custom apps using live IBM Cloudant.
-
DataBind Controls to SurveyMonkey in C++Builder
DataBind to SurveyMonkey in C++Builder with standard components and controls.
-
Access Live Salesforce in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Salesforce & Force.com from your Excel spreadsheets.
-
Stream Calendly into Apache Kafka Topics
Access and stream Calendly in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Real-Time Access to Oracle Service Cloud in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle Service Cloud in real time.
-
Connect to QuickBooks Online in JRuby
Create a simple JRuby app with access to live QuickBooks Online.
-
Visualize SAP Ariba Source in TIBCO Spotfire through ADO.NET
Integrate SAP Ariba Source into dashboards in TIBCO Spotfire.
-
Connect to Pipedrive from a Connection Pool in Jetty
The Pipedrive JDBC Driver supports connection pooling: This article shows how to connect faster to Pipedrive from Web apps in Jetty.
-
ETL Oracle in Oracle Data Integrator
This article shows how to transfer Oracle Database into a data warehouse using Oracle Data Integrator.
-
Use the CData Software JDBC Driver for Oracle Sales in MicroStrategy
Connect to Oracle Sales in MicroStrategy Developer using the CData Software JDBC Driver for Oracle Sales.
-
Publish NetSuite-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live NetSuite CRM & ERP.
-
Enable the Phoenix JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Apache Phoenix.
-
Build Jira Assets-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Jira Assets and build web apps with connectivity to live Jira Assets.
-
Natively Connect to Redis in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Redis. Leverage the native support for ODBC in PHP.
-
Build WordPress-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for WordPress and create custom apps in Mendix.
-
Integrate Unbounce in Pentaho Data Integration
Build ETL pipelines based on Unbounce in the Pentaho Data Integration tool.
-
Host the API Server on Heroku
Host the CData API Servers in Heroku Cloud Application Platform.
-
Publish Crystal Reports on MailChimp
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MailChimp.
-
DataBind Controls to Harvest in Delphi
DataBind to Harvest in Delphi with standard data access components and controls.
-
How to create an RPA flow for SAP ByDesign in UiPath Studio
Use the SAP ByDesign ODBC Driver to create workflows that access real-time SAP Business ByDesign without any coding.
-
Integrate Zendesk with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Zendesk with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Zendesk.
-
Query Wave Financial in DataGrip
Create a Data Source for Wave Financial in DataGrip and use SQL to query live Wave Financial.
-
Create Reports with Azure DevOps in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure DevOps.
-
Create Data Visualizations Based On Trello in Mode
Use CData Connect AI to connect to Trello from Mode and build visualizations using live
-
Create NetSuite-Connected Business Apps in AppSheet
Connect to NetSuite via CData Connect AI in Google AppSheet and create custom business applications with real-time access to NetSuite CRM & ERP.
-
Integrating LangGraph with Microsoft Project via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Project within automated workflows.
-
Connect to Epicor Kinetic from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Epicor Kinetic from Filemaker Pro on Mac.
-
Import Instagram into the Power BI Service for Visualizations
Use CData Connect AI to connect to Instagram and provide access to live Instagram for custom reports in the Power BI Service.
-
Automated Continuous AlloyDB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable AlloyDB replication to Google Cloud SQL.
-
Connect to JSON Services from PowerBuilder via JDBC
This article demonstrates how to access JSON from PowerBuilder using the JSON JDBC Driver.
-
How to integrate Metabase with Greenplum
Use CData Connect AI to connect to live Pivotal GreenPlum and create an interactive dashboard in Metabase from Pivotal GreenPlum.
-
Publish Act-On-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Act-On.
-
Easily Integrate Sybase IQ in Lazarus Pascal IDE
Learn how to easily integrate live Sybase IQ in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Automated Workflows with Live Exact Online in Workato
Use CData Connect AI to connect to live Exact Online and build automated workflows in Workato.
-
Import and Visualize Google Ads in Power View
Create data visualizations based on Google Ads in Excel.
-
A PostgreSQL Interface for Salesloft (MySQL Remoting via JDBC)
Use the Remoting features of the Salesloft JDBC Driver to create a PostgreSQL entry-point for data access.
-
Validate SharePoint Excel Services with QuerySurge
Access and validate SharePoint Excel Services in QuerySurge using the CData JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Tally
Use CData Power BI Connectors to visualize Tally ERP in Power BI.
-
Process & Analyze SAP Concur in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Concur .
-
Access Live Cassandra in AWS Lambda (with IntelliJ IDEA)
Connect to live Apache Cassandra in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to HubSpot from AWS Glue
Use CData Connect AI to gain access to live HubSpot from your AWS Glue jobs.
-
Integrating LangGraph with Snapchat Ads via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Snapchat Ads within automated workflows.
-
Connect to Facebook Ads as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Facebook Ads.
-
Build Workday-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Workday from Zoho Analytics and import live Workday.
-
Build Sage 200-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Sage 200 and create custom apps in Mendix.
-
Connecting Mastra with Google Contacts via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.
-
Automate Instagram Replication to Couchbase
Use CData Sync to Customize and automate Instagram replication to Couchbase.
-
Integrating LangChain with Dynamics CRM via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft Dynamics CRM within automated workflows.
-
Access Live Email in AWS Lambda
Connect to live Email in AWS Lambda using the CData JDBC Driver.
-
Query Amazon Marketplace through ODBC in Node.js
Use node-odbc to execute SQL queries against Amazon Marketplace from Node.js.
-
Visualize Live Excel Online of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Excel Online using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect PolyBase to PostgreSQL
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PostgreSQL.
-
How to Design Avalara AvaTax Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Automate Redis Replication to Azure Data Lake
Use CData Sync to customize and automate Redis replication to Azure Data Lake.
-
Connect to Greenplum from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Pivotal GreenPlum, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Zendesk Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Zendesk replication to Google Cloud SQL.
-
Automated Continuous Lakebase Replication to MySQL
Use CData Sync for automated, continuous, customizable Lakebase replication to MySQL.
-
Analyze WooCommerce in R via JDBC
Use standard R functions and the development environment of your choice to analyze WooCommerce with the CData JDBC Driver for WooCommerce.
-
How to Access Live xBase in Power Automate Desktop via ODBC
The CData ODBC Driver for xBase enables you to integrate xBase into workflows built using Microsoft Power Automate Desktop.
-
How to Visualize Sage Cloud Accounting Data in Python with pandas
Use pandas and other modules to analyze and visualize live Sage Business Cloud Accounting in Python.
-
Import Real-Time Phoenix via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Apache Phoenix in ColdFusion.
-
Build Data Flows from Facebook to SQL Server using SSIS
Easily back up Facebook to SQL Server using the SSIS components for Facebook.
-
Connect to Sybase from a Connection Pool in JBoss
Integrate Sybase into Java servlets: Use the Management Console in JBoss to install the Sybase JDBC Driver.
-
How to connect PolyBase to Zoom
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zoom.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dynamics 365 Business Central
Provide connectivity to Dynamics 365 Business Central through an SAP BusinessObjects universe.
-
Seamlessly Bring Cassandra into Retool Using CData Connect AI
Integrate Cassandra data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
A PostgreSQL Interface for CockroachDB (MySQL Remoting via JDBC)
Use the Remoting features of the CockroachDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build MVC Applications with Connectivity to Jira
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Jira from an ASP.NET MVC application.
-
Automated Continuous Google Ads Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Ads replication to Google BigQuery.
-
Replicate Multiple ShipStation Accounts
Replicate multiple ShipStation accounts to one or many databases.
-
Connect to Salesforce in Aqua Data Studio
Access Salesforce & Force.com from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData ODBC Driver for SAP Fieldglass from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP Fieldglass to connect to SAP Fieldglass from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Fieldglass in Excel.
-
Build Charts with Gmail in Clear Analytics
Create dynamic charts and perform analytics based on Gmail in Clear Analytics.
-
Add SAP Hybris C4C to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Hybris C4C with the Informatica Enterprise Data Catalog to classify and organize data.
-
DataBind Cosmos DB to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Cosmos DB with the DevExpress Windows Forms and Web controls to provide Azure Cosmos DB to a chart.
-
Access Live Dynamics CRM in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Dynamics CRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Data Visualizations Based On Greenplum in Mode
Use CData Connect AI to connect to Greenplum from Mode and build visualizations using live
-
Access Live Drip in AWS Lambda (with IntelliJ IDEA)
Connect to live Drip in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live JotForm Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live JotForm data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use the CData Software ODBC Driver for Salesforce Marketing in MicroStrategy Desktop
Connect to Salesforce Marketing Cloud in MicroStrategy Desktop using the CData Software ODBC Driver for Salesforce Marketing.
-
How to Visualize Workday Data in Python with pandas
Use pandas and other modules to analyze and visualize live Workday in Python.
-
How to Design Twilio Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Integrate Live Amazon DynamoDB into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Amazon DynamoDB and integrate live Amazon DynamoDB into apps built in Microsoft Power Apps.
-
Automated Continuous eBay Replication to Snowflake
Use CData Sync for automated, continuous, customizable eBay replication to Snowflake.
-
Getting Started with the CData ODBC Driver for Asana
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Asana.
-
Query Oracle HCM Cloud as a MySQL Database in Node.js
Execute MySQL queries against Oracle HCM Cloud from Node.js.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Analytics
Provide connectivity to Google Analytics through an SAP BusinessObjects universe.
-
Automated Continuous MarkLogic Replication to Snowflake
Use CData Sync for automated, continuous, customizable MarkLogic replication to Snowflake.
-
Connect to Blackbaud FE NXT from a Connection Pool in JBoss
Integrate Blackbaud FE NXT into Java servlets: Use the Management Console in JBoss to install the Blackbaud FE NXT JDBC Driver.
-
Integrating Gumloop with ServiceNow via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on ServiceNow within automated workflows.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
Automated Continuous Vault CRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Vault CRM replication to Apache Kafka.
-
Add Jira to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Jira with the Informatica Enterprise Data Catalog to classify and organize data.
-
Using the CData Software ODBC Driver for ADP in PyCharm
Connect to ADP as an ODBC data source in PyCharm using the CData Software ODBC Driver for ADP.
-
Creating Google Search-Connected Applications in Unqork
You can use CData Connect AI to feed Google Search to Unqork and build custom business apps.
-
View Reports on Real-Time Box in Power BI Report Server
Use the CData ODBC Driver for Box to visualize Box in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect to Active Directory in DBVisualizer
Integrate Active Directory with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Zoom in Pentaho Data Integration
Build ETL pipelines based on Zoom in the Pentaho Data Integration tool.
-
Integrating Sage 200 in Talend Cloud Data Management Platform
-