Solving with the command line tool

You can use a command line tool to run the Network Optimization, Inventory Optimization, Transportation Optimization and Simulation solvers outside the Supply Chain Guru X user interface. The solver executable is located in your Supply Chain Guru X installation folder. The tool requires the following:

  • the type of solver (Network Optimization, Inventory Optimization, Transportation Optimization or Simulation).
  • the connection string to the model.
  • the working folder to use for the input and output files.

Connection string details

The connection string in the example above will vary depending on your SQL Server implementation. A connection string can include many keyword/value pairs. The keywords included in the example are recommended; however, they may be changed based on your implementation:

Keyword

Description

Required

Server

Provide the instance name as you use to connect in SQL Server Management Studio.

Yes

Database

Enter the full model name as specified in SQL Server Management Studio. You can also see this value in the Model GUID field under Model > Model Info.

Yes

Pooling

When Pooling is True, the number of times that new connections must be opened is reduced.

No

Connection Timeout

Enter the time to wait while trying to establish a connection before terminating the attempt.

No

MultipleActiveResultSets

When MultipleActiveResultSets is True, execution of multiple batches on a single connection is allowed.

Coupa recommends you include this keyword/value pair, with a value of True.

Trusted_Connection When Trusted_Connection is True, the current Windows account credentials are used for authentication. No
Persist Security Info Include Persist Security Info=True when your connection string includes a User Id and Password. This setting persists the password defined in the connection string. Yes, when your connection string includes User Id and Password.

The table lists typical keywords used in the connection string. However, your implementation may include additional keywords, such as User Id and Password.

Working folder details

The folder you define for the working folder must not be the folder where the model is located. It should be a folder without any files you want to keep, as the folder is cleared when the solver runs.

Last modified: Wednesday May 15, 2024

Is this useful?