CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Amazon Athena from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Amazon Athena for you.
-
How to connect to Kintone with Squirrel SQL client
Connect to Kintone and execute queries in the Squirrel SQL Client.
-
Connect to Dynamics 365 Business Central in RapidMiner
Integrate Dynamics 365 Business Central with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software ODBC Driver for DocuSign in MicroStrategy
Connect to DocuSign in MicroStrategy Developer using the CData Software ODBC Driver for DocuSign.
-
Integrate Freshdesk with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Freshdesk with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Freshdesk.
-
Create Sugar CRM-Connected Applications in Appsmith
Connect to Sugar CRM via CData Connect AI in Appsmith and create custom business applications with real-time access to Sugar CRM.
-
How to connect to Amazon Marketplace from IntelliJ
Integrate connectivity to Amazon Marketplace with wizards in IntelliJ.
-
Integrate HBase with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate HBase with External Services.
-
Query Azure DevOps using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Azure DevOps entities in PHP by modeling them as objects.
-
Connect to Google Calendar in RazorSQL
Connect to Google Calendar from wizards and query Google Calendar from the GUI in the RazorSQL database management tool.
-
Access Live Google Spanner in Excel 365 Online (Excel for the web)
Connect to Google Spanner from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Natively Connect to LDAP Objects in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to LDAP. Leverage the native support for ODBC in PHP.
-
How to Connect the Power BI Service to Sugar CRM: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Automated Continuous Calendly Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Calendly replication to delimited files (CSV/TSV).
-
Connect to Office 365 from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Office 365 to connect to Microsoft Office 365 and execute queries in PowerBuilder.
-
Build a Simple VCL Application for Salesforce Marketing
How to build a simple VCL Application to view Salesforce Marketing Cloud in RAD Studio using the CData ODBC Driver for Salesforce Marketing.
-
Integrate Cursor with Live Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Trello from within the editor.
-
Perform Batch Operations with Bing Ads in Apache NiFi
Connect to Bing Ads and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Live GitHub in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live GitHub from your Google Sheets.
-
Integrate with Live Quickbase in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Quickbase from the MuleSoft Anypoint Platform to integrate live Quickbase into custom reports and dashboards.
-
Query SuiteCRM through ODBC in Node.js
Use node-odbc to execute SQL queries against SuiteCRM from Node.js.
-
Connect to Parquet as an External Source in Dremio
Use the CData JDBC Driver to connect to Parquet as an External Source in Dremio.
-
Import SQL Analysis Services into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SQL Analysis Services. In this article, you will use the OData format to import SQL Analysis Services into Microsoft Power Query.
-
Bind Live Salesforce Pardot Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Salesforce Pardot data
-
Object-Relational Mapping (ORM) with PingOne 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 PingOne into a Java-based ORM framework, Hibernate.
-
Use Dash to Build to Web Apps on Aha
Create Python applications that use pandas and Dash to build Aha-connected web apps.
-
View Reports on Real-Time BigQuery in Power BI Report Server
Use the CData ODBC Driver for BigQuery to visualize Google BigQuery in Power BI Desktop and then publish them to Power BI Report Server.
-
ETL xBase in Oracle Data Integrator
This article shows how to transfer xBase into a data warehouse using Oracle Data Integrator.
-
Visualize HDFS in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Apache HDFS into TIBCO Spotfire.
-
Connect to Epicor Kinetic in DBArtisan
Use wizards in DBArtisan to configure Epicor Kinetic as a data source.
-
Create Data Visualizations in Cognos BI with CSV
Access CSV/TSV Files as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to connect to SQL Server with Squirrel SQL client
Connect to Microsoft SQL Server and execute queries in the Squirrel SQL Client.
-
Establish a Live Connection with Zuora using Tableau Bridge
The CData ODBC Driver for Zuora enables you to integrate live Zuora into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Work with SAP Business One in AWS Glue Jobs Using JDBC
Connect to SAP Business One from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to GitHub in SpagoBI
Create reports featuring live GitHub in SpagoBI Studio. Host GitHub reports on SpagoBI Server.
-
Visualize Slack in Tableau
The CData ODBC driver for Slack enables you integrate Slack into Tableau dashboards.
-
Import and Visualize MariaDB in Power View
Create data visualizations based on MariaDB in Excel.
-
How to create Unbounce federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Unbounce in MySQL .
-
Connect to LinkedIn in DBArtisan
Use wizards in DBArtisan to configure LinkedIn as a data source.
-
Create Azure Data Lake Storage-Connected Applications in Appsmith
Connect to Azure Data Lake Storage via CData Connect AI in Appsmith and create custom business applications with real-time access to Azure Data Lake Storage.
-
Connect Adobe Commerce to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Adobe Commerce with IBM WebSphere for seamless data integration and connectivity.
-
Consume Redis OData Feeds in PowerBuilder
This article demonstrates how to consume Redis as OData feeds from PowerBuilder using the API Server.
-
How to Work with Google Cloud Storage in ETL Validator JDBC
Connect to Google Cloud Storage from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Dynamics 365 Business Central in the Pentaho Report Designer
Publish reports based on Dynamics 365 Business Central in the Pentaho BI tool.
-
Choosing the Best Method to Connect Coinbase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Coinbase from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Greenhouse in Coginiti Pro
Connect to and query live Greenhouse from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect to Printify in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Printify. Leverage the pyodbc module for ODBC in Python.
-
Integrate Microsoft Dataverse in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Dataverse (CDS) from Informatica Cloud.
-
Query DB2 through ODBC in Node.js
Use node-odbc to execute SQL queries against IBM DB2 from Node.js.
-
Connect to PayPal from Asprova with CData Software ODBC Driver for PayPal
This article shows how to connect faster to PayPal data from Asprova.
-
How to Seamlessly Import Exact Online Data into IBM SPSS Modeler
Integrate Exact Online data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Slack in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Query BigCommerce through ODBC in Node.js
Use node-odbc to execute SQL queries against BigCommerce from Node.js.
-
Use Azure AI Foundry to Talk to Your SAP Business One via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SAP Business One for you.
-
Automated Continuous Google Spanner Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Spanner replication to Vertica.
-
Analyze Odoo in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Odoo ERP in Microsoft R Open.
-
How to Visualize Pipedrive Data in Python with pandas
Use pandas and other modules to analyze and visualize live Pipedrive in Python.
-
Deploy the ADO.NET Provider for Avalara AvaTax on an SSRS Report Server
Connect to Avalara AvaTax from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Excel Spreadsheet Automation on Authorize.Net with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Build an OLAP Cube in SSAS from xBase
Establish a connection to xBase data from SQL Server Analysis Services, and use the xBase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Migrating data from Twilio to Databricks using CData SSIS Components.
Easily push Twilio to Databricks using the CData SSIS Tasks for Twilio and Databricks.
-
Replicate Multiple SAP HANA Accounts via the CData Sync CLI
Replicate multiple SAP HANA accounts to one or many databases.
-
How to use SQLAlchemy ORM to access QuickBooks in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of QuickBooks Desktop.
-
Build a Simple VCL Application for Dynamics 365 Business Central
How to build a simple VCL Application to view Dynamics 365 Business Central in RAD Studio using the CData ODBC Driver for Dynamics 365 Business Central.
-
Connect to Reckon Accounts Hosted in ACL Analytics
Connect to Reckon Accounts Hosted via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Reckon Accounts Hosted.
-
Bidirectional Access to WordPress from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate WordPress in Filemaker Pro for Mac or Windows.
-
Integrate Zoho Projects into Automated Tasks with Power Automate
Use CData Connect AI to connect to Zoho Projects and integrate live Zoho Projects into your Power Automate tasks.
-
Visualize Zuora in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Zuora into TIBCO Spotfire.
-
Connect to Presto in JRuby
Create a simple JRuby app with access to live Presto.
-
How to Access Impala Using Entity Framework
This article shows how to access Apache Impala using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Visualize NetSuite in Tableau
The CData ODBC driver for NetSuite enables you integrate NetSuite CRM & ERP into Tableau dashboards.
-
Getting Started with the CData SSIS Components for Cosmos DB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Cosmos DB.
-
How to work with SAP ByDesign in Apache Spark using SQL
Access and process SAP ByDesign in Apache Spark using the CData Software JDBC Driver.
-
Connect to Salesforce Data Cloud in Jaspersoft Studio
Execute SQL to remote Salesforce Data Cloud in Jaspersoft Studio.
-
Connect to GraphQL in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to connect to Google Campaign Manager 360 in DBVisualizer
Integrate Google Campaign Manager 360 with visual data analysis tools and data connection wizards in DBVisualizer
-
Bind Live Smartsheet Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Smartsheet data
-
Analyze OneNote in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft OneNote and visualize live Microsoft OneNote in Infragistics Reveal.
-
Load SAP HANA XS Advanced to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP HANA XS Advanced to a database.
-
Automated Continuous JSON Replication to Snowflake
Use CData Sync for automated, continuous, customizable JSON replication to Snowflake.
-
How to Easily Query Sybase in OpenOffice Base
-