Connect to live Sansan data through easy-to-use, bi-directional drivers.


Integrate with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.

"Excellent stuff. I am finally getting the hang of this and it is brilliant may I add!"

- Mark Couvaras, General Manager, Databarracks



BI & Analytics



Our drivers offer the fastest and easiest way to connect real-time Sansan data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to Sansan 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 Sansan in Alteryx Designer Amazon QuickSight: Build Interactive Dashboards from Sansan in Amazon QuickSight Aqua Data Studio: Connect to Sansan in Aqua Data Studio Birst: Build Visualizations of Sansan in Birst BIRT: Design BIRT Reports on Sansan Clear Analytics: Build Charts with Sansan in Clear Analytics Microsoft Excel: Excel Spreadsheet Automation with the QUERY Formula DBxtra: Build Dashboards with Sansan in DBxtra Domo: Create Datasets from Sansan in Domo Workbench Dundas BI: Build Dashboards with Sansan in Dundas BI FineReport: Feed Sansan into FineReport Google Data Studio: Create Reports from Sansan in Google Data Studio IBM Cognos BI: Create Data Visualizations in Cognos BI with Sansan JasperServer: Create Sansan Reports on JasperReports Server Jaspersoft BI Suite: Connect to Sansan in Jaspersoft Studio JReport Designer: Integrate with Sansan in JReport Designer Klipfolio: Create Sansan-Connected Visualizations in Klipfolio KNIME: Enable the Sansan JDBC Driver in KNIME LINQPad: Working with Sansan in LINQPad Power BI Desktop: Author Power BI Reports on Real-Time Sansan Power BI Online: Visualize Live Sansan in the Power BI Service Microsoft SSAS: Build an OLAP Cube in SSAS from Sansan MicroStrategy: Use the CData JDBC Driver for Sansan in MicroStrategy OBIEE: Sansan Reporting in OBIEE with the Sansan JDBC Driver pandas: Use pandas to Visualize Sansan in Python Pentaho Report Designer: Integrate Sansan in the Pentaho Report Designer QlikView: Connect to and Query Sansan in QlikView over ODBC R: Analyze Sansan in R RapidMiner : Connect to Sansan in RapidMiner SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sansan SAP Crystal Reports: Publish Reports with Sansan in Crystal Reports SAP Lumira: Consume Sansan OData Feeds in SAP Lumira SAS: Use the CData ODBC Driver for Sansan in SAS for Real-Time Reporting and Analytics Sisense: Visualize Live Sansan in Sisense Spago BI: Connect to Sansan in SpagoBI Tableau: Visualize Sansan in Tableau Desktop Tableau Online: Build Sansan Visualizations in Tableau Online Tableau Server: Publish Sansan-Connected Dashboards in Tableau Server TIBCO Spotfire: Visualize Sansan in TIBCO Spotfire through ADO.NET TIBCO Spotfire Server: Operational Reporting on Sansan from Spotfire Server Visio: Link Visio Shapes to Sansan

ETL, Replication, & Warehousing



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

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

Developer Tools & Technologies



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



Popular Developer Integrations



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


When Only the Best Sansan Drivers Will Do

See what customers have to say about our products and support.





Industry-Leading Support

Support is not just a part of our business, support is our business. Whenever you need help, please consult the resources below: