SAP Configuration, SAP HANA Training

Add SAP HANA Cloud Account in HANA Studio / Eclipse

Installing SAP HANA Studio/ Eclipse IDE. To add the cloud account to HANA studio or Eclipse. Download and Install HANA Studio from SAP Service MarketPlace. <a href="https://lh3.googleusercontent.com/-HyoCK3MSOG0/VsxqwEc1Y-I/AAAAAAAACyk/TeWEguGdnnY/s1600-h/2-23-2016%2525202-58-30%252520PM%25255B4%25255D.jpg"><img alt="2-23-2016 2-58-30 PM" border="0" height="32" src="https://lh3.googleusercontent.com/-OwQjyAAoo7M/VsxqxBtrz5I/AAAAAAAACyo/xNzgcUDdZtg/2-23-2016%2525202-58-30%252520PM_thumb%25255B2%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-23-2016 2-58-30 PM" width="293"></a> Or Download and Install Eclipse MARS or LUNA from the below Download Link <a href="http://www.eclipse.org/downloads/packages/release/Mars/1" target="_blank">Eclipse MARS Download Link</a> <a href="http://www.eclipse.org/downloads/packages/release/Luna/SR2" target="_blank">Eclipse LUNA Download Link</a> To Access SAP Cloud Account in SAP HANA Studio / Eclipse. Install New Software <ul> <li>Go to Help Menu and Click Install New Software</li></ul>           <a href="https://lh3.googleusercontent.com/-gk_RTcW_dKY/VsxqyC-XcuI/AAAAAAAACys/JEcJ2Yt6n5s/s1600-h/2-22-2016%2525205-34-15%252520PM%25255B5%25255D.jpg"><img alt="2-22-2016 5-34-15 PM" border="0" height="244" src="https://lh3.googleusercontent.com/--Olt9HnxpWU/VsxqzBSZT8I/AAAAAAAACyw/ALfPm4qsysE/2-22-2016%2525205-34-15%252520PM_thumb%25255B1%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-22-2016 5-34-15 PM" width="210"></a> <ul> <li>Click on add button and enter the following link ( https://tools.hana.ondemand.com/kepler ) <li>Select the tools SAP HANA Cloud Platform tools / SAP HANA tools <li>Click Next and Finish the Installation. <li>Restart the SAP HANA Studio / Eclipse.</li></ul> <a href="https://lh3.googleusercontent.com/-B1n59Er45YQ/Vsxq0cgZNdI/AAAAAAAACy0/YqMPoRQvAQk/s1600-h/2-22-2016%2525205-38-32%252520PM%25255B6%25255D.jpg"><img alt="2-22-2016 5-38-32 PM" border="0" height="437" src="https://lh3.googleusercontent.com/-ONxQ7hVba9Q/Vsxq1YLHJVI/AAAAAAAACy4/896DWJBdrzc/2-22-2016%2525205-38-32%252520PM_thumb%25255B4%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-22-2016 5-38-32 PM" width="572"></a> Adding Cloud System <ul> <li>Go to Modeler Prespective > Click on Add Cloud System</li></ul> <a href="https://lh3.googleusercontent.com/-s2eaAcXyyUU/Vsxq2ZjMzlI/AAAAAAAACy8/73uSsu2A30c/s1600-h/2-23-2016%2525203-18-10%252520PM%25255B2%25255D.jpg"><img alt="2-23-2016 3-18-10 PM" border="0" height="211" src="https://lh3.googleusercontent.com/-IRZW-hAerHU/Vsxq3Gb6GuI/AAAAAAAACzA/eHLboXPs4gw/2-23-2016%2525203-18-10%252520PM_thumb.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-23-2016 3-18-10 PM" width="244"></a> <ul> <li>Input your SAP HANA trial account name, username & password as shown below in the screen. Make sure that Landscape host: hanatrial.ondemand.com</li></ul> <a href="https://lh3.googleusercontent.com/-Hdy52kMeW8g/Vsxq3ztBL1I/AAAAAAAACzE/gleNk0cXJlI/s1600-h/2-22-2016%2525205-39-48%252520PM%25255B7%25255D.jpg"><img alt="2-22-2016 5-39-48 PM" border="0" height="462" src="https://lh3.googleusercontent.com/-WKkBknNIolQ/Vsxq4wjKVvI/AAAAAAAACzI/PL_CEnocLMw/2-22-2016%2525205-39-48%252520PM_thumb%25255B3%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-22-2016 5-39-48 PM" width="570"></a> <ul> <li>Click next </li></ul> <a href="https://lh3.googleusercontent.com/-fsNUk0-pyJM/Vsxq5mGKx1I/AAAAAAAACzM/ko6zYbm6DkU/s1600-h/2-22-2016%2525205-40-43%252520PM%25255B5%25255D.png"><img alt="2-22-2016 5-40-43 PM" border="0" height="468" src="https://lh3.googleusercontent.com/-INvKxLdGwqE/Vsxq7E-bH5I/AAAAAAAACzQ/3jTwfMfCAGM/2-22-2016%2525205-40-43%252520PM_thumb%25255B3%25255D.png?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-22-2016 5-40-43 PM" width="574"></a> <ul> <li>Select the HANA instance created in the Cloud Account. <a href="http://www.itstuffs.net/2016/02/sap-hana-free-server-access-trail.html" target="_blank">Check on how to create HANA trial account.</a> <li>Click finish.</li></ul> <a href="https://lh3.googleusercontent.com/-lZ_s4SZvElQ/Vsxq8cE8JPI/AAAAAAAACzU/oayePTkA10k/s1600-h/2-23-2016%2525205-04-22%252520PM%25255B4%25255D.jpg"><img alt="2-23-2016 5-04-22 PM" border="0" height="469" src="https://lh3.googleusercontent.com/-sCt9zpt3Iiw/Vsxq9X-T_eI/AAAAAAAACzY/_H6bxu4WBFg/2-23-2016%2525205-04-22%252520PM_thumb%25255B2%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-23-2016 5-04-22 PM" width="578"></a> <ul> <li>Now you can see the cloud system added to SAP HANA studio.</li></ul> <a href="https://lh3.googleusercontent.com/-9TMq0Ki94D8/Vsxq-cbh1dI/AAAAAAAACzc/c7V34MCFYP0/s1600-h/2-23-2016%2525205-13-45%252520PM%25255B3%25255D.jpg"><img alt="2-23-2016 5-13-45 PM" border="0" height="484" src="https://lh3.googleusercontent.com/-cPF4OirM300/VsxrAUZ4G1I/AAAAAAAACzg/DKzz4OeYR2Y/2-23-2016%2525205-13-45%252520PM_thumb%25255B1%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-23-2016 5-13-45 PM" width="306"></a>

Add SAP HANA Cloud Account in HANA Studio / Eclipse

Installing SAP HANA Studio/ Eclipse IDE. To add the cloud account to HANA studio or Eclipse. Download and Install HANA Studio from SAP Ser...

Personal Action PA40 Part 2

shahul hameed 0 SAP HR

Personal Action PA40 – Part 2 The first step in the HCM Modules is Hiring an Employee. Then Maintain record for the Hired Employee and execute the payroll. Hiring an Employee in SAP T-Code : PA40 Menu Path: Human Resource > Personnel Management > Administration >HR Master Data>Personnel Action Check the <a href="http://www.itstuffs.net/2016/02/personal-action-pa40-part-1.html" target="_blank">Personal Action PA40 – Part 1</a> Action  Enter the details as mentioned in <a href="http://www.itstuffs.net/2016/02/personal-action-pa40-part-1.html" target="_blank">Personal Action PA40 – Part 1.</a> Save the entry & Press Next. <a href="https://lh3.googleusercontent.com/-4ACNGGCD_Ik/VsXS44VcBjI/AAAAAAAACxA/LWZclpvMWlw/s1600-h/TM1%25255B3%25255D.jpg"><img alt="TM1" border="0" height="368" src="https://lh3.googleusercontent.com/-T9ffInHWjdg/VsXS6KTO2gI/AAAAAAAACxE/Z5Ot47GA0Ys/TM1_thumb%25255B3%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="TM1" width="387"></a> Organizational Assigment <ul> <li>Maintain the Subarea Ex: Location <li>Payroll Area.  Save the entry & Press Next.</li></ul> Administrator Group: Following are the administrator heads in PA module: <ul> <li>Personnel Administrator – Head of HR/Administration department. <li>Time Administrator – Head of Time department. <li>Payroll Administrator – Head of Payroll department. <li>Supervisor – Head of any department.</li></ul> Payroll Area: Payroll Area is not at all concerned with the geographical location but it is decided or created by considering following two characteristics: <ul> <li>Processing cycle of payroll i.e. Weekly/Fortnightly/Monthly ( Payment date i.e. 1st of each month for worker and 7th of each month for manager and staff) <li>Earliest possible retroactive accounting period.</li></ul> <a href="https://lh3.googleusercontent.com/-974GY5pMWqQ/VsXS7X7Fu9I/AAAAAAAACxI/swnUgOud4iA/s1600-h/TM2%25255B2%25255D.jpg"><img alt="TM2" border="0" height="376" src="https://lh3.googleusercontent.com/-8DviJSmb7IA/VsXS8l3HQtI/AAAAAAAACxM/txDZDdrx8to/TM2_thumb%25255B1%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="TM2" width="395"></a> Personal Data <ul> <li>Maintain the Personal Information of the Employee. Ex: Birth Date, Birth Place, Nationality, Religion. etc <li>Save the entry & Press Next.</li></ul> <a href="https://lh3.googleusercontent.com/-JgOlBq4zIsg/VsXS9qVUnaI/AAAAAAAACxQ/xx1nMJaBl7g/s1600-h/TM3%25255B2%25255D.jpg"><img alt="TM3" border="0" height="365" src="https://lh3.googleusercontent.com/-xBlQt8QrJLc/VsXS-iARiKI/AAAAAAAACxU/3YsV3I3o2Zg/TM3_thumb%25255B2%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="TM3" width="391"></a> Family Member/ Dependents <ul> <li>Maintain the Spouse and Child Details if employee status is Married.</li></ul> <a href="https://lh3.googleusercontent.com/-pCwZrLIOW4I/VsXS_732wOI/AAAAAAAACxY/OETkPw6FynA/s1600-h/TM4%25255B2%25255D.jpg"><img alt="TM4" border="0" height="306" src="https://lh3.googleusercontent.com/-yo1JeM6bB2A/VsXTAvcNSDI/AAAAAAAACxc/oOl9Ajtzl3M/TM4_thumb%25255B1%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="TM4" width="393"></a> <a href="https://lh3.googleusercontent.com/-VhrNijp02DE/VsXTBjKOFKI/AAAAAAAACxg/HdIEOGp1_a8/s1600-h/TM5%25255B2%25255D.jpg"><img alt="TM5" border="0" height="317" src="https://lh3.googleusercontent.com/-9jV7flNJTF4/VsXTC-yHS4I/AAAAAAAACxk/aYcpG5dY4sI/TM5_thumb%25255B1%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="TM5" width="399"></a> Address <ul> <li>Select Permanent Residence and Press enter. <li>Maintain the Address details of the Employee</li></ul> <a href="https://lh3.googleusercontent.com/-pfbA6-B35uI/VsXTDxDO_eI/AAAAAAAACxo/2A31nTwME2w/s1600-h/TM6%25255B2%25255D.jpg"><img alt="TM6" border="0" height="360" src="https://lh3.googleusercontent.com/-OnFSx-bRvlY/VsXTE6Qq7_I/AAAAAAAACxs/ZvJ0RWLFeP8/TM6_thumb%25255B1%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="TM6" width="398"></a> Planned Working Time <ul> <li>Maintain the Work Schedule rule. <li>Time Managment Status: </li></ul> <a href="https://lh3.googleusercontent.com/-k4tfbbtus0Q/VsXTFkhJdlI/AAAAAAAACxw/HIHwh1F4L6c/s1600-h/2-18-2016-4-17-16-PM4.jpg"><img alt="2-18-2016 4-17-16 PM" border="0" height="86" src="https://lh3.googleusercontent.com/-ijn6IYXFe1I/VsXTGhoxJzI/AAAAAAAACx0/G4MLiFtJJ98/2-18-2016-4-17-16-PM_thumb2.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-18-2016 4-17-16 PM" width="241"></a> <a href="https://lh3.googleusercontent.com/-rVmGpPn0HjM/VsXTHpkBNOI/AAAAAAAACx4/k84nhvRoxkA/s1600-h/TM7%25255B2%25255D.jpg"><img alt="TM7" border="0" height="324" src="https://lh3.googleusercontent.com/-NjdoGyP-FCk/VsXTIUdSJHI/AAAAAAAACx8/lSjIB5lw-8Q/TM7_thumb%25255B1%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="TM7" width="400"></a> Basic Pay <ul> <li>In the Payscale Section maintain the Group (As per the position) and in the level as per the grade. Press enter <li>Wage types are configured as per the position. It will Automatically shows the assigned wagetype to the position. <li>Maintain the Amount for the Wage types. <li>Save the Entry.</li></ul> <a href="https://lh3.googleusercontent.com/-J22qwXZF-CY/VsXTJlgrdBI/AAAAAAAACyA/pLIO17DMfqY/s1600-h/TM8%25255B7%25255D.jpg"><img alt="TM8" border="0" height="377" src="https://lh3.googleusercontent.com/-kUXIPWuBVWc/VsXTKr9D4vI/AAAAAAAACyE/GQFj5-5lvS8/TM8_thumb%25255B6%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="TM8" width="403"></a> Bank Details <ul> <li>Maintain the Bank Details. If salary is transferred to Bank <li>For the payment method Cash. No need to enter the Bank Key. <li>Save the entry.</li></ul> <a href="https://lh3.googleusercontent.com/-e0NAF1jH0lk/VsXTLs7yGKI/AAAAAAAACyM/P4qo0AhP1Sc/s1600-h/TM90%25255B2%25255D.jpg"><img alt="TM90" border="0" height="306" src="https://lh3.googleusercontent.com/-pIJGvDUcVao/VsXTMjewUKI/AAAAAAAACyQ/lUrGVt_aQpQ/TM90_thumb%25255B1%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="TM90" width="406"></a> After the Hiring Process is completed. Then Next Action is to Maintain the employee Master Data in PA30. Maintain HR Master Data PA30

Personal Action PA40 Part 2

Personal Action PA40 – Part 2 The first step in the HCM Modules is Hiring an Employee. Then Maintain record for the Hired Employee and exec...

Personal Action PA40 Part 1

shahul hameed 0 SAP HR

Personal Action PA40 – Part 1 The first step in the HCM Modules is Hiring an Employee. Then Maintain Master Data for the Hired Employee and execute the payroll. Personnel Actions: Personnel Actions are the activities carried out on an employee (personnel) within the organization. All personnel actions viz. Hiring, Confirmation, Promotion, Transfer, Change in pay, Separation, Re-hire etc. are maintained here. Hiring an Employee in SAP T-Code : PA40 Menu Path: Human Resource > Personnel Management > Administration >HR Master Data>Personnel Action <ul> <li>Select the Action Type – Hiring. Then press F8 (Execute).</li></ul> <a href="https://lh3.googleusercontent.com/-2DmHqyFtsq4/VsXR50fPa3I/AAAAAAAACwA/l-Em-AX3G_A/s1600-h/2-18-2016%25252011-55-39%252520AM%25255B2%25255D.jpg"><img alt="2-18-2016 11-55-39 AM" border="0" height="349" src="https://lh3.googleusercontent.com/-u0_YHouEPwE/VsXR7JwAF3I/AAAAAAAACwE/Qj8lP6NbtaQ/2-18-2016%25252011-55-39%252520AM_thumb%25255B2%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-18-2016 11-55-39 AM" width="612"></a> Action <ul> <li>Maintain the Start date which is Date of Joining and to Date . <li>Maintain the Personal Data <li>Maintain the Organization Assignment</li></ul> <a href="https://lh3.googleusercontent.com/-E3eylpb6BJc/VsXR8jVBWvI/AAAAAAAACwI/zsMNr2ITrsY/s1600-h/2-18-2016%25252012-03-34%252520PM%25255B1%25255D.jpg"><img alt="2-18-2016 12-03-34 PM" border="0" height="448" src="https://lh3.googleusercontent.com/-sHHvLq8wxOU/VsXR96XLoCI/AAAAAAAACwM/QtMl_lETg0w/2-18-2016%25252012-03-34%252520PM_thumb%25255B1%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-18-2016 12-03-34 PM" width="489"></a>   * Assign the position if it is maintained already by pressing F4. If not create the new Position. Creating Position and Job T-Code: PPOM_OLD <ul> <li>Select the Organization Unit. Press Enter</li></ul> <a href="https://lh3.googleusercontent.com/-EoypcBOfBVQ/VsXR_fGbsWI/AAAAAAAACwQ/jFA57YYz-d8/s1600-h/2-18-2016%25252011-59-51%252520AM%25255B1%25255D.jpg"><img alt="2-18-2016 11-59-51 AM" border="0" height="310" src="https://lh3.googleusercontent.com/-LMCK_GOsUzI/VsXSAm-RZXI/AAAAAAAACwU/hQRyFLSFTyw/2-18-2016%25252011-59-51%252520AM_thumb%25255B1%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-18-2016 11-59-51 AM" width="471"></a> <ul> <li>Place the cursor on top of the organizational Unit Company and press Create. <li>Maintain the department for the company if not exist.</li></ul> <a href="https://lh3.googleusercontent.com/-xP2MhJ2MqCQ/VsXSC9VhQ0I/AAAAAAAACwY/r_y07SQqRBU/s1600-h/2-18-2016%2525201-59-34%252520PM%25255B1%25255D.jpg"><img alt="2-18-2016 1-59-34 PM" border="0" height="244" src="https://lh3.googleusercontent.com/-6zPpY7s_9SY/VsXSEO78gcI/AAAAAAAACwc/2Mji0zUbRU8/2-18-2016%2525201-59-34%252520PM_thumb%25255B1%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-18-2016 1-59-34 PM" width="547"></a> <ul> <li>Place the cursor on top of the organization unit department and press create. <li>Maintain the Position for the department</li></ul> <a href="https://lh3.googleusercontent.com/-SGDZj24S_xg/VsXRPFVXWxI/AAAAAAAACwg/AwchHNbBOp8/s1600-h/2-18-2016%2525202-00-45%252520PM%25255B1%25255D.jpg"><img alt="2-18-2016 2-00-45 PM" border="0" height="255" src="https://lh3.googleusercontent.com/-iWVZFjfjHq4/VsXRQcHqcBI/AAAAAAAACwo/V-QQkqqgomU/2-18-2016%2525202-00-45%252520PM_thumb%25255B1%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-18-2016 2-00-45 PM" width="549"></a> <ul> <li>Give the Abbrevation and Name for the position and create job. <li>Enter the validity period for the Position. <li>Save the entry.</li></ul> <a href="https://lh3.googleusercontent.com/-uFPaU3nz0Ho/VsXSI0382HI/AAAAAAAACws/x41b1rMZbT0/s1600-h/2-18-2016%2525202-02-12%252520PM%25255B1%25255D.jpg"><img alt="2-18-2016 2-02-12 PM" border="0" height="249" src="https://lh3.googleusercontent.com/-4ibz4yMGh_k/VsXSKMhdm2I/AAAAAAAACww/Dfq04lNsxk0/2-18-2016%2525202-02-12%252520PM_thumb%25255B1%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-18-2016 2-02-12 PM" width="548"></a> <ul> <li>Now Assign the Position to the Hired New Employee. <li>Save the entry.</li></ul> <a href="https://lh3.googleusercontent.com/-fWlBNYxFX-4/VsXSLa5l2CI/AAAAAAAACw0/YanItFnMxxk/s1600-h/2-18-2016%2525202-33-24%252520PM%25255B1%25255D.jpg"><img alt="2-18-2016 2-33-24 PM" border="0" height="422" src="https://lh3.googleusercontent.com/-9wEKs8j1WIk/VsXSMrk3sTI/AAAAAAAACw4/EGfcyakv9ds/2-18-2016%2525202-33-24%252520PM_thumb%25255B1%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-18-2016 2-33-24 PM" width="452"></a> Personnel Area: Personnel Area is an organizational unit that represents a specific area of the enterprise and is organized according to the aspects of ‘Personnel’, ‘Time Management’ and ‘Payroll’. Personnel Sub-area: Personnel Sub-area is an organizational unit that represents a specific area of the enterprise and is organized according to aspects of ‘Personnel’, ‘Time Management’ and ‘Payroll’. It is further division of Personnel Area. Employee Group( EE Group): Employee groups are categorized based on employee/staff regulations of work and pay such as 1-Active, 2-Inactive, A-Retiree, B-Pensioner etc Employee Sub-group: Employee Subgroups are the further divisions of employee group such as under ‘Active’ employee group the possible employee subgroups could be A1–Hourly wage earner, A2–Salaried Employee OR B1-Manager, B2-Executive, B3-Supervisor etc <a href="http://www.itstuffs.net/2016/02/personal-action-pa40-part-2.html" target="_blank">Personal Action PA40 – Part 2</a>

Personal Action PA40 Part 1

Personal Action PA40 – Part 1 The first step in the HCM Modules is Hiring an Employee. Then Maintain Master Data for the Hired Employee and...

SAP HANA Free Server Access Trial Account on Cloud.

shahul hameed 0 SAP HANA

SAP HANA Free Server Access Trial Account on Cloud. How to Practice SAP HANA ?. SAP is offering  a free trial account on Cloud for developer. But it comes up with limitations and shared space. You can register one for free and start your hands on to explore SAP HANA. Creating SAP HANA Cloud Account. 1) Create the trial account from the <a href="https://account.hanatrial.ondemand.com/" target="_blank">following link</a>  <a href="https://lh3.googleusercontent.com/-N0i265_WLvs/VsR4MaEiFhI/AAAAAAAACtE/4YKnt26UcKE/s1600-h/2-15-2016%2525208-24-47%252520AM%25255B23%25255D.jpg"><img alt="2-15-2016 8-24-47 AM" border="0" height="201" src="https://lh3.googleusercontent.com/-1UO6XZXvpsA/VsR4NbTpdiI/AAAAAAAACtI/ETNtnYWJvm4/2-15-2016%2525208-24-47%252520AM_thumb%25255B17%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-15-2016 8-24-47 AM" width="383"></a> 2) Register with your name, E-mail & Password. Accept the terms and conditions. <a href="https://lh3.googleusercontent.com/-ZQ-Haq9tCdM/VsR4OeuGMsI/AAAAAAAACtM/Da9kkFLdtxE/s1600-h/2-15-2016%2525208-26-29%252520AM%25255B15%25255D.jpg"><img alt="2-15-2016 8-26-29 AM" border="0" height="293" src="https://lh3.googleusercontent.com/-GIZVSEfR7iI/VsR4PKCr6YI/AAAAAAAACtQ/7vKMJ-Cbm2k/2-15-2016%2525208-26-29%252520AM_thumb%25255B9%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-15-2016 8-26-29 AM" width="415"></a> 3) An Email link will be send for the activation. Activate the account. <a href="https://lh3.googleusercontent.com/-BPqQF-FOJd0/VsR4P8KoNVI/AAAAAAAACtU/e2l3U_uii-A/s1600-h/2-15-2016%2525208-28-13%252520AM%25255B12%25255D.jpg"><img alt="2-15-2016 8-28-13 AM" border="0" height="166" src="https://lh3.googleusercontent.com/-WveOQD4tTfs/VsR4RAAsXNI/AAAAAAAACtY/2ogDNj-aWWY/2-15-2016%2525208-28-13%252520AM_thumb%25255B6%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-15-2016 8-28-13 AM" width="327"></a> 4) After Successful activation. Press continue. <a href="https://lh3.googleusercontent.com/-d5AfwA8nNAE/VsR4R10vPoI/AAAAAAAACtc/6xIm-bRs-W4/s1600-h/2-15-2016%2525208-29-33%252520AM%25255B13%25255D.jpg"><img alt="2-15-2016 8-29-33 AM" border="0" height="193" src="https://lh3.googleusercontent.com/-7o-UWVjsA-U/VsR4Sw307QI/AAAAAAAACtg/rZsjiWL18dc/2-15-2016%2525208-29-33%252520AM_thumb%25255B7%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-15-2016 8-29-33 AM" width="328"></a> 5)  SAP HANA Cloud Platform Cockpit will be opened. <a href="https://lh3.googleusercontent.com/-zkNT-pJhp30/VsR4TpNJnWI/AAAAAAAACtk/sPZUprGm5W4/s1600-h/2-15-2016%2525208-30-39%252520AM%25255B11%25255D.jpg"><img alt="2-15-2016 8-30-39 AM" border="0" height="325" src="https://lh3.googleusercontent.com/-kpEAWUs7lMI/VsR4Uj9fPhI/AAAAAAAACto/tn6pchKgBnk/2-15-2016%2525208-30-39%252520AM_thumb%25255B5%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-15-2016 8-30-39 AM" width="644"></a> 6) Go to Database & Schemas in the left pane of the cockpit. Create New Instance/Database <a href="https://lh3.googleusercontent.com/-MqGmIgbPAPs/VsR4VhTcd8I/AAAAAAAACts/0bMhyk1ApEU/s1600-h/2-15-2016%2525208-31-08%252520AM%25255B13%25255D.jpg"><img alt="2-15-2016 8-31-08 AM" border="0" height="222" src="https://lh3.googleusercontent.com/-Qtx-GlAB6hY/VsR4WnLk5mI/AAAAAAAACtw/H2dQy6qf0rs/2-15-2016%2525208-31-08%252520AM_thumb%25255B7%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-15-2016 8-31-08 AM" width="644"></a> 7) Give the Schema name. And, Select  the database system as HANA <Shared >from the Drop Down. <a href="https://lh3.googleusercontent.com/-Xy2QwfPT5Kw/VsR4Xq0GqCI/AAAAAAAACt0/B32Zbv1dEoQ/s1600-h/2-15-2016%2525208-31-27%252520AM%25255B11%25255D.jpg"><img alt="2-15-2016 8-31-27 AM" border="0" height="249" src="https://lh3.googleusercontent.com/-CiNgzdUPbec/VsR4YhyWYUI/AAAAAAAACt4/kmzrSb6Hkl4/2-15-2016%2525208-31-27%252520AM_thumb%25255B5%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-15-2016 8-31-27 AM" width="644"></a> 8) The Schema  will be created. In the development tools, Click on the SAP HANA Web-based Development Workbench to Launch the WebIDE. <a href="https://lh3.googleusercontent.com/-4Eetc16EKOs/VsR4ZvOOxVI/AAAAAAAACt8/fn7IkFCvYQg/s1600-h/2-15-2016%2525208-41-10%252520AM%25255B17%25255D.jpg"><img alt="2-15-2016 8-41-10 AM" border="0" height="289" src="https://lh3.googleusercontent.com/-Durzw57jBnc/VsR4a1Ph5GI/AAAAAAAACuA/JuLdxRTqPNA/2-15-2016%2525208-41-10%252520AM_thumb%25255B9%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-15-2016 8-41-10 AM" width="602"></a> 9) SAP HANA web based Editor will be opened. <a href="https://lh3.googleusercontent.com/-mJ7uidsdK8c/VsR4bpr1HcI/AAAAAAAACuE/GqBRVcjwt5I/s1600-h/2-17-2016%2525202-57-09%252520PM%25255B11%25255D.jpg"><img alt="2-17-2016 2-57-09 PM" border="0" height="230" src="https://lh3.googleusercontent.com/-wnm54QOorxs/VsR4c10O4kI/AAAAAAAACuI/luecsBq-SXs/2-17-2016%2525202-57-09%252520PM_thumb%25255B7%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-17-2016 2-57-09 PM" width="559"></a> 10) Goto Navigation link and choose catalog. <a href="https://lh3.googleusercontent.com/-8GFUsYnqe80/VsR4dhfywHI/AAAAAAAACuM/wFGKsU_JDYI/s1600-h/2-17-2016%2525202-59-14%252520PM%25255B7%25255D.jpg"><img alt="2-17-2016 2-59-14 PM" border="0" height="196" src="https://lh3.googleusercontent.com/-I-WxXQIqbEI/VsR4e1BpEWI/AAAAAAAACuQ/4bbZBLSxUpU/2-17-2016%2525202-59-14%252520PM_thumb%25255B5%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-17-2016 2-59-14 PM" width="417"></a> 11) In the catalog, you can see list of SCHEMA. Where SYS, _SYS_BI,  _SYS_REPO, _SYS_TASK are System SCHEMA. <a href="https://lh3.googleusercontent.com/-Gem-zI-KBR4/VsR4gQEnjUI/AAAAAAAACuU/fkpJ9fev9DI/s1600-h/2-17-2016%2525202-59-02%252520PM%25255B18%25255D.jpg"><img alt="2-17-2016 2-59-02 PM" border="0" height="263" src="https://lh3.googleusercontent.com/-JzZGCsohpto/VsR4h9wQt2I/AAAAAAAACuY/jKgDETrWt2Y/2-17-2016%2525202-59-02%252520PM_thumb%25255B10%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-17-2016 2-59-02 PM" width="539"></a> Create Tables in SAP HANA Now lets create tables and test it. Click on the SCHEMA and Select the SQL editor. Input the SQL statement to create the table. And Press Run. CREATE COLUMN TABLE "<SHEMA_NAME>"."TEST" (     ID INTEGER PRIMARY KEY,     EMPLOYEE_NAME VARCHAR (50) ) ; <a href="https://lh3.googleusercontent.com/-bvn33EQ040Q/VsR4jCWNd9I/AAAAAAAACuc/q-FXBLP0wfo/s1600-h/2-17-2016%2525203-36-45%252520PM%25255B10%25255D.jpg"><img alt="2-17-2016 3-36-45 PM" border="0" height="311" src="https://lh3.googleusercontent.com/-7R3SK0VOf7o/VsR4kZXNwQI/AAAAAAAACug/ohAhc3bV6Zw/2-17-2016%2525203-36-45%252520PM_thumb%25255B6%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-17-2016 3-36-45 PM" width="644"></a> Right Click on the SCHEMA and refresh to see the created table. <a href="https://lh3.googleusercontent.com/-Tm2VhIjkBck/VsR4lM7gSkI/AAAAAAAACuk/gaopUnC2e80/s1600-h/2-17-2016%2525203-42-28%252520PM%25255B8%25255D.jpg"><img alt="2-17-2016 3-42-28 PM" border="0" height="256" src="https://lh3.googleusercontent.com/-_c7aA4E_AWQ/VsR4mMrGPaI/AAAAAAAACuo/WJ68SpniINQ/2-17-2016%2525203-42-28%252520PM_thumb%25255B6%25255D.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2-17-2016 3-42-28 PM" width="183"></a> Happy Learning <img alt="Smile" class="wlEmoticon wlEmoticon-smile" src="https://lh3.googleusercontent.com/-lWCiKq47b74/VsR4m5j_bVI/AAAAAAAACus/b8OAoB_C2Oo/wlEmoticon-smile%25255B2%25255D.png?imgmax=800" style="border-top-style: none; border-bottom-style: none; border-right-style: none; border-left-style: none">. <div id="scid:77ECF5F8-D252-44F5-B4EB-D463C5396A79:0a8cf540-8d4f-4b9a-b614-c7243c3c4896" class="wlWriterEditableSmartContent" style="float: none; padding-bottom: 0px; padding-top: 0px; padding-left: 0px; margin: 0px; display: inline; padding-right: 0px">Technorati Tags: <a href="http://technorati.com/tags/SAP+HANA+CLoud+Access" rel="tag">SAP HANA CLoud Access</a>,<a href="http://technorati.com/tags/SAP+HANA+Free+Server+Access" rel="tag">SAP HANA Free Server Access</a>,<a href="http://technorati.com/tags/SAP+HANA+create+table" rel="tag">SAP HANA create table</a></div>   How to add a Cloud system to SAP HANA Studio or Eclipse IDE

SAP HANA Free Server Access Trial Account on Cloud.

SAP HANA Free Server Access Trial Account on Cloud. How to Practice SAP HANA ?. SAP is offering a free trial account on Cloud for develo...

How to Load PDF file to SAP HANA

shahul hameed 0 SAP HANA

How to Load PDF file to SAP HANA As explained in the following tutorials. <a href="http://www.itstuffs.net/2016/02/sap-hana-cloud-platform-connecting-via.html" target="_blank">Creating tunel to SAP HANA Cloud Platform</a> <a href="http://www.itstuffs.net/2016/02/sap-hana-cloud-platform-connecting-via.html" target="_blank">Creating ODBC datasource to SAP HANA Cloud Platform</a> <a href="http://www.itstuffs.net/2016/02/python-to-load-binary-documents-to-sap.html" target="_blank">Python to Load Binary Documents to SAP HANA</a> We will now upload the unstructured data into SAP HANA. Create table in SAP HANA First create the table in SAP HANA. Replace the SCHEMA with your SCHEMA name. CREATE COLUMN TABLE <"SCHEMA_NAME">."PDFTEST" ( ID INTEGER PRIMARY KEY, STRING BLOB ); <a href="https://lh3.googleusercontent.com/-9pNh2wZhxpI/VsHp5lnPsQI/AAAAAAAACq4/KjmsdXwr98g/s1600-h/2-15-2016%2525205-01-28%252520PM%25255B7%25255D.jpg"><img alt="2-15-2016 5-01-28 PM" border="0" height="166" src="https://lh3.googleusercontent.com/-xKkoOv61kP8/VsHp6yWWdKI/AAAAAAAACq8/-XPW33-JFWc/2-15-2016%2525205-01-28%252520PM_thumb%25255B5%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="2-15-2016 5-01-28 PM" width="528"></a> Right click > Open content. No data found in the table. Now we will see how to load the pdf data via Python code. <a href="https://lh3.googleusercontent.com/-GgokwVtDtMI/VsHp7qmdy8I/AAAAAAAACrA/nGXB6hOl5RU/s1600-h/2-15-2016%2525205-23-05%252520PM%25255B7%25255D.jpg"><img alt="2-15-2016 5-23-05 PM" border="0" height="252" src="https://lh3.googleusercontent.com/-xBMr_xWsKzE/VsHp89LwQSI/AAAAAAAACrE/P8A11mpsdYk/2-15-2016%2525205-23-05%252520PM_thumb%25255B5%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="2-15-2016 5-23-05 PM" width="519"></a> Copy the following python code Replace the ServerNode, SERVER DB, UID , PWD with your Server DB, Username & Password. Replace SCHEMA NAME & give the pdf file location. import pyodbc #Open Connection to HANA conn = pyodbc.connect('DRIVER={HDBODBC};SERVERNODE=localhost:30115;SERVERDB=hanadbs;UID=ITSTUFFS;PWD=ITSTUFFS') #Open a cursor cur = conn.cursor() #Open file in read-only and binary file = open('c:/pdftest.pdf', 'rb')  # Save the content of the file in a variable content = file.read() #Save the content to the table cur.execute("INSERT INTO NEO_90PWY22OTOLA96KL8HTRM3EJ5.PDFTEST VALUES( ?,?)", ('1',content)) #Save the content to the table cur.execute("COMMIT") # Close the file file.close() # Close the cursor cur.close() # Close the connection conn.close() Copy the program in notepad and Save the file with the extension pdftest.py Right click on the file and Open the file with the Python editor (IDLE) <a href="https://lh3.googleusercontent.com/-_fwgMl5pZYw/VsHp9mYKv7I/AAAAAAAACrI/oTWTtILpVho/s1600-h/2-15-2016%2525205-21-18%252520PM%25255B3%25255D.jpg"><img alt="2-15-2016 5-21-18 PM" border="0" height="220" src="https://lh3.googleusercontent.com/-MF6U_uXqcyA/VsHp-ohsO1I/AAAAAAAACrM/twMDGBNAJgQ/2-15-2016%2525205-21-18%252520PM_thumb%25255B1%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="2-15-2016 5-21-18 PM" width="132"></a> Click on run > Run Module in the python shell. <a href="https://lh3.googleusercontent.com/-Uu-othU7GQk/VsHp_4y8aNI/AAAAAAAACrQ/6vkhnfeYtUE/s1600-h/2-15-2016%2525205-23-39%252520PM%25255B11%25255D.jpg"><img alt="2-15-2016 5-23-39 PM" border="0" height="297" src="https://lh3.googleusercontent.com/-1nSNmbw-Vd8/VsHqBPQXZmI/AAAAAAAACrU/MnCgui8oMJ8/2-15-2016%2525205-23-39%252520PM_thumb%25255B9%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="2-15-2016 5-23-39 PM" width="567"></a> You we get the below screen after execution. <a href="https://lh3.googleusercontent.com/-wLCs9wsMRVU/VsHqCC8gVNI/AAAAAAAACrY/BA3SFFGwbuE/s1600-h/2-15-2016%2525205-30-17%252520PM%25255B7%25255D.jpg"><img alt="2-15-2016 5-30-17 PM" border="0" height="131" src="https://lh3.googleusercontent.com/-CEcg6Dhy0Zc/VsHqDQlA_tI/AAAAAAAACrc/g3Asx-1WTTo/2-15-2016%2525205-30-17%252520PM_thumb%25255B5%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="2-15-2016 5-30-17 PM" width="572"></a> Now go to SAP HANA and refresh the table PDFTEST. You will find the successfully uploaded pdf data. <a href="https://lh3.googleusercontent.com/-K7WgH3ZbX9c/VsHqEUsRSBI/AAAAAAAACrg/7Xx1I1xWBMk/s1600-h/2-15-2016%2525205-40-21%252520PM%25255B8%25255D.jpg"><img alt="2-15-2016 5-40-21 PM" border="0" height="174" src="https://lh3.googleusercontent.com/-MfiVviAJeZw/VsHqFv6dm0I/AAAAAAAACrk/6ht51vyZMS0/2-15-2016%2525205-40-21%252520PM_thumb%25255B6%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="2-15-2016 5-40-21 PM" width="571"></a> We can also perfom further analysis on this unstructured data by Text Analysis feature in SAP HANA. I will cover up Text Analysis, Full text Index, Fuzzy search in upcoming tutorials.

How to Load PDF file to SAP HANA

How to Load PDF file to SAP HANA As explained in the following tutorials. Creating tunel to SAP HANA Cloud Platform Creating ODBC datasou...

Python to Load Binary Documents to SAP HANA

shahul hameed 0 SAP HANA

Python to Load Binary Documents to SAP HANA Python Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in languages such as C++ or Java. Unstructured Data What is Unstructured Data?. Unstructured data (or unstructured information) refers to information that either does not have a pre-defined data model or is not organized in a pre-defined manner. Unstructured information is typically text-heavy, but may contain data such as dates, numbers, and facts as well. How to Load PDF or XML files (Unstructured data) to SAP HANA by using Python Installing Python 1) Download Python for windows from the following link <a href="https://www.python.org/downloads/windows/" target="_blank">click here</a> 2) Download Python odbc drivers from the following link <a href="https://code.google.com/archive/p/pyodbc/downloads" target="_blank">click here</a>     <a href="https://lh3.googleusercontent.com/-O1ofqAMjJTg/VsHlzEPx7hI/AAAAAAAACqA/OLuJxrSI4Q0/s1600-h/2016-02-15_15-18-103.png"><img alt="2016-02-15_15-18-10" border="0" height="53" src="https://lh3.googleusercontent.com/-7BCxZG-WQJc/VsHl0MU9MUI/AAAAAAAACqE/8Y4Fp__sRmQ/2016-02-15_15-18-10_thumb1.png?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="2016-02-15_15-18-10" width="644"></a> 3) Install python in windows directory C:\Python33\ as shown in the picture. Click on finish to complete the installation process.  <a href="https://lh3.googleusercontent.com/-ij4KBVe8VbA/VsHqnpAqpeI/AAAAAAAACro/zIIK7QwDlpQ/s1600-h/2016-02-15_15-18-34%25255B4%25255D.png"><img alt="2016-02-15_15-18-34" border="0" height="198" src="https://lh3.googleusercontent.com/-ZHtd3LL00gk/VsHqpSkK8lI/AAAAAAAACrs/JAGWkUUsvMk/2016-02-15_15-18-34_thumb%25255B3%25255D.png?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="2016-02-15_15-18-34" width="233"></a><a href="https://lh3.googleusercontent.com/-SkP9y37niOw/VsHqqgwtxCI/AAAAAAAACr0/j5bCfxPpFu8/s1600-h/2016-02-15_15-18-49%25255B4%25255D.png"><img alt="2016-02-15_15-18-49" border="0" height="199" src="https://lh3.googleusercontent.com/-e-hS6MIB5sU/VsHqsFZ9JnI/AAAAAAAACr4/SwPFs-WHsvo/2016-02-15_15-18-49_thumb%25255B3%25255D.png?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="2016-02-15_15-18-49" width="229"></a> <a href="https://lh3.googleusercontent.com/-yfalFUNF6ss/VsHqtew0P7I/AAAAAAAACr8/iPL0uSpyacA/s1600-h/2016-02-15_15-19-05%25255B5%25255D.png"><img alt="2016-02-15_15-19-05" border="0" height="203" src="https://lh3.googleusercontent.com/-I5BkMvjnDR4/VsHqu8W2qPI/AAAAAAAACsA/39pNEhE6ayo/2016-02-15_15-19-05_thumb%25255B4%25255D.png?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="2016-02-15_15-19-05" width="240"></a><a href="https://lh3.googleusercontent.com/-l62qX8QIMV8/VsHqwTz0SPI/AAAAAAAACsE/gH2PSI8RccE/s1600-h/2016-02-15_15-21-39%25255B4%25255D.png"><img alt="2016-02-15_15-21-39" border="0" height="204" src="https://lh3.googleusercontent.com/-eXLxPO1g3hc/VsHqx8uG5aI/AAAAAAAACsI/Ayf3DP785aM/2016-02-15_15-21-39_thumb%25255B3%25255D.png?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="2016-02-15_15-21-39" width="237"></a> 4) Next install downloaded Python ODBC driver. Click on finish to complete the installation process. <a href="https://lh3.googleusercontent.com/-6nR8esTYYgA/VsHqzUORBGI/AAAAAAAACsM/b9h2aeqypl8/s1600-h/2016-02-15_15-22-30%25255B4%25255D.png"><img alt="2016-02-15_15-22-30" border="0" height="213" src="https://lh3.googleusercontent.com/-f9UYYBARodU/VsHq02rcK7I/AAAAAAAACsQ/lzy_MVfDZxY/2016-02-15_15-22-30_thumb%25255B3%25255D.png?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="2016-02-15_15-22-30" width="418"></a> Now we are ready to load the (PDF or XML ) Unstructured files to SAP HANA Cloud Platform. Before doing that make sure that you followed the prerequisite steps. <a href="http://www.itstuffs.net/2016/02/sap-hana-cloud-platform-connecting-via.html" target="_blank">Creating tunel to SAP HANA Cloud Platform</a> <a href="http://www.itstuffs.net/2016/02/sap-hana-cloud-platform-connecting-via_15.html" target="_blank">Creating ODBC datasource to SAP HANA Cloud Platform</a> If you are loading data to SAP HANA on Premises. Then you can skip the step of creating the tunel. <a href="http://www.itstuffs.net/2016/02/how-to-load-pdf-file-to-sap-hana.html" target="_blank">How to Load PDF file to SAP HANA</a>

Python to Load Binary Documents to SAP HANA

Python to Load Binary Documents to SAP HANA Python Python is a widely used general-purpose, high-level programming language . Its design ...

SAP Configuration, SAP HANA Training

Add SAP HANA Cloud Account in HANA Studio / Eclipse

Personal Action PA40 Part 2

Personal Action PA40 Part 1

SAP HANA Free Server Access Trial Account on Cloud.

How to Load PDF file to SAP HANA

Python to Load Binary Documents to SAP HANA

Blog Archive

Labels

Popular Posts