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
-
Process & Analyze Instagram in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Instagram .
-
Automated Continuous Microsoft Dataverse Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Amazon S3.
-
Integrate Phoenix with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Phoenix with External Services.
-
Automated SAP HANA Replication to Teradata
Use CData Sync to Customize and automate SAP HANA replication to Teradata.
-
Connect to SurveyMonkey from Asprova with CData Software ODBC Driver for SurveyMonkey
This article shows how to connect faster to SurveyMonkey data from Asprova.
-
How to Use a Microsoft Access Database to Update Blackbaud FE NXT in Real Time
Update Blackbaud FE NXT data by creating a linked table in Microsoft Access with the CData Blackbaud FE NXT ODBC Driver.
-
Build a Simple VCL Application for EnterpriseDB
How to build a simple VCL Application to view EnterpriseDB in RAD Studio using the CData ODBC Driver for EnterpriseDB.
-
Automated Continuous Facebook Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Facebook replication to Apache Kafka.
-
Automated Continuous ADP Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ADP replication to Google Cloud SQL.
-
Integrate Real-Time Access to Zoho Projects in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zoho Projects in real time.
-
SendGrid Reporting in OBIEE with the SendGrid JDBC Driver
Deploy the SendGrid JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to work with Reckon in Apache Spark using SQL
Access and process Reckon in Apache Spark using the CData Software JDBC Driver.
-
Perform Batch Operations with Reckon Accounts Hosted in Apache NiFi
Connect to Reckon Accounts Hosted and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automate OneNote Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft OneNote from PowerShell? This article demonstrates how to utilize the OneNote Cmdlets for tasks like connecting to Microsoft OneNote, automating operations, downloading data, and more.
-
Integrate with live Trello in Jitterbit
Use CData Connect Cloud to connect to and integrate live Trello in Jitterbit.
-
How to load JSON data into Elasticsearch via Logstash
Introducing a simple method to load JSON data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Oracle Financials Cloud Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle Financials Cloud through CData Connect Cloud using different applications and tools.
-
Replicate Multiple Splunk Accounts
Replicate multiple Splunk accounts to one or many databases.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Jira
Provide connectivity to Atlassian Jira through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for Paylocity in MicroStrategy Web
Connect to Paylocity in MicroStrategy Web using the CData Software ODBC Driver for Paylocity.
-
Build Interactive Dashboards from Reckon in Amazon QuickSight
Create a virtual SQL Server database for Reckon in CData Software Connect Server and import Reckon into Amazon QuickSight SPICE to build interactive dashboards.
-
Access Live Instagram in Excel 365 Online (Excel for the web)
Connect to Instagram from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
Build OData-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live OData and build OData-connected web apps with Axios.
-
Automated Continuous Azure Synapse Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Google Cloud SQL.
-
Connect to SAS Data Sets from Asprova with CData Software ODBC Driver for SAS Data Sets
This article shows how to connect faster to SAS Data Sets data from Asprova.
-
Visualize Live SAP HANA in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live SAP HANA into custom reports in Power BI.
-
Query Dynamics 365 Business Central in DataGrip
Create a Data Source for Dynamics 365 Business Central in DataGrip and use SQL to query live Dynamics 365 Business Central.
-
Build Visualizations of SAP HANA XS Advanced in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP HANA XS Advanced in Birst.
-
Integrate with Aha using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Aha! to a JSON file on disk.
-
Connect to Act CRM in DBArtisan
Use wizards in DBArtisan to configure Act CRM as a data source.
-
Integrate Live Adobe Analytics into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to Adobe Analytics from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Adobe Analytics.
-
Automated Continuous Veeva Replication to Snowflake
Use CData Sync for automated, continuous, customizable Veeva replication to Snowflake.
-
Use the CData SSIS Components to Insert New or Update Existing Jira Service Management Records from SQL Server
Easily push SQL Server data to Jira Service Management using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Jira Service Management or update existing records with data from a SQL Server database.
-
Create Informatica Mappings From/To a JDBC Data Source for Active Directory
Create Active Directory data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to use SQLAlchemy ORM to access OneNote in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft OneNote.
-
Integrate API into Power Automate Desktop using CData Connect
CData Connect for API enables you to integrate API into workflows built using Microsoft Power Automate Desktop.
-
Import Real-Time HubDB in ColdFusion to Build Applications
Use CData ODBC drivers to import and use HubDB in ColdFusion.
-
A PostgreSQL Interface for Microsoft Planner
Use the Remoting features of the Microsoft Planner JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Live Salesloft in Power Automate Desktop via ODBC
The CData ODBC Driver for Salesloft enables you to integrate Salesloft into workflows built using Microsoft Power Automate Desktop.
-
Connect to Live Wave Financial in MicroStrategy through CData Software Connect Server
Create a virtual database for Wave Financial in CData Software Connect Server and connect to it from MicroStrategy.
-
How to connect to PayPal with Squirrel SQL client
Connect to PayPal and execute queries in the Squirrel SQL Client.
-
Connect to Slack from Filemaker Pro (Mac)
Use CData Connect Cloud to connect to and query live Slack from Filemaker Pro on Mac.
-
Perform Batch Operations with Quickbase in Apache NiFi
Connect to Quickbase and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to connect to Wave Financial from Spring Boot
Connect to Wave Financial in a Spring Boot Application using CData JDBC Wave Financial Driver
-
Prepare, Blend, and Analyze Phoenix in Alteryx Designer
Build workflows to access live Apache Phoenix for self-service data analytics.
-
Connect to Pinterest in Ruby
Connect to Pinterest in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Interactive Dashboards from Google Drive in Amazon QuickSight
Create a virtual SQL Server database for Google Drive in CData Software Connect Server and import Google Drive into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Query Live Outreach.io Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Outreach.io data in natural language using Python.
-
How to connect to Harvest from Spring Boot
Connect to Harvest in a Spring Boot Application using CData JDBC Harvest Driver
-
Automated Continuous Raisers Edge NXT Replication to SQL Server
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to SQL Server.
-
Create Salesloft Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create AlloyDB-Connected Nintex Workflows
Use CData Connect Cloud to connect to AlloyDB from Nintex Workflow Cloud and build custom workflows using live Google AlloyDB.
-
Visualize Live Instagram in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Instagram.
-
Visualize Google Directory from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Directory.
-
Create Reports from Paylocity in Looker Studio
Use CData Connect Cloud to gain access to live Paylocity and create custom reports in Looker Studio.
-
Amazon Marketplace Reporting in OBIEE with the Amazon Marketplace JDBC Driver
Deploy the Amazon Marketplace JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to publish and share Confluence dashboards with Tableau Server
The CData ODBC driver for Confluence enables you integrate Atlassian Confluence into Tableau dashboards.
-
How to Connect the Power BI Service to Azure Data Catalog: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Connect to Highrise in Aqua Data Studio
Access Highrise CRM from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Couchbase-Connected Apps in Bubble
Use CData Connect Cloud to create an OData feed for Couchbase and create custom apps in Bubble.
-
Visualize Active Directory from Tableau
Use the Tableau Desktop business intelligence tool to connect to Active Directory.
-
Natively Connect to HarperDB in PHP
Create PHP applications on Linux/UNIX machines with connectivity to HarperDB. Leverage the native support for ODBC in PHP.
-
Build a Simple VCL Application for CockroachDB
How to build a simple VCL Application to view CockroachDB in RAD Studio using the CData ODBC Driver for CockroachDB.
-
How to connect PolyBase to Azure Synapse
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Azure Synapse.
-
DataBind Charts to Greenhouse
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Greenhouse 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.
-
DataBind Okta to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Okta with the DevExpress Windows Forms and Web controls to provide Okta to a chart.
-
Create Act CRM Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Act CRM data access from reports, embedded analytics, and more.
-
A PostgreSQL Interface for Dynamics NAV
Use the SQL Gateway and Dynamics NAV ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to EnterpriseDB in RazorSQL
Connect to EnterpriseDB from wizards and query EnterpriseDB from the GUI in the RazorSQL database management tool.
-
How to use SQLAlchemy ORM to access ADP in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ADP.
-
Design BIRT Reports on Oracle
Provide current Oracle Database to your embedded analytics.
-
Query EventBrite in ColdFusion
Write standard ColdFusion data access code to connect to Eventbrite.
-
How to Use a Microsoft Access Database to Update Sage Cloud Accounting in Real Time
Update Sage Cloud Accounting data by creating a linked table in Microsoft Access with the CData Sage Cloud Accounting ODBC Driver.
-
Integrate with Clio using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Clio to a JSON file on disk.
-
Automated Continuous DB2 Replication to Vertica
Use CData Sync for automated, continuous, customizable DB2 replication to Vertica.
-
Configure the CData JDBC Driver for Microsoft OneDrive in a Connection Pool in Tomcat
Connect to Microsoft OneDrive from a connection pool in Tomcat.
-
Model, Search, and Visualize Live CockroachDB in ThoughtSpot
Use CData Connect Cloud to connect to live CockroachDB for modeling, searching, and visualizing.
-
Use the CData Software JDBC Driver for IBM Cloud Object Storage in MicroStrategy
Connect to IBM Cloud Object Storage in MicroStrategy Developer using the CData Software JDBC Driver for IBM Cloud Object Storage.
-
Visualize Live Adobe Commerce of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Adobe Commerce using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software JDBC Driver for Pipedrive in MicroStrategy Desktop
Connect to Pipedrive in MicroStrategy Desktop using the CData Software JDBC Driver for Pipedrive.
-
Connect to Bing Ads in Google Apps Script
Use the ODBC Driver for Bing Ads and the SQL Gateway to access Bing Ads from Google Apps Script.
-
Provide OData Services of TaxJar from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for TaxJar by developing a WCF Service Application.
-
Import Avro into FileMaker Pro
Create reports that integrate Apache Avro in Filemaker Pro.
-
Use the CData Software JDBC Driver for SAP Ariba Source in MicroStrategy Desktop
Connect to SAP Ariba Source in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Ariba Source.
-
Create Harvest-Connected Visualizations in Klipfolio
Use CData Software Connect Server to connect to Harvest from Klipfolio and build custom visualizations using live Harvest.
-
Manage MarkLogic in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for MarkLogic.
-
Replicate Multiple NetSuite Accounts
Replicate multiple NetSuite accounts to one or many databases.
-
Build an OLAP Cube in SSAS from Oracle HCM Cloud
Establish a connection to Oracle HCM Cloud data from SQL Server Analysis Services, and use the Oracle HCM Cloud Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate BigCommerce from PowerShell
Write a quick PowerShell script to query BigCommerce. Use connectivity to the live data to replicate BigCommerce to SQL Server.
-
Connect to BigQuery from PowerBuilder
This article demonstrates how to use the CData ODBC Driver for BigQuery to connect to Google BigQuery and execute queries in PowerBuilder.
-
How to connect to Kafka with Squirrel SQL client
Connect to Apache Kafka and execute queries in the Squirrel SQL Client.
-
Connect to Epicor Kinetic as an External Data Source using PolyBase
Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Epicor Kinetic.
-
Phoenix Reporting in OBIEE with the Phoenix JDBC Driver
Deploy the Phoenix JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Salesloft from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Salesloft from HeidiSQL.
-
Create DocuSign-Connected Visualizations in Klipfolio
Use CData Connect Cloud to connect to DocuSign from Klipfolio and build custom visualizations using live DocuSign.
-
Connect to AlloyDB from HeidiSQL
Use CData Connect Cloud to connect to and query live Google AlloyDB from HeidiSQL.
-
Create Instagram Dashboards in Bold BI
Use CData Software Connect Server to create a virtual SQL Server Database for Instagram to build custom dashboards in Bold BI.
-
Automated Continuous Outreach.io Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Outreach.io replication to AlloyDB.
-
Use the CData Software ODBC Driver for Access in MicroStrategy Desktop
Connect to Microsoft Access in MicroStrategy Desktop using the CData Software ODBC Driver for Access.
-
Write a Simple Go Application to work with LDAP Objects on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to LDAP.