Middleware Batch Application Using the Windows OS Case Assignment
Order ID 53563633773 Type Essay Writer Level Masters Style APA Sources/References 4 Perfect Number of Pages to Order 5-10 Pages
Middleware Batch Application Using the Windows OS Case Assignment
This is the last lab for this course, and in this lab, we will outline and create the beginning process to tie all of the pieces for the project together. As has been discussed in the lecture material, middleware is the glue that holds applications in an integrated system together. In this lab, we will create a simple middleware batch application using the Windows OS to execute all of our Oracle and C#.NET applications. For the lab, you will only need to set up processing for the first half of the application processes, but you will need to build on the lab deliverable to finish the project.
A Windows OS batch file application can be a very powerful thing, yet it is very simple to construct and execute. The key things that will need to be dealt with in this process are making sure that data files are being sent to the correct place and that application executables are where they should be and referenced correctly in the batch file. You will be using the user input form screen to create your test data for the lab. Try to create data that will test both valid and invalid order data so that you will get errors reported in the error_audit table. Make sure that as you put the pieces together for the lab and testing that you are using the correct file names to test with.
Be sure to check each of the applications and script files to ensure they are saving and reading files from the correct locations and with the correct names. For example, in iLab 2, the order entry input file was named “Lab2OE.txt” and in iLab 6 it was named “Lab6OE.txt.“For the final project, all applications should refer to this file the same way, such as by the name “Lab7TestOE.txt.” You should verify the location and naming of all other input and output files used by the applications.
For this lab, you will be required to submit the batch file application that you will be creating and the resulting files from the TRANS_APP and INV_GRAB C#.NET applications. You will be provided with test files to run through the applications. Place the batch file along with the two output files in a single ZIP file and submit to the Dropbox for Lab 7.
STEP 1: Setting up the Processing Order
Before you can proceed any further, you need to determine the processing order for all of the applications you are going to use in the system. The Oracle Form is used to create the initial order information files that will be used by the other applications at the front. What you need to be concerned with is what applications will need to be executed and in what order to be able to complete the order transaction process successfully.
For this lab, we will only set up the scenario for the first set of processes, it will be your task then to continue forward and complete the set of processes for the project. For the lab, you will need to set up the correct process order in the middleware application to execute the user input form, XML_PROC and SEQ_PROC procedures and the TRANS_APP and INV_GRAB C#.NET applications.
To simplify things with the Oracle XML_PROC and SEQ_PROC, it might be easier to create a SQL file that will log you into Oracle and then execute both the procedures and then exit SQLPlus. By doing this, you will only need to execute one statement verses several. Your statements inside the file might look similar to the following:
execute XML_PROC(‘SAI430_###_DIR, ‘LAB7TEST.XML’);
execute SEQ_PROC(‘SAI430_###_DIR, ‘LAB7TESTOE.TXT’, ‘LAB7TESTOL.TXT’);
You will need to include your login information of course for the connection string. You could save the file with a name like ProcessScript.SQL and then simply reference the one file in your batch listing.
STEP 2: Plugging in the Paths
The process of setting up a Windows OS batch file is very simple and can be done using Notepad as the editor. There are only a few basic commands that you will need, and most of the coding is simply telling the OS where to find things.
To execute the user input form you simply need to provide the path to the form. Be sure that you have set the paths in the form for the output files to go to the Q: drive directory you have been assigned as they will be read by the Oracle procedures and must be on that drive. Your command to execute this application should look similar to the following.
To communicate with Oracle, you will need to invoke SQL*Plus which can be done with a simple reference to SQLPLUS. Since your login credentials are setup in the file that will be called you do not need to login at the time you invoke SQL*Plus. For example, to invoke SQL*Plus and then execute the SQL file you created in Step 1 you would use the following syntax line:
SQLPLUSW /nolog @Q:\SAI430_###\ProcessScript.sql
This will start up the SQL*Plus editor in the Windows OS and the log into Oracle and then immediately execute the SQL file you have provided the path to. You will be able to see the process take place in the command window. By adding the EXIT statement in the SQL file then SQL*Plus will close as soon as the two procedures have completed. Now we need to be able to call the C#.NET applications.
To simplify the process, or at least the path used for the C# calls you can take the executable file found in the bin\debug directory under the project name and move it to the SAI430_### root directory. It will still execute the same but it will simplify the full path you have to use in the call. This is only a suggestion and in no way will affect the way your application executes. To call the application you simply list the path to the executable. For example, to execute the TRANS_APP application you would list the following in the batch file.
Or if you did not want to move the executable then the path would be –
During development it is often easier to leave the executables in their debug directories so that you don’t need to move them every time you have to fix an error.
One additional consideration you might want to think about would be to include the word PAUSE between each line that calls an application. This will cause the processing to pause between each application until you press the enter key, at which time the process will continue to the next command.
Now you have the syntax for the two PL/SQL procedures and one of the C#.NET applications, all you need to do now is add the second C# application call for this lab. When finished, you want to make sure that you save your file with a .BAT extension (be sure it does not save it with a .bat.txt type extension).
VERY IMPORTANT – Once saved, this file is now an executable. DO NOT double click on the file if you need to edit it. Doing so will cause the file to execute! If you need to edit the file, then right click on it and select Edit from the list. This will open the file in Notepad.
STEP 3: Testing by Pieces
To test your batch file, you will need to make sure you have everything in the correct directory on Citrix and that you have used the correct file names in the batch file that you created. You will have three input files created by the user input form for the PL/SQL procedures and the two C#.NET applications should each produce a single output file. Also, you will need to start a session in Oracle and delete the data from the ERROR_AUDIT, ODER_LINE, ORDER_ENTRY, and CUST_ENTRY tables before running your batch program. Not doing this will cause integrity violations in the tables and cause the process to stop.
To test your middleware application, you simply need to double click on it. You should first be presented with the user input form which you can use to create the files to go to Oracle. Once you exit out of the form, you should see the OS command window appear and then the processes start to run. If the process is successful then check the TRANS_FILE.TXT and INV_GRAB.TXT files that were generated by the C# applications to make sure there is data in them. You will be submitting these for grading of the lab. If there were errors in the processing, then work on correcting these and rerun the batch file.
Middleware Batch Application Using the Windows OS Case Assignment
QUALITY OF RESPONSE NO RESPONSE POOR / UNSATISFACTORY SATISFACTORY GOOD EXCELLENT Content (worth a maximum of 50% of the total points) Zero points: Student failed to submit the final paper. 20 points out of 50: The essay illustrates poor understanding of the relevant material by failing to address or incorrectly addressing the relevant content; failing to identify or inaccurately explaining/defining key concepts/ideas; ignoring or incorrectly explaining key points/claims and the reasoning behind them; and/or incorrectly or inappropriately using terminology; and elements of the response are lacking. 30 points out of 50: The essay illustrates a rudimentary understanding of the relevant material by mentioning but not full explaining the relevant content; identifying some of the key concepts/ideas though failing to fully or accurately explain many of them; using terminology, though sometimes inaccurately or inappropriately; and/or incorporating some key claims/points but failing to explain the reasoning behind them or doing so inaccurately. Elements of the required response may also be lacking. 40 points out of 50: The essay illustrates solid understanding of the relevant material by correctly addressing most of the relevant content; identifying and explaining most of the key concepts/ideas; using correct terminology; explaining the reasoning behind most of the key points/claims; and/or where necessary or useful, substantiating some points with accurate examples. The answer is complete. 50 points: The essay illustrates exemplary understanding of the relevant material by thoroughly and correctly addressing the relevant content; identifying and explaining all of the key concepts/ideas; using correct terminology explaining the reasoning behind key points/claims and substantiating, as necessary/useful, points with several accurate and illuminating examples. No aspects of the required answer are missing. Use of Sources (worth a maximum of 20% of the total points). Zero points: Student failed to include citations and/or references. Or the student failed to submit a final paper. 5 out 20 points: Sources are seldom cited to support statements and/or format of citations are not recognizable as APA 6th Edition format. There are major errors in the formation of the references and citations. And/or there is a major reliance on highly questionable. The Student fails to provide an adequate synthesis of research collected for the paper. 10 out 20 points: References to scholarly sources are occasionally given; many statements seem unsubstantiated. Frequent errors in APA 6th Edition format, leaving the reader confused about the source of the information. There are significant errors of the formation in the references and citations. And/or there is a significant use of highly questionable sources. 15 out 20 points: Credible Scholarly sources are used effectively support claims and are, for the most part, clear and fairly represented. APA 6th Edition is used with only a few minor errors. There are minor errors in reference and/or citations. And/or there is some use of questionable sources. 20 points: Credible scholarly sources are used to give compelling evidence to support claims and are clearly and fairly represented. APA 6th Edition format is used accurately and consistently. The student uses above the maximum required references in the development of the assignment. Grammar (worth maximum of 20% of total points) Zero points: Student failed to submit the final paper. 5 points out of 20: The paper does not communicate ideas/points clearly due to inappropriate use of terminology and vague language; thoughts and sentences are disjointed or incomprehensible; organization lacking; and/or numerous grammatical, spelling/punctuation errors 10 points out 20: The paper is often unclear and difficult to follow due to some inappropriate terminology and/or vague language; ideas may be fragmented, wandering and/or repetitive; poor organization; and/or some grammatical, spelling, punctuation errors 15 points out of 20: The paper is mostly clear as a result of appropriate use of terminology and minimal vagueness; no tangents and no repetition; fairly good organization; almost perfect grammar, spelling, punctuation, and word usage. 20 points: The paper is clear, concise, and a pleasure to read as a result of appropriate and precise use of terminology; total coherence of thoughts and presentation and logical organization; and the essay is error free. Structure of the Paper (worth 10% of total points) Zero points: Student failed to submit the final paper. 3 points out of 10: Student needs to develop better formatting skills. The paper omits significant structural elements required for and APA 6th edition paper. Formatting of the paper has major flaws. The paper does not conform to APA 6th edition requirements whatsoever. 5 points out of 10: Appearance of final paper demonstrates the student’s limited ability to format the paper. There are significant errors in formatting and/or the total omission of major components of an APA 6th edition paper. They can include the omission of the cover page, abstract, and page numbers. Additionally the page has major formatting issues with spacing or paragraph formation. Font size might not conform to size requirements. The student also significantly writes too large or too short of and paper 7 points out of 10: Research paper presents an above-average use of formatting skills. The paper has slight errors within the paper. This can include small errors or omissions with the cover page, abstract, page number, and headers. There could be also slight formatting issues with the document spacing or the font Additionally the paper might slightly exceed or undershoot the specific number of required written pages for the assignment. 10 points: Student provides a high-caliber, formatted paper. This includes an APA 6th edition cover page, abstract, page number, headers and is double spaced in 12’ Times Roman Font. Additionally, the paper conforms to the specific number of required written pages and neither goes over or under the specified length of the paper.
GET THIS PROJECT NOW BY CLICKING ON THIS LINK TO PLACE THE ORDER
Do You Have Any Other Essay/Assignment/Class Project/Homework Related to this? Click Here Now [CLICK ME] and Have It Done by Our PhD Qualified Writers!!
Tired of getting an average grade in all your school assignments, projects, essays, and homework? Try us today for all your academic schoolwork needs. We are among the most trusted and recognized professional writing services in the market.
We provide unique, original and plagiarism-free high quality academic, homework, assignments and essay submissions for all our clients. At our company, we capitalize on producing A+ Grades for all our clients and also ensure that you have smooth academic progress in all your school term and semesters.
High-quality academic submissions, A 100% plagiarism-free submission, Meet even the most urgent deadlines, Provide our services to you at the most competitive rates in the market, Give you free revisions until you meet your desired grades and Provide you with 24/7 customer support service via calls or live chats.