{"id":51362,"date":"2021-08-04T07:01:12","date_gmt":"2021-08-03T23:01:12","guid":{"rendered":"https:\/\/oihelp.corporate.ifs.com\/help\/?page_id=51362"},"modified":"2024-06-28T14:48:48","modified_gmt":"2024-06-28T06:48:48","slug":"using-data-mart","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/connecting-your-data\/using-data-mart\/","title":{"rendered":"Using Data Mart"},"content":{"rendered":"\n

The Data Mart is a database that contains Shift Log entries, and enables data to be extracted from the database, for general use in IFS OI Explorer.<\/p>\n

The data mart works by enabling shift log entries to be written to tables in the database. Each General Entry form and Log Entry form writes to its own table, which is named after the form name. All Case Entry forms write to the one Cases table.<\/p>\n

External queries can be written to extract Shift Log data from the database, in a format that is easy to use in other systems such as Power BI or SSRS.<\/p>\n

Configuring a Data Mart<\/h2>\n

A data mart is configured in IFS OI Server Management.<\/p>\n

1. Open IFS OI Server Management, and click the Connections<\/strong> \"\" icon.<\/p>\n

2. Click Data Mart<\/strong> and fill in the fields as required.<\/p>\n

\"\"<\/a><\/p>\n\n\n\n\n\n\n\n\n
3.<\/strong><\/td>\nEnable<\/strong><\/td>\nSelect the checkbox to enable the Data Mart.<\/td>\n<\/tr>\n
4.<\/strong><\/td>\nServer<\/strong><\/td>\nEnter the name of the Microsoft SQL Server machine you want to connect to.<\/td>\n<\/tr>\n
5.<\/strong><\/td>\nDatabase<\/strong><\/td>\nEnter the name of the Microsoft SQL Server database you want your Shift Log entries written to.<\/td>\n<\/tr>\n
6.<\/strong><\/td>\nTrusted connection<\/strong><\/td>\nSelect the checkbox to use a trusted connection.<\/td>\n<\/tr>\n
7.<\/strong><\/td>\nLog on<\/strong><\/td>\nEnter username and password if a trusted connection is not being used.<\/td>\n<\/tr>\n
8.<\/strong><\/td>\nSave<\/strong><\/td>\nClick Save<\/strong>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Note: Only one data mart connection is active at a time.<\/p>\n

Using a Data Mart<\/h2>\n

Shift Log entry forms can be set up to write to the database you specified in your data mart configuration.<\/p>\n

Setting up the Entry Forms<\/h3>\n

To set up a form to use the data mart:<\/p>\n

1. Open IFS OI Server Management, and click the Shift Log<\/strong> \"\" icon.<\/p>\n

2. Click Case Entry Forms, Log Entry Forms,\u00a0<\/b>or\u00a0General Entry Forms<\/b>.<\/p>\n

3.\u00a0Click the\u00a0<\/span>Add Form<\/strong> button, or click the form you want to edit.<\/span><\/p>\n

\"\"<\/a><\/p>\n

4. Complete the form details.<\/p>\n

5. Select the Write to Data Mart<\/strong> checkbox.<\/p>\n

\"\"<\/a><\/p>\n

6. Click Save.<\/p>\n

\"\"<\/a><\/p>\n

Related: Forms<\/a><\/p>\n

Writing to the Database<\/h3>\n

When you enter data into a form that has the Write to Data Mart checkbox selected, a table of data is created in the database you specified in your data mart configuration.<\/p>\n

Different forms write to different tables.<\/p>\n\n\n\n\n
\u00a0<\/td>\nCase Entry<\/strong><\/td>\nLog Entry<\/strong><\/td>\nGeneral Entry<\/strong><\/td>\n<\/tr>\n
Table name<\/strong><\/td>\n\n

All case entry forms write to the table:<\/p>\n

exrp.Cases.<\/p>\n<\/td>\n

\n

Each log entry form generates a separate table:<\/p>\n

exrp.Form Name<\/em>_Log Entry_ShiftLog<\/p>\n

Where Form Name<\/em> is the name of the log entry form.<\/p>\n<\/td>\n

\n

Each general entry form generates a separate table:<\/p>\n

exrp.Form Name<\/em>_General Entry_ShiftLog<\/p>\n

Where Form Name<\/em> is the name of the general entry form.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Database and tables in Microsoft SQL Server Management Studio:<\/em><\/p>\n

\"\"<\/a><\/p>\n\n\n\n\n\n\n
1.<\/strong><\/td>\nDatabase<\/strong><\/td>\nThe predefined database specified in the Data Mart configuration.<\/td>\n<\/tr>\n
2.<\/strong><\/td>\nLog Entry table<\/strong><\/td>\nAdakite Log Data form entries are written to this table.<\/td>\n<\/tr>\n
3.<\/strong><\/td>\nGeneral Entry table<\/strong><\/td>\nAdakite Production Data form entries are written to this table.<\/td>\n<\/tr>\n
4.<\/strong><\/td>\nCases table<\/strong><\/td>\nAdakite Cases Data form entries are written to this table.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Adakite Log Data_Log Entry_ShiftLog table in Microsoft SQL Server Management Studio:<\/em><\/p>\n

\"\"<\/a><\/p>\n

Related: Entry Dialog<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

A data mart is a connection between Shift Log and a predefined Microsoft SQL Server database. The datamart works by enabling shift log entries to be written to tables in the database. External queries can be written to extract Shift Log data from the database, in a format that is easy to use in other systems such as Power BI or SSRS.<\/p>\n

Read more<\/i><\/a><\/p>\n","protected":false},"author":29,"featured_media":51499,"parent":3649,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[4],"tags":[896,20,257,674,330,308,218,270,329,306,251],"class_list":["post-51362","page","type-page","status-publish","has-post-thumbnail","hentry","category-explainer","tag-datamart","tag-dataset","tag-datasources","tag-datatype","tag-integrating-systems","tag-oracle","tag-param","tag-sql-server","tag-system-identifiers","tag-tabular-data","tag-time-zones","Version-4-9-3","Product-srv","Product-shiftlog"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/51362","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\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=51362"}],"version-history":[{"count":69,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/51362\/revisions"}],"predecessor-version":[{"id":67737,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/51362\/revisions\/67737"}],"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\/51499"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=51362"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=51362"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=51362"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}