CData Software - Knowledge Base
Recent Articles
-
Edit and Search Jira Service Management External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Atlassian Jira Service Management to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Jira Service Management objects that you can access from apps and the dashboard.
-
Automated Continuous Outreach.io Replication to Snowflake
Use CData Sync for automated, continuous, customizable Outreach.io replication to Snowflake.
-
Access Oracle SCM from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle SCM from HeidiSQL.
-
How to connect and process Tableau CRM Analytics from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Tableau CRM Analytics.
-
Build Databricks-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Databricks and create custom apps in Bubble.
-
Connect to Kintone as an External Source in Dremio
Use the CData JDBC Driver to connect to Kintone as an External Source in Dremio.
-
Google Sheets Reporting in OBIEE with the Google Sheets JDBC Driver
Deploy the Google Sheets JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Migrating data from Acumatica to Databricks using CData SSIS Components.
Easily push Acumatica ERP to Databricks using the CData SSIS Tasks for Acumatica and Databricks.
-
Connect to GraphQL from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from GraphQL, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Choosing the Best Method to Connect SAP SuccessFactors to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP SuccessFactors from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Dashboards with SAP in DBxtra
Create dynamic dashboards and perform analytics based on SAP ERP/NetWeaver in DBxtra.
-
Build Charts with Azure Active Directory in Clear Analytics
Create dynamic charts and perform analytics based on Azure Active Directory in Clear Analytics.
-
Replicate Multiple Todoist Accounts via the CData Sync CLI
Replicate multiple Todoist accounts to one or many databases.
-
Operational Reporting on Neo4J from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Neo4J.
-
Bridge HBase Connectivity with Apache NiFi
Access and process Apache HBase in Apache NiFi using the CData JDBC Driver.
-
How to Connect to & Open SAP HANA XS Advanced in Microsoft Excel
This article uses the CData ODBC driver for SAP HANA XS Advanced to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData Software ODBC Driver for SAP SuccessFactors in MicroStrategy Web
Connect to SAP SuccessFactors in MicroStrategy Web using the CData Software ODBC Driver for SAP SuccessFactors.
-
Connect and Visualize Live Google Calendar Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google Calendar into the Databricks platform and create visualization dashboards with real-time Google Calendar.
-
DataBind Controls to Blackbaud FE NXT in Delphi
DataBind to Blackbaud FE NXT in Delphi with standard data access components and controls.
-
Import and Visualize Databricks in Power View
Create data visualizations based on Databricks in Excel.
-
Create Informatica Mappings From/To a JDBC Data Source for DB2
Create DB2 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData Software ODBC Driver for QuickBooks Time in SAS for Real-Time Reporting and Analytics
Connect to real-time QuickBooks Time in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for QuickBooks Time.
-
How to update Teradata from Excel
This article explains how to transfer data from Excel to Teradata using the Excel Add-In for Teradata.
-
A PostgreSQL Interface for IBM Cloud Object Storage (MySQL Remoting via JDBC)
Use the Remoting features of the IBM Cloud Object Storage JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Live SharePoint in SAS Viya
Use CData Connect AI to connect to Microsoft SharePoint from SAS Viya and deploy self-service analytics using live Microsoft SharePoint.
-
Replicate Multiple Drift Accounts via the CData Sync CLI
Replicate multiple Drift accounts to one or many databases.
-
Build Splunk-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Splunk.
-
Connect to Bitbucket from a Connection Pool in Jetty
The Bitbucket JDBC Driver supports connection pooling: This article shows how to connect faster to Bitbucket from Web apps in Jetty.
-
Connect to Azure Active Directory in NetBeans
Connect to Azure Active Directory in NetBeans with the data source configuration wizard.
-
Analyze ADP in Cognos Analytics
Use CData Connect AI to connect to ADP from Cognos Analytics and analyze live ADP.
-
Build Charts with Power BI XMLA in Clear Analytics
Create dynamic charts and perform analytics based on Power BI XMLA in Clear Analytics.
-
Rapidly Develop Salesforce Marketing-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.
-
Access SAP Fieldglass 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 SAP Fieldglass.
-
Write a Simple Go Application to work with Google Spanner on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Spanner.
-
Connect to Azure Synapse in JRuby
Create a simple JRuby app with access to live Azure Synapse.
-
A PostgreSQL Interface for Basecamp (MySQL Remoting via JDBC)
Use the Remoting features of the Basecamp JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Google Cloud Storage in MySQL Workbench
Execute MySQL queries against live Google Cloud Storage from MySQL Workbench.
-
Create Workday-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Workday from OutSystems and build custom enterprise apps using live Workday.
-
Automate Dynamics NAV Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Dynamics NAV from PowerShell? This article demonstrates how to utilize the Dynamics NAV Cmdlets for tasks like connecting to Microsoft Dynamics NAV, automating operations, downloading data, and more.
-
How to Query Live Elasticsearch Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Elasticsearch data in natural language using Python.
-
How to connect Amazon QuickSight to LinkedIn Ads
Create a connection to LinkedIn Ads in CData Connect AI and insert LinkedIn Ads into Amazon QuickSight SPICE to build interactive dashboards.
-
Analyze JotForm in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze JotForm in Microsoft R Open.
-
Visualize Sage 300 in Sisense
Create an ElastiCube in Sisense app with access to Sage 300.
-
Connect to WordPress through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with WordPress using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Live Wave Financial into Blue Prism for Intelligent Robotic Process Automation (RPA)
-