SAP Security – How Secured are SAP Systems?

sap securitySAP is one of the leaders in enterprise application software and has the largest market share in Enterprise Resource Planning or ERP solution . SAP stands for “Systems, Applications and Products” in data processing and provides end-to-end solutions for financials, manufacturing, human resource planning, logistics, distribution, and so. SAP’s application software which comprise of different modules is based on the concepts of specialization and integration.  Each of the modules or products inside the SAP family meets a particular need of an organization and is integrated with the other modules.

[Read more…]

Jump Start with Database Programming

sql commentNot too long ago, when we walked into an office, we used to find huge file cabinets holding files containing tons of information and documents. But those cabinets are sitting dormant today, as computers and Database Management Systems (DBMS) have taken over the storage, backup, access, recovery, and retrieval of data. DBMSs have revolutionized the way we store and access data.

[Read more…]

PLC and SCADA – Tools of Automation

plc scadaIndustrial automation is a phrase we often hear, when reducing labor cost and increasing production volume are the goals of all manufacturing companies. But what do we mean by automation? An industrial manufacturing setup involves different processes which have to be controlled as per a particular sequence, and need to be monitored 24/7.These operations can either be done by deploying manpower or can be automated by employing control systems, information technologies, machines, and automation devices like PLC and SCADA. These automation devices can be used for controlling Variable frequency Drives (VFDs), industrial processes, machinery and factory assembly lines. Replacement of human interference and operator may result in substantial cost reduction in the long run, can lead to a steady and fast rate of production, may be good substitutes for humans in hazardous conditions, and more apt for monotonous human work.

[Read more…]

WAN Connection – The Technology Behind It

Overview

mysqlallowremoteconnectionsUnlike LAN or Local Area Network, WAN or a Wide Area Network spans over a large geographical area, which can be over a state, province or country. WANs often connect multiple smaller networks, such as LANs or metro area networks (MANs). One good example of a WAN is the Internet. Many WANs are corporate or research networks that utilize leased lines.

WANs normally use the public telecommunication system to provide cost-effective connection between LANs. WAN communication can use the public packet-switched networks, satellite communication networks, and wireless packet switching network. Since these links are supplied by independent telecommunications utilities, they are commonly referred to as ‘communication cloud’.  Routers perform this type of activity. They store the message at LAN speed and re-transmit it across the communication cloud at a different speed.  When the entire message has been received at the access router of the remote LAN, it is once again forwarded at LAN speed.  A typical speed at which a WAN interconnects varies between 9600 bps for a leased line to 40 Gbps for a SDH/SONET connection.

[Read more…]

PLC Programming Basics – Simplified and Unearthed

plc basicsPLC is a major component in industrial automation and is an essential aspect of any automated manufacturing process.  The functionality of the PLC has evolved over the years to include sequential relay control, motion control, process control, distributed control systems and networking. They were initially invented to replace the electromagnetic relays and the cumbersome wirings in a control circuit. The data handling, storage, processing power and communication capabilities of some modern PLCs are approximately equivalent to desktop computers. A PLC continuously monitors the state of input devices, such as sensors, pressure switch, level switch, on/off switch, and makes decisions based upon a custom program or logic to control the state of the output devices like actuators, motors, relays or solenoids, and analog devices. It can also measure analog process variables, such as temperature and pressure and values from positioning and vision systems. The programs that are required to control the operation are usually stored in battery-backed or non-volatile memory. The logic or sequence of operation for a process or the program is fed into a PLC so that it can control several functions in industrial processes.

[Read more…]

A Trigger In SQL – What Does it Trigger?

trigger in sqlSQL – An Intuitive Way to Interact with Databases

SQL has become very popular and is a universally acceptable database language used to communicate with a relational database. Every business has data and requires organizational methods or data management processes to maintain the data. So it is important to learn and understand SQL and how data structures are used to store information in an organization. SQL is the language you use to convey your needs to the database. You can learn this single language, and with minor adjustments, can apply it to a wide variety of database platforms, applications, and products. You can request specific information from within a database by writing a query in SQL. A trigger is one such query that gets executed when changes are made to the structure of a database table.

[Read more…]

SAP HCM Modules – Complete HR Solution

sap hcm modulesSAP is one of the leaders in enterprise applications and has the largest market share in Enterprise Resource Planning or ERP solution. SAP stands for “Systems, Applications and Products” in data processing and provides end-to-end solutions for financials, manufacturing, human resource planning, logistics, distribution, and so on. SAP’s application software comprises of different modules, and it is based on the concepts of specialization and integration.  Each of the modules or products inside the SAP family meets a particular need of an organization and is integrated with the other modules. SAP Beginners Training course will give you an overview of the different SAP modules, an introduction to the basics of an SAP system, how to navigate through an SAP system, work with master data and multiple sessions, understand the icons used in SAP, and illustrate how to customize a layout.

[Read more…]

Examples of PLC Programming

Programmable Logic Controller And RelaysIf you are thinking of working in the automation industry, then you have to get familiar with PLCs and how to program them. Industrial automation plays a very important role in manufacturing and processing industries and Programmable Logic Controller (PLC) is extensively used for automation and process control systems. To have a head start on learning about PLCs, browsing through the course PLC Automation Training may be a good idea. [Read more…]

Using MS Access with VBA

microsoft access 2010 tutorialMicrosoft Access is another Microsoft product, used for creating computer databases. It can be used on a Microsoft Windows operating system, on a web site, or on a portable medium. Though a good performing database can be created by using only Microsoft Office Access, you may sometimes require more complex databases and may need to perform functions such as automate certain processes and tie your database objects together. These can be achieved by programming and writing code techniques in VBA. Learn VBA for Microsoft Access will orient to the programming tools in Microsoft Office Access 2007 and will point you to some resources where you can learn more about VBA codes and scripts.

[Read more…]

Managed vs Unmanaged Switch – Which to Choose?

managed vs unmanaged switch

Networking and Network Devices

The practice of linking two or more computing devices together for the purpose of sharing data is called networking. When a house with different family members want to interconnect their computers to exchange information, an office wants to set up a network to provide internet access to all its computers or exchange files between its different branch offices, then networking is the way to go. Certain hardware equipment and wiring (or wireless) is required to interconnect these devices. Network devices such as routers, switches, hubs and bridges installed in a network improve connectivity, reduce traffic, and enhance performance.

[Read more…]