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 Drift Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Drift replication to Google Cloud SQL.
-
Export Data from SQL Server to Databricks through SSIS
Easily push SQL Server data to Databricks using the CData SSIS Tasks for Databricks.
-
Create SSAS Tabular Models from Google Cloud Storage
How to build a SQL Server Analysis Service Tabular Model from Google Cloud Storage using CData drivers.
-
Query Salesloft as a MySQL Database in Node.js
Execute MySQL queries against Salesloft from Node.js.
-
Choosing the Best Method to Connect Marketo to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Marketo from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Use a Microsoft Access Database to Update Sybase in Real Time
Update Sybase data by creating a linked table in Microsoft Access with the CData Sybase ODBC Driver.
-
Build WooCommerce-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to WooCommerce from Zoho Analytics and import live WooCommerce.
-
How to connect to Teradata in DBVisualizer
Integrate Teradata with visual data analysis tools and data connection wizards in DBVisualizer
-
Using AngularJS to Build Dynamic Web Pages with SAP Hybris C4C
Use the CData Connect Server to create SAP Hybris C4C OData feeds and build single-page applications with live SAP Hybris C4C.
-
A PostgreSQL Interface for Google Drive
Use the Remoting features of the Google Drive JDBC Driver to create a PostgreSQL entry-point for data access.
-
Design BIRT Reports on RSS Feeds
Provide current RSS Feeds to your embedded analytics.
-
Publish Crystal Reports on Zoho Books
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoho Books.
-
Connect to MariaDB in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for MariaDB and connect to MariaDB in Akorbi Digital RunMyProcess.
-
Create Dynamic MongoDB Grids Using the Infragistics XamDataGrid
Learn how you can connect MongoDB to Infragistics XamDataGrid to build dynamic grids.
-
Publish Excel-Connected Dashboards in Tableau Server
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Excel.
-
How to Connect to & Open eBay Analytics in Microsoft Excel
This article uses the CData ODBC driver for eBay Analytics to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Gmail-Connected Business Apps in AppSheet
Connect to Gmail via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Gmail.
-
Create Datasets from LDAP in Domo Workbench and Build Visualizations of LDAP Objects in Domo
Use the CData Software ODBC Driver for LDAP to create datasets from LDAP in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous SuiteCRM Replication to Oracle
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Oracle.
-
Use Dash to Build to Web Apps on ClickUp
Create Python applications that use pandas and Dash to build ClickUp-connected web apps.
-
Create Exact Online Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Exact Online data access from reports, embedded analytics, and more.
-
Automated Continuous LinkedIn Ads Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Google BigQuery.
-
Choosing the Best Method to Connect Neo4J to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Neo4J from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Visualize Live Google Analytics in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Analytics.
-
Connect to Sage Cloud Accounting in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for Sage Business Cloud Accounting in Airbyte.
-
Connect to Live Outreach.io in MicroStrategy through CData Connect Cloud
Create a live connection to Outreach.io in CData Connect Cloud and connect to your Outreach.io from MicroStrategy.
-
Author and Share Power BI Reports on Real-Time eBay Analytics
Use the CData ODBC Driver for eBay Analytics to visualize eBay Analytics in Power BI Desktop and then upload to the Power BI service.
-
Connect to ClickUp in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build Google Sheets-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to Google Sheets from Zoho Analytics and import live Google Sheets.
-
Integrate Office 365 in the Pentaho Report Designer
Publish reports based on Microsoft Office 365 in the Pentaho BI tool.
-
Connect to FTP in Aqua Data Studio
Access FTP Servers from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Analyze QuickBooks in Infragistics Reveal
Use the CData Connect Server to create an OData API on top of QuickBooks Desktop and visualize live QuickBooks Desktop in Ingragistics Reveal.
-
Access Live Google Ad Manager in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for Google Ad Manager to create a Google Ad Manager source in TIBCO Data Virtualization Studio and gain access to live Google Ad Manager from your TDV Server.
-
Model, Search, and Visualize Live Redis in ThoughtSpot
Use CData Connect Cloud to connect to live Redis for modeling, searching, and visualizing.
-
A PostgreSQL Interface for IBM Cloud Data Engine
Use the Remoting features of the IBM Cloud Data Engine JDBC Driver to create a PostgreSQL entry-point for data access.
-
Write a Simple Go Application to work with Oracle SCM on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle SCM.
-
Stream Jira Service Management into Apache Kafka Topics
Access and stream Atlassian Jira Service Management in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to pipe Zoho Inventory to CSV in PowerShell
Use standard PowerShell cmdlets to access Zoho Inventory tables.
-
Connect to Live Bullhorn CRM in PostGresSQL Interface through CData Connect Cloud
Create a live connection to Bullhorn CRM in CData Connect Cloud and connect to your Bullhorn CRM from PostgreSQL.
-
Automated Continuous Azure DevOps Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Microsoft Access.
-
Integrate with Kafka in JReport Designer
Create charts and reports based on Apache Kafka in JReport Designer.
-
Access Microsoft Exchange as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Exchange from your Oracle system.
-
Automated Continuous Excel Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Excel replication to AlloyDB.
-
Integrate Kafka with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Kafka with External Services.
-
Extract, Transform, and Load SuiteCRM in Informatica PowerCenter
Create a simple Workflow for SuiteCRM in Informatica PowerCenter.
-
Operational Reporting on Act CRM from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Act CRM.
-
How to Connect to & Open Google Spanner in Microsoft Excel
This article uses the CData ODBC driver for Google Spanner to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
View Reports on Real-Time SAS xpt in Power BI Report Server
Use the CData ODBC Driver for SAS xpt to visualize SAS XPORT in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize Harvest in TIBCO Spotfire through ADO.NET
Integrate Harvest into dashboards in TIBCO Spotfire.
-
Replicate Multiple Amazon DynamoDB Accounts
Replicate multiple Amazon DynamoDB accounts to one or many databases.
-
Replicate CockroachDB for Use in Salesforce Connect
Replicate CockroachDB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
DataBind Controls to CouchDB in Delphi
DataBind to Apache CouchDB in Delphi with standard data access components and controls.
-
ETL SendGrid in Oracle Data Integrator
This article shows how to transfer SendGrid into a data warehouse using Oracle Data Integrator.
-
Access Blackbaud FE NXT from MySQL in Amazon QuickSight
Connect to Blackbaud FE NXT and build visualizations of Blackbaud FE NXT using a MySQL Connection in Amazon QuickSight.
-
Build Redshift Visualizations in Tableau Desktop
Use CData Connect Cloud to connect to live Amazon Redshift and build visualizations in Tableau.
-
Operational Reporting on Google Calendar from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Calendar.
-
Build Bullhorn CRM-Connected Apps in Choreo
Use CData Connect Cloud to connect to Bullhorn CRM from Choreo and build custom apps using live Bullhorn CRM.
-
Write a Simple Go Application to work with Google Ad Manager on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Ad Manager.
-
Explore Geographical Relationships in Calendly with Power Map
Create data visualizations with Calendly in Power Map.
-
Azure DevOps Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Azure DevOps through CData Connect Cloud using different applications and tools.
-
Add ActiveCampaign to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ActiveCampaign with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Oracle Eloqua-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle Eloqua.
-
Access Live Jira Service Management in Excel for the Web (Excel 365/Online)
Connect to Atlassian Jira Service Management from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Work with Dynamics 365 Business Central in ETL Validator JDBC
Connect to Dynamics 365 Business Central from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Work with TigerGraph in ETL Validator JDBC
Connect to TigerGraph from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Greenplum-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for Greenplum and create custom apps in Mendix.
-
Build Semantic Layer Views for Sybase in APOS Live Data Gateway
Use the CData Connector for Sybase in APOS Live Data Gateway to build Semantic Layer Views for Sybase.
-
Connect to Basecamp from PowerBuilder
This article demonstrates how to use the CData ODBC Driver for Basecamp to connect to Basecamp and execute queries in PowerBuilder.
-
Connect to Harvest from PowerBuilder
This article demonstrates how to access Harvest from PowerBuilder using the Harvest JDBC Driver.
-
Connect to Presto from HeidiSQL
Use CData Connect Cloud to connect to and query live Presto from HeidiSQL.
-
How to update Splunk from Excel
This article explains how to transfer data from Excel to Splunk using the Excel Add-In for Splunk.
-
Download files from a SharePoint site using the CData SSIS Components
The CData SSIS data flow components allow you to easily import and export data from various data sources. However in some cases the type of operation you need does not fit the SSIS Data Source or the SSIS Data Destination model. In this article, we will demonstrate how to use a CData stored procedure in your SSIS data flow.
-
Access Live Instagram in Excel (Desktop)
Use CData Connect Cloud to gain access to live Instagram from your Excel spreadsheets.
-
Integrate Monday.com in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Monday.com from Informatica Cloud.
-
Integrate Kintone in the Pentaho Report Designer
Publish reports based on Kintone in the Pentaho BI tool.
-
Automated Continuous MailChimp Replication to Oracle
Use CData Sync for automated, continuous, customizable MailChimp replication to Oracle.
-
Automated Continuous Unbounce Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Unbounce replication to Amazon Redshift.
-
How to connect to SAP BusinessObjects BI from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for SAP BusinessObjects BI and work with SAP BusinessObjects BI in Microsoft Excel on Mac OS X.
-
A PostgreSQL Interface for Google Cloud Storage
Use the Remoting features of the Google Cloud Storage JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Sage Cloud Accounting in MicroStrategy Desktop
Connect to Sage Business Cloud Accounting in MicroStrategy Desktop using the CData Software JDBC Driver for Sage Cloud Accounting.
-
Import Real-Time SharePoint in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft SharePoint in ColdFusion.
-
Connect to NetSuite from a Connection Pool in WebLogic
Use the CData JDBC Driver for NetSuite to connect to NetSuite CRM & ERP from Web applications running on WebLogic.
-
Back Up Avalara AvaTax to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Avalara AvaTax. In this article, we will employ an SSIS workflow to populate a database with Avalara AvaTax data.
-
Create SAP Hybris C4C-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to SAP Hybris C4C from OutSystems and build custom enterprise apps using live SAP Hybris C4C.
-
Use CData Connect Cloud to Access Zuora in Microsoft Power Pivot
Use CData Connect Cloud to connect to live Zuora in the Power Pivot business intelligence tool.
-
Create a Data Access Object for Azure Table using JDBI
A brief overview of creating a SQL Object API for Azure Table Storage in JDBI.
-
Work with Live Power BI XMLA in Power Query
Use CData Connect Cloud to connect to Power BI XMLA and work with live Power BI XMLA in Microsoft Power Query.
-
Create Informatica Mappings From/To a JDBC Data Source for YouTube Analytics
Create YouTube Analytics data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Analyze Raisers Edge NXT in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of Raisers Edge NXT and visualize Raisers Edge NXT in SAP Analytics Cloud.
-
How to update Dynamics CRM from Excel
This article explains how to transfer data from Excel to Dynamics CRM using the Excel Add-In for Dynamics CRM.
-
How to connect Amazon QuickSight to API
Create a connection to API in CData Connect Cloud and insert API into Amazon QuickSight SPICE to build interactive dashboards.
-
DataBind Controls to Active Directory in C++Builder
DataBind to Active Directory in C++Builder with standard components and controls.
-
Manage Google Ads in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Ads.
-
Connect to Todoist from a Connection Pool in WebLogic
Use the CData JDBC Driver for Todoist to connect to Todoist from Web applications running on WebLogic.
-
A PostgreSQL Interface for Slack
Use the SQL Gateway and Slack ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to EventBrite in DBVisualizer
Integrate Eventbrite with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate SAP Ariba Source in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Ariba Source from Informatica Cloud.
-
Manage Dropbox in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Dropbox.
-
Create SSAS Tabular Models from Google Search Results
How to build a SQL Server Analysis Service Tabular Model from Google Search using CData drivers.
-
Natively Connect to Oracle Service Cloud in PHP
Create PHP applications on Linux/UNIX machines with connectivity to Oracle Service Cloud. Leverage the native support for ODBC in PHP.