{"id":4098,"date":"2017-12-20T21:47:35","date_gmt":"2017-12-20T13:47:35","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=4098"},"modified":"2025-05-08T15:40:59","modified_gmt":"2025-05-08T07:40:59","slug":"creating-a-tag-datasource","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/connecting-your-data\/creating-a-tag-datasource\/","title":{"rendered":"Creating a Tag Datasource"},"content":{"rendered":"\n<p class=\"intro-text\">Before you can get data into IFS OI Server, you must define a datasource. A datasource is a connection that allows IFS OI Server to retrieve data from an external system, such as an historian, database, accounting system, etc.<\/p>\n<p class=\"intro-text\">Each datasource retrieves data from one source system. You need to define a connection for each system you want to connect to.\u00a0When defining a datasource, there are some technical terms to be aware of. This article\u00a0explains how to create a datasource, and the terms that relate to tag\u00a0datasources (e.g. data stored in an historian\u00a0database, such as PI).<\/p>\n<p class=\"intro-text\">You can add a datasource using IFS OI Server Management or the Import\/Export spreadsheet.<\/p>\n<h2 class=\"page-subheading\" style=\"border-top: 1px solid #cccccc;\">Server Management<\/h2>\n<h3>Step 1. Create the Datasource<\/h3>\n<p class=\"intro-text\">In IFS OI Server Management, adding a datasource is performed through the Configuration\u00a0<strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-6523\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/09\/configurationicon.png\" alt=\"\" width=\"21\" height=\"20\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/09\/configurationicon.png 30w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/09\/configurationicon-24x24.png 24w\" sizes=\"auto, (max-width: 21px) 100vw, 21px\" \/><\/strong>\u00a0menu option.<\/p>\n<p class=\"intro-text\">1. Open IFS OI Server Management, and click the <strong>Configuration\u00a0<\/strong>icon.<\/p>\n<p class=\"intro-text\">2. Select the <strong>Datasources<\/strong> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-21662\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/11\/Datasources-e1502778538485.png\" alt=\"\" width=\"20\" height=\"22\" \/>\u00a0option from the middle panel.<\/p>\n<p class=\"intro-text\">3. Click the <strong>Create New Datasource<\/strong>\u00a0button.<\/p>\n<p class=\"note\">If you are updating a datasource, click the name of the datasource instead.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/create-datasource.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18629\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/create-datasource.png\" alt=\"create-datasource\" width=\"1174\" height=\"546\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/create-datasource.png 1174w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/create-datasource-768x357.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/create-datasource-150x70.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/create-datasource-24x11.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/create-datasource-36x17.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/create-datasource-48x22.png 48w\" sizes=\"auto, (max-width: 1174px) 100vw, 1174px\" \/><\/a><\/p>\n<h3>Step 2. Configure a Connection<\/h3>\n<p class=\"intro-text\">The configuration parameters are different depending on the type of datasource you are configuring. For a tag\u00a0datasource, the parameters are as follows.<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>Parameter<\/strong><\/td>\n<td><strong>Description and example<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>Name<\/strong><\/td>\n<td>\n<p>The name that this datasource will be known by, to be used in other applications such as <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/\">IFS OI Explorer<\/a>. In the example below, the list of datasources appears in IFS OI Explorer when adding a dataset to a page.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/adddatasource.png\" rel=\"lightbox-1\"><img loading=\"lazy\" decoding=\"async\" class=\"border-image alignnone wp-image-4056 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/adddatasource.png\" alt=\"adddatasource\" width=\"655\" height=\"502\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/adddatasource.png 655w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/adddatasource-150x115.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/adddatasource-24x18.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/adddatasource-36x28.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/adddatasource-48x37.png 48w\" sizes=\"auto, (max-width: 655px) 100vw, 655px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>Description<\/strong><\/td>\n<td>\n<p>Detailed information on the external system that this datasource connects to. A good description helps to address any ambiguities when there are several datasources with similar names.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/description1.png\" rel=\"lightbox-2\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4077 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/description1.png\" alt=\"\" width=\"691\" height=\"197\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/description1.png 691w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/description1-150x43.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/description1-24x7.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/description1-36x10.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/description1-48x14.png 48w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/a>\u00a0<\/p>\n<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><span style=\"color: #000000;\"><b>Discovery Prefix<\/b><\/span><\/td>\n<td>\n<p>A prefix that is attached to the start of the tag name, usually used as a shorthand way of identifying the datasource. E.g. rel-<br \/>\n<em>Note: This setting was added in P2 Server v 4.5.0.<\/em><\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/disovery-prefix.png\" rel=\"lightbox-3\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31860\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/disovery-prefix.png\" alt=\"\" width=\"815\" height=\"120\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/disovery-prefix.png 815w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/disovery-prefix-768x113.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/disovery-prefix-150x22.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/disovery-prefix-24x4.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/disovery-prefix-36x5.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/disovery-prefix-48x7.png 48w\" sizes=\"auto, (max-width: 815px) 100vw, 815px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>Default Tag Scan Rate<\/strong><\/td>\n<td>\n<p>Used to estimate the number of data points a tag fetch will return, when performing\u00a0<strong>raw<\/strong>\u00a0<strong>fetches<\/strong>. This property is used to reflect the collection interval of the underlying tag in the datasource.<\/p>\n<p>It is important to choose the lowest Scan Rate that is being used by tags in the source system. E.g. If this is set to 1 day on a datasource which also contains 30-second tags, then a user may cause the system to become unresponsive by performing large raw fetches for the 30-second tags.<\/p>\n<p>If there is a mixture of tags, or specific tags that use a higher Scan Rate (e.g. daily scan rate), then we recommend configuring the Scan Rate on those specific tags and leaving the datasource at the lowest Scan Rate that is being used by tags in the source system. The Scan Rate calculation for raw fetches (see above) will by preference use the tag\u2019s Scan Rate, and then fall back to this Default Tag Scan Rate, if the Scan Rate is not configured.<\/p>\n<p><em>Note: This setting was added in P2 Server v 4.5.3.<\/em><\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/default-tag-scan-rate.png\" rel=\"lightbox-4\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31861\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/default-tag-scan-rate.png\" alt=\"\" width=\"817\" height=\"131\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/default-tag-scan-rate.png 817w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/default-tag-scan-rate-768x123.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/default-tag-scan-rate-150x24.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/default-tag-scan-rate-24x4.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/default-tag-scan-rate-36x6.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/default-tag-scan-rate-48x8.png 48w\" sizes=\"auto, (max-width: 817px) 100vw, 817px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>Data Type<\/strong><\/td>\n<td>\n<p>The format of data retrieved by the datasource. For time series\u00a0data stored in historians, you should choose \"Tag\".<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/tagdatatype.png\" rel=\"lightbox-5\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4102\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/tagdatatype.png\" alt=\"tagdatatype\" width=\"508\" height=\"110\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/tagdatatype.png 508w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/tagdatatype-150x32.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/tagdatatype-24x5.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/tagdatatype-36x8.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/tagdatatype-48x10.png 48w\" sizes=\"auto, (max-width: 508px) 100vw, 508px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>Adaptor<\/strong><\/td>\n<td>\n<p>The type of connection that is used by the datasource to retrieve the data.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/adaptorpi.png\" rel=\"lightbox-6\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4103\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/adaptorpi.png\" alt=\"adaptorpi\" width=\"557\" height=\"97\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/adaptorpi.png 557w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/adaptorpi-150x26.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/adaptorpi-24x4.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/adaptorpi-36x6.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/adaptorpi-48x8.png 48w\" sizes=\"auto, (max-width: 557px) 100vw, 557px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>Time Zone<\/strong><\/td>\n<td>\n<p>The time zone applicable for the location of the source system. Choose \"Geographical Timezone\" if you want the system to automatically obey daylight savings, otherwise choose \"Fixed Offset\" to specify the difference in hours and minutes from UTC.<\/p>\n<p>Example: If your\u00a0source data timestamps are in UTC, you should use a Fixed Offset with 0 hours. The adaptor will use the Time Zone setting in the datasource to offset the timestamps (to UTC) for consumption elsewhere (e.g. charts or calculations).<\/p>\n<p><em><strong>Geographical Timezone<\/strong><\/em>: Begin typing the name of the <a href=\"https:\/\/en.wikipedia.org\/wiki\/List_of_tz_database_time_zones\" target=\"_blank\" rel=\"noopener noreferrer\">time zone<\/a> you are looking for. This field uses predictive text, so choose one of the items that appears in the list.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/timezone1a.png\" rel=\"lightbox-7\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4080 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/timezone1a.png\" alt=\"\" width=\"645\" height=\"223\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/timezone1a.png 645w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/timezone1a-150x52.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/timezone1a-24x8.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/timezone1a-36x12.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/timezone1a-48x17.png 48w\" sizes=\"auto, (max-width: 645px) 100vw, 645px\" \/><\/a><\/p>\n<p><em><strong>Fixed Offset<\/strong><\/em>: Specify the offset from <a href=\"https:\/\/www.timeanddate.com\/time\/aboututc.html\" target=\"_blank\" rel=\"noopener noreferrer\">UTC\/GMT<\/a>\u00a0(e.g. + 08 00).\u00a0<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/timezone2a.png\" rel=\"lightbox-8\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4081 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/timezone2a.png\" alt=\"\" width=\"287\" height=\"67\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/timezone2a.png 287w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/timezone2a-150x35.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/timezone2a-24x6.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/timezone2a-36x8.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/timezone2a-48x11.png 48w\" sizes=\"auto, (max-width: 287px) 100vw, 287px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>Adaptor Pool Size<\/strong><\/td>\n<td>\n<p>The adaptor pool hosts a number of adaptors (datasource connections), which can be called upon to retrieve data. You need to specify the minimum and maximum adaptor pool size by moving the sliders left and right.<br \/>\nIf your external system only allows one active connection at a time, set both minimum and maximum to 1. Default: Min=2, Max=8.<\/p>\n<p>For more information on adaptor pool sizes, see \u201c<a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/primers\/datasources\/\" data-slimstat-type=\"2\" data-slimstat-callback=\"true\" data-slimstat-tracking=\"false\">Datasources and Adaptors<\/a>\u201c.<\/p>\n<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>Initialisation Timeout<\/strong><\/td>\n<td>\n<p>Applies to the initialisation of an adaptor, when it first connects to a datasource. This is the same as the Init_Timeout setting used in P2 Explorer 2.6.x. \u00a0<em>Note: This setting was added in P2 Server v 4.5.2.<\/em><\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/init-timeout.png\" rel=\"lightbox-9\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29231\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/init-timeout.png\" alt=\"\" width=\"565\" height=\"118\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/init-timeout.png 565w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/init-timeout-150x31.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/init-timeout-24x5.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/init-timeout-36x8.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/init-timeout-48x10.png 48w\" sizes=\"auto, (max-width: 565px) 100vw, 565px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>Request Timeout<\/strong><\/td>\n<td>\n<p>Applies to all other operations against the datasource, such as tag fetch. It is similar to the Submit_Timeout setting used in P2 Explorer 2.6.x.<\/p>\n<p><em>Note: This setting was added in P2 Server v 4.5.2.<\/em><\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/request-timeout.png\" rel=\"lightbox-10\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29233\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/request-timeout.png\" alt=\"\" width=\"601\" height=\"132\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/request-timeout.png 601w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/request-timeout-150x33.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/request-timeout-24x5.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/request-timeout-36x8.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/05\/request-timeout-48x11.png 48w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>Data Object Discovery Timeout<\/strong><\/td>\n<td>\n<p>The Request Timeout parameter has been split into two parameters to allows a longer timeframe to be set for discovering tags on large systems, and a short timeframe for fetching actual tag data.\u00a0If you had previously set the Request Timeout to a longer period due to the time it was taking to complete a Tag Discovery, then set Data Object Discovery Timeout to this larger value and reduce the Request Timeout value.\u00a0We recommend setting the data fetch parameter (Request Timeout) to 60 seconds to reduce the load on system resources.\u00a0 This means that any request for data will be terminated after 60 seconds.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/01\/DODT.png\" rel=\"lightbox-11\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-65026\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/01\/DODT.png\" alt=\"\" width=\"537\" height=\"121\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/01\/DODT.png 639w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/01\/DODT-150x34.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/01\/DODT-600x135.png 600w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2024\/01\/DODT-48x11.png 48w\" sizes=\"auto, (max-width: 537px) 100vw, 537px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Step 3. Configure the Adaptor<\/h3>\n<p class=\"intro-text\">The Adaptor Parameters depend on the adaptor that has been selected.<\/p>\n<p class=\"intro-text\">The tag adaptors currently available are:<\/p>\n<ul class=\"intro-text\">\n<li><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/primers\/datasources\/relational-adaptor-features\/\">Relational<\/a><\/li>\n<li><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/primers\/datasources\/cygnet-adaptor-features\/\">CygNet<\/a><\/li>\n<li><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/primers\/datasources\/ip21-adaptor-features\/\">IP21<\/a><\/li>\n<li><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/primers\/datasources\/opc-adaptor-features\/\">OPC<\/a><\/li>\n<li><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/primers\/datasources\/pi-adaptor\/\">PI<\/a><\/li>\n<li><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/primers\/datasources\/phd-adaptor-features\/\">PHD<\/a><\/li>\n<li><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/primers\/datasources\/proficy-adaptor-features\/\">Proficy<\/a><\/li>\n<li><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/primers\/datasources\/canary-adaptor\/\">Canary<\/a><\/li>\n<li><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/primers\/datasources\/influxdb-adaptor\/\">InfluxDB<\/a><\/li>\n<\/ul>\n<h3>Step 4. Save the Datasource<\/h3>\n<p class=\"intro-text\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1348\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/save.png\" alt=\"save\" width=\"48\" height=\"53\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/save.png 48w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/save-22x24.png 22w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/save-33x36.png 33w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/save-43x48.png 43w\" sizes=\"auto, (max-width: 48px) 100vw, 48px\" \/>\u00a0Save your datasource by clicking the <strong>Save<\/strong> button in the top right corner.<\/p>\n<h3>Step 5. Fetch the Tags<\/h3>\n<p class=\"intro-text\">Once you have set up your datasource, you can:<\/p>\n<ul>\n<li class=\"intro-text\">Start fetching tags (see <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/connecting-your-data\/time-series-tag-fetch\/\">Time Series Tag Fetch<\/a>).\u00a0<\/li>\n<li class=\"intro-text\">Set up a <a href=\"https:\/\/windows.microsoft.com\/en-au\/windows\/schedule-task\" target=\"_blank\" rel=\"noopener noreferrer\">scheduled task in Windows<\/a> to do a tag fetch on a regular basis.\u00a0<\/li>\n<\/ul>\n<p class=\"intro-text\">Once the tags have been imported, you can edit them to change their properties, if required.<\/p>\n<p class=\"left-bar\">Related: <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/configuring-your-system\/editing-tags\/\">Editing Tags<\/a><\/p>\n<hr \/>\n<h2>Import\/Export Spreadsheet<\/h2>\n<p class=\"intro-text\">The Import\/Export spreadsheet is generally only used to make bulk changes.\u00a0<\/p>\n<p class=\"left-bar\">For details on the spreadsheet and how to obtain it, see <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/importexport\/exporting-your-config\/\">Exporting Your Configuration<\/a>.\u00a0<\/p>\n<p class=\"intro-text\">If you want to create or update tag datasources as part of a bulk configuration, you need to\u00a0use the following\u00a0tabs in the\u00a0<a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/importexport\/tips-on-filling-in-the-import-spreadsheet\/\">Import\/Export spreadsheet<\/a>:<\/p>\n<ul class=\"intro-text\">\n<li>Datasource<\/li>\n<li>Datasource Parameter<\/li>\n<\/ul>\n<p class=\"note\">Look for the red\u00a0comment\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6551\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/09\/commentred.png\" alt=\"commentred\" width=\"5\" height=\"5\" \/>\u00a0icon in the row headers, to get help with each column.<\/p>\n<p class=\"intro-text\">DO NOT change anything in the Global Id field - this is the unique identifier for the datasource that allows it to be tracked across systems, and when it is renamed. It is automatically generated by the system.\u00a0<\/p>\n<h3>Datasource Tab<\/h3>\n<p class=\"intro-text\">The screenshot below shows an example of configured tag datasources. \u00a0The fields are the same as the ones required when configuring the datasource connection using Server Management, following the above instructions on this page (<a href=\"#Step_2_Configure_a_Connection\">step 2<\/a>).\u00a0<\/p>\n<p class=\"intro-text\"><strong>Key Points<\/strong>:<\/p>\n<ul class=\"intro-text\">\n<li>The <strong>Name<\/strong> column must match the name of the datasource, as specified in Step 2 above.<\/li>\n<li>The <span style=\"color: #000000;\"><b>Adaptor Name\u00a0<\/b><\/span>must match one of the adaptors available in the drop-down list in Step 2 above.<\/li>\n<li><strong>Data Type<\/strong> must be <em>Tag.<\/em><\/li>\n<li><strong>Timezone<\/strong> must be either a geographical timezone (available in the drop-down list in Step 2 above) or specified in UTC (e.g. UTC+08).<\/li>\n<li>The <strong>System<\/strong> column does not apply to tag datasources.<\/li>\n<li><strong>Init Timeout<\/strong> and <strong>Request Timeout<\/strong> must be in the format: days:hours:minutes:seconds<\/li>\n<\/ul>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/tag-datasource.png\" rel=\"lightbox-12\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30177\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/tag-datasource.png\" alt=\"\" width=\"1371\" height=\"195\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/tag-datasource.png 1371w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/tag-datasource-768x109.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/tag-datasource-150x21.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/tag-datasource-1280x182.png 1280w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/tag-datasource-24x3.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/tag-datasource-36x5.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/tag-datasource-48x7.png 48w\" sizes=\"auto, (max-width: 1371px) 100vw, 1371px\" \/><\/a><\/p>\n<h4>Dependencies<\/h4>\n<p class=\"intro-text\">The Datasource tab has a direct dependency on information from the System tab.\u00a0<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>This column<\/strong><\/td>\n<td><strong>On this tab<\/strong><\/td>\n<td><strong>Why you need to pay attention<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">Name<\/td>\n<td>System<\/td>\n<td>Required by the 'System' column on the 'Datasource' tab.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"left-bar\">Read more: <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/importexport\/tips-on-filling-in-the-import-spreadsheet\/#Tip_4_Understand_object_dependencies\">Understanding Object Dependencies<\/a><\/p>\n<h3>Datasource Parameter Tab<\/h3>\n<p class=\"intro-text\">The screenshot below shows an example of configured parameters for a datasource using the PI Adaptor.\u00a0The fields are the same as the ones required when completing the datasource parameters using Server Management, following the above instructions on this page. See <a href=\"#Step_3_Configure_the_Adaptor\">Step 3<\/a> above for the available adaptor parameters.<\/p>\n<p class=\"intro-text\"><strong>Key Points<\/strong>:<\/p>\n<ul class=\"intro-text\">\n<li>Each parameter for each datasource must be added on a separate row.<\/li>\n<li>The <strong>Datasource<\/strong> column must match the name of the datasource, as specified in <a href=\"#Step_2_Configure_a_Connection\">Step 2<\/a> above.<\/li>\n<li>The <strong>Name<\/strong> column is the name of the adaptor parameter, as specified in <a href=\"#Step_3_Configure_the_Adaptor\">Step 3<\/a>\u00a0above.<\/li>\n<li>Valid values for <strong>Type<\/strong> are: Boolean, DateTime, Decimal, Duration, Integer, String, EncryptedString. These are specified in the adaptor parameter tables in <a href=\"#Step_3_Configure_the_Adaptor\">Step 3<\/a> above.\u00a0<\/li>\n<li><strong>Is Value Encrypted<\/strong> should be <em>FALSE,<\/em> unless 'Type' is\u00a0'EncryptedString'.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/pi-datasource-param.png\" rel=\"lightbox-13\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30178\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/pi-datasource-param.png\" alt=\"\" width=\"768\" height=\"232\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/pi-datasource-param.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/pi-datasource-param-150x45.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/pi-datasource-param-24x7.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/pi-datasource-param-36x11.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/06\/pi-datasource-param-48x15.png 48w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/a><\/p>\n<h4>Dependencies<\/h4>\n<p class=\"intro-text\">The Datasource Parameter tab\u00a0has a direct dependency on information from the Datasource tab.\u00a0<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>This column<\/strong><\/td>\n<td><strong>On this tab<\/strong><\/td>\n<td><strong>Why you need to pay attention<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">Name<\/td>\n<td>Datasource<\/td>\n<td>Required by the 'Datasource' column on the 'Datasource Parameter' tab.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"left-bar\">Related: <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/importexport\/updating-the-config\/\">Updating the Configuration<\/a><\/p>\n<hr \/>\n<h2 class=\"page-subheading\"><span id=\"Release_History\">Release History<\/span><\/h2>\n<ul class=\"intro-text\">\n<li>PI Adaptor Features 4.10.4\n<ul class=\"intro-text\">\n<li>Added Data Object Discovery Timeout<\/li>\n<\/ul>\n<\/li>\n<li>Creating a Tag Datasource 4.5.3\n<ul class=\"intro-text\">\n<li>Initial version<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Before you can get data into IFS OI Server, you must define a datasource. A datasource is a connection that allows IFS OI Server to retrieve data from an external system, such as an historian, relational database, accounting system, etc. Each datasource retrieves data from one source system. This article explains how to define a connection for the system you want to connect to. <\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/connecting-your-data\/creating-a-tag-datasource\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":70251,"parent":3649,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[11],"tags":[257,674,572,305,304,412,320,223,95],"class_list":["post-4098","page","type-page","status-publish","has-post-thumbnail","hentry","category-tutorial","tag-datasources","tag-datatype","tag-opc","tag-phd","tag-pi","tag-proficy","tag-relational-adaptor","tag-tag-fetch","tag-time-series","Version-4-5-3","Product-srv"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/4098","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=4098"}],"version-history":[{"count":10,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/4098\/revisions"}],"predecessor-version":[{"id":67736,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/4098\/revisions\/67736"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/3649"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/70251"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=4098"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=4098"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=4098"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}