CData Software - Knowledge Base
Recent Articles
-
Visualize Live Procore in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Procore.
-
View Reports on Real-Time Oracle Financials Cloud in Power BI Report Server
Use the CData ODBC Driver for Oracle Financials Cloud to visualize Oracle Financials Cloud in Power BI Desktop and then publish them to Power BI Report Server.
-
Import ServiceNow into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access ServiceNow. In this article, you will use the OData format to import ServiceNow into Microsoft Power Query.
-
Build Dashboards with ShipStation in DBxtra
Create dynamic dashboards and perform analytics based on ShipStation in DBxtra.
-
Connect to LinkedIn from Crystal Reports
Use CData Connect AI to connect to and report on live LinkedIn from Crystal Reports.
-
Create Data Visualizations Based On Zendesk in Mode
Use CData Connect AI to connect to Zendesk from Mode and build visualizations using live
-
Analyze SAP HANA XS Advanced with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP HANA XS Advanced from Power Pivot. You will use the Table Import Wizard to load SAP HANA XS Advanced. You can visually build the import query or use any SQL supported by the driver.
-
ConstantContact Reporting in OBIEE with the ConstantContact JDBC Driver
Deploy the ConstantContact JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated eBay Analytics Replication to Teradata
Use CData Sync to Customize and automate eBay Analytics replication to Teradata.
-
Integrate Cursor with Live SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP Business One from within the editor.
-
Migrating data from Confluence to Google BigQuery using CData SSIS Components.
Easily push Atlassian Confluence to Google BigQuery using the CData SSIS Tasks for Confluence and Google BigQuery.
-
Visualize Sage 50 UK from Tableau
Use the Tableau Desktop business intelligence tool to connect to Sage 50 UK.
-
Analyze Procore in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Procore and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Data Visualizations in Cognos BI with Sugar CRM
Access Sugar CRM as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate with ActiveCampaign using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ActiveCampaign to a JSON file on disk.
-
Integrate with Freshdesk in SnapLogic
Use CData Connect AI to connect to and integrate with live Freshdesk in SnapLogic.
-
Replicate LinkedIn to Multiple Databases
Replicate LinkedIn to disparate databases with a point-and-click configuration.
-
Configure the CData JDBC Driver for Zoho Inventory in a Connection Pool in Tomcat
Connect to Zoho Inventory from a connection pool in Tomcat.
-
Integrating Gumloop with Databricks via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Databricks within automated workflows.
-
Consume Oracle Sales OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Oracle Sales feeds that reflect any changes in SAP Lumira.
-
Connect to Office 365 from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Office 365 from Appeon PowerBuilder using the CData ADO.NET Provider for Office 365.
-
Build a Singer.io Tap for Greenhouse With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Greenhouse data using
-
How to connect to Highrise from IntelliJ
Integrate connectivity to Highrise CRM with wizards in IntelliJ.
-
DataBind Controls to NetSuite in C++Builder
DataBind to NetSuite CRM & ERP in C++Builder with standard components and controls.
-
Create SAP SuccessFactors-Connected Dashboards in Grafana
Connect to SAP SuccessFactors via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP SuccessFactors.
-
Use the CData Software ODBC Driver for Klaviyo in SAS for Real-Time Reporting and Analytics
Connect to real-time Klaviyo in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Klaviyo.
-
Build Calendly-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Calendly and build web apps with connectivity to live Calendly.
-
Load Microsoft Teams to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Teams to a database.
-
Integrate Smartsheet with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Smartsheet with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Smartsheet.
-
PowerShell Scripting to Replicate Klaviyo to MySQL
Write a simple PowerShell script to replicate Klaviyo to a MySQL database.
-
Visualize Live Procore of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Procore using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous MySQL Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable MySQL replication to Apache Cassandra.
-
Access Klipfolio 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 Klipfolio.
-
Work with Wave Financial in FoxPro
Load Wave Financial into a FoxPro database. This article includes full code and a walk-through of the process.
-
Kintone Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Kintone facts in real time.
-
Viewing ConstantContact in RAD Studio Data Explorer
How to view ConstantContact in RAD Studio Data Explorer using the CData ODBC Driver for ConstantContact.
-
Automated Continuous WordPress Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable WordPress replication to Apache Kafka.
-
How to work with Google Ads in Apache Spark using SQL
Access and process Google Ads in Apache Spark using the CData Software JDBC Driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Atlassian Jira within intelligent workflows.
-
Build Dashboards with Azure Analysis Services in Dundas BI
Create dynamic dashboards and perform analytics based on Azure Analysis Services in Dundas BI.
-
How to connect Amazon QuickSight to Oracle Financials Cloud
Create a connection to Oracle Financials Cloud in CData Connect AI and insert Oracle Financials Cloud into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to CockroachDB in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for CockroachDB and connect to CockroachDB in Akorbi Digital RunMyProcess.
-
Access Microsoft OneDrive as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft OneDrive from your Oracle system.
-
How to publish and share SAS Data Sets dashboards with Tableau Server
The CData ODBC driver for SAS Data Sets enables you integrate SAS Data Sets into Tableau dashboards.
-
How to Query Live Salesforce Pardot in Perplexity MacOS Desktop
Connect to and query live Salesforce Pardot in Perplexity Desktop using the CData MCP Server.
-
How to Work with Jira in AWS Glue Jobs Using JDBC
Connect to Jira from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Seamlessly Import Harvest Data into IBM SPSS Modeler
Integrate Harvest data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData ODBC Driver for Outreach.io from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Outreach.io to connect to Outreach.io from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Outreach.io in Excel.
-
Connect to FTP from PowerBuilder via JDBC
This article demonstrates how to access FTP Servers from PowerBuilder using the FTP JDBC Driver.
-
Acumatica Reporting in OBIEE with the Acumatica JDBC Driver
Deploy the Acumatica JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Live Redshift in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Amazon Redshift into the statistical analysis tools available in SAS JMP. This article shows how to use Amazon Redshift in the Graph Builder and Query Builder.
-
Automated Continuous Twitter Replication to Snowflake
Use CData Sync for automated, continuous, customizable Twitter replication to Snowflake.
-
How to Import Data from Epicor Kinetic into Google Sheets
Import Epicor Kinetic into a Google spreadsheet that is automatically refreshed.
-
Import Real-Time Sage 300 via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Sage 300 in ColdFusion.
-
Use the CData Software JDBC Driver for Monday.com in MicroStrategy Web
Connect to Monday.com in MicroStrategy Web using the CData Software JDBC Driver for Monday.com.
-
Analyze Sage Intacct in Looker
Use CData Connect AI to connect to Sage Intacct from Looker and build custom apps using live Sage Intacct.
-
How to pipe SAS xpt to CSV in PowerShell
Use standard PowerShell cmdlets to access SAS xpt tables.
-
Analyze Epicor Kinetic with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Epicor Kinetic from Power Pivot. You will use the Table Import Wizard to load Epicor Kinetic. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Zoho CRM in JRuby
Create a simple JRuby app with access to live Zoho CRM.
-
Access DocuSign from MySQL in Amazon QuickSight
Connect to DocuSign and build visualizations of DocuSign using a MySQL Connection in Amazon QuickSight.
-
Build Automated Freshdesk-Connected Workflows in Zapier
Use CData Connect AI to connect to live Freshdesk and build automated workflows in Zapier.
-
How to create an RPA flow for Shippo in UiPath Studio
Use the Shippo ODBC Driver to create workflows that access real-time Shippo without any coding.
-
Create Salesforce Pardot-Connected Applications in Appsmith
Connect to Salesforce Pardot via CData Connect AI in Appsmith and create custom business applications with real-time access to Salesforce Pardot.
-
Automated Continuous Dynamics NAV Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Microsoft Dynamics NAV replication to OneLake in Microsoft Fabric.
-
Connect to Marketo in SpagoBI
Create reports featuring live Marketo in SpagoBI Studio. Host Marketo reports on SpagoBI Server.
-
How to integrate Metabase with MongoDB
Use CData Connect AI to connect to live MongoDB and create an interactive dashboard in Metabase from MongoDB.
-
How to pipe Act-On to CSV in PowerShell
Use standard PowerShell cmdlets to access Act-On tables.
-
Automated Continuous Kintone Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Kintone replication to Microsoft Access.
-
Consume IBM Informix OData Feeds in PowerBuilder
This article demonstrates how to consume IBM Informix as OData feeds from PowerBuilder using the API Server.
-
Connect to Clio in Claris FileMaker Pro
-