Discngine Connector 5.3 Overview

The Discngine Connector bridges TIBCO Spotfire and BIOVIA Pipeline Pilot

Transcript

1. DISCNGINE CONNECTOR Spotfire Connector for Pipeline Pilot Release 5.3 2020
2. Agenda Introduction Connector Modules Deployment Architecture 2
3. Company Paris 2004 ~50 employees >70 customers worldwide More Information: www.discngine.com SOFTWARE FOR LIFE SCIENCES RESEARCH
4. References
5. 5 Business Expertise Data acquisition and analysis – Sample management
6. 6 Business Expertise Scientfics Data Science
7. Business Expertise Cheminformatics & Bioinformatics 7
8. INTRODUCTION Objectives 01 8
9. Objective Scientific Data Science TIBCO Spotfire BIOVIA Pipeline Pilot 9
10. Objective Visual analytics + Scientific data handling Bidirectional Any Spotfire Client Analyst, Consumer, Business Author, Automation Any Science Chemistry, Biology, Imaging, ADMET... Data: Binary objects, molecules, images, sequences… API: Events, Visualizations, Job Control… 2 3 1 10
11. Objective Citizen Developer Data Functions Calculated Columns Automation Services Experienced Developer JavaScript SDK IronPython Web Development 11
12. DISCNGINE CONNECTOR Components in the Connector suite 02 12
13. Server-side Spotfire authoring Bi-directional data exchange Pipeline Pilot Data Functions & Calculated Columns Pipeline Pilot Automation Tasks Dynamic Spotfire authoring Client Automation SDK and S.W.A.P.P 13
14. Pipeline Pilot Data Functions & Calculated Columns Objective ▪ Easy to use bi-directional data integration between a Spotfire document and Pipeline Pilot protocols What are TIBCO Spotfire Data Functions? A way to integrate external software for data retrieval and processing Used by TIBCO to integrate with: R, SAS, Matlab, S+ Can be extended with the public API Use standardized integration mechanisms and interfaces supported by TIBCO 14
15. Pipeline Pilot Data Functions Use cases ▪ Retrieve data from the execution of a protocol without developing an interface ▪ Send multiple Spotfire records to Pipeline Pilot for processing > E.g. an entire data table, marked rows, selected columns... ▪ Interact with Pipeline Pilot protocols based on events > Forms in text areas, changed document property, changed marked records > Write back to a database/filesystem ▪ Deliver custom data tables to Web Player users 15
16. Pipeline Pilot Data Functions A Spotfire extension based on the Data Function API ▪ Data only integration > SBDF in/out > Parameters in/out > Pipeline Pilot Global Variables in/out > Works with images, structures, sequences… ▪ Runs in all clients > Analyst > Web Player Consumer > Web Player Business Author > Automation ▪ No programming skills required! 16
17. Pipeline Pilot Data Functions Starting with Connector v5.1, several data tables can be generated from one protocol execution 17
18. Pipeline Pilot Calculated Columns Extend Spotfire Calculated Columns concept to use Pipeline Pilot protocols as new column calculation engines ▪ Spotfire Standard functions > Concatenate([IDNUMBER],'-',[CL_SIZE]) > Sum([Sales]) / Sum([Sales]) OVER (Intersect(All([Axis.Color]), [Axis.X])) ▪ Connector Pipeline Pilot Calculated Columns functions > executeProtocol_String('Protocols/Expression Functions/Calculate', [Structure <MOLFILE>], 'ECFP_6’) 18 New in v5.3
19. Pipeline Pilot Calculated Columns executeProtocol_String('Protocols/Expression Functions/Calculate', [Structure <MOLFILE>], 'ECFP_6’) 19 New in v5.3
20. Pipeline Pilot Calculated Columns executeProtocol_String('Protocols/Expression Functions/Calculate', [Structure <MOLFILE>], 'ECFP_6’) Data Column Parameter Path to Pipeline Pilot protocol 20 New in v5.3
21. Client Automation SDK Objective ▪ Allow developers to programmatically interact with the Spotfire C# client API through JavaScripting ▪ Runs in both Analyst and Web Player clients ▪ Leverage modern JavaScript Libraries (Angular, React.js, D3.js, Vue.js…) ▪ Works with Pipeline Pilot and any other web capable technology (J2EE, Node.js, Python, php, Apex…) ▪ Used to build advanced mashup applications > Web application + Spotfire documents 21
22. Client Automation SDK spotfireDocument .addDataTable(sbdfFileURL) .addPage("Comparison Of Mean Ranges") .addBoxPlot(jsonConfig); 22
23. Client Automation SDK 23 spotfireDocument .addDataTable(sbdfFileURL) .addPage("Comparison Of Mean Ranges") .addBoxPlot(jsonConfig);
24. S.W.A.P.P Spotfire Web Application for Pipeline Pilot ▪ A low-code framework to streamline Pipeline Pilot protocol integration ▪ Based on Client Automation SDK ▪ Low code > Declare the Pipeline Pilot protocol > Map the parameters to a web form (Wizard) > Define actions on the Spotfire document based on protocol output files ▪ Co-Developed with AstraZeneca ▪ Developed with React.js 24
25. S.W.A.P.P: Spotfire Web Application for Pipeline Pilot 25
26. S.W.A.P.P: Register Protocol 1/2 26
27. S.W.A.P.P: Register Protocol 2/2 27
28. S.W.A.P.P: Execute (Form is created automatically) 28
29. S.W.A.P.P: Software Architecture Spotfire Web Application for Pipeline Pilot Discngine Client Automation Extension Spotfire Web Player HTML+JS React.js Pipeline Pilot Server Web (http) Data (http) Discngine Client Automation API 29
30. S.W.A.K: Software Architecture Spotfire Web Application for Knime Server (coming soon) Discngine Client Automation Extension Spotfire Web Player HTML+JS React.js KNIME Server Web (http) Data (http) Discngine Client Automation API 30
31. Pipeline Pilot Automation Tasks Objective ▪ Generate a Spotfire Document server-side from the execution of a Pipeline Pilot protocol 31
32. Pipeline Pilot Automation Tasks Use case ▪ Spotfire Document generated server-side with dynamic content On Schedule / Event Pipeline Pilot Protocol with Automation Tasks components New Document prepared and stored in the Spotfire Library User Notification 32
33. Pipeline Pilot Automation Tasks Automation Custom Tasks ▪ Pipeline Pilot Login > Allow execution of a PP Data Function ▪ IronPython Executor > Do anything you want… Pipeline Pilot Components ▪ Spotfire Automation Tasks Writers > Open & Save DXP, add pages, add charts, run script... ▪ Spotfire Automation Script Runner > Execute the Automation task from a PP protocol > Uses Spotfire WebService Rest API 33
34. Summary 34 Simple: Add new columns with Expressions UI: Default Data First: Retrieve or transform multiple data tables UI:Text Areas Interactive: Build Web Applications with Spotfire UI:Full Web + Spotfire Visuals Scheduled: Generate/Edit Spotfire Documents server-side Pipeline Pilot Calculated Columns Pipeline Pilot Data Functions … Spotfire Web Application for Pipeline Pilot / SDK … Pipeline Pilot Automation Services Tasks
35. Summary 35 Simple: Add new columns with Expressions UI: Default Data First: Retrieve or transform multiple data tables UI:Text Areas Interactive: Build Web Applications with Spotfire UI:Full Web + Spotfire Visuals Scheduled: Generate/Edit Spotfire Documents server-side Pipeline Pilot Calculated Columns Pipeline Pilot Data Functions … Spotfire Web Application for Pipeline Pilot / SDK … Pipeline Pilot Automation Services Tasks
36. Summary 36 Simple: Add new columns with Expressions UI: Default Data First: Retrieve or transform multiple data tables UI:Text Areas Interactive: Build Web Applications with Spotfire UI:Full Web + Spotfire Visuals Scheduled: Generate/Edit Spotfire Documents server-side Pipeline Pilot Calculated Columns Pipeline Pilot Data Functions … Spotfire Web Application for Pipeline Pilot / SDK … Pipeline Pilot Automation Services Tasks
37. Summary 37 Simple: Add new columns with Expressions UI: Default Data First: Retrieve or transform multiple data tables UI:Text Areas Interactive: Build Web Applications with Spotfire UI:Full Web + Spotfire Visuals Scheduled: Generate/Edit Spotfire Documents server-side Pipeline Pilot Calculated Columns Pipeline Pilot Data Functions … Spotfire Web Application for Pipeline Pilot / SDK … Pipeline Pilot Automation Services Tasks
38. DEPLOYMENT Installation, Licensing, Security 03 38
39. Security SSO & Connector Authenticator ▪ Compatible with Pipeline Pilot authentication mechanism ▪ Compatible with Spotfire SSO configuration (e.g Kerberos) ▪ Optionally: A specific Authentication extension is provided with the Connector to enable transparent authentication of Spotfire users using a Pipeline Pilot session ID 39
40. Deployment Spotfire extensions ▪ Provided as a single .sdn file Pipeline Pilot components and protocols ▪ Provided as a Component Collection (single zip file) Compatibility ▪ Spotfire 7.11 LTS, 10.3 LTS ▪ Pipeline Pilot 2017 R2 → 2020 40
41. Licensing Developer annual licenses ▪ Developers can use the product to create protocols and applications that uses Connector components ▪ End-users can execute protocols and application with no restriction Product Code Product Pack of 5 Pack of 10 Additionnal license DNGSPODF Pipeline Pilot Data Functions and Calculated Columns 15 000 € 25 000 € 2 500 € DNGSPOCAS Client Automation SDK for Web Developers 12 000 € 20 000 € 2 000 € DNGSPOCAPP Client Automation SDK for Pipeline Pilot 15 000 € 25 000 € 2 500 € DNGSPOAUTO Pipeline Pilot Automation Tasks 9 000 € 15 000 € 1 500 € DNGSPOCONN Connector Suite (all extensions above) 28 000 € 45 000 € 4 500 € 41
42. ARCHITECTURE Public API extension points 04 42
43. Spotfire Architecture 43
44. Spotfire Architecture Windows Client Web Client “Headless” Client 44
45. Discngine Connector Spotfire Extensions Pipeline Pilot 45
46. More information Documentation ▪ https://connector.discngine.com Support ▪ support@discngine.com ▪ https://discngineusergroup.slack.com/ 46
47. +33 1 80 48 66 70 contact@discngine.com Discngine, 79 avenue Ledru-Rollin, 75012 Paris – France www.discngine.com Thanks!