BI & Analytics

---

Our drivers offer the fastest and easiest way to connect real-time NetSuite data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to NetSuite data and metadata, and seamlessly integrate with your favorite analytics tools.

LEARN MORE: Connectivity for BI & Analytics

Popular BI & Analytics Integrations

---

Alteryx Designer: Prepare, Blend, and Analyze NetSuite in Alteryx Designer Amazon QuickSight: Build Interactive Dashboards from NetSuite in Amazon QuickSight Aqua Data Studio: Connect to NetSuite in Aqua Data Studio Birst: Build Visualizations of NetSuite in Birst BIRT: Design BIRT Reports on NetSuite Clear Analytics: Build Charts with NetSuite in Clear Analytics Microsoft Excel: Excel Spreadsheet Automation with the QUERY Formula DBxtra: Build Dashboards with NetSuite in DBxtra Domo: Create Datasets from NetSuite in Domo Workbench Dundas BI: Build Dashboards with NetSuite in Dundas BI FineReport: Feed NetSuite into FineReport Google Data Studio: Create Reports from NetSuite in Google Data Studio IBM Cognos BI: Create Data Visualizations in Cognos BI with NetSuite JasperServer: Create NetSuite Reports on JasperReports Server Jaspersoft BI Suite: Connect to NetSuite in Jaspersoft Studio JReport Designer: Integrate with NetSuite in JReport Designer Klipfolio: Create NetSuite-Connected Visualizations in Klipfolio KNIME: Enable the NetSuite JDBC Driver in KNIME LINQPad: Working with NetSuite in LINQPad Power BI Desktop: Author Power BI Reports on Real-Time NetSuite Power BI Online: Visualize Live NetSuite in the Power BI Service Microsoft SSAS: Build an OLAP Cube in SSAS from NetSuite MicroStrategy: Use the CData JDBC Driver for NetSuite in MicroStrategy OBIEE: NetSuite Reporting in OBIEE with the NetSuite JDBC Driver pandas: Use pandas to Visualize NetSuite in Python Pentaho Report Designer: Integrate NetSuite in the Pentaho Report Designer QlikView: Connect to and Query NetSuite in QlikView over ODBC R: Analyze NetSuite in R RapidMiner : Connect to NetSuite in RapidMiner SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for NetSuite SAP Crystal Reports: Publish Reports with NetSuite in Crystal Reports SAP Lumira: Consume NetSuite OData Feeds in SAP Lumira SAS: Use the CData ODBC Driver for NetSuite in SAS for Real-Time Reporting and Analytics Sisense: Visualize Live NetSuite in Sisense Spago BI: Connect to NetSuite in SpagoBI Tableau: Visualize NetSuite in Tableau Desktop Tableau Online: Build NetSuite Visualizations in Tableau Online Tableau Server: Publish NetSuite-Connected Dashboards in Tableau Server TIBCO Spotfire: Visualize NetSuite in TIBCO Spotfire through ADO.NET TIBCO Spotfire Server: Operational Reporting on NetSuite from Spotfire Server Visio: Link Visio Shapes to NetSuite

ETL, Replication, & Warehousing

---

From drivers and adapters that extend your favorite ETL tools with NetSuite connectivity to ETL/ELT tools for replication — our NetSuite integration solutions provide robust, reliable, and secure data movement.

Connect your RDBMS or data warehouse with NetSuite to facilitate operational reporting, offload queries and increase performance, support data governance initiatives, archive data for disaster recovery, and more.

Popular Data Warehousing Integrations

---

Amazon Redshift: Automated Continuous NetSuite Replication to Amazon Redshift Amazon S3: Automated Continuous NetSuite Replication to Amazon S3 Apache Camel: Integrate with NetSuite using Apache Camel Apache Cassandra: Automated Continuous NetSuite Replication to Apache Cassandra Apache NiFi: Bridge NetSuite Connectivity with Apache NiFi AWS Glue: Connect to NetSuite in AWS Glue Jobs Using JDBC BIML: Use Biml to Build SSIS Tasks to Replicate NetSuite to SQL Server CloverDX: Connect to NetSuite in CloverDX (formerly CloverETL) CSV: Automated Continuous NetSuite Replication to Local Delimited Files IBM DB2: Automated Continuous NetSuite Replication to IBM DB2 FoxPro: Work with NetSuite in FoxPro Google BigQuery: Automated Continuous NetSuite Replication to Google BigQuery Google Cloud SQL: Automated Continuous NetSuite Replication to Google Cloud SQL Google Data Fusion: Build NetSuite-Connected ETL Processes in Google Data Fusion Heroku / Salesforce Connect: Replicate NetSuite for Use in Salesforce Connect HULFT Integrate: Connect to NetSuite in HULFT Integrate Informatica Cloud: Integrate NetSuite in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for NetSuite Jaspersoft ETL: Connect to NetSuite in Jaspersoft Studio Microsoft Access: Automated Continuous NetSuite Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous NetSuite Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to NetSuite MongoDB: Automated Continuous NetSuite Replication to MongoDB MySQL: Automated Continuous NetSuite Replication to MySQL Oracle Data Integrator: ETL NetSuite in Oracle Data Integrator Oracle Database: Automated Continuous NetSuite Replication to Oracle petl: Extract, Transform, and Load NetSuite in Python PostgreSQL: Automated Continuous NetSuite Replication to PostgreSQL Replicate to CSV: Replicate NetSuite to MySQL with PowerShell Snowflake: Automated Continuous NetSuite Replication to Snowflake SQL Server: Automated Continuous NetSuite Replication to SQL Server SQLite: Automated Continuous NetSuite Replication to SQLite Talend: Connect to NetSuite and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to NetSuite in UiPath Studio

Data Management

---

By supporting popular database protocols like ODBC, JDBC, and ADO.NET, as well as wire-protocol interfaces for SQL Server and MySQL, it is easy to connect to and manage NetSuite data from a wide range of database management applications.

Popular Data Management Tool Integrations

---

Apache Solr: Import NetSuite Data into Apache Solr DBeaver: Connect to NetSuite in DBeaver DbVisualizer: Connect to NetSuite in DBVisualizer DB Artisan: Manage NetSuite in DBArtisan as a JDBC Source DB Artisan: Connect to NetSuite in DBArtisan Informatica Enterprise Data Catalog: Add NetSuite to Informatica Enterprise Data Catalog MySQL Workbench: Query NetSuite in MySQL Workbench RazorSQL: Connect to NetSuite in RazorSQL SQuirreL: Connect to NetSuite in Squirrel SQL Client

Workflow & Automation Tools

---

Connect to NetSuite from popular data migration, ESB, iPaaS, and BPM tools.

Our drivers and adapters provide straightforward access to NetSuite data from popular applications like BizTalk, MuleSoft, SQL SSIS, Microsoft Flow, Power Apps, Talend, and many more.

Popular Workflow & Automation Tool Integrations

---

BizTalk: How to Generate SQL Command Schemas for the CData BizTalk Adapter for NetSuite BizTalk: Configure a One-Way Send Port for the CData BizTalk Adapter for NetSuite BizTalk: Configure a CData NetSuite Adapter Receive Location BizTalk: Configure a Solicit-Response Send Port for NetSuite Power Automate: Automate Tasks in Power Automate Using API Server Power Automate: Integrate NetSuite into Power Automate Automated Tasks Microsoft Power Apps: Design NetSuite Power Apps Nintex Workflow Cloud: Build NetSuite-Connected Workflows in Nintex Microsoft Power Apps: Integrate Live NetSuite into Custom Business Apps Built in Power Apps MuleSoft Anypoint: Access NetSuite in Anypoint Using SQL SSIS Export: Export Data from SQL Server to NetSuite through SSIS SSIS Import: Import NetSuite Data into SQL Server using SSIS SSIS Lookup: Insert New or Update Existing NetSuite Records from SQL Server MuleSoft Anypoint: Deploy CData Mule Connectors (On-Premise or Cloud)

Developer Tools & Technologies

---

The easiest way to integrate with NetSuite from anywhere. Our NetSuite drivers offer a data-centric model for NetSuite that dramatically simplifies integration — allowing developers to build higher quality applications, faster than ever before. Learn more about the benefits for developers:

• Pragmatic API Integration: from SDKs to Data Drivers
• Data APIs: Gateway to Data Driven Operation & Digital Transformation

Popular Developer Integrations

---

.NET Charts: DataBind Charts to NetSuite .NET QueryBuilder: Rapidly Develop NetSuite-Driven Apps with Active Query Builder Angular JS: Using AngularJS to Build Dynamic Web Pages with NetSuite Apache Spark: Work with NetSuite in Apache Spark Using SQL AppSheet: Create NetSuite-Connected Business Apps in AppSheet Microsoft Azure Logic Apps: Trigger NetSuite IFTTT Flows in Azure App Service ColdFusion: Query NetSuite in ColdFusion Dash: Use Dash & Python to Build Web Apps on NetSuite DevExpress: DataBind NetSuite to the DevExpress Data Grid EF - Code First: Access NetSuite with Entity Framework 6 EF - LINQ: LINQ to NetSuite EF - MVC: Build MVC Applications with Connectivity to NetSuite Filemaker Pro: Bidirectional Access to NetSuite from FileMaker Pro Go: Write a Simple Go Application to work with NetSuite on Linux Google Apps Script: Connect to NetSuite in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with NetSuite Entities in Java IntelliJ: Connect to NetSuite in IntelliJ JBoss: Connect to NetSuite from a Connection Pool in JBoss JDBI: Create a Data Access Object for NetSuite using JDBI JRuby: Connect to NetSuite in JRuby NodeJS: Query NetSuite from Node.js NodeJS: Query NetSuite as a MySQL Database in Node.js NodeJS: Query NetSuite through ODBC in Node.js PHP: Access NetSuite in PHP through the Cloud Hub PHP: Natively Connect to NetSuite in PHP PowerShell: Pipe NetSuite to CSV in PowerShell PowerBuilder: Connect to NetSuite from PowerBuilder PyCharm: Using the CData ODBC Driver for NetSuite in PyCharm Python: Connect to NetSuite in Python on Linux/UNIX Ruby: Connect to NetSuite in Ruby SAP UI5: Integrate Real-Time Access to NetSuite in SAPUI5 MVC Apps Servoy: Build NetSuite-Connected Apps in Servoy SQLAlchemy: Use SQLAlchemy ORMs to Access NetSuite in Python Tomcat: Configure the CData JDBC Driver for NetSuite in a Connection Pool in Tomcat VCL App (RAD Studio): Build a Simple VCL Application for NetSuite WebLogic: Connect to NetSuite from a Connection Pool in WebLogic

Data Virtualization

---

Our drivers provide a virtual database abstraction on top of NetSuite data and support popular data virtualization features like query federation through advanced capabilities for query delegation / predicate pushdown.

Learn more about how our tools can be used in popular data virtualization scenarios below:

Popular Data Virtualization Tool Integrations

---

Access Linked Tables: Update NetSuite with a Microsoft Access Linked Table Denodo: Create A Data Source for NetSuite in Denodo Platform MySQL Federated Tables: Connect to NetSuite as Federated Tables in MySQL MySQL Federated Tables: Connect to NetSuite as Federated Tables in MySQL Oracle Database: Access NetSuite as a Remote Oracle Database PostgreSQL FDW: A PostgreSQL Interface for NetSuite Salesforce Connect: Edit and Search NetSuite External Objects SharePoint External List: Access NetSuite in SharePoint External Lists SQL Server Linked Servers: Connect to NetSuite as a Linked Server SQL Server PolyBase: Connect to NetSuite as an External Data Source using PolyBase TIBCO Data Virtualization: Access Live NetSuite Data in TIBCO Data Virtualization