Skip to main content
Solved

When I create an FME Server Resource Connection, how can I work with this in FME Desktop?

  • May 12, 2020
  • 3 replies
  • 220 views

fmelizard
Safer
Forum|alt.badge.img+20

After creating an FME Server Resource Connection, how can I work with this to author my workspaces?

When I view the Folder properties in FME Server I can see the System path references an FME Server macro $(), however when I specify this path within my workspace it shows red because FME Desktop does not recognise this as an existing parameter.

Best answer by hollyatsafe

Since FME Desktop is a separate application, this means that whilst you've created a Resource Connection successfully on FME Server, FME Desktop doesn't know this definition so will display red when you point to the path using the macros $(). Therefore to use FME Server Resource Connections in FME Workbench you'll need to create a private parameter with the same name as the resource and you should then be able to create a workspace using this connection.

 

  1. In the Navigator panel create a new private parameter give it the name of your Resource Connection. If you do not know the name you can find it in FME Server by selecting the Resource Folder and clicking Action > Properties and see the name

     

     

     

     

  2. For the value of the parameter you can leave this blank, set it to the UNC path you used to create the connection, or a dummy local file path. Setting a value will simply allow you to run the workspace on FME Desktop while you are testing however when published to FME Server whatever value is stored there will then take precedence over the setting in Workbench just like with the other FME Server parameters.

     

     

  3. Now this has been created you can reference this anywhere in your workbench. E.g. in a writer, if you want to write to a folder within this Resource it would be $(NewResourceConnection)/OutputFolderName/OutputFilePath.ext

     

     

     

     

  4. If you gave this parameter a value, once it’s published to FME Server, we will ignore this and use the path specified when you created your Resource Connection in FME Server.

 

An enhancement request (FMEDESKTOP-10285) has been filed in support of adding your own FME Server Parameters, the advantage being these would need to be set up one time only as opposed to for every workspace you use these connections in.

Please add your vote and support comments to this idea: https://knowledge.safe.com/idea/113828/add-option-to-create-your-own-fme-server-parameter.html if this is something you would like to see.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

Forum|alt.badge.img+2
  • 719 replies
  • Best Answer
  • May 12, 2020

Since FME Desktop is a separate application, this means that whilst you've created a Resource Connection successfully on FME Server, FME Desktop doesn't know this definition so will display red when you point to the path using the macros $(). Therefore to use FME Server Resource Connections in FME Workbench you'll need to create a private parameter with the same name as the resource and you should then be able to create a workspace using this connection.

 

  1. In the Navigator panel create a new private parameter give it the name of your Resource Connection. If you do not know the name you can find it in FME Server by selecting the Resource Folder and clicking Action > Properties and see the name

     

     

     

     

  2. For the value of the parameter you can leave this blank, set it to the UNC path you used to create the connection, or a dummy local file path. Setting a value will simply allow you to run the workspace on FME Desktop while you are testing however when published to FME Server whatever value is stored there will then take precedence over the setting in Workbench just like with the other FME Server parameters.

     

     

  3. Now this has been created you can reference this anywhere in your workbench. E.g. in a writer, if you want to write to a folder within this Resource it would be $(NewResourceConnection)/OutputFolderName/OutputFilePath.ext

     

     

     

     

  4. If you gave this parameter a value, once it’s published to FME Server, we will ignore this and use the path specified when you created your Resource Connection in FME Server.

 

An enhancement request (FMEDESKTOP-10285) has been filed in support of adding your own FME Server Parameters, the advantage being these would need to be set up one time only as opposed to for every workspace you use these connections in.

Please add your vote and support comments to this idea: https://knowledge.safe.com/idea/113828/add-option-to-create-your-own-fme-server-parameter.html if this is something you would like to see.


  • 2 replies
  • August 11, 2020

 

Hello, Very helpful article, thanx. I just have a similar case.

I would like to use *.sde connection files I did store om my FME Server which is located in $(FME_SHAREDRESOURCE_DATA)/SDEFiles on the server.

I did configured Server Paramater > FME_SHAREDRESOURCE_DATA on the FME desktop as " d: " , which is the drive letter of the installation folder of my fme server.

Now, if i try to create a User parameter with Filename (Existing) type , however when I specify this $() path within Default Value Field it shows red! FME Desktop does not recognise this as an existing path.

fme-sde-to-server-refrence

this folder is also shared folder and i can reach it with an UNC path to the server machine.

Do you have any idea?

thank you, Ghavam

 

 


Forum|alt.badge.img+2
  • 719 replies
  • August 18, 2020

 

Hello, Very helpful article, thanx. I just have a similar case.

I would like to use *.sde connection files I did store om my FME Server which is located in $(FME_SHAREDRESOURCE_DATA)/SDEFiles on the server.

I did configured Server Paramater > FME_SHAREDRESOURCE_DATA on the FME desktop as " d: " , which is the drive letter of the installation folder of my fme server.

Now, if i try to create a User parameter with Filename (Existing) type , however when I specify this $() path within Default Value Field it shows red! FME Desktop does not recognise this as an existing path.

fme-sde-to-server-refrence

this folder is also shared folder and i can reach it with an UNC path to the server machine.

Do you have any idea?

thank you, Ghavam

 

 

Hi @ghavam​ ,

Unfortunately it looks like you have encountered a bug with the Filename (Existing) User Parameter type. I have filed an issue with our team to request this fix (FMEDESKTOP-10624).

 

I'm sorry you encountered this issue, in the mean time I'd recommend changing the parameter Type to Filename (Multiple) which seems to accept the user parameters as a default value and should allow your workspace to perform in the same way.