{"id":35185,"date":"2019-04-09T15:19:07","date_gmt":"2019-04-09T15:19:07","guid":{"rendered":"https:\/\/qa1.ats-global.com\/data-traceability-in-pharmaceutical-manufacturing\/"},"modified":"2020-12-24T13:05:36","modified_gmt":"2020-12-24T13:05:36","slug":"data-traceability-in-pharmaceutical-manufacturing","status":"publish","type":"post","link":"https:\/\/www.ats-global.com\/nl\/data-traceability-in-pharmaceutical-manufacturing\/","title":{"rendered":"Data Traceability in Pharmaceutical Manufacturing"},"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>The need for quality and data traceability in pharmaceutical manufacturing makes this a very special industry. Program specifications, change procedures and approval must follow FDA and GAP standards.ATS engineers have experience of these environments and a number of projects have been completed with PLC and SCADA systems.<\/p>\n<p>The producer of a filter installation for a pharmaceutical industry asked ATS for help. For the filter in question it is required that process data is available at any time. A Siemens S7 400 PLC is used to control the system and Wonderware InTouch is used for SCADA.<\/p>\n<p>The 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 take care of the communication between the PLC and the Wonderware applications.<\/p>\n<p>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 <u>anyone with access rights to run his own report<\/u> of the data available in the database server.<br \/>\n<a target=\"_blank\" href=\"\/storage\/images\/article\/References-Bosch-MES.jpg\" rel=\"noopener\"><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":[417],"tags":[],"success_stories_industry":[],"business_offerings":[],"page_categories":[],"knowledge_services":[],"class_list":["post-35185","post","type-post","status-publish","format-standard","hentry","category-medical-devices-nl"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.ats-global.com\/nl\/wp-json\/wp\/v2\/posts\/35185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ats-global.com\/nl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ats-global.com\/nl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ats-global.com\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ats-global.com\/nl\/wp-json\/wp\/v2\/comments?post=35185"}],"version-history":[{"count":0,"href":"https:\/\/www.ats-global.com\/nl\/wp-json\/wp\/v2\/posts\/35185\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.ats-global.com\/nl\/wp-json\/wp\/v2\/media?parent=35185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ats-global.com\/nl\/wp-json\/wp\/v2\/categories?post=35185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ats-global.com\/nl\/wp-json\/wp\/v2\/tags?post=35185"},{"taxonomy":"success_stories_industry","embeddable":true,"href":"https:\/\/www.ats-global.com\/nl\/wp-json\/wp\/v2\/success_stories_industry?post=35185"},{"taxonomy":"business_offerings","embeddable":true,"href":"https:\/\/www.ats-global.com\/nl\/wp-json\/wp\/v2\/business_offerings?post=35185"},{"taxonomy":"page_categories","embeddable":true,"href":"https:\/\/www.ats-global.com\/nl\/wp-json\/wp\/v2\/page_categories?post=35185"},{"taxonomy":"knowledge_services","embeddable":true,"href":"https:\/\/www.ats-global.com\/nl\/wp-json\/wp\/v2\/knowledge_services?post=35185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}