Page Comparison

This section is applicable only if you want to use Web Forms with Adeptia Connect. You need to configure the following to access Web Forms in Adeptia Connect:

Prerequisites:

Ensure Before start configuring, ensure that you have :

...

To configure:

...

applied the latest patch of Adeptia Connect.

You can configure Web Forms in MySQL, SQL Server, and Oracle database only.

Anchor

	ConfigurationSteps
	ConfigurationSteps

To configure Web Forms in Adeptia Connect:

Import Adeptia Suite and Adeptia Connect public certificate to Adeptia Suite Truststore. This step is mandatory only if you are accessing Adeptia Suite through HTTPS protocol.
1. Export Public Key
  The steps to export the key varies from browser to browser. The following are the steps to export the public key in Google Chrome browser. You need to follow the same steps to export Adeptia Suite and Adeptia Connect public key.
  1. Open the browser and type the HTTPS URL to access Adeptia Suite.
    Info
    Type Adeptia Connect URL to export Adeptia Connect public key.
  2. Click Image Added > More tools > Developer tools.
  3. Click Security tab.
  4. Click View Certificate.
    
    Image Added
  5. On the Certificate window, on the Details tab, click Copy to File.
    
    Image Added
  6. Click Next to start exporting the certificate.
    
    Image Added
  7. Choose DER encoded binary X.509 (.CER) and click Next.
    
    Image Added
  8. Specify the location to save the exported file and click Next.
    
    Image Added
  9. Click Finish to export. A dialog box appears confirming the export process have been completed successfully.
  10. Click OK to exit from the wizard.
2. Import Adeptia Suite and Adeptia Connect certificate into Adeptia Suite Truststore. Below are the steps to import Adeptia Suite certificate into Adeptia Suite truststore. Follow the same steps to import Adeptia Connect certificate into Adeptia Suite truststore.
  1. Open Command Prompt (press Win + R and type cmd).
  2. Go to the directory where JRE is installed (for example, C:/Program Files/Java/jre8/bin).
  3. Run the following Keytool command to import a certificate.
```
keytool -import -trustcacerts -file <Path_of_SSL_Certificate> -alias <alias_name> -keystore <Path of Truststore file> -storepass changeit
```
    where,
    <Path_of_SSL_Certificate> is the path of Adeptia Suite or Adeptia Connect SSL certificate.
    <Path of Truststore file> is the path of Adeptia Suite Truststore.
    For example, keytool -import -trustcacerts -file C:/adeptia.cer -alias selfsign -keystore "C:/Program Files/AdeptiaSuite-6.9/AdeptiaServer/ServerKernel/etc/truststore/cacerts"
Apply the Web Form patch by following the same steps applied in Adeptia Suite patch.

After applying the patch, create a new database with utf-8 character set. Depending on the database you are using, expand the database to find the query to create a new database.

Expand

title	MySQL

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

Expand

title	SQL Server

create database <database_name>;

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.

Go to .../<AdeptiaInstallFolder>/ServerKernel/etc folder.
Open server-configure.properties file in the Text Editor.
In the Rich Forms group,
1. Type https in the abpm.frevvo.httpScheme property to access Web Forms in a secure mode.
  Info
  Skip this step if you are accessing Adeptia Suite through HTTP protocol.
2. Type the URL of the server hosting Adeptia Suite in the <param-value> parameter of the frevvo.internal.baseurl property. The format of the URL is: <protocol_name>://<ipaddress>:<port_no>.
  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.
3. Type the URL of the server hosting Tomcat in the <param-value> parameter of the frevvo.forms.server.external.url property. The format of the URL is: <protocol_name>://<ipaddress>:<port_no>.
  Image Removed
  Image Added
4. In Frevvo Database Configuration subgroup, provide the details of the database you are using in the properties.
  Property Name
  Image Removed
In the Web Server category, in the
1. Description
  abpm.
webserver
1. frevvo.
public.address property, type the IP address of the server hosting Adeptia Suite.
Image Removed
Save the file.
Restart Kernel and WebRunner.

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

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_Step3>

If you are using a named instance of SQL Server database then enter the URL in the following format:

jdbc:<Database_Name>://<IPaddress_on_which_Database_is_installed>:<Database_Port_No>/<Database_Name_Created_in_Step3>;instanceName=<instance_name>

For example,

MySQL: jdbc:mysql://192.168.1.

1:8080/frevvo.

On the Update License screen, type the license key. Contact Adeptia Support Team for the license key.

Login to Frevvo using following default credentials and create a tenant:

Username: admin@d

Password: admin

Image Removed

On the

Manage server

screen, click

Manage Tenants

.

Image Removed

On the Tenants screen, click Image Removed.
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.

Type

support@adeptia.com

in the

Admin User Email Address

.

Image Removed

Click Submit. This creates your tenant.
Logout from Frevvo.

Now login to Frevvo using following credentials and deploy Adeptia Template Rich Form.

Username: adeptia@adeptia

Password: adeptia

Click

Home

.

Image Removed

Click

Upload

.

Image Removed

On the

Upload Application

screen, click

Choose File

, and upload

AdeptiaTemplate_app.zip

file from the folder where you have extracted Frevvo patch.

Image Removed

Click Upload.
This deploys Adeptia Template Rich Form.
Click Styles from the left menu.

Click

Upload

.

Image Removed

On the

Upload Application

screen, click

Choose File

, and upload

ConnectColorScheme.style

file from the folder where you have extracted Frevvo patch.

Image Removed

Click Upload.
This deploys Connect Color Scheme style file.
Click My Applications from the left menu. The list of all applications appears on the right side of the screen.

Click

Properties

on the

Adeptia Template

.

Image Removed

On the

Adeptia Template Properties

screen, select

ConnectColorScheme

option in the

Choose Style

property.

Image Removed

Click Update.

Click

Edit

on the

Adeptia Template

.

Image Removed

Click

Edit

on the

AdeptiaForm

.

Image Removed

On the Adeptia Form, expand PROPERTIES and then click the Style tab.

Select

ConnectColorScheme

option in the

Style

property.

Image Removed

Click Image Removedto save and exit from the form.

Verifying Configuration

After you have configured the steps, you need to verify whether Web Forms are accessible or not. To verify:

Login to Adeptia Connect.
Click Configure > Web Forms.
Click CREATE Web Form.
On the Create Web Form window, provide the details of the Web Form.

In the Design Form, click

Image Removedto open the form.

Image Removed
On clicking, if the Web Form opens in a new tab, indicates you have configured Web Forms in Adeptia Connect successfully.

Image Removed
For more information. click here.

2:3306/frevvoDB SQL-Server: jdbc:sqlserver://192.168.1.1:1433;databaseName=frevvo SQL-Server (using instance): jdbc:sqlserver://192.168.1.1:1433;databaseName=frevvo;instanceName=adeptia 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_Step3> 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 3.
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 3. To use an encrypted password of the database, change the value of 'encrypt' property to "y".
abpm.frevvo.dbType	Database you are using, for example, MySQL, SQL-Server, Oracle.

Image Added

In the Web Server category, in the abpm.webserver.public.address property, type the IP address of the server hosting Adeptia Suite.

Image Added

Save the file.

Go to the extracted Web Form patch folder.
1. Open jetty.xml.
2. Copy the highlighted code from the file.
  
  Image Added
3. Open jetty.xml file in the Text Editor from the .../<AdeptiaInstallFolder>/ServerKernel/etc/jetty folder.
4. Replace the copied code in the file.
5. Save the file.
Go to .../<AdeptiaInstallFolder>/ServerKernel/etc/jetty/contexts folder.
Rename richForms.xml_disable file to richForms.xml.
Restart Kernel and WebRunner. This will create Frevvo related tables in the newly created database.

Next Step

Verifying Patch

Versions Compared

Old Version 19

New Version Current

Key

Verifying Configuration