Page Comparison

...

1. Create a new database with utf-8 character set. Following is  Depending on the database you are using, expand the database to find the query to create a new database in MySQL:

   code

   . 

   Expand
   title MySQL
   create database <database_name> default character set "utf8" default collate "utf8_unicode_ci";

   Expand
   title SQL Server
   create database <database_name>;

   In case you are using Oracle database then

   Expand
   title Oracle
   Adeptia supports Oracle 12c and 11g only. Depending on the version you are using, follow the wizard to create a new database. After creating the new database, you need to create a user other than System user and grant access to the Oracle database (created above) to the new user. Log in to the new database created above. Create a user by executing the following command: CREATE USER <Username> IDENTIFIED BY <Password> QUOTA UNLIMITED ON USERS; where,           <Username> is the name of the user.           <Password> is the password to authenticate a user. Run the following queries to grant permissions: Code Block GRANT CONNECT, CREATE SESSION, RESOURCE, CREATE VIEW TO <Username>; GRANT create session TO <Username>; GRANT create table TO <Username>; GRANT create view TO <Username>; GRANT create any trigger TO <Username>; GRANT create any procedure TO <Username>; GRANT create sequence TO <Username>; GRANT create synonym TO <Username>; GRANT create sequence TO <Username>; GRANT create any index TO <Username>; GRANT create sequence TO <Username>; GRANT alter any table TO <Username>;

   where, <Username> is the name of the new user created above.

2. Go to .../<AdeptiaInstallFolder>/ServerKernel/etc folder.
3. Open server-configure.properties file in the Text Editor.

   1. In Frevvo Database Configuration subgroup, provide the details of the database you are using in the properties. 

      abpm.frevvo.db.driver	Name of the Frevvo database driver URL. MySQL: com.mysql.jdbc.Driver SQL-Server: com.microsoft.sqlserver.jdbc.SQLServerDriver Oracle: oracle.jdbc.OracleDriver
      abpm.frevvo.db.url	Name of the Frevvo database connection URL. The format of the URL for MySQL and SQL Server database is: jdbc:<Database_Name>://<IPaddress_on_which_Database_is_installed>:<Database_Port_No>/<Database_Name_Created_in_Step1> MySQL: jdbc:mysql://192.168.1.2:3306/frevvoDB SQL-Server: jdbc:sqlserver://192.168.1.1:1433;databaseName=frevvo The format of the URL for Oracle database is: Oracle: jdbc:oracle:thin:@<IPaddress_on_which_Database_is_installed>:<Database_Port_No>:<Database_Name_Created_in_Step1> for example, jdbc:oracle:thin:@192.168.1.3:1521:frevvodb
      abpm.frevvo.db.username	Database username you are using. In case you are using Oracle then type the user name that you have created in the database in Step 1b.
      abpm.frevvo.db.password	Password to access database. In case you are using Oracle then type the password that you have provided in the database in Step 1b.
      abpm.frevvo.dpType	Database you are using, for example, MySQL, SQL-Server, Oracle.
      Property Name	Description

      
      

      Info
      If you are using SQL Server database, use Microsoft driver class and database URL instead of using JTDS.

   2. Save the file.
4. Start Kernel and WebRunner. This will create Rich Forms related tables in the newly created database.
5. Open the browser and type the URL in the format: 
   <protocol_name>://<IPaddress>:<Port_No>/frevvo 
   where,
              <protocol_name> is the protocol you are using, for example, http or https.
              <IPaddress> is the domain name or IP address of the server hosting Adeptia Suite.
              <Port_No> is the port number of the server hosting Adeptia Suite.
   For example, http://192.168.1.1:8080/frevvo.

6. On the License Expired screen, type the license key and click Submit. Contact Adeptia Support Team for the license key.

   

   
   

7. Sign in to Frevvo using following default credentials and create a tenant:
   Username: admin@d
   Password: admin
   
   
   
   
   1. On the Manage server screen, click Manage Tenants.
      
      
      
      
   2. On the Tenants screen, click .
   3. On the Add New Tenant screen, type adeptia in the Tenant Id, Admin User Id, Tenant Name, Admin User Password, Tenant Description, and Re-enter Admin User Password.
   4. Type support@adeptia.com in the Admin User Email Address.
      
      
      
      
   5. Click Submit. This creates your tenant.
   6. Sign out from the user account.
      
      
8. Now sign in to Frevvo using following credentials and deploy Adeptia Template Rich Form.   
   Username: adeptia@adeptia
   Password: adeptia
   
   1. Click Home.
      
      
      
      
   2. Click Upload.
      
      
      
      
   3. On the Upload Application screen, click Choose File, and upload AdeptiaTemplate_app.zip file from the folder where you have extracted RichForm patch.
      
      
      
      
   4. Click Upload.
      This deploys Adeptia Template Rich Form.
      
      

...