CData Software - Knowledge Base
Recent Articles
-
Automate Azure Data Catalog Replication to SAP HANA
Use CData Sync to customize and automate Azure Data Catalog replication to SAP HANA.
-
How to Seamlessly Import Azure Synapse Data into IBM SPSS Modeler
Integrate Azure Synapse data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Act-On in Coginiti Pro
Connect to and query live Act-On from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Parquet Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apache Parquet replication to OneLake in Microsoft Fabric.
-
Create Datasets from EventBrite in Domo Workbench and Build Visualizations of EventBrite in Domo
Use the CData Software ODBC Driver for EventBrite to create datasets from Eventbrite in Domo Workbench and then build visualizations in the Domo service.
-
Establish a Live Connection with Wave Financial using Tableau Bridge
The CData ODBC Driver for Wave Financial enables you to integrate live Wave Financial into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Create Power BI Visual Reports with Real-Time IBM Cloud Object Storage
Use CData Power BI Connectors to visualize IBM Cloud Object Storage in Power BI.
-
Automated Continuous Google Contacts Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Contacts replication to SQL Server.
-
Connect to SAP in Aqua Data Studio
Access SAP ERP/NetWeaver from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData Python Connector for Oracle Sales
Learn to install and license the CData Python Connector
-
Connect to Zuora in Google Apps Script via Connect AI
Use CData Connect AI to access Zuora in Google Apps Script.
-
Bind Live Google Calendar Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Calendar data
-
Connect to Sybase from PowerBuilder via JDBC
This article demonstrates how to access Sybase from PowerBuilder using the Sybase JDBC Driver.
-
Visualize Marketo in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Marketo into TIBCO Spotfire.
-
Build Salesforce Marketing-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Salesforce Marketing and create custom apps in Bubble.
-
Use the CData Software JDBC Driver for BigCommerce in MicroStrategy Web
Connect to BigCommerce in MicroStrategy Web using the CData Software JDBC Driver for BigCommerce.
-
Connect to IBM Informix from PowerBuilder via JDBC
This article demonstrates how to access IBM Informix from PowerBuilder using the IBM Informix JDBC Driver.
-
Back Up SingleStore to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SingleStore. In this article, we will employ an SSIS workflow to populate a database with SingleStore data.
-
Perform Batch Operations with SuiteCRM in Apache NiFi
Connect to SuiteCRM and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Write a Simple Go Application to work with Sage Cloud Accounting on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sage Business Cloud Accounting.
-
How to pipe Microsoft Planner to CSV in PowerShell
Use standard PowerShell cmdlets to access Microsoft Planner tables.
-
Manage Email in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Email.
-
How to connect Amazon QuickSight to LinkedIn
Create a connection to LinkedIn in CData Connect AI and insert LinkedIn into Amazon QuickSight SPICE to build interactive dashboards.
-
Office 365 Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Office 365 through CData Connect AI using different applications and tools.
-
Replicate Multiple Office 365 Accounts
Replicate multiple Office 365 accounts to one or many databases.
-
Automated Continuous Zoho Creator Replication to SingleStore
Use CData Sync for automated, continuous, customizable Zoho Creator replication to SingleStore.
-
Use the CData ODBC Driver for Microsoft Project from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Microsoft Project to connect to Microsoft Project from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Project in Excel.
-
Connect to Shopify from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Shopify, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Access Live HubDB in Power Automate Desktop via ODBC
The CData ODBC Driver for HubDB enables you to integrate HubDB into workflows built using Microsoft Power Automate Desktop.
-
Connect to Odoo in HULFT Integrate
Connect to Odoo as a JDBC data source in HULFT Integrate
-
How to Import Data from Wave Financial into Google Sheets
Import Wave Financial into a Google spreadsheet that is automatically refreshed.
-
Model, Search, and Visualize Live Oracle SCM in ThoughtSpot
Use CData Connect AI to connect to live Oracle SCM for modeling, searching, and visualizing.
-
Integrate with Oracle Sales in JReport Designer
Create charts and reports based on Oracle Sales in JReport Designer.
-
Create Datasets from Okta in Domo Workbench and Build Visualizations of Okta in Domo
Use the CData Software ODBC Driver for Okta to create datasets from Okta in Domo Workbench and then build visualizations in the Domo service.
-
Integrate with Okta using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Okta to a JSON file on disk.
-
Integrate Real-Time Access to Act-On in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Act-On in real time.
-
Build a Simple VCL Application for Splunk
How to build a simple VCL Application to view Splunk in RAD Studio using the CData ODBC Driver for Splunk.
-
Consume Twitter Ads OData Feeds in PowerBuilder
This article demonstrates how to consume Twitter Ads as OData feeds from PowerBuilder using the API Server.
-
Use the CData ODBC Driver for Sage Cloud Accounting in Microsoft Power Query
You can use the CData Sage Cloud Accounting ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sage Business Cloud Accounting into Microsoft Power Query.
-
Integrate Avro with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Avro with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apache Avro.
-
How to connect SharePoint with Aha through external lists
Provide Aha! to SharePoint users as an external list.
-
Replicate Pinterest from PowerShell
Write a quick PowerShell script to query Pinterest. Use connectivity to the live data to replicate Pinterest to SQL Server.
-
How to connect to JotForm in DBVisualizer
Integrate JotForm with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate HarperDB in the Pentaho Report Designer
Publish reports based on HarperDB in the Pentaho BI tool.
-
Integrate Cursor with Live Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Smartsheet from within the editor.
-
Connect to Oracle Service Cloud as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Oracle Service Cloud.
-
How to create Visio diagrams from Google Directory
Automatically update Google Directory with the changes you make to Visio master shapes.
-
Connect to Shippo in the Denodo Platform
Use CData driver technologies to create a virtual data source for Shippo in the Denodo Virtual DataPort Administrator.
-
Connect and Query Live Redshift Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Amazon Redshift into Databricks
-
Access Live Epicor Kinetic in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Epicor Kinetic into the statistical analysis tools available in SAS JMP. This article shows how to use Epicor Kinetic in the Graph Builder and Query Builder.
-
Getting Started with the CData SSIS Components for Google Calendar
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Calendar.
-
Connect to and Visualize Live Microsoft Teams in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Teams.
-
Automate Sage 300 Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Sage 300 and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build an OLAP Cube in SSAS from PayPal
Establish a connection to PayPal data from SQL Server Analysis Services, and use the PayPal Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Informatica Mappings From/To a JDBC Data Source for Paylocity
Create Paylocity data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automate LinkedIn Ads Replication to Azure Synapse
Use CData Sync to customize and automate LinkedIn Ads replication to Azure Synapse.
-
Getting Started with the CData JDBC Driver for Dynamics 365 Business Central
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dynamics 365 Business Central.
-
Choosing the Best Method to Connect Airtable to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Airtable from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Analyze Stripe in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Stripe and visualize Stripe in SAP Analytics Cloud.
-
How to Connect the Power BI Service to Asana: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Build Dashboards with Azure Active Directory in Dundas BI
Create dynamic dashboards and perform analytics based on Azure Active Directory in Dundas BI.
-
How to integrate Metabase with Kintone
Use CData Connect AI to connect to live Kintone and create an interactive dashboard in Metabase from Kintone.
-
Integrating Sage Intacct in Talend Cloud Data Management Platform
-