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
-
Integrate Confluence with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Confluence with External Services.
-
Connect to and Visualize Live Elasticsearch in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Elasticsearch.
-
Use the CData ODBC Driver for REST from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for REST to connect to REST from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring REST in Excel.
-
Visualize Live Dynamics CRM in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live Microsoft Dynamics CRM into custom reports in Power BI.
-
View Reports on Real-Time Spark in Power BI Report Server
Use the CData ODBC Driver for Spark to visualize Apache Spark SQL in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Sage Intacct as an External Source in Dremio
Use the CData JDBC Driver to connect to Sage Intacct as an External Source in Dremio.
-
Query Salesforce Pardot as a MySQL Database in Node.js
Execute MySQL queries against Salesforce Pardot from Node.js.
-
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.
-
Replicate Klaviyo from PowerShell
Write a quick PowerShell script to query Klaviyo. Use connectivity to the live data to replicate Klaviyo to SQL Server.
-
Access JSON Services in PHP through Connect Server
Connect to JSON through the standard SQL Server libraries in PHP.
-
Install a Microsoft Excel Add-In Manually
Some Microsoft Excel users may need to follow these steps to manually add the CData Excel Add-In formulas, enabling you to execute your own database queries.
-
Create Reports with Greenplum in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pivotal GreenPlum.
-
Build Shopify Visualizations in Tableau Desktop
Use CData Connect Cloud to connect to live Shopify and build visualizations in Tableau.
-
Automated Continuous QuickBooks Replication to Azure SQL
Use CData Sync for automated, continuous, customizable QuickBooks replication to Azure SQL.
-
Excel Spreadsheet Automation with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software JDBC Driver for Wave Financial in MicroStrategy
Connect to Wave Financial in MicroStrategy Developer using the CData Software JDBC Driver for Wave Financial.
-
Connect to HDFS in NetBeans
Connect to Apache HDFS in NetBeans with the data source configuration wizard.
-
Connect to Facebook from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Facebook using standard SQL.
-
Connect to Microsoft Planner in HULFT Integrate
Connect to Microsoft Planner as a JDBC data source in HULFT Integrate
-
Establish a Live Connection with Outreach.io using Tableau Bridge
The CData ODBC Driver for Outreach.io enables you to integrate live Outreach.io into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Google Calendar Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Calendar replication to MySQL.
-
Import SAP HANA XS Advanced into FileMaker Pro
Create reports that integrate SAP HANA XS Advanced in Filemaker Pro.
-
How to Connect DBeaver to PostgreSQL via a JDBC Driver
Manage PostgreSQL with visual tools in DBeaver like the query browser.
-
Automated Continuous MongoDB Replication to MySQL
Use CData Sync for automated, continuous, customizable MongoDB replication to MySQL.
-
Extract, Transform, and Load Avalara AvaTax in Informatica PowerCenter
Create a simple Workflow for Avalara AvaTax in Informatica PowerCenter.
-
How to pipe IBM Cloud Data Engine to CSV in PowerShell
Use standard PowerShell cmdlets to access IBM Cloud Data Engine tables.
-
Provide OData Services of ConstantContact from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ConstantContact by developing a WCF Service Application.
-
Access Live Oracle HCM Cloud in Coginiti Pro
Connect to and query live Oracle HCM Cloud from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Informatica Mappings From/To a JDBC Data Source for Sage 50 UK
Create Sage 50 UK data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Data Visualizations Based On LinkedIn in Mode
Use CData Connect Cloud to connect to LinkedIn from Mode and build visualizations using live
-
Automated Continuous Amazon S3 Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Amazon S3 replication to IBM DB2.
-