{"id":48151,"date":"2018-01-30T07:06:20","date_gmt":"2018-01-30T01:36:20","guid":{"rendered":"http:\/\/blog.odango.com\/?p=48151"},"modified":"2023-02-04T09:37:08","modified_gmt":"2023-02-04T04:07:08","slug":"guide-on-database-setup-in-pega","status":"publish","type":"post","link":"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/","title":{"rendered":"Guide on Database Setup in Pega &#8211; 2018"},"content":{"rendered":"\n[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;3.22&#8243;][et_pb_row _builder_version=&#8221;3.25&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;3.0.106&#8243; title_font=&#8221;Titillium Web||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;rgba(0,0,0,0.8)&#8221; title_font_size=&#8221;47&#8243; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;3.25&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;Titillium Web|300|||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.8)&#8221; text_font_size=&#8221;20&#8243; text_line_height=&#8221;1.6em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|desktop&#8221; text_line_height_last_edited=&#8221;off|phone&#8221;]<p style=\"text-align: center;\">\u00a0<a href='https:\/\/asha24.net\/learn\/pega' class='big-button bigblue' target=\"_blank\"><span style=\"color: #ffffff;\"><strong>100% Free Pega Course, Enroll Now<\/strong><\/span><\/a><\/p>\r[\/et_pb_text][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;Titillium Web|300|||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.8)&#8221; text_font_size=&#8221;20&#8243; text_line_height=&#8221;1.6em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|desktop&#8221; text_line_height_last_edited=&#8221;off|phone&#8221;]Hola Amigos!\r\n\r\nToday, I\u2019m going to introduce to you, and help you install, an amazing cloud based Business Process Management tool\/ program, <a href=\"https:\/\/asha24.net\/blog\/use-cases-of-pega\/\">PEGA<\/a>, a fantastic application development platform.\r\n\r\nIt\u2019s basically intended for large enterprises, where business analysts, system analysts and developers design, build, deploy, and evolve strategic business applications. PRPC server (PEGA Rules Process Commander) provides the platform and interfaces\r[\/et_pb_text][et_pb_image src=&#8221;https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/download-124.png&#8221; align=&#8221;center&#8221; align_tablet=&#8221;center&#8221; align_last_edited=&#8221;on|desktop&#8221; _builder_version=&#8221;3.23&#8243; always_center_on_mobile=&#8221;on&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;Titillium Web|300|||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.8)&#8221; text_font_size=&#8221;20&#8243; text_line_height=&#8221;1.6em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|desktop&#8221; text_line_height_last_edited=&#8221;off|phone&#8221;]PEGA implements a systematic approach to construct and use process-oriented and rule-based solution and applications. The main focus is on automation of works and program code.\r\n\r\nAre you wondering about the concepts on which PEGA was developed? Well, it was developed on Java and uses OOP and java concepts.\r\n\r\n<strong>What is BPM?<\/strong>\r\n\r\nBusiness process management (BPM) is a methodology to manage processes and <a href=\"https:\/\/www.pega.com\/workflow-management\">workflows<\/a> in an organization. The goal of BPM is to increase efficiency, performance, and agility in the day-to-day operations of a business.\r[\/et_pb_text][et_pb_image src=&#8221;https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/download-14.jpg&#8221; align=&#8221;center&#8221; align_tablet=&#8221;center&#8221; align_last_edited=&#8221;on|desktop&#8221; _builder_version=&#8221;3.23&#8243; always_center_on_mobile=&#8221;on&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;Titillium Web|300|||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.8)&#8221; text_font_size=&#8221;20&#8243; text_line_height=&#8221;1.6em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|desktop&#8221; text_line_height_last_edited=&#8221;off|phone&#8221;]BPM methodology can generally be implemented in the following steps:\r\n\r\n<strong>Analysis: \u00a0<\/strong>Done to determine and identify processes that can be designed or optimized to meet business requirements or improve performance. Specifications for a design solution can be derived from this <a href=\"https:\/\/www1.pega.com\/insights\/resources\/pega-transformation-analysis\">analysis<\/a>.\r\n\r\n<strong>Design:\u00a0<\/strong>\u00a0Involves workflows that involve human-to-human, system-to-system, or human-to-system interactions.\r\n\r\nThe design should aim to reduce errors and maintain relevant standard operating procedures or service level agreements.\r\n\r\n<strong>Modelling:\u00a0<\/strong>Design, once ready, can be modelled using different input values to observe its behaviour.\r\n\r\nIf the undesirable behaviour is observed, design changes can be made iteratively. Software tools are available to effectively design and evaluate processes.\r\n\r\n<strong>Execution:\u00a0<\/strong>\u00a0A process model can be executed using a business rules engine to govern process execution.\r\n\r\n<strong>Monitoring:\u00a0<\/strong>\u00a0Execution processes can be monitored to collect reporting data for performance, errors, and compliance. Monitoring allows companies to evaluate executed BPM solutions against similar design models and against relevant KPIs.\r\n\r\nData collected by real-time or ad-hoc monitoring can also be used by predictive analytics software to anticipate future problems.\r\n\r\n<strong>Optimization:<\/strong>\u00a0Data from the modelling and monitoring phases can be used to identify fields of the solution that can be improved to derive higher performance and better value.\r\n\r\n<strong>System\u00a0requirements<\/strong>\r\n\r\nEnsure that your system meets the minimum requirements. UI-based installation tool (Installation and Upgrade Assistant).\r\n\r\nIf you plan on using the UI-based Installation and Upgrade Assistant ensure that the system on which you install, meets these minimum system requirements in addition to all other requirements:\r\n<ul>\r\n \t<li>Windows or Linux operating system.<\/li>\r\n \t<li>1.25 GB minimum available memory.<\/li>\r\n \t<li>10 GB minimum disk space plus at least 8 GB available space in the temporary directory of the root file system.<\/li>\r\n \t<li>Java Platform, Standard Edition Development Kit (JDK).<\/li>\r\n<\/ul>\r\n<strong>Application server<\/strong>\r\n\r\nThe application server requires:\r\n<ul>\r\n \t<li>A supported 64-bit JDK. See the Platform Support Guide on the PDN for a list of supported versions.<\/li>\r\n \t<li>1 GB minimum free disk space. You might need additional storage space for debugging and logging.<\/li>\r\n \t<li>PEGA systems recommend that only the PEGA 7 Platform be installed on the application server.<\/li>\r\n<\/ul>\r\n<strong>Application server memory requirements<\/strong>\r\n\r\nThe <a href=\"https:\/\/en.wikipedia.org\/wiki\/Pegasystems\">PEGA 7<\/a> Platform runs in memory (heap) on Java Virtual Machines (JVMs). In general, all activity is distributed over multiple JVMs (nodes) on the application server.\r\n<ul>\r\n \t<li>Standard suggested system heap size is 4 &#8211; 8 GB based on monitoring of memory usage and garbage collection frequency.<\/li>\r\n \t<li>Larger heaps are advisable if your applications allow a high number of concurrent open tasks per session or cache a large collection of transaction or reference data.<\/li>\r\n \t<li>Do not deploy the PEGA 7 Platform in an environment where the heap size exceeds the vendor specific effectiveness limit.<\/li>\r\n<\/ul>\r\nIn current 64-bit JVMs, compression is enabled by default.\r\n\r\nThe host application server memory size must be at least 4 GB larger than the PEGA 7 Platform heap size to allow space for the operating system, monitoring tools, operating system network file buffering, and JVM memory size (-XMX option). The minimum host application server memory size is 8 GB:\r\n\r\nThe 4 GB heap + 4 GB for native memory, operating system, and buffering.\r\n\r\nIf the server does not have enough memory allocated to run the PEGA 7 Platform, the system might hang without an error message. Your values might need to be higher than these recommendations based on your server hardware, the number of other applications, and the number of users on the server.\r\n\r\n<strong>Setting up the database server<\/strong>\r\n\r\nThis section describes how to prepare and configure your database server:\r\n<ul>\r\n \t<li>Configure the database users.<\/li>\r\n \t<li>Create an empty database.<\/li>\r\n<\/ul>\r\n<strong>Verifying the database configuration<\/strong>\r\n\r\nBefore you begin preparing your database, confirm that your database server is installed and running. Verify that your database meets the requirements described below.\r\n\r\nYour system includes a supported version of the JDBC4 driver for your version of the database.\r\n\r\nIf you plan to use user-defined functions (UDF), the common language run time (CLR) is enabled on the database. To check whether CLR is enabled, run the following script:\r\n\r\n<strong>Select value from sys.configurations where name =&#8217;clr enabled&#8217;<\/strong>\r\n\r\nIf the return value is 1, CLR is enabled.\r\n\r\nIf you plan to use user-defined functions (UDF), support for UDF installed by the PEGA 7 Platform is enabled.\r\n\r\nIf you plan to use user-defined functions (UDF), Java is enabled in the database.\r\n\r\n<strong>Configuring your Microsoft SQL Server database<\/strong>\r\n\r\nTo prepare your Microsoft SQL Server database server for use with the PEGA 7 Platform, complete the following steps:\r\n\r\n1. Create database user accounts.\r\n\r\n2. Create an empty database.\r\n\r\n3. Create the database schema.\r\n\r\n<strong>Database users<\/strong>\r\n\r\nThis guide refers to the following database users:\r\n\r\n<strong>Deployment user:\u00a0<\/strong>These users run the installation. After the installation, you can remove this user.\r\n\r\n<strong>Run-time users:\u00a0<\/strong>These users perform actions on the PEGA 7 Platform after the installation. In dual-user configuration, an Admin user is granted full privileges, and a Base user is granted smaller subset. <a href=\"https:\/\/asha24.net\/blog\/pega-tutorial-certification-training-and-interview-qa\/\">PEGA systems<\/a> recommend the dual-user configuration:\r\n\r\n<strong>Base user:<\/strong>\u00a0These users run the PEGA 7 Platform. For most run-time operations, the PEGA 7 Platform uses the Base user and associated data source. The data schema should be the default schema for Base users.\r\n\r\n<strong>Admin user:<\/strong>\u00a0An optional user provided to the PEGA 7 Platform, preferentially used by certain features that require creating, modifying, or dropping database schema objects; for example, System Management facilities and certain decision operations.\r\n\r\nPEGA systems recommend you to use the dual-user configuration with separate Admin and Base users, however, you can create a single Base user with both sets of privileges. If there is no separate Admin user, the PEGA 7 Platform uses the Base user for all run-time operations.\r\n\r\n<strong>Creating an empty database<\/strong>\r\n\r\nCreate a database with a minimum of 5 GB for the user tablespace. This minimum size allows you to load the initial rule base and do simple development.\r\n\r\nMonitor the database. As development begins, the size of the database will need to increase significantly, depending on your use of the PEGA 7 Platform and the number of users.\r\n\r\nWhen you configure your Microsoft SQL Server database, you can set the collation type to either Windows or binary. To shorten sort time in environments where you do not need language-specific sorting, consider setting a binary sort.\r\n\r\n<strong>Creating new schema<\/strong>\r\n\r\nCreate the required schema depending on whether you are using a single-schema or split-schema configuration.\r\n\r\n<strong>Installing the Personal Edition<\/strong>\r\n\r\n1. Download the\u00a0PRPC_PE_win64.zip\u00a0file from your installation package.\r\n\r\n2. Extract the contents to a directory on your computer.\r\n\r\n3. In that directory, double-click the\u00a0install.bat\u00a0file. The system opens a command window, and then starts the installation wizard. If the\u00a0install.bat\u00a0file fails to run, confirm that there are no spaces in the directory path.\r[\/et_pb_text][et_pb_image src=&#8221;https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/download-1-25.png&#8221; align=&#8221;center&#8221; align_tablet=&#8221;center&#8221; align_last_edited=&#8221;on|desktop&#8221; _builder_version=&#8221;3.23&#8243; always_center_on_mobile=&#8221;on&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;Titillium Web|300|||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.8)&#8221; text_font_size=&#8221;20&#8243; text_line_height=&#8221;1.6em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|desktop&#8221; text_line_height_last_edited=&#8221;off|phone&#8221;]4. On the Personal Edition Installation page, click on<strong>\u00a0Next<\/strong>.\r\n\r\n5. Review the information on the\u00a0Overview and Prerequisites\u00a0page to ensure that the Personal Edition installation was successful.\r\n\r\n6. Click\u00a0<strong>Next<\/strong>.\r\n\r\n7. On the\u00a0<strong>License Agreement\u00a0<\/strong>page, review the software license for the Personal Edition and its third-party products.\r\n\r\n8. Click\u00a0<strong>Accept.<\/strong>\r[\/et_pb_text][et_pb_image src=&#8221;https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/download-2-18.png&#8221; align=&#8221;center&#8221; align_tablet=&#8221;center&#8221; align_last_edited=&#8221;on|desktop&#8221; _builder_version=&#8221;3.23&#8243; always_center_on_mobile=&#8221;on&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;Titillium Web|300|||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.8)&#8221; text_font_size=&#8221;20&#8243; text_line_height=&#8221;1.6em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|desktop&#8221; text_line_height_last_edited=&#8221;off|phone&#8221;]9. Select the components to install.\r\n\r\n10. Click on Next.\r\n\r\n11. On the Directories Selection page, browse to the directory where you want to install the Personal Edition. Otherwise, the installation creates the PRPC Personal Edition directory on your\u00a0<strong>C: drive<\/strong>.\r\n\r\n12. Select Drivers and click\u00a0<strong>Open<\/strong>.\r\n\r\n11. Click on\u00a0<strong>Next.<\/strong>\r\n\r\n12. The\u00a0Port Configuration\u00a0page displays the default port assignment that the Personal Edition uses for the database and Tomcat server.\r[\/et_pb_text][et_pb_image src=&#8221;https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/download-3-16.png&#8221; align=&#8221;center&#8221; align_tablet=&#8221;center&#8221; align_last_edited=&#8221;on|desktop&#8221; _builder_version=&#8221;3.23&#8243; always_center_on_mobile=&#8221;on&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;Titillium Web|300|||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.8)&#8221; text_font_size=&#8221;20&#8243; text_line_height=&#8221;1.6em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|desktop&#8221; text_line_height_last_edited=&#8221;off|phone&#8221;]13. Click Port Availability to verify that the default ports are available. If there are conflicts, enter a different port number and repeat this step.\r\n\r\n14. Click\u00a0<strong>Next<\/strong>.\r\n\r\n15. Click\u00a0Start\u00a0to\u00a0<strong>start<\/strong>\u00a0the installation.\r[\/et_pb_text][et_pb_image src=&#8221;https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/download-4-20.png&#8221; align=&#8221;center&#8221; align_tablet=&#8221;center&#8221; align_last_edited=&#8221;on|desktop&#8221; _builder_version=&#8221;3.23&#8243; always_center_on_mobile=&#8221;on&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;Titillium Web|300|||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.8)&#8221; text_font_size=&#8221;20&#8243; text_line_height=&#8221;1.6em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|desktop&#8221; text_line_height_last_edited=&#8221;off|phone&#8221;]16. The\u00a0<strong>Output<\/strong>\u00a0and\u00a0Error\u00a0tabs display the progress of the installation.\r\n\r\n17. When the confirmation message is displayed, click\u00a0<strong>OK<\/strong>.\r\n\r\n18. Click Exit to close the installation window.\r\n\r\n19. Login to the PEGA Platform instance:\r\n\r\nIf you accepted the default Launch PRPC selection, you can login by using the browser window that is open after you close the installation window.\r\n\r\nIf you did not select the default, see the Using shortcuts to start, log in to, and shut down the Personal Edition section of this article for instructions.\r\n\r\nIf you see a 404 error, use the desktop shortcuts to stop and restart the Personal Edition:\r\n\r\nOn the desktop, click Shutdown.\r\n\r\n20. Click Startup.Give the credentials for<strong>\u00a0log in<\/strong>.\r[\/et_pb_text][et_pb_image src=&#8221;https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/download-5-15.png&#8221; align=&#8221;center&#8221; align_tablet=&#8221;center&#8221; align_last_edited=&#8221;on|desktop&#8221; _builder_version=&#8221;3.23&#8243; max_width=&#8221;80%&#8221; always_center_on_mobile=&#8221;on&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;Titillium Web|300|||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.8)&#8221; text_font_size=&#8221;20&#8243; text_line_height=&#8221;1.6em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|desktop&#8221; text_line_height_last_edited=&#8221;off|phone&#8221;]21. Click on\u00a0<strong>Default.<\/strong>\r\n\r\n22. Write a Name of your application and Click\u00a0<strong>Create application.<\/strong>\r\n\r\n23. Click on Build a mobile app and then click\u00a0<strong>GO<\/strong>.\r[\/et_pb_text][et_pb_image src=&#8221;https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/download-6-13.png&#8221; align=&#8221;center&#8221; align_tablet=&#8221;center&#8221; align_last_edited=&#8221;on|desktop&#8221; _builder_version=&#8221;3.23&#8243; max_width=&#8221;81%&#8221; always_center_on_mobile=&#8221;on&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;3.27.4&#8243; text_font=&#8221;Titillium Web|300|||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.8)&#8221; text_font_size=&#8221;20&#8243; text_line_height=&#8221;1.6em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|desktop&#8221; text_line_height_last_edited=&#8221;off|phone&#8221;]Here, you can have a look at the information on PEGA materials. If you have any doubts also you can clarify from\u00a0these\u00a0documents.\r\n\r\nI hope my guidance was good, and the information provided by me was helpful.\r\n\r\nIf you have any further doubts, queries or personal thoughts, on this blog, do share them in the comment section below.\r\n\r\nIf you appreciate my blogs, want to know more about PEGA and it\u2019s certification, <a href=\"https:\/\/asha24.net\/blog\/pega-certification-guide\/\">click here<\/a> and read up.\r\n<p style=\"text-align: center;\"><a href='https:\/\/asha24.net\/pega-online-training' class='big-button bigblue'><span style=\"color: #ffffff;\"><strong>Enroll for PEGA Training Course<\/strong><\/span><\/a><\/p>\r[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;3.22&#8243;][et_pb_row _builder_version=&#8221;3.25&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_team_member name=&#8221;Naveen E&#8221; position=&#8221;Author&#8221; image_url=&#8221;https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/1234.gif&#8221; _builder_version=&#8221;3.0.106&#8243; header_font=&#8221;Titillium Web|700|||||||&#8221; body_font=&#8221;Titillium Web||||||||&#8221; body_font_size=&#8221;16&#8243; body_font_size_tablet=&#8221;&#8221; body_font_size_phone=&#8221;&#8221; body_font_size_last_edited=&#8221;on|phone&#8221;]Hola peeps! Meet an adventure maniac, seeking life in every moment, interacting and writing at Asha24.\r[\/et_pb_team_member][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":4,"featured_media":48170,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[34],"tags":[],"class_list":["post-48151","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pega"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Guide on Database Setup in Pega - 2018 - Asha24 Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Guide on Database Setup in Pega - 2018 - Asha24 Blog\" \/>\n<meta property=\"og:url\" content=\"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/\" \/>\n<meta property=\"og:site_name\" content=\"Asha24 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-30T01:36:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-04T04:07:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/guide-on-database-setup-in-pega-2018-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"459\" \/>\n\t<meta property=\"og:image:height\" content=\"306\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mahesh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/asha24.net\/blog\/#website\",\"url\":\"https:\/\/asha24.net\/blog\/\",\"name\":\"Asha24 Blog\",\"description\":\"Dedication Towards Learning\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/asha24.net\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/guide-on-database-setup-in-pega-2018-1.jpg\",\"contentUrl\":\"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/guide-on-database-setup-in-pega-2018-1.jpg\",\"width\":459,\"height\":306},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/#webpage\",\"url\":\"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/\",\"name\":\"Guide on Database Setup in Pega - 2018 - Asha24 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/asha24.net\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/#primaryimage\"},\"datePublished\":\"2018-01-30T01:36:20+00:00\",\"dateModified\":\"2023-02-04T04:07:08+00:00\",\"author\":{\"@id\":\"https:\/\/asha24.net\/blog\/#\/schema\/person\/f6167b78bbaddfc399ae1154cd5b6759\"},\"breadcrumb\":{\"@id\":\"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/asha24.net\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Guide on Database Setup in Pega &#8211; 2018\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/asha24.net\/blog\/#\/schema\/person\/f6167b78bbaddfc399ae1154cd5b6759\",\"name\":\"Mahesh\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/asha24.net\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/085c03e75ffb51af2509c1cfad9c7d78b30236d43a008db2e46f96e2f40c67fc?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/085c03e75ffb51af2509c1cfad9c7d78b30236d43a008db2e46f96e2f40c67fc?s=96&d=wavatar&r=g\",\"caption\":\"Mahesh\"},\"url\":\"https:\/\/asha24.net\/blog\/author\/mahesh\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Guide on Database Setup in Pega - 2018 - Asha24 Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/","og_locale":"en_US","og_type":"article","og_title":"Guide on Database Setup in Pega - 2018 - Asha24 Blog","og_url":"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/","og_site_name":"Asha24 Blog","article_published_time":"2018-01-30T01:36:20+00:00","article_modified_time":"2023-02-04T04:07:08+00:00","og_image":[{"width":459,"height":306,"url":"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/guide-on-database-setup-in-pega-2018-1.jpg","path":"\/home\/reviews981\/public_html\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/guide-on-database-setup-in-pega-2018-1.jpg","size":"full","id":48170,"alt":"","pixels":140454,"type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mahesh","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/asha24.net\/blog\/#website","url":"https:\/\/asha24.net\/blog\/","name":"Asha24 Blog","description":"Dedication Towards Learning","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/asha24.net\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/#primaryimage","inLanguage":"en-US","url":"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/guide-on-database-setup-in-pega-2018-1.jpg","contentUrl":"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/guide-on-database-setup-in-pega-2018-1.jpg","width":459,"height":306},{"@type":"WebPage","@id":"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/#webpage","url":"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/","name":"Guide on Database Setup in Pega - 2018 - Asha24 Blog","isPartOf":{"@id":"https:\/\/asha24.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/#primaryimage"},"datePublished":"2018-01-30T01:36:20+00:00","dateModified":"2023-02-04T04:07:08+00:00","author":{"@id":"https:\/\/asha24.net\/blog\/#\/schema\/person\/f6167b78bbaddfc399ae1154cd5b6759"},"breadcrumb":{"@id":"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/asha24.net\/blog\/guide-on-database-setup-in-pega\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/asha24.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Guide on Database Setup in Pega &#8211; 2018"}]},{"@type":"Person","@id":"https:\/\/asha24.net\/blog\/#\/schema\/person\/f6167b78bbaddfc399ae1154cd5b6759","name":"Mahesh","image":{"@type":"ImageObject","@id":"https:\/\/asha24.net\/blog\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/085c03e75ffb51af2509c1cfad9c7d78b30236d43a008db2e46f96e2f40c67fc?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/085c03e75ffb51af2509c1cfad9c7d78b30236d43a008db2e46f96e2f40c67fc?s=96&d=wavatar&r=g","caption":"Mahesh"},"url":"https:\/\/asha24.net\/blog\/author\/mahesh\/"}]}},"_links":{"self":[{"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/posts\/48151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/comments?post=48151"}],"version-history":[{"count":20,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/posts\/48151\/revisions"}],"predecessor-version":[{"id":52203,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/posts\/48151\/revisions\/52203"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/media\/48170"}],"wp:attachment":[{"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/media?parent=48151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/categories?post=48151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/tags?post=48151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}