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 connect to Kintone from Spring Boot
Connect to Kintone in a Spring Boot Application using CData JDBC Kintone Driver
-
Configure the CData JDBC Driver for QuickBooks Online in a Connection Pool in Tomcat
Connect to QuickBooks Online from a connection pool in Tomcat.
-
Create SSAS Tabular Models from GraphQL
How to build a SQL Server Analysis Service Tabular Model from GraphQL using CData drivers.
-
Create Dynamic DocuSign Grids Using the Infragistics XamDataGrid
Learn how you can connect DocuSign to Infragistics XamDataGrid to build dynamic grids.
-
How to connect to BambooHR in DBVisualizer
Integrate BambooHR with visual data analysis tools and data connection wizards in DBVisualizer
-
Design BIRT Reports on Sugar CRM
Provide current Sugar CRM to your embedded analytics.
-
Connect to Elasticsearch from AWS Glue
Use CData Connect Cloud to gain access to live Elasticsearch from your AWS Glue jobs.
-
Create PostgreSQL-Connected Business Apps in AppSheet
Connect to PostgreSQL via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to PostgreSQL.
-
Build Charts with SharePoint Excel Services in Clear Analytics
Create dynamic charts and perform analytics based on SharePoint Excel Services in Clear Analytics.
-
Connect to ActiveCampaign from AWS Glue
Use CData Connect Cloud to gain access to live ActiveCampaign from your AWS Glue jobs.
-
Automated Continuous WordPress Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable WordPress replication to delimited files (CSV/TSV).
-
DataBind SAP Concur to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for SAP Concur with the DevExpress Windows Forms and Web controls to provide SAP Concur to a chart.
-
Automated Continuous MariaDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable MariaDB replication to SingleStore.
-
Query DocuSign as a SQL Server Database in Node.js
Execute SQL Server queries against DocuSign from Node.js.
-
Integrate Jira Assets in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Jira Assets from Informatica Cloud.
-
Work with Certinia in FoxPro
Load Certinia into a FoxPro database. This article includes full code and a walk-through of the process.
-
Object-Relational Mapping (ORM) with DB2 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 IBM DB2 into a Java-based ORM framework, Hibernate.
-
A PostgreSQL Interface for Zoho Projects
Use the SQL Gateway and Zoho Projects ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Facebook Replication to SQLite
Use CData Sync for automated, continuous, customizable Facebook replication to SQLite.
-
Build Cloudant-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for Cloudant and create custom apps in Mendix.
-
Use JayDeBeApi to access Azure DevOps in Python
Use standard Python scripting and the development environment of your choice to access live Azure DevOps.
-
Build Xero Visualizations in Tableau Desktop
Use CData Connect Cloud to connect to live Xero Accounting and build visualizations in Tableau.
-
LINQ to Harvest
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 Harvest Data Provider.
-
Use the CData Software JDBC Driver for Sage Intacct in MicroStrategy Web
Connect to Sage Intacct in MicroStrategy Web using the CData Software JDBC Driver for Sage Intacct.
-
Connect to Smartsheet in Jaspersoft Studio
Execute SQL to remote Smartsheet in Jaspersoft Studio.
-
Automated Continuous QuickBooks Online Replication to Azure SQL
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Azure SQL.
-
Connect to AlloyDB in Google Apps Script
Use the ODBC Driver for AlloyDB and the SQL Gateway to access Google AlloyDB from Google Apps Script.
-
How to connect to Wave Financial in DBVisualizer
Integrate Wave Financial with visual data analysis tools and data connection wizards in DBVisualizer
-
Import Google Cloud Storage into FileMaker Pro
Create reports that integrate Google Cloud Storage in Filemaker Pro.
-
Model, Search, and Visualize Live Bing Ads in ThoughtSpot
Use CData Connect Cloud to connect to live Bing Ads for modeling, searching, and visualizing.
-
Automated Continuous MarkLogic Replication to Azure SQL
Use CData Sync for automated, continuous, customizable MarkLogic replication to Azure SQL.
-
Visualize Raisers Edge NXT in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Raisers Edge NXT into TIBCO Spotfire.
-
Automate Bing Ads Replication to SAP HANA
Use CData Sync to customize and automate Bing Ads replication to SAP HANA.
-
Add Facebook Ads to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Facebook Ads with the Informatica Enterprise Data Catalog to classify and organize data.
-
Load AlloyDB to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google AlloyDB to a database.
-
Creating Impala-Connected Applications in Unqork
You can use CData Connect Cloud to feed Apache Impala to Unqork and build custom business apps.
-
How to create Visio diagrams from Reckon Accounts Hosted
Automatically update Reckon Accounts Hosted with the changes you make to Visio master shapes.
-
Build Automated Impala-Connected Workflows in Zapier
Use CData Connect Cloud to connect to live Apache Impala and build automated workflows in Zapier.
-
Use the CData ODBC Driver for Google Sheets in SAS JMP
You can use the CData ODBC Driver to integrate Google Sheets into the statistical analysis tools available in SAS JMP. This article shows how to use Google Sheets in the Graph Builder and Query Builder.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Shopify
Provide connectivity to Shopify through an SAP BusinessObjects universe.
-
Build Dashboards with Salesloft in DBxtra
Create dynamic dashboards and perform analytics based on Salesloft in DBxtra.
-
Create Reports with Impala in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Impala.
-
Connect to Unbounce in Jaspersoft Studio
Execute SQL to remote Unbounce in Jaspersoft Studio.
-
Stream Odoo into Apache Kafka Topics
Access and stream Odoo ERP in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Author and Share Power BI Reports on Real-Time Sugar CRM
Use the CData ODBC Driver for Sugar CRM to visualize Sugar CRM in Power BI Desktop and then upload to the Power BI service.
-
Connect to Greenhouse in DBeaver
Use the CData ODBC Driver to connect to Greenhouse in DBeaver.
-
Query Procore as a MySQL Database in Node.js
Execute MySQL queries against Procore from Node.js.
-
How to connect to Zuora from IntelliJ
Integrate connectivity to Zuora with wizards in IntelliJ.
-
Access Live WooCommerce in AWS Lambda
Connect to live WooCommerce in AWS Lambda using the CData JDBC Driver.
-
How to Replicate Data Between MySQL and SQL Server with CData
In this entry you will find how to replicate MySQL data into SQL Server (and vice versa) using CData.
-
Using AngularJS to Build Dynamic Web Pages with Office 365
Use the CData Connect Server to create Office 365 OData feeds and build single-page applications with live Microsoft Office 365.
-
Use the Connect Server to Access SAS Data Sets in Microsoft Power Pivot
Use the Connect Server to connect to live SAS Data Sets in the Power Pivot business intelligence tool.
-
Automated Continuous Google Ad Manager Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Apache Cassandra.
-
Build Quickbase-Connected Apps in Bubble
Use CData Connect Cloud to create an OData feed for Quickbase and create custom apps in Bubble.
-
Import SAP Hybris C4C Using Azure Data Factory
Use CData Connect Cloud to connect to SAP Hybris C4C from Azure Data Factory and import live SAP Hybris C4C.
-
Working with Twitter Ads in LINQPad
Execute LINQ queries to Twitter Ads in LINQPad.
-
Replicate Trello to Multiple Databases
Replicate Trello to disparate databases with a single configuration.
-
Bidirectional Access to QuickBooks Online from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate QuickBooks Online in Filemaker Pro for Mac or Windows.
-
Connect to SAP BusinessObjects BI in JRuby
Create a simple JRuby app with access to live SAP BusinessObjects BI.
-
Automated RSS Feeds Replication to Teradata
Use CData Sync to Customize and automate RSS Feeds replication to Teradata.
-
How to Visualize Splunk Data in Python with pandas
Use pandas and other modules to analyze and visualize live Splunk in Python.
-
Automated Continuous Drift Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Drift replication to Amazon Redshift.
-
Use Biml to Build SSIS Tasks to Replicate HCL Domino to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate HCL Domino to SQL Server.
-
Automated Continuous Facebook Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Amazon S3.
-
Automated Continuous Couchbase Replication to Oracle
Use CData Sync for automated, continuous, customizable Couchbase replication to Oracle.
-
Create Drift-Connected Visualizations in Klipfolio
Use CData Software Connect Server to connect to Drift from Klipfolio and build custom visualizations using live Drift.
-
DataBind Charts to Sage Cloud Accounting
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Sage Business Cloud Accounting 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.
-
Import QuickBooks into the Power BI Service for Visualizations
Use CData Software Connect Server to create an OData feed for QuickBooks and create custom reports in the Power BI Service.
-
How to Access Live Zuora in Power Automate Desktop via ODBC
The CData ODBC Driver for Zuora enables you to integrate Zuora into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software JDBC Driver for Zuora in MicroStrategy Web
Connect to Zuora in MicroStrategy Web using the CData Software JDBC Driver for Zuora.
-
Stream ADP into Apache Kafka Topics
Access and stream ADP in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Creating Procore-Connected Applications in Unqork
You can use CData Connect to feed Procore to Unqork and build custom business apps.
-
Use the CData ODBC Driver for eBay from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for eBay to connect to eBay from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring eBay in Excel.
-
A PostgreSQL Interface for Printify
Use the Remoting features of the Printify JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Cvent with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Cvent with External Services.
-
Analyze Zoho Creator in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of Zoho Creator and visualize live Zoho Creator in Infragistics Reveal.
-
How to Visualize Invoiced Data in Python with pandas
Use pandas and other modules to analyze and visualize live Invoiced in Python.
-
Build Charts with Cassandra in Clear Analytics
Create dynamic charts and perform analytics based on Apache Cassandra in Clear Analytics.
-
Connect to Email from a Connection Pool in JBoss
Integrate Email into Java servlets: Use the Management Console in JBoss to install the Email JDBC Driver.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Access Sage 300 as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sage 300 from your Oracle system.
-
Use the CData Software ODBC Driver for ServiceNow in MicroStrategy Web
Connect to ServiceNow in MicroStrategy Web using the CData Software ODBC Driver for ServiceNow.
-
Access Live Google Analytics in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for Google Analytics to create a Google Analytics source in TIBCO Data Virtualization Studio and gain access to live Google Analytics from your TDV Server.
-
Create SSAS Tabular Models from Okta
How to build a SQL Server Analysis Service Tabular Model from Okta using CData drivers.
-
How to connect to Twilio in DBVisualizer
Integrate Twilio with visual data analysis tools and data connection wizards in DBVisualizer
-
Create SSAS Tabular Models from Microsoft Planner
How to build a SQL Server Analysis Service Tabular Model from Microsoft Planner using CData drivers.
-
Connect to Real-Time Active Directory Data in Power Apps Using Dataflows to Build Custom Applications
-