{"id":39007,"date":"2019-04-09T15:19:24","date_gmt":"2019-04-09T15:19:24","guid":{"rendered":"https:\/\/qa1.ats-global.com\/a-filter-installation-for-the-pharmaceutical-industry\/"},"modified":"2020-12-18T07:42:35","modified_gmt":"2020-12-18T07:42:35","slug":"a-filter-installation-for-the-pharmaceutical-industry","status":"publish","type":"post","link":"https:\/\/www.ats-global.com\/it\/a-filter-installation-for-the-pharmaceutical-industry\/","title":{"rendered":"A Filter Installation for the Pharmaceutical Industry"},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;--awb-margin-bottom:0px;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-1\"><p>Amafilter produces filter installation for the pharmaceutical industry. For this filter it is required that process data is available at any time needed. A Siemens S7 400 PLC is used to control the system and Wonderware InTouch is used for SCADA.<br \/>\nThe choice was to implement Wonderware InSQL Server and Active Factory for visualisation, analysing and reporting the \u2018real\u2019 time and historical data.ATS was asked to implement InSQL Server plus Active Factory and implement communication between the PLC and the Wonderware applications.<\/p>\n<p>The following configuration was applied. (See fig 1). The Siemens PLC is installed with an Ethernet card (CP443-1). The Database server is directly connected to the Siemens PLC with a CP1613 Ethernet card. This card is configured on the server with Siematic Net to assure a secure working card. On the server side a Wonderware I\/O Server is implemented to handle the data acquisition for InSQL Server and InTouch.<\/p>\n<p>InSQL Server uses a MS SQL Database server for data storage but there is no further configuration required at the MS SQL server. All configurations are completed upon installation and configuration of InSQL Server. With Active Factory it is possible to retrieve on-line data and historical data on basis of simple SQL queries. This can be done from any workstation connected to the network where InSQL server is located. Now it is possible for anyone with access rights to run his own report from the data available in the database server.<a target=\"_blank\" href=\"\/storage\/images\/article\/References-Bosch-MES.jpg\" rel=\"noopener noreferrer\"><img decoding=\"async\" data-src=\"\/storage\/images\/article\/References-Amafilter.jpg\" alt=\"Amafilter References\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/a><\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[412],"tags":[],"success_stories_industry":[],"business_offerings":[],"page_categories":[],"knowledge_services":[],"class_list":["post-39007","post","type-post","status-publish","format-standard","hentry","category-medical-devices-it"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.ats-global.com\/it\/wp-json\/wp\/v2\/posts\/39007","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ats-global.com\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ats-global.com\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ats-global.com\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ats-global.com\/it\/wp-json\/wp\/v2\/comments?post=39007"}],"version-history":[{"count":0,"href":"https:\/\/www.ats-global.com\/it\/wp-json\/wp\/v2\/posts\/39007\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.ats-global.com\/it\/wp-json\/wp\/v2\/media?parent=39007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ats-global.com\/it\/wp-json\/wp\/v2\/categories?post=39007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ats-global.com\/it\/wp-json\/wp\/v2\/tags?post=39007"},{"taxonomy":"success_stories_industry","embeddable":true,"href":"https:\/\/www.ats-global.com\/it\/wp-json\/wp\/v2\/success_stories_industry?post=39007"},{"taxonomy":"business_offerings","embeddable":true,"href":"https:\/\/www.ats-global.com\/it\/wp-json\/wp\/v2\/business_offerings?post=39007"},{"taxonomy":"page_categories","embeddable":true,"href":"https:\/\/www.ats-global.com\/it\/wp-json\/wp\/v2\/page_categories?post=39007"},{"taxonomy":"knowledge_services","embeddable":true,"href":"https:\/\/www.ats-global.com\/it\/wp-json\/wp\/v2\/knowledge_services?post=39007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}