Installing Aras Office Connector Server Components

Once the installation of Aras Innovator is complete and confirmed, the Aras Innovator database must be modified with the metadata required to run the Aras Office Productivity Connector 27. Before applying these changes, confirm that all required components are present.

• Aras Innovator 27
• Aras Office Productivity Connector Feature License
• Aras Update Tool 1.23

or

• Aras Innovator Package Import Export Utilities

1. Notify users that the system will be down at a scheduled time and that they should log out before the process starts.

1. Backup the Code Tree.

The “Code Tree” refers to files and folders installed on the disk when Aras Innovator was first installed. The default path for the Code Tree installation would be something like:

C:\Program Files (x86)\Aras\Innovator

With the following contents:

The following steps can be used to confirm the installation folder:

• From the Windows search field, enter Control to access the Control Panel.
• Select Programs and Features.
• Right-click the Name column and select More…
  1. Select the Comments header if it has not been checked.
  2. Click OK.
     • Search for the Aras Innovator entry in the Programs and Features window.
     • View the value set in the Comments column for the Aras Innovator entry:

After verifying the Code Tree installation path, back up the folder and all its contents.

2. Disconnect all users from the database.

The easiest way to prevent client sessions from committing any further changes to the database is to change the database connection string in the InnovatorServerConfig.xml from ＜DB-Connection... to ＜xDB-Connection… and restart the w3svc service (IIS). This expires all sessions and prevents all new connections to the Aras Innovator database through the existing instance.

3. Backup the database.

Store these files in a safe location, as they will need to be restored if the process fails.

4. Enable database connections.

After the database backup has been completed, enable the database connection string in the InnovatorServerConfig.xml by changing it from ＜xDB-Connection... to ＜DB-Connection... and restarting the w3svc service (IIS).

Aras Office Productivity Connector 27 can be installed using the Automated Installation Option (using the Aras Update Tool) or the Manual Installation Option (using the Aras Import Tool).

1. Download the Aras Office Productivity Connector 27 CD Image from the Aras MFT site and unzip the file on the local computer.
   1. Enable the Super User login.
   2. Launch the ArasUpdate.exe file as administrator.

If default options were selected during installation, the ArasUpdate.exe file can be found in the C:\Program Files (x86)\Aras\Aras Update\ directory.

3. On the Local tab, click Add package reference and navigate to the folder where the Aras Office Productivity Connector 27 package was extracted from the first step.
4. Expand the Aras Office Productivity Connector package and click Install.

5. Select Aras Innovator Code Tree Updates and Aras Innovator Database Updates options and click Next.

6. Select the Detailed logging option and click Next.

The logging option records the installation attempt and can be used to troubleshoot issues.

7. Input the connection information and click Install.

• Install Path: The physical path to the Aras Innovator code tree
• Server URL: The connection URL for Aras Innovator
• Database: The target Aras Innovator database
• Username: root
• Password: Password for “root” login (Default is “innovator”)

Aras Update will import everything required for Aras Office Productivity Connector 27.

8. After the import is complete, disable the Super User login.

1. Download the Aras Office Productivity Connector 27 CD Image from the Aras MFT site and unzip the file on the local computer.
   1. Copy DLLs from the ..\Files\Innovator\Server\bin folder to the Innovator\Server\bin folder and update method-config.xml.
   2. Copy content from the ..\Files\Innovator\Client folder to the Innovator\Client folder.
   3. Use the Package Import Export Utilities to import the Aras Office Productivity Connector 27 database package. For more information about using this tool, please see the Aras Innovator 27 – Package Import Export Utilities documentation.
2. Enable the Super User login to perform this step.
   • Browse to the \PackageImportExportUtilities\Import\ folder and run the Import.exe file as administrator.

• Enter the following information:
  • Server: The connection URL for Aras Innovator
  • Database: The target Aras Innovator database
  • Username: root
  • Password: Password for “root” login (Default is “innovator”)
  • Target Release: OPC27
  • Description: Aras Office Productivity Connector 27
  • Manifest File Path: The manifest file \Office Productivity Connector 27 CD Image\Imports\imports.mf
  • Available for Import: Select All Packages
  • Type: Merge
  • Mode: Thorough Mode
• Click the Import button.

Use the Package Import Export Utilities to import the Aras Office Productivity Connector 27 Post Import AML Scripts package.

3. Enter the following information:
   • Server: The connection URL for Aras Innovator
   • Database: The target Aras Innovator database
   • Username: root
   • Password: Password for “root” login (Default is “innovator”)
   • Target Release: OPC27
   • Description: Aras Office Productivity Connector 27 Post Import AML Scrips
   • Manifest File Path: The manifest file \Office Productivity Connector 27 CD Image\PostImportAMLScripts\Import Package\imports.mf
   • Available for Import: Select All Packages
   • Type: Merge
   • Mode: Thorough Mode
4. Click the Import button.

1. Navigate to the Aras Innovator Code Tree.
   1. Open the /Innovator/OAuthServer/OAuth.config file for editing.
   2. Add a redirect URL for Aras Office Productivity Connector under the redirectUrissection of the file.

<redirectUri value='https://${InnovatorURL}Client/Solutions/ OfficeProductivityConnector/taskpane.html?redirect=loginSuccess'/>

Replace ${InnovatorURL} with the URL to the Aras Innovator instance being used.

Use the following procedure to check if the database has been updated correctly:

1. Log in to Aras Innovator as an administrator.
   1. From the TOC, expand Administration and select Variables.
   2. Confirm the following variable:

If the installation fails at any time, revert to backups and contact Aras Support at the Aras Subscriber Portal.