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
-
How to create Visio diagrams from Office 365
Automatically update Microsoft Office 365 with the changes you make to Visio master shapes.
-
Create Splunk Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Use CData Connect to Access Live Avro in Power Automate
CData Connect for Avro enables you to integrate Apache Avro into workflows built using Microsoft Power Automate Desktop.
-
Access Twilio in PHP through Connect Server
Connect to Twilio through the standard SQL Server libraries in PHP.
-
A PostgreSQL Interface for Google Sheets
Use the Remoting features of the Google Sheets JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize SAP in Tableau
The CData ODBC driver for SAP enables you integrate SAP ERP/NetWeaver into Tableau dashboards.
-
Build Apps with Live Exact Online in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live Exact Online into the Adalo platform and build custom mobile and web applications with real-time Exact Online.
-
Replicate Twitter Ads for Use in Salesforce Connect
Replicate Twitter Ads to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
DataBind Wijmo Grid to Sybase IQ
Provide real-time Sybase IQ to interactive controls.
-
Automated Continuous JSON Replication to AlloyDB
Use CData Sync for automated, continuous, customizable JSON replication to AlloyDB.
-
DataBind Trello to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Trello with the DevExpress Windows Forms and Web controls to provide Trello to a chart.
-
Connect to and Query Klipfolio in QlikView over ODBC
Create data visualizations with Klipfolio in QlikView.
-
Integrate Zoho Inventory with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zoho Inventory with External Services.
-
Access IBM Cloud Data Engine from MySQL in PHP
Connect to IBM Cloud Data Engine through the standard MySQL libraries in PHP.
-
Integrate with SAP Hybris C4C in JReport Designer
Create charts and reports based on SAP Hybris C4C in JReport Designer.
-
Create Dynamic Zoho CRM Grids Using the Infragistics XamDataGrid
Learn how you can connect Zoho CRM to Infragistics XamDataGrid to build dynamic grids.
-
Access Live Excel Online in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Excel Online in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate with Active Directory in JReport Designer
Create charts and reports based on Active Directory in JReport Designer.
-
Object-Relational Mapping (ORM) with Google Calendar 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 Google Calendar into a Java-based ORM framework, Hibernate.
-
Automated Continuous YouTube Analytics Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Google Cloud SQL.
-
How to Connect the Power BI Service to JotForm: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Replicate Multiple Odoo Accounts
Replicate multiple Odoo accounts to one or many databases.
-
Connect to Google Drive in CloverDX (formerly CloverETL)
Transfer Google Drive using the visual workflow in the CloverDX data integration tool.
-
Connect to and Visualize Live FTP in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live FTP Servers.
-
A PostgreSQL Interface for Microsoft Planner
Use the Remoting features of the Microsoft Planner ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Spark Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Spark replication to Google BigQuery.
-
Replicate CSV to Multiple Databases
Replicate CSV/TSV Files to disparate databases with a point-and-click configuration.
-
Connect to Microsoft Exchange in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Publish SQL Analysis Services-Connected Dashboards in Tableau Server
Use CData JDBC drivers and Tableau Server to visualize live SQL Analysis Services.
-
Query Monday.com through ODBC in Node.js
Use node-odbc to execute SQL queries against Monday.com from Node.js.
-
Load Zenefits to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zenefits to a database.
-
Connect to Live LinkedIn in PostGresSQL Interface through CData Connect Cloud
Create a live connection to LinkedIn in CData Connect Cloud and connect to your LinkedIn from PostgreSQL.
-
Create REST-Connected Nintex Workflows
Use CData Software Connect Server to connect to REST from Nintex Workflow Cloud and build custom workflows using live REST.
-
Build Sugar CRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sugar CRM.
-
DataBind Controls to Aha in C++Builder
DataBind to Aha! in C++Builder with standard components and controls.
-
Connect to SAP Concur in RapidMiner
Integrate SAP Concur with standard components and data source configuration wizards in RapidMiner Studio.
-
How to load Paylocity data into Elasticsearch via Logstash
Introducing a simple method to load Paylocity data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect to Clio from Google Apps Script
Use CData Software Connect Server to access Clio in Google Apps Script.
-
Automated Continuous Sugar CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Amazon Redshift.
-
Replicate Sage 300 from PowerShell
Write a quick PowerShell script to query Sage 300. Use connectivity to the live data to replicate Sage 300 to SQL Server.
-
Publish Klaviyo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Klaviyo.
-
Access Highrise as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Highrise CRM from your Oracle system.
-
Integrate with Live Smartsheet in MuleSoft (via CData Connect Cloud)
Use CData Connect Cloud to connect to Smartsheet from the MuleSoft Anypoint Platform to integrate live Smartsheet into custom reports and dashboards.
-
Integrate Live Amazon S3 into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to Amazon S3 from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Amazon S3.
-
How to Connect to & Open GitHub in Microsoft Excel
This article uses the CData ODBC driver for GitHub to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use CData Connect Cloud to Access Monday.com in Microsoft Power Pivot
Use CData Connect Cloud to connect to live Monday.com in the Power Pivot business intelligence tool.
-
Access Authorize.Net from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Authorize.Net from HeidiSQL.
-
Connect to Quickbase from PowerBuilder
This article demonstrates how to access Quickbase from Appeon PowerBuilder using the CData ADO.NET Provider for Quickbase.
-
Connect to Amazon S3 from a Connection Pool in Jetty
The Amazon S3 JDBC Driver supports connection pooling: This article shows how to connect faster to Amazon S3 from Web apps in Jetty.
-
Connect to Databricks in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous MYOB AccountRight Replication to SQLite
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to SQLite.
-
Connect to SAP HANA XS Advanced from a Connection Pool in JBoss
Integrate SAP HANA XS Advanced into Java servlets: Use the Management Console in JBoss to install the SAP HANA XS Advanced JDBC Driver.
-
Visualize Live SAP Netweaver Gateway in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Netweaver Gateway.
-
Query Reckon Accounts Hosted in DataGrip
Create a Data Source for Reckon Accounts Hosted in DataGrip and use SQL to query live Reckon Accounts Hosted.
-
Use the CData Software JDBC Driver for Xero in MicroStrategy
Connect to Xero Accounting in MicroStrategy Developer using the CData Software JDBC Driver for Xero.
-
Rapidly Develop Presto-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.
-
Automated Continuous Oracle Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Oracle replication to Microsoft Access.
-
Use the CData ODBC Driver for MongoDB in SAS JMP
You can use the CData ODBC Driver to integrate MongoDB into the statistical analysis tools available in SAS JMP. This article shows how to use MongoDB in the Graph Builder and Query Builder.
-
How to load SurveyMonkey data into Elasticsearch via Logstash
Introducing a simple method to load SurveyMonkey data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Publish SharePoint Excel Services-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SharePoint Excel Services.
-
How to connect PolyBase to Calendly
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Calendly.
-
Extract, Transform, and Load ShipStation in Informatica PowerCenter
Create a simple Workflow for ShipStation in Informatica PowerCenter.
-
Connect to and Visualize Live Square in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Square.
-
Connect to and Query Monday.com in QlikView over ODBC
Create data visualizations with Monday.com in QlikView.
-
Operational Reporting on Redis from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Redis.
-
Use the Connect Server to Access Reckon Accounts Hosted in Microsoft Power Pivot
Use the Connect Server to connect to live Reckon Accounts Hosted in the Power Pivot business intelligence tool.
-
Replicate Dynamics CRM to Multiple Databases
Replicate Microsoft Dynamics CRM to disparate databases with a point-and-click configuration.
-
Extract, Transform, and Load Cassandra in Informatica PowerCenter
Create a simple Workflow for Apache Cassandra in Informatica PowerCenter.
-
Automated Continuous Shippo Replication to SQLite
Use CData Sync for automated, continuous, customizable Shippo replication to SQLite.
-
Build Pipelines with Live Hive in Google Cloud Data Fusion (via CData Connect Cloud)
Use CData Connect Cloud to connect to Hive from Google Cloud Data Fusion, enabling the integration of live Apache Hive into the building and management of effective data pipelines.
-
Create Square Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Dynamics 365 Business Central Replication to MySQL
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to MySQL.
-
Automated Continuous IBM Informix Replication to MySQL
Use CData Sync for automated, continuous, customizable IBM Informix replication to MySQL.
-
How to Access Live Quickbase in Power Automate Desktop via ODBC
The CData ODBC Driver for Quickbase enables you to integrate Quickbase into workflows built using Microsoft Power Automate Desktop.
-
Bidirectional Access to Gmail from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Gmail in Filemaker Pro for Mac or Windows.
-
Connect to Amazon S3 in Google Apps Script
Use CData Connect Cloud to access Amazon S3 in Google Apps Script.
-
Use the CData Software ODBC Driver for Azure Active Directory in MicroStrategy Web
Connect to Azure Active Directory in MicroStrategy Web using the CData Software ODBC Driver for Azure Active Directory.
-
Process & Analyze LinkedIn in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live LinkedIn .
-
Query Slack in ColdFusion
Write standard ColdFusion data access code to connect to Slack.
-
Build MailChimp-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for MailChimp and create custom apps in Mendix.
-
How to integrate Metabase with MailChimp
Use CData Connect Cloud to connect to live MailChimp and create an interactive dashboard in Metabase from MailChimp.
-
Integrate Live Dynamics 365 Business Central into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to Dynamics 365 Business Central from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Dynamics 365 Business Central.
-
Analyze SQL Analysis Services with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SQL Analysis Services from Power Pivot. You will use the Table Import Wizard to load SQL Analysis Services. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Real-Time Access to Facebook Ads in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Facebook Ads in real time.
-
Query OneNote as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft OneNote from Node.js.
-
Create Apps from WooCommerce in Qlik Sense Cloud
Use CData Connect Cloud to connect to WooCommerce and build apps from live WooCommerce in Qlik Sense Cloud.
-
Connect to Greenhouse in RazorSQL
Connect to Greenhouse from wizards and query Greenhouse from the GUI in the RazorSQL database management tool.
-
Analyze Snowflake with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Snowflake from Power Pivot. You will use the Table Import Wizard to load Snowflake. You can visually build the import query or use any SQL supported by the driver.
-
Query Freshdesk in DataGrip
Create a Data Source for Freshdesk in DataGrip and use SQL to query live Freshdesk.
-
Connect to SAP HANA from a Connection Pool in JBoss
Integrate SAP HANA into Java servlets: Use the Management Console in JBoss to install the SAP HANA JDBC Driver.
-
Enable the Exact Online JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Exact Online.
-
Connect to RSS Feeds in Google Apps Script
Use the ODBC Driver for RSS and the SQL Gateway to access RSS Feeds from Google Apps Script.
-
Connect to xBase from a Connection Pool in Jetty
The xBase JDBC Driver supports connection pooling: This article shows how to connect faster to xBase from Web apps in Jetty.
-
Automated Continuous Aha Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Aha replication to Apache Kafka.
-
How to integrate ConstantContact with Apache Airflow
Access and process ConstantContact in Apache Airflow using the CData JDBC Driver.
-
Integrate with Cvent in JReport Designer
Create charts and reports based on Cvent in JReport Designer.
-
Visualize Basecamp in TIBCO Spotfire through OData
Integrate Basecamp into dashboards in TIBCO Spotfire.
-
How to Connect DBeaver to EventBrite via a JDBC Driver
Manage Eventbrite with visual tools in DBeaver like the query browser.
-
How to load Bing Search data into Elasticsearch via Logstash
Introducing a simple method to load Bing Search data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
A PostgreSQL Interface for Amazon DynamoDB
Use the Remoting features of the Amazon DynamoDB JDBC Driver to create a PostgreSQL entry-point for data access.