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
-
Viewing Exact Online in RAD Studio Data Explorer
How to view Exact Online in RAD Studio Data Explorer using the CData ODBC Driver for Exact Online.
-
Use the CData ODBC Driver for Dynamics GP in Microsoft Power Query
You can use the CData Dynamics GP ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Dynamics GP into Microsoft Power Query.
-
Automated Continuous Zoho Creator Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Amazon S3.
-
Build Azure DevOps-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Azure DevOps and build web apps with connectivity to live Azure DevOps.
-
Build MySQL-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to MySQL and build web apps with connectivity to live MySQL.
-
Access Live Printify in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for Printify to create a Printify source in TIBCO Data Virtualization Studio and gain access to live Printify from your TDV Server.
-
Analyze Microsoft OneDrive with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Microsoft OneDrive from Power Pivot. You will use the Table Import Wizard to load Microsoft OneDrive. You can visually build the import query or use any SQL supported by the driver.
-
Create Data Visualizations Based On ServiceNow in Mode
Use CData Connect Cloud to connect to ServiceNow from Mode and build visualizations using live
-
Build Visualizations of Live SharePoint Excel Services in Power BI (through CData Connect)
Use CData Connect to create a virtual database for SharePoint Excel Services and build custom reports in Power BI.
-
Automated Continuous SAP Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP replication to Google BigQuery.
-
How to connect to PostgreSQL in DBVisualizer
Integrate PostgreSQL with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live MariaDB in Google Sheets
Use CData Connect Cloud to gain access to live MariaDB from your Google Sheets.
-
Extract, Transform, and Load EnterpriseDB in Informatica PowerCenter
Create a simple Workflow for EnterpriseDB in Informatica PowerCenter.
-
Perform Batch Operations with Veeva in Apache NiFi
Connect to Veeva Vault and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Bing Search Results in Aqua Data Studio
Access Bing Search from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Apps with Live SAP Concur in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live SAP Concur into the Adalo platform and build custom mobile and web applications with real-time SAP Concur.
-
Create Data Visualizations in Cognos BI with Google Analytics
Access Google Analytics as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Excel from PowerBuilder
This article demonstrates how to access Microsoft Excel from Appeon PowerBuilder using the CData ADO.NET Provider for Excel.
-
Model Power BI XMLA Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Power BI XMLA, enabling the direct import of real-time Power BI XMLA.
-
Export Data from SQL Server to FTP through SSIS
Easily push SQL Server data to FTP using the CData SSIS Tasks for FTP.
-
How to connect to SurveyMonkey from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for SurveyMonkey and work with SurveyMonkey in Microsoft Excel on Mac OS X.
-
Automated Continuous Basecamp Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Basecamp replication to Amazon Redshift.
-
DataBind Controls to Azure DevOps in Delphi
DataBind to Azure DevOps in Delphi with standard data access components and controls.
-
How to Access Live Bitbucket in Power Automate Desktop via ODBC
The CData ODBC Driver for Bitbucket enables you to integrate Bitbucket into workflows built using Microsoft Power Automate Desktop.
-
How to publish and share ActiveCampaign dashboards with Tableau Server
The CData ODBC driver for ActiveCampaign enables you integrate ActiveCampaign into Tableau dashboards.
-
Automated Continuous SharePoint Replication to MySQL
Use CData Sync for automated, continuous, customizable SharePoint replication to MySQL.
-
Automated Continuous SAP Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP replication to AlloyDB.
-
Integrate Pipedrive in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Pipedrive from Informatica Cloud.
-
Build Amazon DynamoDB-Connected Apps in Bubble
Use CData Connect Cloud to create an OData feed for Amazon DynamoDB and create custom apps in Bubble.
-
Access Live Microsoft Planner in Excel 365 Online (Excel for the web)
Connect to Microsoft Planner from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
Automate Dynamics 365 Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Dynamics 365 replication to Couchbase.
-
Access Microsoft OneDrive in PHP through Connect Server
Connect to Microsoft OneDrive through the standard SQL Server libraries in PHP.
-
Establish a Live Connection with Facebook using Tableau Bridge
The CData ODBC Driver for Facebook enables you to integrate live Facebook into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Amazon Athena in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous Coinbase Replication to SQLite
Use CData Sync for automated, continuous, customizable Coinbase replication to SQLite.
-
Connect to Oracle HCM Cloud in RapidMiner
Integrate Oracle HCM Cloud with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous ConstantContact Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ConstantContact replication to Google Cloud SQL.
-
Use Biml to Build SSIS Tasks to Replicate Microsoft OneDrive to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft OneDrive to SQL Server.
-
Operational Reporting on BigQuery from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google BigQuery.
-
Natively Connect to Avro in PHP
Create PHP applications on Linux/UNIX machines with connectivity to Apache Avro. Leverage the native support for ODBC in PHP.
-
Create Data Visualizations in Cognos BI with Kintone
Access Kintone as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Google Directory-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to Google Directory from Zoho Analytics and import live Google Directory.
-
Design BIRT Reports on MariaDB
Provide current MariaDB to your embedded analytics.
-
How to connect PolyBase to Harvest
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Harvest.
-
Visualize xBase in Sisense
Create an ElastiCube in Sisense app with access to xBase.
-
How to load Freshdesk data into Elasticsearch via Logstash
Introducing a simple method to load Freshdesk data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Rapidly Develop Google Data Catalog-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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Tally
Provide connectivity to Tally ERP through an SAP BusinessObjects universe.
-
Integrate with HDFS in JReport Designer
Create charts and reports based on Apache HDFS in JReport Designer.
-
Automated Continuous CSV Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable CSV replication to Microsoft Access.
-
Connect to Cassandra in Jaspersoft Studio
Execute SQL to remote Apache Cassandra in Jaspersoft Studio.
-
Automate eBay Replication to Azure Data Lake
Use CData Sync to customize and automate eBay replication to Azure Data Lake.
-
Load CouchDB to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apache CouchDB to a database.
-
Connect to Zendesk in RapidMiner
Integrate Zendesk with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Access Live Microsoft Project in Power Automate Desktop via ODBC
The CData ODBC Driver for Microsoft Project enables you to integrate Microsoft Project into workflows built using Microsoft Power Automate Desktop.
-
Deploy the ADO.NET Provider for Harvest on an SSRS Report Server
Connect to Harvest 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.
-
DataBind Wijmo Grid to Printful
Provide real-time Printful to interactive controls.
-
Publish Crystal Reports on Microsoft OneDrive
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft OneDrive.
-
Automate MailChimp Replication to SAP HANA
Use CData Sync to customize and automate MailChimp replication to SAP HANA.
-
Work with Live Zoho CRM in Power Query
Use CData Connect Cloud to connect to Zoho CRM and work with live Zoho CRM in Microsoft Power Query.
-
Explore Geographical Relationships in Microsoft OneDrive with Power Map
Create data visualizations with Microsoft OneDrive in Power Map.
-
Build Dashboards with TigerGraph in DBxtra
Create dynamic dashboards and perform analytics based on TigerGraph in DBxtra.
-
Import Google Spanner into FileMaker Pro
Create reports that integrate Google Spanner in Filemaker Pro.
-
Use the CData ODBC Driver for Zoho Projects in SAS JMP
You can use the CData ODBC Driver to integrate Zoho Projects into the statistical analysis tools available in SAS JMP. This article shows how to use Zoho Projects in the Graph Builder and Query Builder.
-
Automated Continuous Phoenix Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Phoenix replication to IBM DB2.
-
Bridge Google Data Catalog Connectivity with Apache NiFi
Access and process Google Data Catalog in Apache NiFi using the CData JDBC Driver.
-
Connect to Phoenix in SpagoBI
Create reports featuring live Apache Phoenix in SpagoBI Studio. Host Phoenix reports on SpagoBI Server.
-
Author and Share Power BI Reports on Real-Time GitHub
Use the CData ODBC Driver for GitHub to visualize GitHub in Power BI Desktop and then upload to the Power BI service.
-
Analyze Azure Analysis Services in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of Azure Analysis Services and visualize live Azure Analysis Services in Infragistics Reveal.
-
Create Data Visualizations Based On Adobe Analytics in Mode
Use CData Connect Cloud to connect to Adobe Analytics from Mode and build visualizations using live
-
Build Google Ads-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for Google Ads and create custom apps in Mendix.
-
Integrate Instagram in the Pentaho Report Designer
Publish reports based on Instagram in the Pentaho BI tool.
-
Automated Continuous SAP BusinessObjects BI Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Amazon S3.
-
Operational Reporting on Excel Online from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Excel Online.
-
Integrate Live Oracle Sales into Custom Business Apps Built in Power Apps
Use CData Connect Cloud to connect to Oracle Sales and integrate live Oracle Sales into apps built in Microsoft Power Apps.
-
Connect to Dynamics 365 in Google Apps Script
Use the ODBC Driver for Dynamics 365 and the SQL Gateway to access Microsoft Dynamics 365 from Google Apps Script.
-
Access Aha from MySQL in PHP
Connect to Aha through the standard MySQL libraries in PHP.
-
A PostgreSQL Interface for Zoom
Use the Remoting features of the Zoom ODBC Driver to create a PostgreSQL entry-point for data access.
-
Object-Relational Mapping (ORM) with HarperDB 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 HarperDB into a Java-based ORM framework, Hibernate.
-
How to create an RPA flow for SQL Server in UiPath Studio
Use the SQL Server ODBC Driver to create workflows that access real-time Microsoft SQL Server without any coding.
-
Build Redis-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Redis.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
LINQ to Oracle Eloqua
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Oracle Eloqua Data Provider.
-
Object-Relational Mapping (ORM) with Microsoft OneDrive 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 Microsoft OneDrive into a Java-based ORM framework, Hibernate.
-
Visualize Azure Active Directory in TIBCO Spotfire through OData
Integrate Azure Active Directory into dashboards in TIBCO Spotfire.
-
Extract, Transform, and Load Dynamics 365 Business Central in Informatica PowerCenter
Create a simple Workflow for Dynamics 365 Business Central in Informatica PowerCenter.
-
Automated Continuous Dynamics GP Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Dynamics GP replication to PostgreSQL.
-
Connect to Microsoft Exchange from AWS Glue
Use CData Connect Cloud to gain access to live Microsoft Exchange from your AWS Glue jobs.
-
Analyze Snowflake in R
Create data visualizations and use high-performance statistical functions to analyze Snowflake in Microsoft R Open.
-
How to connect PolyBase to Amazon Athena
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Amazon Athena.
-
Automated Continuous EventBrite Replication to IBM DB2
Use CData Sync for automated, continuous, customizable EventBrite replication to IBM DB2.
-
Query Sybase IQ through ODBC in Node.js
Use node-odbc to execute SQL queries against Sybase IQ from Node.js.
-
Build Interactive Dashboards from HBase in Amazon QuickSight
Create a virtual SQL Server database for Apache HBase in CData Software Connect Server and import Apache HBase into Amazon QuickSight SPICE to build interactive dashboards.
-
DataBind Controls to TaxJar in Delphi
DataBind to TaxJar in Delphi with standard data access components and controls.
-
Access Live Azure Active Directory in Coginiti Pro
Connect to and query live Azure Active Directory from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze Twilio in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of Twilio and visualize live Twilio in Infragistics Reveal.
-
Create Apps from Salesforce Marketing in Qlik Sense Cloud
Use CData Connect Cloud to connect to Salesforce Marketing and build apps from live Salesforce Marketing Cloud in Qlik Sense Cloud.
-
Connect to Slack from Crystal Reports
Use CData Connect Cloud to connect to and report on live Slack from Crystal Reports.
-
Replicate Monday.com for Use in Salesforce Connect
Replicate Monday.com to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Bing Ads from Asprova with CData Software ODBC Driver for Bing Ads
This article shows how to connect faster to Bing Ads data from Asprova.