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
-
Manage Dynamics CRM in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Dynamics CRM.
-
How to create SQL Server federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft SQL Server in MySQL .
-
Connect to Box in Ruby
Connect to Box in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Explore Geographical Relationships in MariaDB with Power Map
Create data visualizations with MariaDB in Power Map.
-
Connect to REST in RapidMiner
Integrate REST with standard components and data source configuration wizards in RapidMiner Studio.
-
Import Real-Time Smartsheet in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Smartsheet in ColdFusion.
-
Visualize ClickUp in Tableau Desktop (through CData Connect)
Create a virtual SQL Server database for ClickUp in CData Software Connect (or Connect Server) and build visualizations from live ClickUp in Tableau Desktop.
-
Visualize Zoho Inventory in TIBCO Spotfire through ADO.NET
Integrate Zoho Inventory into dashboards in TIBCO Spotfire.
-
Automated Continuous Google Calendar Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Google Calendar replication to Microsoft Access.
-
Natively Connect to QuickBooks Online in PHP
The CData ODBC driver for QuickBooks Online enables you to create PHP applications with connectivity to QuickBooks Online. Leverage the native support for ODBC in PHP.
-
Automated Continuous Google Ads Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Ads replication to Amazon Redshift.
-
Publish Reports with BigQuery in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google BigQuery.
-
Bridge Printify Connectivity with Apache NiFi
Access and process Printify in Apache NiFi using the CData JDBC Driver.
-
Build Snapchat Ads-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Snapchat Ads and build web apps with connectivity to live Snapchat Ads.
-
Process & Analyze ConstantContact in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ConstantContact .
-
A PostgreSQL Interface for YouTube Analytics
Use the Remoting features of the YouTube Analytics ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Amazon DynamoDB 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 Amazon DynamoDB.
-
Query WooCommerce in MySQL Workbench
Create a virtual MySQL database for WooCommerce in CData Software Connect (or Connect Server) and work with live WooCommerce in MySQL Workbench.
-
Import Real-Time Drip in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Drip in ColdFusion.
-
Query Azure Active Directory as a MySQL Database in Node.js
Execute MySQL queries against Azure Active Directory from Node.js.
-
Create Datasets from HBase in Domo Workbench and Build Visualizations of HBase in Domo
Use the CData Software ODBC Driver for HBase to create datasets from Apache HBase in Domo Workbench and then build visualizations in the Domo service.
-
DataBind Blackbaud FE NXT to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Blackbaud FE NXT with the DevExpress Windows Forms and Web controls to provide Blackbaud FE NXT to a chart.
-
Build a Simple VCL Application for MarkLogic
How to build a simple VCL Application to view MarkLogic in RAD Studio using the CData ODBC Driver for MarkLogic.
-
Analyze SAP BusinessObjects BI with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP BusinessObjects BI from Power Pivot. You will use the Table Import Wizard to load SAP BusinessObjects BI. You can visually build the import query or use any SQL supported by the driver.
-
Connect to ClickUp from a Connection Pool in Jetty
The ClickUp JDBC Driver supports connection pooling: This article shows how to connect faster to ClickUp from Web apps in Jetty.
-
Automate Zuora Replication to Azure Data Lake
Use CData Sync to customize and automate Zuora replication to Azure Data Lake.
-
Create Data Visualizations in Cognos BI with Google Ads
Access Google Ads as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Printful in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for Printful to create a Printful source in TIBCO Data Virtualization Studio and gain access to live Printful from your TDV Server.
-
Automated Continuous Hive Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Hive replication to IBM DB2.
-
Build an OLAP Cube in SSAS from Kafka
Establish a connection to Apache Kafka data from SQL Server Analysis Services, and use the Kafka Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live MailChimp in Google Sheets
Use CData Connect Cloud to gain access to live MailChimp from your Google Sheets.
-
Build Adobe Analytics-Connected Apps in Choreo
Use CData Connect Cloud to connect to Adobe Analytics from Choreo and build custom apps using live Adobe Analytics.
-
Query Reckon Accounts Hosted through ODBC in Node.js
Use node-odbc to execute SQL queries against Reckon Accounts Hosted from Node.js.
-
Automated Continuous Phoenix Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Phoenix replication to Apache Kafka.
-
Create HBase Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
DataBind Controls to LinkedIn Ads in C++Builder
DataBind to LinkedIn Ads in C++Builder with standard components and controls.
-
Connect to and Query Todoist in QlikView over ODBC
Create data visualizations with Todoist in QlikView.
-
Import Real-Time NetSuite in ColdFusion to Build Applications
Use CData JDBC drivers to import and use NetSuite CRM & ERP in ColdFusion.
-
Automated Continuous Google Spanner Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Spanner replication to Vertica.
-
Connect to SFTP from a Connection Pool in JBoss
Integrate SFTP into Java servlets: Use the Management Console in JBoss to install the SFTP JDBC Driver.
-
Use the CData Software ODBC Driver for MySQL in MicroStrategy Desktop
Connect to MySQL in MicroStrategy Desktop using the CData Software ODBC Driver for MySQL.
-
Access ConstantContact 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 ConstantContact.
-
Automated Continuous Google Search Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Search replication to Apache Cassandra.
-
Edit and Search External JSON Objects in Salesforce Connect
Use CData Connect Server to securely provide OData feeds of JSON to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create JSON objects that you can access from apps and the dashboard.
-
How to Import Drip into SQL Server using SSIS
Easily back up Drip to SQL Server using the SSIS components for Drip.
-
Replicate Vertica to Multiple Databases
Replicate Vertica to disparate databases with a single configuration.
-
Create Bullhorn CRM-Connected Business Apps in AppSheet
Connect to Bullhorn CRM via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Bullhorn CRM.
-
Model Tableau CRM Analytics Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Tableau CRM Analytics, enabling the direct import of real-time Tableau CRM Analytics.
-
Perform Batch Operations with WordPress in Apache NiFi
Connect to WordPress and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to SAP HANA from PowerBuilder
This article demonstrates how to use the CData ODBC Driver for SAP HANA to connect to SAP HANA and execute queries in PowerBuilder.
-
Connect to SAP Hybris C4C from PowerBuilder
This article demonstrates how to access SAP Hybris C4C from PowerBuilder using the SAP Hybris C4C JDBC Driver.
-
Create Data Visualizations in Cognos BI with FTP
Access FTP Servers as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Back Up IBM Cloud Object Storage to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for IBM Cloud Object Storage. In this article, we will employ an SSIS workflow to populate a database with IBM Cloud Object Storage data.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Outreach.io Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Outreach.io replication to Apache Cassandra.
-
Visualize Live Monday.com in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live Monday.com into custom reports in Power BI.
-
Automate Snowflake Replication to Azure Synapse
Use CData Sync to customize and automate Snowflake replication to Azure Synapse.
-
PowerShell Scripting to Replicate Oracle SCM to MySQL
Write a simple PowerShell script to replicate Oracle SCM to a MySQL database.
-
How to Import SAP Fieldglass into SQL Server using SSIS
Easily back up SAP Fieldglass to SQL Server using the SSIS components for SAP Fieldglass.
-
Natively Connect to Greenhouse in PHP
Create PHP applications on Linux/UNIX machines with connectivity to Greenhouse. Leverage the native support for ODBC in PHP.
-
Automate Typeform Replication to SAP HANA
Use CData Sync to customize and automate Typeform replication to SAP HANA.
-
Access Live MySQL in Excel 365 Online (Excel for the web)
Connect to MySQL from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
Access Live Google Ads in Google Sheets
Use CData Connect Cloud to gain access to live Google Ads from your Google Sheets.
-
Natively Connect to Typeform in PHP
The CData ODBC driver for Typeform enables you to create PHP applications with connectivity to Typeform. Leverage the native support for ODBC in PHP.
-
Visualize Splunk in TIBCO Spotfire through ADO.NET
Integrate Splunk into dashboards in TIBCO Spotfire.
-
Creating Salesforce Marketing-Connected Applications in Unqork
You can use CData Connect Cloud to feed Salesforce Marketing Cloud to Unqork and build custom business apps.
-
Connect to Azure Data Catalog from PowerBuilder
This article demonstrates how to use the CData ODBC Driver for Azure Data Catalog to connect to Azure Data Catalog and execute queries in PowerBuilder.
-
Connect to Couchbase in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Couchbase and connect to Couchbase in Akorbi Digital RunMyProcess.
-
Visualize Zoho Projects in Sisense
Create an ElastiCube in Sisense app with access to Zoho Projects.
-
Publish Avalara AvaTax-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Avalara AvaTax.
-
Process & Analyze CockroachDB in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live CockroachDB .
-
Connect to ClickUp from Asprova with CData Software ODBC Driver for ClickUp
This article shows how to connect faster to ClickUp data from Asprova.
-
How to connect to ShipStation from Spring Boot
Connect to ShipStation in a Spring Boot Application using CData JDBC ShipStation Driver
-
Automated Continuous QuickBooks Online Replication to Vertica
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Vertica.
-
PowerShell Scripting to Replicate SAP Netweaver Gateway to MySQL
Write a simple PowerShell script to replicate SAP Netweaver Gateway to a MySQL database.
-
Build Active Directory-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Active Directory.
-
Create a Data Access Object for Sybase IQ using JDBI
A brief overview of creating a SQL Object API for Sybase IQ in JDBI.
-
Create EventBrite Dashboards in Bold BI
Use CData Software Connect Server to create a virtual SQL Server Database for Eventbrite to build custom dashboards in Bold BI.
-
Create Data Visualizations in Cognos BI with SendGrid
Access SendGrid as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query Slack as a MySQL Database in Node.js
Execute MySQL queries against Slack from Node.js.
-
Model Smartsheet Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Smartsheet, enabling the direct import of real-time Smartsheet.
-
Use the CData Software ODBC Driver for Quickbase in SAS for Real-Time Reporting and Analytics
Connect to real-time Quickbase in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Quickbase.
-
Build Automated Amazon DynamoDB-Connected Workflows in Zapier
Use CData Connect Cloud to connect to live Amazon DynamoDB and build automated workflows in Zapier.
-
Working with Sage Cloud Accounting in LINQPad
Execute LINQ queries to Sage Business Cloud Accounting in LINQPad.
-
How to connect to Bullhorn CRM with Squirrel SQL client
Connect to Bullhorn CRM and execute queries in the Squirrel SQL Client.
-
Automated Continuous Raisers Edge NXT Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Amazon Redshift.
-
Analyze Google Data Catalog in R
Use standard R functions and the development environment of your choice to analyze Google Data Catalog with the CData JDBC Driver for Google Data Catalog.
-
Manage Klaviyo in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Klaviyo.
-
Use the CData ODBC Driver for Cosmos DB in Microsoft Power Query
You can use the CData Cosmos DB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Azure Cosmos DB into Microsoft Power Query.
-
Connect to TaxJar from a Connection Pool in Jetty
The TaxJar JDBC Driver supports connection pooling: This article shows how to connect faster to TaxJar from Web apps in Jetty.
-
LINQ to FTP
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 FTP Data Provider.
-
Provide OData Services of Unbounce from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Unbounce by developing a WCF Service Application.
-
How to Connect DBeaver to SAP Netweaver Gateway via a JDBC Driver
Manage SAP Netweaver Gateway with visual tools in DBeaver like the query browser.
-
Visualize Twitter Ads in Tableau
The CData ODBC driver for Twitter Ads enables you integrate Twitter Ads into Tableau dashboards.
-
Connect to Salesforce Pardot in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Build Dynamic React Apps with Act CRM
Use the CData Connect and React to Build Dynamic Web Apps with Live Act CRM .
-
How to connect to eBay Analytics from Google Apps Script
Use CData Software Connect Server to access eBay Analytics in Google Apps Script.
-
Automated Continuous Microsoft Project Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Microsoft Project replication to AlloyDB.
-
Analyze Sage Intacct in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of Sage Intacct and visualize Sage Intacct in SAP Analytics Cloud.
-
Prepare, Blend, and Analyze NetSuite in Alteryx Designer
Build workflows to access live NetSuite CRM & ERP for self-service data analytics.