To upgrade your AP Invoice Approval Connector installation to a recent version with new database configurations, complete the following steps.
- Install the latest version of AP Invoice Approval Connector.
-
In a browser, type the Perceptive Connect Runtime Web Console address in the
format http://<PerceptiveConnectRuntimeHostname>:<port>.
Note: If prompted for user name and password, enter the log-in credentials. The default user name and password are set as admin.
- In the Perceptive Connect Runtime home page, in the left pane, under Manage, select Configure.
-
In the Configuration page, complete the following substeps.
- Under AP Approval Connector, select Approval Connector Configuration.
-
In the Database Connection String box, modify the existing value and
provide a JDBC connection string that points to a new database.
Typically, you must adhere to one of the following formats for the
database connection string. H2 file database connection string format:
jdbc:h2:file:<location of database file> or H2 TCP server connection
string format: jdbc:h2:tcp:<URL path to database> or MS SQL database
server connection string format:
jdbc:sqlserver://<host>:<port>;databaseName=<database
name>.
Note: To set up H2 TCP server, refer to the relevant documentation available in the H2 Database Engine website.
- In the Database Connection User Name box, provide the user name for the updated JDBC connection.
- In the Database Connection Password box, provide the password for the updated JDBC connection.
- Select Save.