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
-
Automated Continuous MYOB AccountRight Replication to SingleStore
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to SingleStore.
-
Extract, Transform, and Load HubSpot in Informatica PowerCenter
Create a simple Workflow for HubSpot in Informatica PowerCenter.
-
Replicate Multiple MarkLogic Accounts
Replicate multiple MarkLogic accounts to one or many databases.
-
Build MVC Applications with Connectivity to Zoho Projects
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoho Projects from an ASP.NET MVC application.
-
Connect to Avalara AvaTax in RapidMiner
Integrate Avalara AvaTax with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Zuora from a Connection Pool in Jetty
The Zuora JDBC Driver supports connection pooling: This article shows how to connect faster to Zuora from Web apps in Jetty.
-
Use the CData ODBC Driver for Printful in Microsoft Power Query
You can use the CData Printful ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Printful into Microsoft Power Query.
-
Natively Connect to Microsoft Exchange in PHP
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Exchange. Leverage the native support for ODBC in PHP.
-
Build Automated Workflows with Live OneNote in Workato
Use CData Connect Cloud to connect to live Microsoft OneNote and build automated workflows in Workato.
-
Build Google Ads-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Google Ads.
-
Create Informatica Mappings From/To an ODBC Data Source for Pinterest
Create an ODBC connection to Pinterest in Informatica and browse and transfer Pinterest.
-
Connect to Freshdesk in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Freshdesk and connect to Freshdesk in Akorbi Digital RunMyProcess.
-
Connect to Dynamics CRM in HULFT Integrate
Connect to Dynamics CRM as a JDBC data source in HULFT Integrate
-
Feed SendGrid into FineReport
How to set SendGrid as a JDBC data source in FineReport.
-
Automated Continuous Quickbase Replication to SQL Server
Use CData Sync for automated, continuous, customizable Quickbase replication to SQL Server.
-
Build MVC Applications with Connectivity to Instagram
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Instagram from an ASP.NET MVC application.
-
DataBind Charts to IBM Informix
Use the standard ADO.NET procedures for databinding to provide bidirectional access to IBM Informix 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.
-
How to connect to Salesforce from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Salesforce and work with Salesforce & Force.com in Microsoft Excel on Mac OS X.
-
Connect to Acumatica from Asprova with CData Software ODBC Driver for Acumatica
This article shows how to connect faster to Acumatica data from Asprova.
-
Use JayDeBeApi to access Facebook in Python
Use standard Python scripting and the development environment of your choice to access live Facebook.
-
Rapidly Develop Azure 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.
-
Automated Continuous Avalara AvaTax Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Amazon Redshift.
-
Automate REST Replication to SAP HANA
Use CData Sync to customize and automate REST replication to SAP HANA.
-
Use the CData SSIS Components to Insert New or Update Existing Zoho CRM Records from SQL Server
Easily push SQL Server data to Zoho CRM using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Zoho CRM or update existing records with data from a SQL Server database.
-
Access Salesforce Data in QlikView Using the CData ODBC Driver for Salesforce
The CData ODBC drivers expand your ability to work with data from a wide variety of data sources. For example, you can use the ODBC drivers to create visualizations that organize and present your Salesforce data in QlikView. In this article we outline simple steps to use CData ODBC Drivers from QlikView.
-
Integrate with Oracle Financials Cloud in JReport Designer
Create charts and reports based on Oracle Financials Cloud in JReport Designer.
-
Import Zoho Creator into FileMaker Pro
Create reports that integrate Zoho Creator in Filemaker Pro.
-
Query MariaDB in ColdFusion
Write standard ColdFusion data access code to connect to MariaDB.
-
Connect to Google Cloud Storage in CloverDX (formerly CloverETL)
Transfer Google Cloud Storage using the visual workflow in the CloverDX data integration tool.
-
Operational Reporting on DocuSign from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote DocuSign.
-
Automated Continuous QuickBooks Time Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Microsoft Access.
-
How to Connect DBeaver to Azure Table via a JDBC Driver
Manage Azure Table Storage with visual tools in DBeaver like the query browser.
-
Replicate Airtable for Use in Salesforce Connect
Replicate Airtable to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect to Acumatica from Spring Boot
Connect to Acumatica in a Spring Boot Application using CData JDBC Acumatica Driver
-
Access Hive in PHP through Connect Server
Connect to Hive through the standard SQL Server libraries in PHP.
-
Establish a Live Connection with SAP using Tableau Bridge
The CData ODBC Driver for SAP enables you to integrate live SAP ERP/NetWeaver into Tableau Cloud dashboards using the Tableau Bridge.
-
GitHub Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to GitHub through CData Connect Cloud using different applications and tools.
-
How to connect to SharePoint from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for SharePoint and work with Microsoft SharePoint in Microsoft Excel on Mac OS X.
-
Enable the Act CRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Act CRM.
-
Bidirectional Access to Zenefits from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zenefits in Filemaker Pro for Mac or Windows.
-
Visualize SAP SuccessFactors in Tableau
The CData ODBC driver for SAP SuccessFactors enables you integrate SAP SuccessFactors into Tableau dashboards.
-
How to create JotForm federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for JotForm in MySQL .
-
How to update Salesforce from Excel
This article explains how to transfer data from Excel to Salesforce using the Excel Add-In for Salesforce.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Work with Live Sugar CRM in Power Query
Use CData Connect Cloud to connect to Sugar CRM and work with live Sugar CRM in Microsoft Power Query.
-
Automated Continuous Avro Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Avro replication to PostgreSQL.
-
Use the CData Software ODBC Driver for Act CRM in MicroStrategy Desktop
Connect to Act CRM in MicroStrategy Desktop using the CData Software ODBC Driver for Act CRM.
-
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.
-
Automated Continuous Zoho CRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zoho CRM replication to Google BigQuery.
-
Automate Dynamics GP Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Dynamics GP replication to SAP HANA.
-
Connect to Asana as a Linked Server
Use the SQL Gateway and the ODBC Driver to set up a linked server for Asana.
-
How to connect and process Impala from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Impala
-
Connect to Google Directory in SpagoBI
Create reports featuring live Google Directory in SpagoBI Studio. Host Google Directory reports on SpagoBI Server.
-
Visualize Live Google Sheets of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Sheets using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Reports from Oracle in Looker Studio
Use CData Connect Cloud to gain access to live Oracle Database and create custom reports in Looker Studio.
-
Use JayDeBeApi to access Certinia in Python
Use standard Python scripting and the development environment of your choice to access live Certinia.
-
Build Paylocity Visualizations in Tableau Cloud
Use CData Connect Cloud to connect to live Paylocity and build visualizations in Tableau Cloud.
-
How to Build Dynamic React Apps with Dynamics 365
Use the CData Connect and React to Build Dynamic Web Apps with Live Dynamics 365 .
-
How to use SQLAlchemy ORM to access Greenhouse in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Greenhouse.
-
Automated Continuous MYOB AccountRight Replication to AlloyDB
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to AlloyDB.
-
Object-Relational Mapping (ORM) with SuiteCRM 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 SuiteCRM into a Java-based ORM framework, Hibernate.
-
Connect to Dropbox in as an External Source in Dremio
Use the CData JDBC Driver to connect to Dropbox as an External Source in Dremio.
-
Build ADP-Connected Apps in Choreo
Use CData Connect Cloud to connect to ADP from Choreo and build custom apps using live ADP.
-
Integrate with MariaDB in JReport Designer
Create charts and reports based on MariaDB in JReport Designer.
-
How to pipe Dynamics 365 to CSV in PowerShell
Use standard PowerShell cmdlets to access Dynamics 365 tables.
-
Access Aha as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Aha! from your Oracle system.
-
Integrate Sage 50 UK in the Pentaho Report Designer
Publish reports based on Sage 50 UK in the Pentaho BI tool.
-
Deploy the ADO.NET Provider for Google Data Catalog on an SSRS Report Server
Connect to Google Data Catalog 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.
-
Create Data Visualizations Based On MailChimp in Mode
Use CData Connect Cloud to connect to MailChimp from Mode and build visualizations using live
-
Access SAS Data Sets from MySQL in PHP
Connect to SAS Data Sets through the standard MySQL libraries in PHP.
-
DataBind Microsoft Dataverse to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Microsoft Dataverse with the DevExpress Windows Forms and Web controls to provide Microsoft Dataverse (CDS) to a chart.
-
How to Access Zenefits Using Entity Framework
This article shows how to access Zenefits using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Replicate Tableau CRM Analytics to Multiple Databases
Replicate Tableau CRM Analytics to disparate databases with a single configuration.
-
Create HubSpot Dashboards in Bold BI
Use CData Software Connect Server to create a virtual SQL Server Database for HubSpot to build custom dashboards in Bold BI.
-
Connect to Wave Financial in JRuby
Create a simple JRuby app with access to live Wave Financial.
-
Bidirectional Access to SAP Hybris C4C from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Hybris C4C in Filemaker Pro for Mac or Windows.
-
Build Charts with Google Ads in Clear Analytics
Create dynamic charts and perform analytics based on Google Ads in Clear Analytics.
-
A PostgreSQL Interface for Phoenix
Use the SQL Gateway and Phoenix ODBC Driver to create a PostgreSQL entry-point for data access.
-
Microsoft Teams Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Teams through CData Connect Cloud using different applications and tools.
-
Extract, Transform, and Load Azure DevOps in Informatica PowerCenter
Create a simple Workflow for Azure DevOps in Informatica PowerCenter.
-
DataBind Wijmo Grid to Instagram
Provide real-time Instagram to interactive controls.
-
Connect to Redis in RapidMiner
Integrate Redis with standard components and data source configuration wizards in RapidMiner Studio.
-
Establish a Live Connection with Amazon S3 using Tableau Bridge
The CData ODBC Driver for Amazon S3 enables you to integrate live Amazon S3 into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Use CData Connect to Access Live Klaviyo in Power Automate
CData Connect for Klaviyo enables you to integrate Klaviyo into workflows built using Microsoft Power Automate Desktop.
-
Integrate with Sage 200 in JReport Designer
Create charts and reports based on Sage 200 in JReport Designer.
-
Create Data Visualizations in Cognos BI with AlloyDB
Access Google AlloyDB as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to integrate Amazon S3 with Apache Airflow
Access and process Amazon S3 in Apache Airflow using the CData JDBC Driver.
-
DataBind Wijmo Grid to Zenefits
Provide real-time Zenefits to interactive controls.
-
How to create Shippo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Shippo in MySQL .
-
Replicate Multiple Oracle Financials Cloud Accounts
Replicate multiple Oracle Financials Cloud accounts to one or many databases.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zoho Books
Provide connectivity to Zoho Books through an SAP BusinessObjects universe.
-
Connect to BigCommerce from Asprova with CData Software ODBC Driver for BigCommerce
This article shows how to connect faster to BigCommerce data from Asprova.
-
Bridge Google Cloud Storage Connectivity with Apache NiFi
Access and process Google Cloud Storage in Apache NiFi using the CData JDBC Driver.
-
Configure the CData JDBC Driver for Office 365 in a Connection Pool in Tomcat
Connect to Microsoft Office 365 from a connection pool in Tomcat.
-
Build Charts with Outreach.io in Clear Analytics
Create dynamic charts and perform analytics based on Outreach.io in Clear Analytics.
-
Natively Connect to Basecamp in PHP
The CData ODBC driver for Basecamp enables you to create PHP applications with connectivity to Basecamp. Leverage the native support for ODBC in PHP.
-
Connect to Snowflake from PowerBuilder
This article demonstrates how to access Snowflake from Appeon PowerBuilder using the CData ADO.NET Provider for Snowflake.
-
Provide OData Services of Email from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Email by developing a WCF Service Application.
-
Create Datasets from SAP Ariba Procurement in Domo Workbench and Build Visualizations of SAP Ariba Procurement in Domo
Use the CData Software ODBC Driver for SAP Ariba Procurement to create datasets from SAP Ariba Procurement in Domo Workbench and then build visualizations in the Domo service.
-
How to load HubDB data into Elasticsearch via Logstash
Introducing a simple method to load HubDB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.