Kofax TotalAgility AP Automation Manual do Utilizador descarregar pdf (Página 10)

Deployment

Kofax TotalAgility AP Automation Kofax TotalAgility AP Automation Guide

Deployment

Extract the Zip

Extract the KofaxTotalAgilityAccountsPayable zip to a folder on the destination machine's

root drive. This location will be referred to as <Extract Location> throughout this document.

Deploy the Custom Database

Manually create a database called AP_Solution with default settings or run <Extract

Location>\KTA\Database\Create_Database.sql.

Create the DB objects by running <Extract Location>\Database\RunSQL.bat.

Ensure .bat server is the SQL instance required (currently localhost).

Run as Administrator.

This will run all the scripts in folders in alphabetical order.

If using Azure, do the following:

Create the database as needed.

Configure the connection to the database. See Deploy the TotalAgility Components >

Server Variables for further details.

If using AX Extract to database:

From Start > SQL Server Configuration Manager.

Select Protocols for MSSQLSERVER.

Enable TCP/IP.

DB Login and User will be installed using the bat.

Within the properties of the user, check the “db_owner” for both Schemas owned by

this user and Database Role membership.

Deploy KSMS

Set Up ODBC

The ODBC login is created on AP_Solution when deploying the custom database.

Create the ODBC System DSN:

Name: AccountsPayable.

Server: SQL Server localhost.

Select SQL Server authentication.

▪ Login = ODBCKSMSLogin

1 2 ... 5 6 7 8 9 10 11 12 13 14 15 ... 42 43

Sem comentários

Kofax TotalAgility AP Automation Manual do Utilizador Página 10