B2BEdiExportsODBC Client Software - Manual Installation

THIS IS A DRAFT DOCUMENT - PLEASE USE ONLY WITH B2B SUPPORT

This article explains how to install and set up the client software provided by B2B.  It assumed that anybody following these instructions is competent in modifying Microsoft Windows system configurations. If you are not please stop now and seek advice.

System Requirements

Operating Systems: Microsoft Windows 7, 8 or 10 or later, Microsoft Windows Server 2008R2 or later.

CPU: Any capable of running above operating systems.

Memory: At least 2GB RAM.

Free Disc Space: At least 10MB.

Software/Drivers: ODBC drivers for source database installed. Microsoft .Net 4.5 Runtime or later installed. Amazon AWS CLI installed (optional).

Network: Firewall permissions to access source database. Firewall permissions to enable sending of data to AWS Kinesis.

User Requirement: Local System Administrator Rights

Instructions:

1. Copy the contents of the supplied zip file to a suitable directory. We recommend a sub directory within the default program directory.
2. If the Amazon AWS CLI has been installed ensure that the default credentials are those for a user who has the necessary access to B2B's Kinesis stream. Check with B2B if unsure.
3. Using the values supplied by B2B Internet Solutions create the following System Environment Variables.
   • B2B_EDI_COMPANY_ID
   • B2B_EDI_COMPANY_KEY
   • B2B_EDI_CONTROL_FILE (Typically JobList.xml in the directory used in item 1)
   • B2B_EDI_KINESIS_STREAM
   • B2B_EDI_ODBC_SOURCE_CONNECTION_STRING
   • B2B_EDI_SUPPLIER_ID
   • B2B_EDI_SUPPLIER_KEY
4. If the Amazon AWS CLI has not been installed then the following additional System Environment Variables will also be required:
   • AWS_ACCESS_KEY_ID
   • AWS_SECRET_ACCESS_KEY
5. Install B2bEdiExportsODBC.exe (located the program directory) as a service using Microsoft's InstalUtil.
6. Grant Read/Write permissions to the following files for the User name that will be "running" the service:
   • File location stored in B2B_EDI_CONTROL_FILE
   • B2bEdiExportsODBC.exe.config in the program directory
7. Optionally add a shortcut to B2BEDIExportsJobControl.exe to your user desktop and/or start menu.
8. Start DB2BEDIExportsJobControl.exe and create your first export job.  B2B may have provided some example jobs in the JobList.xml file.
9. Start the B2B EDI Exports (ODBC) Windows Service.
10. We recommend that the B2B EDI Exports (ODBC) Windows Service be set to start automatically or automatically (delayed start).