Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →CData Software - Knowledge Base
Recent Articles
-
Build Charts with Calendly in Clear Analytics
Create dynamic charts and perform analytics based on Calendly in Clear Analytics.
-
Connect to WordPress in DBArtisan
Use wizards in DBArtisan to configure WordPress as a data source.
-
Access CouchDB in PHP through Connect Server
Connect to CouchDB through the standard SQL Server libraries in PHP.
-
Model, Search, and Visualize Live BigCommerce in ThoughtSpot
Use CData Connect Cloud to connect to live BigCommerce for modeling, searching, and visualizing.
-
Dynamics 365 Business Central Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Dynamics 365 Business Central through CData Connect Cloud using different applications and tools.
-
Connect to Facebook Ads from Crystal Reports
Use CData Connect Cloud to connect to and report on live Facebook Ads from Crystal Reports.
-
Integrate with Elasticsearch in SnapLogic
Use CData Connect Cloud to connect to and integrate with live Elasticsearch in SnapLogic.
-
Visualize XML in Tableau Desktop (through CData Connect)
Create a virtual SQL Server database for XML Files in CData Software Connect (or Connect Server) and build visualizations from live XML Files in Tableau Desktop.
-
Connect to Monday.com as a Linked Server
Use the SQL Gateway and the ODBC Driver to set up a linked server for Monday.com.
-
Freshdesk Reporting in OBIEE with the Freshdesk JDBC Driver
Deploy the Freshdesk JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Spark in TIBCO Spotfire through ADO.NET
Integrate Apache Spark SQL into dashboards in TIBCO Spotfire.
-
Build Visualizations of Twitter Ads in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Twitter Ads in Birst.
-
Connect to Zoho Creator from a Connection Pool in WebLogic
Use the CData JDBC Driver for Zoho Creator to connect to Zoho Creator from Web applications running on WebLogic.
-
DataBind SFTP to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for SFTP with the DevExpress Windows Forms and Web controls to provide SFTP to a chart.
-
Integrate Real-Time Access to Zuora in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zuora in real time.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Analyze YouTube Analytics in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of YouTube Analytics and visualize live YouTube Analytics in Infragistics Reveal.
-
Import Slack into FileMaker Pro
Create reports that integrate Slack in Filemaker Pro.
-
How to connect to Oracle Sales with Squirrel SQL client
Connect to Oracle Sales and execute queries in the Squirrel SQL Client.
-
Use the CData ODBC Driver for Amazon Marketplace in Microsoft Power Query
You can use the CData Amazon Marketplace ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Amazon Marketplace into Microsoft Power Query.
-
Build Apps with Live Atlassian Jira Service Management in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live Atlassian Jira Service Management into the Adalo platform and build custom mobile and web applications with real-time Atlassian Jira Service Management.
-
Query Quickbase in DataGrip
Create a Data Source for Quickbase in DataGrip and use SQL to query live Quickbase.
-
DataBind Charts to Authorize.Net
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Authorize.Net from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build HDFS-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache HDFS.
-
Operational Reporting on YouTube Analytics from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote YouTube Analytics.
-
How to Create Power BI Visual Reports with Real-Time MailChimp
Use CData Power BI Connectors to visualize MailChimp in Power BI.
-
Use CData Connect Cloud to Access Excel Online in Microsoft Power Pivot
Use CData Connect Cloud to connect to live Microsoft Excel Online in the Power Pivot business intelligence tool.
-
Build Zoho Books-Connected Apps in Choreo
Use CData Connect Cloud to connect to Zoho Books from Choreo and build custom apps using live Zoho Books.
-
Connect to Zendesk from Asprova with CData Software ODBC Driver for Zendesk
This article shows how to connect faster to Zendesk data from Asprova.
-
Automated Continuous Workday Replication to SingleStore
Use CData Sync for automated, continuous, customizable Workday replication to SingleStore.
-
Enable the ClickUp JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ClickUp.
-
Automated Continuous Zoho Inventory Replication to Databricks
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Databricks.
-
Use the CData Software JDBC Driver for Google Sheets in MicroStrategy Web
Connect to Google Sheets in MicroStrategy Web using the CData Software JDBC Driver for Google Sheets.
-
How to Access Live JotForm in Power Automate Desktop via ODBC
The CData ODBC Driver for JotForm enables you to integrate JotForm into workflows built using Microsoft Power Automate Desktop.
-
DataBind Charts to Zoho CRM
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho CRM from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
DataBind Controls to BambooHR in Delphi
DataBind to BambooHR in Delphi with standard data access components and controls.
-
How to connect to IBM Cloud Data Engine with Squirrel SQL client
Connect to IBM Cloud Data Engine and execute queries in the Squirrel SQL Client.
-
Integrate HCL Domino in the Pentaho Report Designer
Publish reports based on HCL Domino in the Pentaho BI tool.
-
Deploy the ADO.NET Provider for EnterpriseDB on an SSRS Report Server
Connect to EnterpriseDB 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.
-
Automate Spark Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apache Spark SQL from PowerShell? This article demonstrates how to utilize the Spark Cmdlets for tasks like connecting to Apache Spark SQL, automating operations, downloading data, and more.
-
Integrate with MailChimp in SnapLogic
Use CData Connect Cloud to connect to and integrate with live MailChimp in SnapLogic.
-
Use the CData ODBC Driver for Raisers Edge NXT in Microsoft Power Query
You can use the CData Raisers Edge NXT ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Raisers Edge NXT into Microsoft Power Query.
-
Create Amazon DynamoDB-Connected Visualizations in Klipfolio
Use CData Connect Cloud to connect to Amazon DynamoDB from Klipfolio and build custom visualizations using live Amazon DynamoDB.
-
Build Amazon S3-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Amazon S3.
-
Build MVC Applications with Connectivity to RSS Feeds
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access RSS from an ASP.NET MVC application.
-
How to load Tableau CRM Analytics data into Elasticsearch via Logstash
Introducing a simple method to load Tableau CRM Analytics data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Analyze Jira Service Management in R
Create data visualizations and use high-performance statistical functions to analyze Atlassian Jira Service Management in Microsoft R Open.
-
Build Pipelines with Live MongoDB in Google Cloud Data Fusion (via CData Connect Cloud)
Use CData Connect Cloud to connect to MongoDB from Google Cloud Data Fusion, enabling the integration of live MongoDB into the building and management of effective data pipelines.
-
Publish Crystal Reports on FTP
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date FTP Servers.
-
Create Blackbaud FE NXT Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Blackbaud FE NXT data access from reports, embedded analytics, and more.
-
Extract, Transform, and Load Epicor Kinetic in Informatica PowerCenter
Create a simple Workflow for Epicor Kinetic in Informatica PowerCenter.
-
DataBind Controls to Phoenix in Delphi
DataBind to Apache Phoenix in Delphi with standard data access components and controls.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
How to Connect the Power BI Service to Coinbase: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Sybase
Provide connectivity to Sybase through an SAP BusinessObjects universe.
-
Publish Tableau CRM Analytics-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Tableau CRM Analytics.
-
How to Access Jira Service Management Using Entity Framework
This article shows how to access Atlassian Jira Service Management using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to work with Azure Analysis Services in Apache Spark using SQL
Access and process Azure Analysis Services in Apache Spark using the CData Software JDBC Driver.
-
Automate Reckon Replication to SAP HANA
Use CData Sync to customize and automate Reckon replication to SAP HANA.
-
Connect to ShipStation from a Connection Pool in JBoss
Integrate ShipStation into Java servlets: Use the Management Console in JBoss to install the ShipStation JDBC Driver.
-
Connect to Tableau CRM Analytics in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Load Amazon Marketplace to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Amazon Marketplace to a database.
-
How to connect to Oracle Financials Cloud from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Oracle Financials Cloud and work with Oracle Financials Cloud in Microsoft Excel on Mac OS X.
-
Connect to Bullhorn CRM through External Services in Salesforce
Use CData Connect Cloud to securely provide OData feeds of Bullhorn CRM to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Bullhorn CRM objects that you can access from apps and the dashboard.
-
Perform Batch Operations with SuiteCRM in Apache NiFi
Connect to SuiteCRM and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Zenefits in DBeaver
Use the CData ODBC Driver to connect to Zenefits in DBeaver.
-
Build Visualizations of Active Directory in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Active Directory in Birst.
-
Publish Reports with Outreach.io in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Outreach.io.
-
Use the CData Software ODBC Driver for Outreach.io in SAS for Real-Time Reporting and Analytics
Connect to real-time Outreach.io in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Outreach.io.
-
Use the CData ODBC Driver for QuickBooks Time in SAS JMP
You can use the CData ODBC Driver to integrate QuickBooks Time into the statistical analysis tools available in SAS JMP. This article shows how to use QuickBooks Time in the Graph Builder and Query Builder.
-
Visualize Dynamics GP from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Dynamics GP.
-
Query Redshift in ColdFusion
Write standard ColdFusion data access code to connect to Amazon Redshift.
-
Create SAP SuccessFactors-Connected Business Apps in AppSheet
Connect to SAP SuccessFactors via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to SAP SuccessFactors.
-
Create Asana Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Analyze Azure Analysis Services in Cognos Analytics
Use CData Connect Cloud to connect to Azure Analysis Services from Cognos Analytics and analyze live Azure Analysis Services.
-
Connect to Printify as a Linked Server
Use CData Connect to set up a linked server for Printify.
-
How to connect PolyBase to Adobe Commerce
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Adobe Commerce.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Publish Redis-Connected Dashboards in Tableau Server
Use CData JDBC drivers and Tableau Server to visualize live Redis.
-
Visualize Access from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Access.
-
Create SurveyMonkey-Connected Business Apps in AppSheet
Connect to SurveyMonkey via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to SurveyMonkey.
-
PowerShell Scripting to Replicate Square to MySQL
Write a simple PowerShell script to replicate Square to a MySQL database.
-
Integrate Tally in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Tally ERP from Informatica Cloud.
-
Automated Continuous REST Replication to Vertica
Use CData Sync for automated, continuous, customizable REST replication to Vertica.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dynamics GP
Provide connectivity to Microsoft Dynamics GP through an SAP BusinessObjects universe.
-
Connect to Cvent from PowerBuilder
This article demonstrates how to use the CData ODBC Driver for Cvent to connect to Cvent and execute queries in PowerBuilder.
-
Using AngularJS to Build Dynamic Web Pages with Invoiced
Use the CData Connect Server to create Invoiced OData feeds and build single-page applications with live Invoiced.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Analyze WooCommerce in Looker
Use CData Connect Cloud to connect to WooCommerce from Looker and build custom apps using live WooCommerce.
-
Automated Continuous Access Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Access replication to Google BigQuery.
-
How to Visualize SAP Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP ERP/NetWeaver in Python.
-
Connect to SAP Hybris C4C through External Services in Salesforce
Use CData Connect Cloud to securely provide OData feeds of SAP Hybris C4C to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP Hybris C4C objects that you can access from apps and the dashboard.
-
Visualize WooCommerce in TIBCO Spotfire through ADO.NET
Integrate WooCommerce into dashboards in TIBCO Spotfire.
-
Automated Continuous Parquet Replication to Oracle
Use CData Sync for automated, continuous, customizable Parquet replication to Oracle.
-
How to Build Dynamic React Apps with Aha
Use the CData Connect and React to Build Dynamic Web Apps with Live Aha .
-
Build Azure Data Lake Storage-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Azure Data Lake Storage.
-
Viewing Sybase in RAD Studio Data Explorer
How to view Sybase in RAD Studio Data Explorer using the CData ODBC Driver for Sybase.
-
How to connect PolyBase to Dynamics 365
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Dynamics 365.
-
Access Live Office 365 in Google Sheets
Use CData Connect Cloud to gain access to live Microsoft Office 365 from your Google Sheets.
-
Access Live Aha in AWS Lambda (with IntelliJ IDEA)
Connect to live Aha! in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.