Creating and executing a ”Remap Data Sources” Automation Services job

Creating and executing a ”Remap Data Sources” Automation Services job

How to setup a "Remap Data Sources" Automation Services job:

1. Create the Automation Services job via “Automation Services Job Builder”, found under Tools menu in Spotfire Analyst.
2. In the “Remap Data Sources” Settings window, do the following:
   1. Choose a certificate (needed in order to secure data source password).
   2. Browse to the directory where the data source is saved.
   3. Manually add the name of data source to be remapped.
   4. Add the new connection string, to which the data source should be remapped
   5. If needed, change password in “Password” field.
   6. Save the job via File – Save As File/Save As Library Item.
3. Prerequisite 1: The certificate chosen in the settings for the job, also needs to be installed on the Node manager running the Automation Services.
4. Prerequisite 2: Make sure the Automation Services User has write access to the folder containing the data source.
5. Prerequisite 3: Make sure to add the license “TIBCO Spotfire Information Modeler” for the Automation Services Users group (done in Administration manager, found in Analyst client – Tools menu).

 
Executing the job:

Spotfire version 7.14 and older:

Use the Client Job Sender in order to execute the job.

Read more about the Client Job Sender here: https://docs.tibco.com/pub/sfire_autsvcs/10.1.0/doc/html/TIB_sfire_autsvcs_10.1.0_UserGuide/GUID-29E8EFA5-A37B-46FF-8874-4CD8A04A8C31.html
 
Spotfire version 10 and newer:

You can user the Client Job Sender OR you can setup to schedule the job via Spotfire administration interface.
Instructions on how this is done can be found here: https://docs.tibco.com/pub/spotfire_server/10.1.0/doc/html/TIB_sfire_server_tsas_admin_help/GUID-1891A737-803F-4680-9F44-66D988F06614.html

  Different errors you might see in the Automation Services log and solutions to them:
 

1. “You do not have sufficient privileges for this action.”

If you see this error, you do not have license “TIBCO Spotfire Information Modeler” added on the Automation Services Users Group. This license is needed in order to have permission to set up and edit data sources used by information links.
 

1. “The automationservices principal has insufficient privileges.”

If you see this error, your Automation Services user do not have Modify rights on the folder/s containing the data source/s that is setup to be remapped.
 

1. “System.Security.Cryptography.CryptographicException: Unable to retrieve the decryption key.”

If you see this error, it means that the certificate, used in the settings for the ”Remap Data Sources” job, has not been installed on the Node Manager running Automation Services.