{"id":29257,"date":"2022-08-22T11:41:18","date_gmt":"2022-08-22T18:41:18","guid":{"rendered":"https:\/\/digilent.com\/blog\/?p=29257"},"modified":"2022-08-22T11:41:18","modified_gmt":"2022-08-22T18:41:18","slug":"reading-generated-data-in-a-real-time-distributed-system-part-1","status":"publish","type":"post","link":"https:\/\/digilent.com\/blog\/reading-generated-data-in-a-real-time-distributed-system-part-1\/","title":{"rendered":"Reading Generated Data in a Real-Time Distributed System – Part 1"},"content":{"rendered":"

\"\"<\/p>\n

In today\u2019s manufacturing world, companies are trying to do more with less staffing by maximizing throughput or looking for critical status of a production line without interrupting focus of production staffing.<\/p>\n

In the past, a manager would often need to walk the production floor to see how the various processes are performing. This took time away from other important tasks, and required these managers to generate reports and perhaps present the data to other managers. One way that the process has evolved to reduce or even eliminate the need for manager oversight is by sending the data collected from various systems to a centralized (physical or cloud-based) data base.<\/p>\n

Many manufacturing facilities utilize data acquisition and control products integrated directly into their production stands.\u00a0 These devices monitor and\/or control the manufacturing process of products from all aspects of life today.\u00a0 The sensor data used to make programmed decisions to any part of the production process can also be used to inform and notify managers, supervisors, directors, administrators, etc. either as a consolidated view or as a report in near real-time.<\/p>\n

The key to this is setting up a database as a repository or collection point for all the data being collected. Once the data base is created and setup, existing code used can be easily modified to send that telemetry to the data base where folks who needs to know, can run an app to see what is happening over in production.<\/p>\n

This series of articles demonstrates creating and setting up a database and suggestions for augmenting applications written in but not limited to Visual Basic.NET, LabVIEW, and DASYLab.<\/p>\n

Part 2 – Creating an Application to Collect and Pass Data<\/a><\/p>\n

Part 3 – Creating an Application to View Data<\/a><\/p>\n

Part 4 – Distributing Applications<\/a><\/p>\n

Part 5 – Using Additional Software Packages<\/a><\/p>\n

Setting Up an MS Database<\/h2>\n

There are a lot of ‘step by step’ instructions on how to accomplish this on the internet, just Google \u201cHow to set up an ODBC connection.\u201d\u00a0 In lieu of that, here are my ‘step by step’ instructions (as performed on Windows 7\/64 bit).<\/p>\n

You will need to put an ODBC connection on the computer you’re working on. Click on Start>> Control Panel >> Administrative Tools, then double click on “Data Sources (ODBC)”. Click on the “System DSN” tab. User DSN means that only you will be able to access this data source, and System DSN means that anyone who is on the machine should be able to access the data source (though only if they provide the necessary credentials). Now click on\u00a0<\/span>Add\u2026<\/strong><\/p>\n

\"\"<\/p>\n

We will be using Microsoft Access, so select \u2018Microsoft Access Driver (*.mdb, *.accdb),\u2019 then click\u00a0<\/span>Finish<\/strong>.<\/p>\n

\"\"<\/p>\n

The ODBC Microsoft Access Setup dialog appears.\u00a0 Enter a Data Source Name, Description, and click on\u00a0<\/span>Create\u2026<\/strong><\/p>\n

\"\"<\/p>\n

The new Database dialog appears.\u00a0 Enter the name of the database.\u00a0 Throughout this article, we will be working with the name\u00a0<\/span>MccGenericOdbc, and it is placed in C:\\Users\\Public\\Documents.<\/p>\n

\"\"<\/p>\n

Click on\u00a0<\/span>OK<\/strong>.\u00a0If all went correctly you should see this message:<\/p>\n

\"\"<\/p>\n

Click on\u00a0<\/span>OK<\/strong>, and you will be back to the ODBC Microsoft Setup now with the database name inserted:<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Click\u00a0<\/span>OK<\/strong>, and now your ODBC Data Source Administrator will look like this:<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Open the Windows explorer and navigate to C:\\Users\\Public\\Documents to see your new database:<\/p>\n

\"\"<\/p>\n

It is assumed you have a copy of Microsoft Access to complete the following steps.\u00a0 However, if you do not, attached to this article is a useable copy of the database for this project.<\/p>\n

Double click on MCCGenericOdbc.mdb to launch Microsoft Access and open the empty database. Click \u201cCreate > Table\u201d.<\/p>\n

\"\"<\/p>\n

A new Table appears. The first column is already labeled \u201cID\u201d.\u00a0 We need 5 additional columns for our table. \u00a0Notice the column to the right of ID is highlighted, and labeled \u201cClick to add<\/em>\u201d.\u00a0 Click on it, and a drop down menu appears with various options for the data type.\u00a0 We want this first column to be the time the data was collected so select \u201cDate & Time\u201d. \u00a0The cursor moves to the field name location.\u00a0 By default it is named \u201cField1\u201d.\u00a0 Change that to \u201cTime\u201d.\u00a0 Repeat this process for the next 4 columns, making the data types all \u201cShort Text\u201d, and with the names changed to, \u201cTemperature\u201d, \u201cPressure\u201d, \u201cTachometer\u201d, and \u201cInterlock\u201d.<\/p>\n

When completed, it will look like this:<\/p>\n

\"\"<\/p>\n

Click on \u201cFile\u201d, \u201cSave\u201d, and a Save as dialog appears.\u00a0 Enter a name for the table.\u00a0 Enter \u201cTestData\u201d and click\u00a0<\/span>OK<\/strong>.\u00a0 Then close Access.\u00a0 We will be reading and writing to this data table in the next sections.<\/p>\n

 <\/p>\n

0<\/span><\/a><\/div><\/div>
Be the 1st to vote.<\/div><\/div>
<\/div>","protected":false},"excerpt":{"rendered":"

In today\u2019s manufacturing world, companies are trying to do more with less staffing by maximizing throughput or looking for critical status of a production line without interrupting focus of production … <\/p>\n","protected":false},"author":59,"featured_media":29344,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4361,4267,1563],"tags":[],"ppma_author":[4507],"class_list":["post-29257","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-acquisition","category-featured","category-guide"],"jetpack_featured_media_url":"https:\/\/digilent.com\/blog\/wp-content\/uploads\/2022\/08\/2022-ReadingGeneratedData2-part1-580.png","authors":[{"term_id":4507,"user_id":59,"is_guest":0,"slug":"jgreenberg","display_name":"Jeff Greenberg","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/7d7c29970e5c0f9f3acaf605ee106bd6?s=96&d=mm&r=g","author_category":"","user_url":"","last_name":"Greenberg","last_name_2":"","first_name":"Jeff","first_name_2":"","job_title":"","description":""}],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/digilent.com\/blog\/wp-json\/wp\/v2\/posts\/29257","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/digilent.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/digilent.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/digilent.com\/blog\/wp-json\/wp\/v2\/users\/59"}],"replies":[{"embeddable":true,"href":"https:\/\/digilent.com\/blog\/wp-json\/wp\/v2\/comments?post=29257"}],"version-history":[{"count":0,"href":"https:\/\/digilent.com\/blog\/wp-json\/wp\/v2\/posts\/29257\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/digilent.com\/blog\/wp-json\/wp\/v2\/media\/29344"}],"wp:attachment":[{"href":"https:\/\/digilent.com\/blog\/wp-json\/wp\/v2\/media?parent=29257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/digilent.com\/blog\/wp-json\/wp\/v2\/categories?post=29257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/digilent.com\/blog\/wp-json\/wp\/v2\/tags?post=29257"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/digilent.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=29257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}