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
-
Provide OData Services of WooCommerce from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for WooCommerce by developing a WCF Service Application.
-
Query Sage 300 through ODBC in Node.js
Use node-odbc to execute SQL queries against Sage 300 from Node.js.
-
Process & Analyze MYOB AccountRight in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MYOB AccountRight .
-
How to connect to Blackbaud FE NXT from IntelliJ
Integrate connectivity to Blackbaud FE NXT with wizards in IntelliJ.
-
Visualize EnterpriseDB from Tableau
Use the Tableau Desktop business intelligence tool to connect to EnterpriseDB.
-
Query, Visualize, and Share live HCL Domino in Redash
Use CData Connect Cloud to connect to live HCL Domino in Redash for querying, visualizing, and sharing.
-
How to connect to Printify from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Printify and work with Printify in Microsoft Excel on Mac OS X.
-
How to connect to Jira in DBVisualizer
Integrate Atlassian Jira with visual data analysis tools and data connection wizards in DBVisualizer
-
Build QuickBooks Online Visualizations in Tableau Desktop
Use CData Connect Cloud to connect to live QuickBooks Online and build visualizations in Tableau.
-
Create a Data Access Object for Zoho Books using JDBI
A brief overview of creating a SQL Object API for Zoho Books in JDBI.
-
Integrate Real-Time Access to Epicor Kinetic in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Epicor Kinetic in real time.
-
Visualize Jira Service Management in TIBCO Spotfire through OData
Integrate Atlassian Jira Service Management into dashboards in TIBCO Spotfire.
-
Create Reports from Tableau CRM Analytics in Looker Studio
Use CData Connect Cloud to gain access to live Tableau CRM Analytics and create custom reports in Looker Studio.
-
How to Create Power BI Visual Reports with Real-Time SAS Data Sets
Use CData Power BI Connectors to visualize SAS Data Sets in Power BI.
-
Automated Continuous Pipedrive Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Pipedrive replication to Amazon Redshift.
-
Import Zoho Creator Using Azure Data Factory
Use CData Connect Cloud to connect to Zoho Creator from Azure Data Factory and import live Zoho Creator.
-
Prepare, Blend, and Analyze Spark in Alteryx Designer
Build workflows to access live Apache Spark SQL for self-service data analytics.
-
Export Data from SQL Server to LDAP through SSIS
Easily push SQL Server data to LDAP using the CData SSIS Tasks for LDAP.
-
How to work with Zoom in Apache Spark using SQL
Access and process Zoom in Apache Spark using the CData Software JDBC Driver.
-
How to integrate ClickUp with Apache Airflow
Access and process ClickUp in Apache Airflow using the CData JDBC Driver.
-
Build Charts with Oracle Sales in Clear Analytics
Create dynamic charts and perform analytics based on Oracle Sales in Clear Analytics.
-
How to Access Live Presto in Power Automate Desktop via ODBC
The CData ODBC Driver for Presto enables you to integrate Presto into workflows built using Microsoft Power Automate Desktop.
-
Replicate Aha for Use in Salesforce Connect
Replicate Aha! to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Work with Twilio in ETL Validator JDBC
Connect to Twilio from ETL Validator jobs using the CData Software JDBC Driver.
-
Query Exact Online in DataGrip
Create a Data Source for Exact Online in DataGrip and use SQL to query live Exact Online.
-
Access NetSuite Sales Orders in Dynamics CRM
Improve your sales team
-
Visualize CSV in Tableau
The CData ODBC driver for CSV enables you integrate CSV/TSV Files into Tableau dashboards.
-
Model SharePoint Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and SharePoint, enabling the direct import of real-time Microsoft SharePoint.
-
Build Dashboards with Office 365 in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Office 365 in Dundas BI.
-
Using AngularJS to Build Dynamic Web Pages with Couchbase
Use the CData Connect Server to create Couchbase OData feeds and build single-page applications with live Couchbase.
-
Visualize Live Access in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Access.
-
Choosing the Best Method to Connect Google Search to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Search from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Semantic Layer Views for SharePoint in APOS Live Data Gateway
Use the CData Connector for SharePoint in APOS Live Data Gateway to build Semantic Layer Views for Microsoft SharePoint.
-
Automated Continuous Neo4J Replication to SingleStore
Use CData Sync for automated, continuous, customizable Neo4J replication to SingleStore.
-
Connect to Amazon Marketplace in Aqua Data Studio
Access Amazon Marketplace from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Rapidly Develop SAS Data Sets-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 Google Contacts Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Contacts replication to IBM DB2.
-
Integrate with Oracle Sales using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Oracle Sales to a JSON file on disk.
-
Create Reports from YouTube Analytics in Looker Studio
Use CData Connect Cloud to gain access to live YouTube Analytics and create custom reports in Looker Studio.
-
Use JayDeBeApi to access Act-On in Python
Use standard Python scripting and the development environment of your choice to access live Act-On.
-
Connect to Snowflake from Crystal Reports
Use CData Connect Cloud to connect to and report on live Snowflake from Crystal Reports.
-
Connect to Reckon Accounts Hosted from a Connection Pool in Jetty
The Reckon Accounts Hosted JDBC Driver supports connection pooling: This article shows how to connect faster to Reckon Accounts Hosted from Web apps in Jetty.
-
Connect to Amazon DynamoDB from HeidiSQL
Use CData Connect Cloud to connect to and query live Amazon DynamoDB from HeidiSQL.
-
Natively Connect to EnterpriseDB in PHP
Create PHP applications on Linux/UNIX machines with connectivity to EnterpriseDB. Leverage the native support for ODBC in PHP.
-
How to connect to REST from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for REST and work with REST in Microsoft Excel on Mac OS X.
-
How to create Clio federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Clio in MySQL .
-
Load Azure Data Catalog to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure Data Catalog to a database.
-
Create xBase-Connected Visualizations in Klipfolio
Use CData Software Connect Server to connect to xBase from Klipfolio and build custom visualizations using live xBase.
-
Manage ConstantContact in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ConstantContact.
-
Load HCL Domino to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load HCL Domino to a database.
-
Stream Sugar CRM into Apache Kafka Topics
Access and stream Sugar CRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Adobe Commerce from Tableau
Use the Tableau Desktop business intelligence tool to connect to Adobe Commerce.
-
Build Apps with Live MySQL in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live MySQL into the Adalo platform and build custom mobile and web applications with real-time MySQL.
-
Build Zoho Projects-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live Zoho Projects and build Zoho Projects-connected web apps with Axios.
-
How to connect to Salesloft from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Salesloft and work with Salesloft in Microsoft Excel on Mac OS X.
-
Create Informatica Mappings From/To an ODBC Data Source for CouchDB
Create an ODBC connection to CouchDB in Informatica and browse and transfer Apache CouchDB.
-
Creating Sage Cloud Accounting-Connected Applications in Unqork
You can use CData Connect Cloud to feed Sage Business Cloud Accounting to Unqork and build custom business apps.
-
Access Reckon from MySQL in Amazon QuickSight
Connect to Reckon and build visualizations of Reckon using a MySQL Connection in Amazon QuickSight.
-
How to import Twitter Ads into Apache Solr
Use the CData Software JDBC Driver for Twitter Ads in Data Import Handler and create an automated import of Twitter Ads to Apache Solr Enterprise Search platform.
-
Access Live HubDB in AWS Lambda
Connect to live HubDB in AWS Lambda using the CData JDBC Driver.
-
Create Apps from Reckon Accounts Hosted in Qlik Sense Cloud
Use the CData Connect Server to create an OData API for Reckon Accounts Hosted and build apps from live Reckon Accounts Hosted in Qlik Sense Cloud.
-
Automated Continuous Wave Financial Replication to Oracle
Use CData Sync for automated, continuous, customizable Wave Financial replication to Oracle.
-
Use the CData Software ODBC Driver for Sybase in MicroStrategy Desktop
Connect to Sybase in MicroStrategy Desktop using the CData Software ODBC Driver for Sybase.
-
Connect to LinkedIn in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Import Real-Time SurveyMonkey in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SurveyMonkey in ColdFusion.
-
Automated Continuous Phoenix Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Phoenix replication to Apache Cassandra.
-
Build Semantic Layer Views for Phoenix in APOS Live Data Gateway
Use the CData Connector for Phoenix in APOS Live Data Gateway to build Semantic Layer Views for Apache Phoenix.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle Financials Cloud
Provide connectivity to Oracle Financials Cloud through an SAP BusinessObjects universe.
-
How to Visualize Greenhouse Data in Python with pandas
Use pandas and other modules to analyze and visualize live Greenhouse in Python.
-
Connect to Live Paylocity in PostGresSQL Interface through CData Connect Cloud
Create a live connection to Paylocity in CData Connect Cloud and connect to your Paylocity from PostgreSQL.
-
DataBind Controls to Odoo in C++Builder
DataBind to Odoo ERP in C++Builder with standard components and controls.
-
Connect to eBay Analytics from a Connection Pool in JBoss
Integrate eBay Analytics into Java servlets: Use the Management Console in JBoss to install the eBay Analytics JDBC Driver.
-
Integrate Zoho CRM into Power Automate Desktop using CData Connect
CData Connect for Zoho CRM enables you to integrate Zoho CRM into workflows built using Microsoft Power Automate Desktop.
-
Monday.com Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Monday.com facts in real time.
-
Using the CData Software ODBC Driver for Sage 300 in PyCharm
Connect to Sage 300 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sage 300.
-
How to connect Amazon QuickSight to DocuSign
Create a connection to DocuSign in CData Connect Cloud and insert DocuSign into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Snowflake in Ruby
Connect to Snowflake in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Zoho Inventory-Connected Visualizations in Klipfolio
Use CData Connect Cloud to connect to Zoho Inventory from Klipfolio and build custom visualizations using live Zoho Inventory.
-
Connect to Greenplum in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for Pivotal GreenPlum in Airbyte.
-
ETL JDBC-ODBC Bridge in Oracle Data Integrator
This article shows how to transfer JDBC-ODBC Bridge into a data warehouse using Oracle Data Integrator.
-
Connect to ServiceNow from a Connection Pool in WebLogic
Use the CData JDBC Driver for ServiceNow to connect to ServiceNow from Web applications running on WebLogic.
-
Access Live Salesforce Marketing in Excel (Desktop)
Use CData Connect Cloud to gain access to live Salesforce Marketing Cloud from your Excel spreadsheets.
-
Integrate Live NetSuite into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to NetSuite from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live NetSuite CRM & ERP.
-
Query xBase through ODBC in Node.js
Use node-odbc to execute SQL queries against xBase from Node.js.
-
Connect to Sage Cloud Accounting from PowerBuilder
This article demonstrates how to access Sage Business Cloud Accounting from PowerBuilder using the Sage Cloud Accounting JDBC Driver.
-
Automate ADP Replication to Couchbase
Use CData Sync to Customize and automate ADP replication to Couchbase.
-
Visualize Invoiced in Tableau Desktop (through CData Connect)
Create a virtual SQL Server database for Invoiced in CData Software Connect (or Connect Server) and build visualizations from live Invoiced in Tableau Desktop.
-
Connect to Spark from Filemaker Pro (Mac)
Use CData Connect Cloud to connect to and query live Apache Spark SQL from Filemaker Pro on Mac.
-
Access Live TigerGraph in Coginiti Pro
Connect to and query live TigerGraph from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to CouchDB in DBeaver
Use the CData ODBC Driver to connect to Apache CouchDB in DBeaver.
-
Query, Visualize, and Share live Bing Search Results in Redash
Use CData Connect Cloud to connect to live Bing Search in Redash for querying, visualizing, and sharing.
-
Feed Zoho Creator into FineReport
How to set Zoho Creator as a JDBC data source in FineReport.
-
PowerShell Scripting to Replicate CSV to MySQL
Write a simple PowerShell script to replicate CSV/TSV Files to a MySQL database.
-
Visualize Zoho CRM from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zoho CRM.
-
How to Create Power BI Visual Reports with Real-Time JSON Services
Use CData Power BI Connectors to visualize JSON in Power BI.
-
How to Access DocuSign Using Entity Framework
This article shows how to access DocuSign using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous ActiveCampaign Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to AlloyDB.
-
Creating OData-Connected Applications in Unqork
You can use CData Connect Cloud to feed OData to Unqork and build custom business apps.
-
Use Biml to Build SSIS Tasks to Replicate Sybase IQ to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sybase IQ to SQL Server.
-
Build Pipelines with Live Microsoft Dataverse in Google Cloud Data Fusion (via CData Connect Cloud)
Use CData Connect Cloud to connect to Microsoft Dataverse from Google Cloud Data Fusion, enabling the integration of live Microsoft Dataverse (CDS) into the building and management of effective data pipelines.