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 LinkedIn Ads Replication to AlloyDB
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to AlloyDB.
-
Integrate Real-Time Access to Sage Cloud Accounting in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Sage Business Cloud Accounting in real time.
-
Use Biml to Build SSIS Tasks to Replicate Oracle Eloqua to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle Eloqua to SQL Server.
-
Connect to Dynamics GP from a Connection Pool in JBoss
Integrate Microsoft Dynamics GP into Java servlets: Use the Management Console in JBoss to install the Dynamics GP JDBC Driver.
-
Access Couchbase as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Couchbase from your Oracle system.
-
Connect to Microsoft Dataverse from Filemaker Pro (Mac)
Use CData Connect Cloud to connect to and query live Microsoft Dataverse (CDS) from Filemaker Pro on Mac.
-
A PostgreSQL Interface for SQL Analysis Services
Use the SQL Gateway and SQL Analysis Services ODBC Driver to create a PostgreSQL entry-point for data access.
-
Model, Search, and Visualize Live Trello in ThoughtSpot
Use CData Connect Cloud to connect to live Trello for modeling, searching, and visualizing.
-
Automate XML Replication to Azure Synapse
Use CData Sync to customize and automate XML Files replication to Azure Synapse.
-
Establish a Live Connection with Salesforce Marketing using Tableau Bridge
The CData ODBC Driver for Salesforce Marketing enables you to integrate live Salesforce Marketing Cloud into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live Teradata in Coginiti Pro
Connect to and query live Teradata from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect to & Open Amazon DynamoDB in Microsoft Excel
This article uses the CData ODBC driver for Amazon DynamoDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Paylocity Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Paylocity replication to PostgreSQL.
-
Edit and Search External Azure Active Directory Objects in Salesforce Connect
Use CData Connect Cloud to securely provide OData feeds of Azure Active Directory to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Azure Active Directory objects that you can access from apps and the dashboard.
-
Create Zoho Inventory-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to Zoho Inventory from OutSystems and build custom enterprise apps using live Zoho Inventory.
-
Access JotForm as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access JotForm from your Oracle system.
-
Automated Continuous eBay Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable eBay replication to Apache Kafka.
-
Back Up Shopify to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Shopify. In this article, we will employ an SSIS workflow to populate a database with Shopify data.
-
Import Real-Time Microsoft Exchange in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Exchange in ColdFusion.
-
Connect to Hive in CloverDX (formerly CloverETL)
Transfer Apache Hive using the visual workflow in the CloverDX data integration tool.
-
Connect to Coinbase from PowerBuilder
This article demonstrates how to use the CData ODBC Driver for Coinbase to connect to Coinbase and execute queries in PowerBuilder.
-
Integrate with Procore using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Procore to a JSON file on disk.
-
Build Square-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live Square and build Square-connected web apps with Axios.
-
Automated Continuous Harvest Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Harvest replication to Amazon Redshift.
-
Use the CData SSIS Components to Insert New or Update Existing REST Records from SQL Server
Easily push SQL Server data to REST using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into REST or update existing records with data from a SQL Server database.
-
Analyze Live Paylocity in SAS Viya
Use CData Connect Cloud to connect to Paylocity from SAS Viya and deploy self-service analytics using live Paylocity.
-
Import and Visualize Dropbox in Power View
Create data visualizations based on Dropbox in Excel.
-
DataBind Wijmo Grid to Microsoft Teams
Provide real-time Microsoft Teams to interactive controls.
-
How to use SQLAlchemy ORM to access SurveyMonkey in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SurveyMonkey.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Replicate Multiple Google Analytics Accounts
Replicate multiple Google Analytics accounts to one or many databases.
-
Use CData Connect Cloud to Access Oracle Service Cloud in Microsoft Power Pivot
Use CData Connect Cloud to connect to live Oracle Service Cloud in the Power Pivot business intelligence tool.
-
Visualize Live SAP Business One of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP Business One using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Informatica Mappings From/To a JDBC Data Source for SQL Server
Create SQL Server data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Facebook in RazorSQL
Connect to Facebook from wizards and query Facebook from the GUI in the RazorSQL database management tool.
-
Connect to Sage Cloud Accounting in as an External Source in Dremio
Use the CData JDBC Driver to connect to Sage Cloud Accounting as an External Source in Dremio.
-
DataBind Controls to Zoho Projects in C++Builder
DataBind to Zoho Projects in C++Builder with standard components and controls.
-
Replicate Multiple YouTube Analytics Accounts
Replicate multiple YouTube Analytics accounts to one or many databases.
-
How to connect to Zoho Books from IntelliJ
Integrate connectivity to Zoho Books with wizards in IntelliJ.
-
How to connect to Cloudant in DBVisualizer
Integrate IBM Cloudant with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live MariaDB in Coginiti Pro
Connect to and query live MariaDB from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Replicate Clio from PowerShell
Write a quick PowerShell script to query Clio. Use connectivity to the live data to replicate Clio to SQL Server.
-
Integrate with SingleStore in JReport Designer
Create charts and reports based on SingleStore in JReport Designer.
-
Create Shopify-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to Shopify from OutSystems and build custom enterprise apps using live Shopify.
-
How to load Zoom data into Elasticsearch via Logstash
Introducing a simple method to load Zoom data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Microsoft Exchange from a Connection Pool in JBoss
Integrate Microsoft Exchange into Java servlets: Use the Management Console in JBoss to install the Microsoft Exchange JDBC Driver.
-
Automated Continuous Twitter Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Twitter replication to delimited files (CSV/TSV).
-
Create Reports from DocuSign in Looker Studio
Use CData Connect Cloud to gain access to live DocuSign and create custom reports in Looker Studio.
-
Connect to Impala in Google Apps Script
Use the ODBC Driver for Impala and the SQL Gateway to access Apache Impala from Google Apps Script.
-
Access Live Oracle Sales in Excel (Desktop)
Use CData Connect Cloud to gain access to live Oracle Sales from your Excel spreadsheets.
-
Using AngularJS to Build Dynamic Web Pages with Exact Online
Use the CData Connect Server to create Exact Online OData feeds and build single-page applications with live Exact Online.
-
A PostgreSQL Interface for ShipStation
Use the Remoting features of the ShipStation JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Spark in Google Sheets
Use CData Connect Cloud to gain access to live Apache Spark SQL from your Google Sheets.
-
Build Dashboards with Confluence in Dundas BI
Create dynamic dashboards and perform analytics based on Atlassian Confluence in Dundas BI.
-
Replicate Multiple Impala Accounts
Replicate multiple Impala accounts to one or many databases.
-
Automated Continuous Slack Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Slack replication to AlloyDB.
-
Replicate Slack to Multiple Databases
Replicate Slack to disparate databases with a single configuration.
-
Load Phoenix to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apache Phoenix to a database.
-
Enable the Zendesk JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Zendesk.
-
Analyze BigCommerce in R
Use standard R functions and the development environment of your choice to analyze BigCommerce with the CData JDBC Driver for BigCommerce.
-
How to Build Dynamic React Apps with Pinterest
Use the CData Connect and React to Build Dynamic Web Apps with Live Pinterest .
-
Automate Oracle Service Cloud Replication to Couchbase
Use CData Sync to Customize and automate Oracle Service Cloud replication to Couchbase.
-
DataBind Charts to Microsoft Teams
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Teams 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.
-
Access Live Amazon S3 in Excel (Desktop)
Use CData Connect Cloud to gain access to live Amazon S3 from your Excel spreadsheets.
-
Integrate Live Zoho Inventory into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to Zoho Inventory from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoho Inventory.
-
Build Automated Workflows with Live Stripe in Workato
Use CData Connect Cloud to connect to live Stripe and build automated workflows in Workato.
-
Automate Drift Replication to Azure Synapse
Use CData Sync to customize and automate Drift replication to Azure Synapse.
-
How to integrate Cassandra with Apache Airflow
Access and process Apache Cassandra in Apache Airflow using the CData JDBC Driver.
-
Visualize Redis in Tableau
The CData ODBC driver for Redis enables you integrate Redis into Tableau dashboards.
-
Visualize Live Odoo in the Power BI Service
Use CData Connect Cloud to connect to live Odoo ERP and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Salesforce Pardot in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Salesforce Pardot.
-
Connect to Real-Time Oracle HCM Cloud Data in Power Apps Using Dataflows to Build Custom Applications
-