CData Software - Knowledge Base
Recent Articles
-
Process & Analyze Google Drive in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Drive .
-
How to Visualize OneNote Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft OneNote in Python.
-
Build Charts with Tally in Clear Analytics
Create dynamic charts and perform analytics based on Tally ERP in Clear Analytics.
-
Build Data Flows from Azure Data Catalog to SQL Server using SSIS
Easily back up Azure Data Catalog to SQL Server using the SSIS components for Azure Data Catalog.
-
How to Connect to MYOB AccountRight in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MYOB AccountRight. Leverage the pyodbc module for ODBC in Python.
-
How to Seamlessly Import NetSuite Data into IBM SPSS Modeler
Integrate NetSuite data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Cassandra from PowerBuilder via ADO.NET
This article demonstrates how to access Apache Cassandra from Appeon PowerBuilder using the CData ADO.NET Provider for Cassandra.
-
Visualize ServiceNow in Sisense
Create an ElastiCube in Sisense app with access to ServiceNow.
-
Integrate Live NetSuite into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to NetSuite CRM & ERP and integrate live NetSuite CRM & ERP into apps built in Microsoft Power Apps.
-
Create Microsoft Exchange Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Microsoft Exchange data access from reports, embedded analytics, and more.
-
Automated Continuous Azure DevOps Replication to Databricks
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Databricks.
-
Connect to Basecamp from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Basecamp using standard SQL.
-
Access Live Azure Data Lake Storage in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure Data Lake Storage in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Informatica Mappings From/To an ODBC Data Source for MarkLogic
Create an ODBC connection to MarkLogic in Informatica and browse and transfer MarkLogic.
-
Query Oracle Sales in ColdFusion
Write standard ColdFusion data access code to connect to Oracle Sales.
-
Integrate with Printful in JReport Designer
Create charts and reports based on Printful in JReport Designer.
-
Edit and Search Snowflake External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Snowflake to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Snowflake objects that you can access from apps and the dashboard.
-
How to import SAP SuccessFactors into Apache Solr
Use the CData Software JDBC Driver for SAP SuccessFactors in Data Import Handler and create an automated import of SAP SuccessFactors to Apache Solr Enterprise Search platform.
-
Connect to Paylocity in Ruby
Connect to Paylocity in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Adobe Analytics from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Adobe Analytics from HeidiSQL.
-
DataBind Controls to Dynamics 365 in Delphi
DataBind to Microsoft Dynamics 365 in Delphi with standard data access components and controls.
-
A PostgreSQL Interface for Workday (MySQL Remoting via JDBC)
Use the Remoting features of the Workday JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build a PostgreSQL Interface for Drift using the CData JDBC Driver
Use the Remoting features of the Drift JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Parquet-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache Parquet.
-
Build Charts with Snowflake in Clear Analytics
Create dynamic charts and perform analytics based on Snowflake in Clear Analytics.
-
Visualize Drip in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Drip into TIBCO Spotfire.
-
Model Azure Table Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Azure Table, enabling the direct import of real-time Azure Table Storage.
-
Use the CData API Server to Access Avalara AvaTax in Microsoft PowerPivot
Use the CData API Server to connect to live Avalara AvaTax in the Power Pivot business intelligence tool.
-
Visualize Live Printify of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Printify using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Zoho Inventory from PowerShell
Write a quick PowerShell script to query Zoho Inventory. Use connectivity to the live data to replicate Zoho Inventory to SQL Server.
-
Prepare, Blend, and Analyze Elasticsearch in Alteryx Designer (ODBC)
Build workflows to access live Elasticsearch for self-service data analytics.
-
Automated Continuous Hive Replication to Oracle
Use CData Sync for automated, continuous, customizable Hive replication to Oracle.
-
Choosing the Best Method to Connect Salesforce Marketing to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Salesforce Marketing Cloud from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Analyze WooCommerce in Infragistics Reveal
Use the CData API Server to create an OData API on top of WooCommerce and visualize live WooCommerce in Infragistics Reveal.
-
Connect to Quickbase from HeidiSQL
Use CData Connect AI to connect to and query live Quickbase from HeidiSQL.
-
Query Stripe through ODBC in Node.js
Use node-odbc to execute SQL queries against Stripe from Node.js.
-
Build Google Ad Manager-Powered Applications in Gemini Code Assist with CData Code Assist MCP
-