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
-
Visualize Monday.com in TIBCO Spotfire through OData
Integrate Monday.com into dashboards in TIBCO Spotfire.
-
Create Splunk-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to Splunk from OutSystems and build custom enterprise apps using live Splunk.
-
Access Zoho CRM from MySQL in Amazon QuickSight
Connect to Zoho CRM and build visualizations of Zoho CRM using a MySQL Connection in Amazon QuickSight.
-
Analyze Dynamics 365 in Cognos Analytics
Use CData Connect Cloud to connect to Dynamics 365 from Cognos Analytics and analyze live Microsoft Dynamics 365.
-
Create SAP Business One Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Raisers Edge NXT in TIBCO Spotfire through ADO.NET
Integrate Raisers Edge NXT into dashboards in TIBCO Spotfire.
-
Import and Visualize Jira Assets in Power View
Create data visualizations based on Jira Assets in Excel.
-
Create Informatica Mappings From/To a JDBC Data Source for Calendly
Create Calendly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
DataBind Power BI XMLA to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Power BI XMLA with the DevExpress Windows Forms and Web controls to provide Power BI XMLA to a chart.
-
Integrate Live Unbounce into Custom Business Apps Built in Power Apps
Use CData Software Connect Server to create a virtual SQL Server Database for Unbounce and integrate live Unbounce into apps built in Microsoft Power Apps.
-
Access Live xBase in AWS Lambda
Connect to live xBase in AWS Lambda using the CData JDBC Driver.
-
Analyze Google Search Results in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of Google Search and visualize Google Search in SAP Analytics Cloud.
-
Configure the CData JDBC Driver for SQL Analysis Services in a Connection Pool in Tomcat
Connect to SQL Analysis Services from a connection pool in Tomcat.
-
Import OData Services Using Azure Data Factory
Use CData Connect Cloud to connect to OData Services from Azure Data Factory and import live OData.
-
Automated Continuous Dynamics 365 Business Central Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Microsoft Access.
-
Create Azure Active Directory Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Azure Active Directory data access from reports, embedded analytics, and more.
-
Klaviyo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Klaviyo facts in real time.
-
Natively Connect to SendGrid in PHP
Create PHP applications on Linux/UNIX machines with connectivity to SendGrid. Leverage the native support for ODBC in PHP.
-
LINQ to Act CRM
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 Act CRM Data Provider.
-
Use the CData Software ODBC Driver for Jira in MicroStrategy
Connect to Atlassian Jira in MicroStrategy Developer using the CData Software ODBC Driver for Jira.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Connect to Active Directory from a Connection Pool in JBoss
Integrate Active Directory into Java servlets: Use the Management Console in JBoss to install the Active Directory JDBC Driver.
-
Automated Sage Cloud Accounting Replication to Teradata
Use CData Sync to Customize and automate Sage Business Cloud Accounting replication to Teradata.
-
Integrate with SAP HANA in JReport Designer
Create charts and reports based on SAP HANA in JReport Designer.
-
How to Access Microsoft Exchange Using Entity Framework
This article shows how to access Microsoft Exchange using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Enable the eBay Analytics JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with eBay Analytics.
-
How to Connect to & Open Couchbase in Microsoft Excel
This article uses the CData ODBC driver for Couchbase to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Replicate MariaDB from PowerShell
Write a quick PowerShell script to query MariaDB. Use connectivity to the live data to replicate MariaDB to SQL Server.
-
Create SSAS Tabular Models from Marketo
How to build a SQL Server Analysis Service Tabular Model from Marketo using CData drivers.
-
How to create SingleStore federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SingleStore in MySQL .
-
Create WordPress Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time WordPress data access from reports, embedded analytics, and more.
-
Use JayDeBeApi to access Procore in Python
Use standard Python scripting and the development environment of your choice to access live Procore.
-
Connect to Azure DevOps in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Azure DevOps and connect to Azure DevOps in Akorbi Digital RunMyProcess.
-
Connect to NetSuite in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Enable the Redshift JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Amazon Redshift.
-
Use JayDeBeApi to access Google Spanner in Python
Use standard Python scripting and the development environment of your choice to access live Google Spanner.
-
Use the CData Software JDBC Driver for Klaviyo in MicroStrategy Web
Connect to Klaviyo in MicroStrategy Web using the CData Software JDBC Driver for Klaviyo.
-
Publish Cvent-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Cvent.
-
Automated Continuous Zoom Replication to Azure SQL
Use CData Sync for automated, continuous, customizable Zoom replication to Azure SQL.
-
Build Charts with Zoho Books in Clear Analytics
Create dynamic charts and perform analytics based on Zoho Books in Clear Analytics.
-
Create Shippo-Connected Visualizations in Klipfolio
Use CData Software Connect Server to connect to Shippo from Klipfolio and build custom visualizations using live Shippo.
-
Object-Relational Mapping (ORM) with JDBC-ODBC Bridge Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to JDBC-ODBC Bridge into a Java-based ORM framework, Hibernate.
-
Query SQL Analysis Services through ODBC in Node.js
Use node-odbc to execute SQL queries against SQL Analysis Services from Node.js.
-
Establish a Live Connection with Adobe Commerce using Tableau Bridge
The CData ODBC Driver for Adobe Commerce enables you to integrate live Adobe Commerce into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Shopify Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Shopify replication to Apache Kafka.
-
Integrate Procore in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Procore from Informatica Cloud.
-
How to import Oracle Eloqua into Apache Solr
Use the CData Software JDBC Driver for Oracle Eloqua in Data Import Handler and create an automated import of Oracle Eloqua to Apache Solr Enterprise Search platform.
-
Create SSAS Tabular Models from Slack
How to build a SQL Server Analysis Service Tabular Model from Slack using CData drivers.
-
Establish a Live Connection with Pinterest using Tableau Bridge
The CData ODBC Driver for Pinterest enables you to integrate live Pinterest into Tableau Cloud dashboards using the Tableau Bridge.
-
Create Oracle Sales-Connected Business Apps in AppSheet
Connect to Oracle Sales via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Oracle Sales.
-
How to Build Dynamic React Apps with Amazon DynamoDB
Use the CData Connect and React to Build Dynamic Web Apps with Live Amazon DynamoDB .
-
Integrate with Live Square in MuleSoft (via CData Connect Cloud)
Use CData Connect Cloud to connect to Square from the MuleSoft Anypoint Platform to integrate live Square into custom reports and dashboards.
-
Query Marketo through ODBC in Node.js
Use node-odbc to execute SQL queries against Marketo from Node.js.
-
LINQ to Greenhouse
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 Greenhouse Data Provider.
-
Access Sage 200 in PHP through Connect Server
Connect to Sage 200 through the standard SQL Server libraries in PHP.
-
How to Create Power BI Visual Reports with Real-Time JotForm
Use CData Power BI Connectors to visualize JotForm in Power BI.
-
Create SSAS Tabular Models from DocuSign
How to build a SQL Server Analysis Service Tabular Model from DocuSign using CData drivers.
-
Establish a Live Connection with Teradata using Tableau Bridge
The CData ODBC Driver for Teradata enables you to integrate live Teradata into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Cosmos DB in TIBCO Spotfire through OData
Integrate Azure Cosmos DB into dashboards in TIBCO Spotfire.
-
Create Dynamic Reckon Accounts Hosted Grids Using the Infragistics XamDataGrid
Learn how you can connect Reckon Accounts Hosted to Infragistics XamDataGrid to build dynamic grids.
-
Automate Paylocity Replication to SAP HANA
Use CData Sync to customize and automate Paylocity replication to SAP HANA.
-
Create Slack-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to Slack from OutSystems and build custom enterprise apps using live Slack.
-
Import Real-Time Databricks in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Databricks in ColdFusion.
-
Using AngularJS to Build Dynamic Web Pages with Oracle Financials Cloud
Use the CData Connect Server to create Oracle Financials Cloud OData feeds and build single-page applications with live Oracle Financials Cloud.
-
How to use SQLAlchemy ORM to access Adobe Commerce in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Adobe Commerce.
-
Use the CData Software JDBC Driver for Certinia in MicroStrategy
Connect to Certinia in MicroStrategy Developer using the CData Software JDBC Driver for Certinia.
-
Choosing the Best Method to Connect Avalara AvaTax to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Avalara AvaTax from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to and Query Basecamp in QlikView over ODBC
Create data visualizations with Basecamp in QlikView.
-
Build Pipelines with Live MySQL in Google Cloud Data Fusion (via CData Connect Cloud)
Use CData Connect Cloud to connect to MySQL from Google Cloud Data Fusion, enabling the integration of live MySQL into the building and management of effective data pipelines.
-
Integrate Google Ads into Automated Tasks with Power Automate
Use CData Connect Cloud to connect to Google Ads and integrate live Google Ads into your Power Automate tasks.
-
Create Data Visualizations Based On Airtable in Mode
Use CData Connect Cloud to connect to Airtable from Mode and build visualizations using live
-
Replicate Square to Multiple Databases
Replicate Square to disparate databases with a point-and-click configuration.
-
Access Acumatica in PHP through Connect Server
Connect to Acumatica through the standard SQL Server libraries in PHP.
-
Connect to Klaviyo in RazorSQL
Connect to Klaviyo from wizards and query Klaviyo from the GUI in the RazorSQL database management tool.
-
Connect to Google Data Catalog from a Connection Pool in JBoss
Integrate Google Data Catalog into Java servlets: Use the Management Console in JBoss to install the Google Data Catalog JDBC Driver.
-
A PostgreSQL Interface for Google Calendar
Use the Remoting features of the Google Calendar ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Act CRM in TIBCO Spotfire through ADO.NET
Integrate Act CRM into dashboards in TIBCO Spotfire.
-
Connect to Twilio from PowerBuilder
This article demonstrates how to access Twilio from Appeon PowerBuilder using the CData ADO.NET Provider for Twilio.
-
Automated Continuous Facebook Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Facebook replication to Google Cloud SQL.
-
Automated Continuous Dynamics NAV Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Google BigQuery.
-
Connect to Invoiced from a Connection Pool in Jetty
The Invoiced JDBC Driver supports connection pooling: This article shows how to connect faster to Invoiced from Web apps in Jetty.
-
Create Dynamic Google Data Catalog Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Data Catalog to Infragistics XamDataGrid to build dynamic grids.
-
DataBind Wijmo Grid to Snowflake
Provide real-time Snowflake to interactive controls.
-
How to Query Live Instagram Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Instagram data in natural language using Python.
-
Create SSAS Tabular Models from Kintone
How to build a SQL Server Analysis Service Tabular Model from Kintone using CData drivers.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Create Apps from SAP SuccessFactors in Qlik Sense Cloud
Use CData Connect Cloud to connect to SAP SuccessFactors and build apps from live SAP SuccessFactors in Qlik Sense Cloud.
-
How to integrate Metabase with SAP SuccessFactors
Use CData Connect Cloud to connect to live SAP SuccessFactors and create an interactive dashboard in Metabase from SAP SuccessFactors.
-
Automated Continuous Acumatica Replication to SQLite
Use CData Sync for automated, continuous, customizable Acumatica replication to SQLite.
-
Access Live Google Contacts in Google Sheets
Use CData Connect Cloud to gain access to live Google Contacts from your Google Sheets.
-
Connect to JSON Services from a Connection Pool in JBoss
Integrate JSON into Java servlets: Use the Management Console in JBoss to install the JSON JDBC Driver.
-
Access Microsoft Dataverse from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Dataverse (CDS) from HeidiSQL.
-
Build an OLAP Cube in SSAS from Bitbucket
Establish a connection to Bitbucket data from SQL Server Analysis Services, and use the Bitbucket Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Excel Online Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Excel Online replication to AlloyDB.
-
Publish SendGrid-Connected Dashboards in Tableau Server
Use CData JDBC drivers and Tableau Server to visualize live SendGrid.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sage Intacct
Provide connectivity to Sage Intacct through an SAP BusinessObjects universe.
-
Connect to and Query Harvest in QlikView over ODBC
Create data visualizations with Harvest in QlikView.
-
Automated Continuous Vertica Replication to Oracle
Use CData Sync for automated, continuous, customizable Vertica replication to Oracle.
-
Build Visualizations of Cvent in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Cvent in Birst.