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
-
Using the CData Software ODBC Driver for Cvent in PyCharm
Connect to Cvent as an ODBC data source in PyCharm using the CData Software ODBC Driver for Cvent.
-
How to import Klipfolio into Apache Solr
Use the CData Software JDBC Driver for Klipfolio in Data Import Handler and create an automated import of Klipfolio to Apache Solr Enterprise Search platform.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Build Semantic Layer Views for SharePoint in APOS Live Data Gateway
Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Microsoft SharePoint.
-
How to connect to Twitter in DBVisualizer
Integrate Twitter with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Excel in the Pentaho Report Designer
Publish reports based on Microsoft Excel in the Pentaho BI tool.
-
Connect to Salesloft in Ruby
Connect to Salesloft in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Excel Online in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Rapidly Develop Impala-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.
-
Dynamics NAV Reporting in OBIEE with the Dynamics NAV JDBC Driver
Deploy the Dynamics NAV JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData ODBC Driver for Salesforce Pardot from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Salesforce Pardot to connect to Salesforce Pardot from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Salesforce Pardot in Excel.
-
Establish a Live Connection with LDAP Objects using Tableau Bridge
The CData ODBC Driver for LDAP enables you to integrate live LDAP into Tableau Cloud dashboards using the Tableau Bridge.
-
Stream SAP Concur into Apache Kafka Topics
Access and stream SAP Concur in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Publish Oracle Sales-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Oracle Sales.
-
Visualize Blackbaud FE NXT from Tableau
Use the Tableau Desktop business intelligence tool to connect to Blackbaud FE NXT.
-
Automated Continuous Zoho Creator Replication to Databricks
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Databricks.
-
Analyze JSON Services in Infragistics Reveal
Use the CData Connect Server to create an OData API on top of JSON and visualize live JSON in Ingragistics Reveal.
-
Access Live SAP HANA in Excel 365 Online (Excel for the web)
Connect to SAP HANA from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
Build PostgreSQL-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live PostgreSQL.
-
Visualize Highrise in Tableau
The CData ODBC driver for Highrise enables you integrate Highrise CRM into Tableau dashboards.
-
Create Klaviyo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Klaviyo data access from reports, embedded analytics, and more.
-
Visualize Authorize.Net in TIBCO Spotfire through OData
Integrate Authorize.Net into dashboards in TIBCO Spotfire.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoho Creator
Provide connectivity to Zoho Creator through an SAP BusinessObjects universe.
-
Creating CockroachDB-Connected Applications in Unqork
You can use CData Connect Cloud to feed CockroachDB to Unqork and build custom business apps.
-
How to Access Live Azure DevOps in Power Automate Desktop via ODBC
The CData ODBC Driver for Azure DevOps enables you to integrate Azure DevOps into workflows built using Microsoft Power Automate Desktop.
-
Integrate MongoDB in the Pentaho Report Designer
Publish reports based on MongoDB in the Pentaho BI tool.
-
Visualize Live Zoho Creator in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Zoho Creator.
-
Connect to Power BI XMLA in DBArtisan
Use wizards in DBArtisan to configure Power BI XMLA as a data source.
-
Connect to PostgreSQL from a Connection Pool in WebLogic
Use the CData JDBC Driver for PostgreSQL to connect to PostgreSQL from Web applications running on WebLogic.
-
Create Data Visualizations Based On PayPal in Mode
Use CData Connect Cloud to connect to PayPal from Mode and build visualizations using live
-
Using the CData Data Providers with the DevExpress Data Grid
The CData ADO.NET providers are standards-based libraries that can be used with various third-party components and tools. This article shows how to use the CData ADO.NET Provider for Salesforce with the DevExpress Chart Control.
-
Using the CData Software ODBC Driver for SAP Concur in PyCharm
Connect to SAP Concur as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP Concur.
-
Connect to MailChimp in Google Apps Script
Use the ODBC Driver for MailChimp and the SQL Gateway to access MailChimp from Google Apps Script.
-
Prepare, Blend, and Analyze TigerGraph in Alteryx Designer
Build workflows to access live TigerGraph for self-service data analytics.
-
Integrate with LinkedIn Ads in JReport Designer
Create charts and reports based on LinkedIn Ads in JReport Designer.
-
Build Gmail-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live Gmail and build Gmail-connected web apps with Axios.
-
Connect to Monday.com in JRuby
Create a simple JRuby app with access to live Monday.com.
-
Access Couchbase 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 Couchbase.
-
Create Datasets from TaxJar in Domo Workbench and Build Visualizations of TaxJar in Domo
Use the CData Software ODBC Driver for TaxJar to create datasets from TaxJar in Domo Workbench and then build visualizations in the Domo service.
-
Access Google Drive 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 Google Drive.
-
Automated GitHub Replication to Teradata
Use CData Sync to Customize and automate GitHub replication to Teradata.
-
Connect to Live Google Campaign Manager 360 in MicroStrategy through CData Connect Cloud
Create a live connection to Google Campaign Manager 360 in CData Connect Cloud and connect to your Google Campaign Manager 360 from MicroStrategy.
-
Provide OData Services of SAP from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP ERP/NetWeaver by developing a WCF Service Application.
-
Extract, Transform, and Load Marketo in Informatica PowerCenter
Create a simple Workflow for Marketo in Informatica PowerCenter.
-
How to connect to Microsoft Exchange with Squirrel SQL client
Connect to Microsoft Exchange and execute queries in the Squirrel SQL Client.
-
Use Dash to Build to Web Apps on Excel
Create Python applications that use pandas and Dash to build Excel-connected web apps.
-
Bidirectional Access to SAP Ariba Source from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Ariba Source in Filemaker Pro for Mac or Windows.
-
Connect to ConstantContact in RapidMiner
Integrate ConstantContact with standard components and data source configuration wizards in RapidMiner Studio.
-
DataBind SAP BusinessObjects BI to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for SAP BusinessObjects BI with the DevExpress Windows Forms and Web controls to provide SAP BusinessObjects BI to a chart.
-
Access Live Oracle SCM in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle SCM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Asana as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live Asana.
-
Model, Search, and Visualize Live Jira Service Management in ThoughtSpot
Use CData Connect Cloud to connect to live Atlassian Jira Service Management for modeling, searching, and visualizing.
-
Build Semantic Layer Views for MySQL in APOS Live Data Gateway
Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for MySQL.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Shippo
Provide connectivity to Shippo through an SAP BusinessObjects universe.
-
Visualize CouchDB in TIBCO Spotfire through ADO.NET
Integrate Apache CouchDB into dashboards in TIBCO Spotfire.
-
Explore Geographical Relationships in Zoho Creator with Power Map
Create data visualizations with Zoho Creator in Power Map.
-
Connect to Google Cloud Storage in SpagoBI
Create reports featuring live Google Cloud Storage in SpagoBI Studio. Host Google Cloud Storage reports on SpagoBI Server.
-
How to connect PolyBase to Drip
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Drip.
-
Automated Continuous Sage 200 Replication to SQLite
Use CData Sync for automated, continuous, customizable Sage 200 replication to SQLite.
-
Connect to Couchbase in the Denodo Platform
Use CData driver technologies to create a virtual data source for Couchbase in the Denodo Virtual DataPort Administrator.
-
DataBind Act-On to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Act-On with the DevExpress Windows Forms and Web controls to provide Act-On to a chart.
-
Use Dash to Build to Web Apps on Sage Cloud Accounting
Create Python applications that use pandas and Dash to build Sage Cloud Accounting-connected web apps.
-
How to Work with DocuSign in ETL Validator JDBC
Connect to DocuSign from ETL Validator jobs using the CData Software JDBC Driver.
-
Validate Azure DevOps with QuerySurge
Access and validate Azure DevOps in QuerySurge using the CData JDBC Driver.
-
Import Real-Time Okta in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Okta in ColdFusion.
-
Use Dash to Build to Web Apps on Jira
Create Python applications that use pandas and Dash to build Jira-connected web apps.
-
Connect to ServiceNow in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for ServiceNow and connect to ServiceNow in Akorbi Digital RunMyProcess.
-
Build Visualizations of DocuSign in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of DocuSign in Birst.
-
Create Airtable Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Bing Search Replication to Databricks
Use CData Sync for automated, continuous, customizable Bing Search replication to Databricks.
-
Replicate Tableau CRM Analytics to Multiple Databases
Replicate Tableau CRM Analytics to disparate databases with a point-and-click configuration.
-
Operational Reporting on SAS Data Sets from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAS Data Sets.
-
Connect to Microsoft Dataverse in Google Apps Script
Use the ODBC Driver for Microsoft Dataverse and the SQL Gateway to access Microsoft Dataverse (CDS) from Google Apps Script.
-
Design BIRT Reports on Wave Financial
Provide current Wave Financial to your embedded analytics.
-
Automated Continuous Jira Service Management Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Jira Service Management replication to IBM DB2.
-
Configure the CData JDBC Driver for Pinterest in a Connection Pool in Tomcat
Connect to Pinterest from a connection pool in Tomcat.
-
Connect to GraphQL in HULFT Integrate
Connect to GraphQL as a JDBC data source in HULFT Integrate
-
How to connect to Databricks from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Databricks and work with Databricks in Microsoft Excel on Mac OS X.
-
How to Connect DBeaver to Wave Financial via a JDBC Driver
Manage Wave Financial with visual tools in DBeaver like the query browser.
-
Connect to Microsoft Project from PowerBuilder
This article demonstrates how to access Microsoft Project from Appeon PowerBuilder using the CData ADO.NET Provider for Microsoft Project.
-
Use the CData Software ODBC Driver for SuiteCRM in MicroStrategy Desktop
Connect to SuiteCRM in MicroStrategy Desktop using the CData Software ODBC Driver for SuiteCRM.
-
Use the CData ODBC Driver for Monday.com in Microsoft Power Query
You can use the CData Monday.com ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Monday.com into Microsoft Power Query.
-
PowerShell Scripting to Replicate SFTP to MySQL
Write a simple PowerShell script to replicate SFTP to a MySQL database.
-
Creating ServiceNow-Connected Applications in Unqork
You can use CData Connect Cloud to feed ServiceNow to Unqork and build custom business apps.
-
Query, Visualize, and Share live Salesforce Pardot in Redash
Use CData Connect Cloud to connect to live Salesforce Pardot in Redash for querying, visualizing, and sharing.
-
Integrate with JSON Services using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy JSON to a JSON file on disk.
-
How to Connect the Power BI Service to RSS: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
How to Work with IBM Cloud Data Engine in AWS Glue Jobs Using JDBC
Connect to IBM Cloud Data Engine from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Live Cassandra in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Apache Cassandra.
-
Automate Act CRM Replication to Azure Data Lake
Use CData Sync to customize and automate Act CRM replication to Azure Data Lake.
-
Publish Unbounce-Connected Dashboards in Tableau Server
Use CData JDBC drivers and Tableau Server to visualize live Unbounce.
-
Connect to ShipStation in NetBeans
Connect to ShipStation in NetBeans with the data source configuration wizard.
-
Visualize HBase in TIBCO Spotfire through OData
Integrate Apache HBase into dashboards in TIBCO Spotfire.
-
Query NetSuite in DataGrip
Create a Data Source for NetSuite in DataGrip and use SQL to query live NetSuite CRM & ERP.
-
Connect to OneNote from AWS Glue
Use CData Connect Cloud to gain access to live Microsoft OneNote from your AWS Glue jobs.
-
Visualize Sage Cloud Accounting in TIBCO Spotfire through OData
Integrate Sage Business Cloud Accounting into dashboards in TIBCO Spotfire.
-
Creating Smartsheet-Connected Applications in Unqork
You can use CData Connect Cloud to feed Smartsheet to Unqork and build custom business apps.
-
Access Square from MySQL in PHP
Connect to Square through the standard MySQL libraries in PHP.
-
Visualize Twilio in Tableau
The CData ODBC driver for Twilio enables you integrate Twilio into Tableau dashboards.
-
Connect to Phoenix from PowerBuilder
This article demonstrates how to access Apache Phoenix from PowerBuilder using the Phoenix JDBC Driver.