Step 1 – Set Connectivity of Fixer in the Integration Hub

Step 1 – Set Connectivity of Fixer in the Integration Hub


  1. Choose the SAP Business One SLD to provide the connection between SAP Business One System Id and Fixer Id.

Note

By default, the solution displays all the SAP Business One SLDs available in SLD Category selected during customer creation.


  1. To add a new SLD or edit existing SAP Business One SLD under SAP Business System Id area, choose Add / Edit button. 



The SAP Business One Connection Details window contains the following fields:

Field Name

Description

SLD Category

Displays the SLD Category selected during customer creation. This field is read only.

System Name

Enter the name of the system.

Note

System Name is the mandatory field to add or update SAP Business One SLD.

SAP Business One Server

Enter SAP Business One Server Name / IP Address.

Note

SAP Business One Server  is the mandatory field to add/update SLD information for SAP Business One.

License Server

Enter License Server details. i.e. Server Name or IP Address and port number of the SAP Business One License Server.

The default port is 30000. 

SLD Server

Enter the valid SLD Server details with port.

Note

SLD Server details is the mandatory field to add/update SLD information for SAP Business One.

Database Name

Enter the name of the SAP Business One Database.


Database Name is the mandatory field to add/update SAP Business One System SLD.

Caution

The Database Name must be entered same as SAP Business One Database Name.

Database Type

Currently, only Microsoft SQL Server 2005, 2008, 2012, 2014, 2016, 2017 and SAP Hana DB are supported. Choose the database type from the dropdown list.

Note

Database Type is the mandatory field to add/update SAP Business One SLD.

Database User

Enter the user to access the company database using the database connection. Database User is the mandatory field to add/update SAP Business One SLD.

Caution

The Database User must be valid. Invalid Database User will result in failure to establish the connection.

Database Password

Enter a valid password for database login. 

Note

Database Password is the mandatory field to add/update SAP Business One SLD.

Caution

The Database Password must be valid. Invalid Database Password will result in failure to establish the connection.

Database Port

Enter the port for database.

Username

Enter B1i in this field.

Note

Username is the mandatory field to add/update SAP Business One SLD. It is set as B1i by default and un editable.

Caution

Ensure that a user with this name exists in the SAP Business One database. 

Password

Enter a valid password for B1i user of SAP Business One.

Language

Select the language from the list of languages.

Is Trust

Select True or False. The default value for this field is False. To use a trusted connection, choose True from the dropdown list.

jcoPath

Enter path for jco library. Example of Installation path of JCO: C:\Program Files (x86)\SAP\SAP Business One DI API\JCO\LIB

DI ProxyHost

The DI Proxy host must be defined if B1i is installed on a separate server (this is, other than the SAP Business One server). 

The value in this field must be same as SAP Business One Server address.

Example

Proxyhost can be same as SAP Business One Server. 

DI ProxyPort

The default value of DI Proxy Port is 2099. 

Proxy Host

The proxy host is defined in a multi-instance scenario. If the B1i server connects to the SAP Business One server through a proxy server then, enter the address of the proxy server in this field.

Proxy Port

Enter the proxy port in this field.


  1. Enter the valid data and choose the Submit button. An SAP Business One SLD is created.
  1. Choose the Test Connection  icon to test the connection between the SAP Business One System Id in Integration Hub and SAP Business One System Landscape Directory.

If the connection is successful, a success message appears “Test Connection Successful”. 

If the connection is unsuccessful, a failure message appears “Test Connection Failed”. Please provide the correct credentials. 

  1. To add / edit Fixer instance SLD under Fixer Id area, choose the  Add / Edit button. 


The Fixer Connection Details window contains the following fields:

Field Name

Description

SLD Category

Displays the SLD Category selected during customer creation. This field is read only.

System Name

Enter the name of the system.


System Name is the mandatory field to add or update Fixer SLD.

App Key

Application Key provided by Fixer 


  1. Provide the valid information in the fields and choose the Submit button. SLD for Fixer will be created.


  1. Choose the Test Connection  icon to test the connection between the Integration Hub and Fixer.

If the connection is successful, a success message appears “Test Connection Successful”.

If the connection is unsuccessful, a failure message appears “Test Connection Failed”.


  1. Choose the Next button to proceed to Step2.


Summary 


  1. The Configuration summary displays the Date and time for Template Selection and Set Connectivity steps. 



Next Step:  Step 2 – Deployment of Fixer in the Integration Hub

    • Related Articles

    • Fixer integration with SAP Business One

      The Fixer API is capable of delivering real-time exchange rate data for 170 world currencies. The API comes with multiple endpoints, each serving a different use case. Endpoint functionalities include getting the latest exchange rate data for all or ...

    • Setup in SAP Business One for Fixer in the Integration Hub

      To check the activation status, choose Administration → Integration Hub →Feature Activation.  The Active field should be flagged. The Active checkbox enables for the feature deployed in the Integration Hub. If the flag is not set to active, then ...

    • Step 2 – Deployment of Fixer in the Integration Hub

      To deploy the solution, choose the Deploy Now button. The application prompts you to provide the license details. For more information, refer to the Assigning the Integration Hub licenses knowledge Article. The Integration Hub displays the Deployment ...

    • Setting Up Fixer in the Integration Hub

      The following are the steps to setup Fixer in Administration Console:  Add New Customer. Refer to Add New Customer Knowledge Article.  Select the Fixer template to integrate. Upon selecting the template, a message “Let’s Start” prompts to start ...

    • Manual Exchange Rates Retrieval in Fixer in the Integration Hub

      The application provides the option to manually retrieve the exchange rates at any time. The following steps describe the process to retrieve the exchange rates:  A Retrieve Exchange Rates button is available on Exchange Rates and Indexes window.  ...