Connecting Supply Chain Guru X and Data Guru

You can connect a Supply Chain Guru X model to a Data Guru project in one of two ways:

  • Create a connection to your model database from Data Guru.
  • Connect the Data Guru project to your model within Supply Chain Guru X.

Data Guru connection to a model database

In this process, you initiate the connection to your model from Data Guru. By default, Supply Chain Guru X uses a SQL Server LocalDB instance. If you want to use this instance to establish the connection, you can find the name of the instance in this file:
C:\Users\<username>\AppData\Local\LLamasoft\LocalDBInstance.txt

where <username> is your user name on the computer. For example, if you user name is “LLamaUser”, the LocalDBInstance name will be GURU-LLamaUser. When you want to use this instance, you enter the instance name as (localdb)\GURU-LLamaUser.

  1. In Supply Chain Guru X, open the model to which you want to connect. This will attach the model to your SQL Server LocalDB instance.
  2. In Data Guru, create a new Database Connection.
  3. Name the new Database Connection.
  4. Select SQL Server as the Database Type.
  5. Select your SQL Server LocalDB instance name (such as “(localdb)\GURU-LLamaUser“) as the Server Name. If you do not see the LocalDB instance name, you can enter it.
  6. Select the appropriate database. Use one of the following methods:
    • Select the database name from the list of Hosted Database Names.
    • In the Attachable Database File Path, select the .scgm file for the model you want to use.

Run a Data Guru project from Supply Chain Guru X

In this process, you connect the Data Guru project to your model from within Supply Chain Guru X.

  1. In Data Guru, create two new Project Parameters that will be used to reference the current model and current server. You can provide desired names, but Coupa recommends the following convention:
    1. CurrentModel - When you click on info about the parameter it should read:

      Name: @@[CurrentModel]

      Type: String

      Value:

    2. CurrentServer - When you click on info about the parameter it should read:

      Name: @@[CurrentServer]

      Type: String

      Value:

  2. Once you have the parameters set up, create a new connection or edit an existing one, using the following options:
    • Database Type: SQL Server
    • Server Name: @@[CurrentServer]
    • Use Windows Authentication: Checked
    • Hosted Database Name: @@[CurrentModel]
  3. In Supply Chain Guru X, select Data Guru > Data Guru Tools.
  4. Create a new Data Guru tool.
  5. Click Configuration, then select the project you created or edited in Data Guru.
  6. When using this tool, you can select:
    • Parameter Type: Current Model Name for the CurrentModel parameter
    • Parameter Type: Server Name for the CurrentServer parameter

Last modified: Wednesday May 15, 2024

Is this useful?