CData Software - Knowledge Base
Recent Articles
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Elasticsearch to Power BI dashboards. Simply drag and drop Elasticsearch into data visuals on the Power BI canvas.
-
Connect PingOne to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PingOne using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Salesforce Pardot Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to PostgreSQL.
-
Natively Connect to Greenplum in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Pivotal GreenPlum. Leverage the native support for ODBC in PHP.
-
Connect to Printful in JRuby
Create a simple JRuby app with access to live Printful.
-
Create Informatica Mappings From/To a JDBC Data Source for Wave Financial
Create Wave Financial data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Connect to & Open Adobe Target in Microsoft Excel
This article uses the CData ODBC driver for Adobe Target to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Bridge Act-On Connectivity with Apache NiFi
Access and process Act-On in Apache NiFi using the CData JDBC Driver.
-
Creating Azure Table-Connected Applications in Unqork
You can use CData Connect AI to feed Azure Table Storage to Unqork and build custom business apps.
-
A PostgreSQL Interface for GraphQL (MySQL Remoting via JDBC)
Use the Remoting features of the GraphQL JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to WordPress in Google Apps Script via SQL Gateway
Use the ODBC Driver for WordPress and the SQL Gateway to access WordPress from Google Apps Script.
-
Integrate HCL Domino in Pentaho Data Integration
Build ETL pipelines based on HCL Domino in the Pentaho Data Integration tool.
-
Connect ADP to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ADP with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Drip from a Connection Pool in WebLogic
Use the CData JDBC Driver for Drip to connect to Drip from Web applications running on WebLogic.
-
Connect to Bullhorn CRM in the Denodo Platform
Use CData driver technologies to create a virtual data source for Bullhorn CRM in the Denodo Virtual DataPort Administrator.
-
Use the CData Software ODBC Driver for Impala in MicroStrategy Web
Connect to Apache Impala in MicroStrategy Web using the CData Software ODBC Driver for Impala.
-
Process & Analyze Avro in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Avro .
-
Automated Continuous Elasticsearch Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Apache Kafka.
-
Publish Pipedrive-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Pipedrive.
-
Query SAS xpt in DataGrip
Create a Data Source for SAS xpt in DataGrip and use SQL to query live SAS XPORT.
-
Building Dynamic Web Pages with Trello Using AngularJS
Create single-page applications with live connectivity to Trello using the CData API Server.
-
Visualize Live REST in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live REST.
-
Connect to Amazon Marketplace through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Amazon Marketplace using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Edit and Search Amazon Athena External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Amazon Athena to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Amazon Athena objects that you can access from apps and the dashboard.
-
How to Connect to & Open EnterpriseDB in Microsoft Excel
This article uses the CData ODBC driver for EnterpriseDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use Dash to Build to Web Apps on xBase
Create Python applications that use pandas and Dash to build xBase-connected web apps.
-
How to Connect to Live Oracle Financials Cloud in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Oracle Financials Cloud for you.
-
Import Real-Time Amazon Athena via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Amazon Athena in ColdFusion.
-
Visualize Shippo in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Shippo into TIBCO Spotfire.
-
Publish Reports with Aha in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Aha!.
-
Natively Connect to Sage Intacct in PHP
The CData ODBC driver for Sage Intacct enables you to create PHP applications with connectivity to Sage Intacct. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for Tally in MicroStrategy Web
Connect to Tally ERP in MicroStrategy Web using the CData Software ODBC Driver for Tally.
-
Build Automated ShipStation-Connected Workflows in Zapier
Use CData Connect AI to connect to live ShipStation and build automated workflows in Zapier.
-
How to publish and share PostgreSQL dashboards with Tableau Server
The CData ODBC driver for PostgreSQL enables you integrate PostgreSQL into Tableau dashboards.
-
DataBind Controls to HubSpot in Delphi
DataBind to HubSpot in Delphi with standard data access components and controls.
-
Import Instagram Using Azure Data Factory
Use CData Connect AI to connect to Instagram from Azure Data Factory and import live Instagram.
-
Automated Continuous Microsoft Teams Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to AlloyDB.
-
Access Live SurveyMonkey in Coginiti Pro
Connect to and query live SurveyMonkey from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Couchbase from PowerBuilder via ADO.NET
This article demonstrates how to access Couchbase from Appeon PowerBuilder using the CData ADO.NET Provider for Couchbase.
-
Replicate Multiple PayPal Accounts
Replicate multiple PayPal accounts to one or many databases.
-
Use the CData Software JDBC Driver for Azure Active Directory in MicroStrategy
Connect to Azure Active Directory in MicroStrategy Developer using the CData Software JDBC Driver for Azure Active Directory.
-
ETL Bullhorn CRM in Oracle Data Integrator
This article shows how to transfer Bullhorn CRM into a data warehouse using Oracle Data Integrator.
-
How to publish and share Square dashboards with Tableau Server
The CData ODBC driver for Square enables you integrate Square into Tableau dashboards.
-
Automated Continuous Microsoft Planner Replication to Vertica
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Vertica.
-
Viewing Tableau CRM Analytics in RAD Studio Data Explorer
How to view Tableau CRM Analytics in RAD Studio Data Explorer using the CData ODBC Driver for Tableau CRM Analytics.
-
Rapidly Develop Google Spanner-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Connect to Live Azure Data Lake Storage in PostGresSQL Interface through CData Connect AI
Create a live connection to Azure Data Lake Storage in CData Connect AI and connect to your Azure Data Lake Storage from PostgreSQL.
-
Automate Zendesk Replication to Couchbase
Use CData Sync to Customize and automate Zendesk replication to Couchbase.
-
Create Zoho Projects-Connected Dashboards in Grafana
Connect to Zoho Projects via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zoho Projects.
-
Integrate SFTP with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SFTP with External Services.
-
Access Live Facebook Ads in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Facebook Ads from your Excel spreadsheets.
-
Connect to HubDB as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for HubDB.
-
How to integrate Quickbase with Apache Airflow
Access and process Quickbase in Apache Airflow using the CData JDBC Driver.
-
Access Live Sage 300 in TIBCO Data Virtualization
-