Connection to Snowflake (Credential Profile)

[Andrew McGowan]

Is there a way to create a credential profile in Spotfire outside of updating the Spotfire.Dxp.Worker.Host.exe.config file? Specifically, is there any way to store credentials for connecting to a data source similar to how they are stored for information links?

I'm wondering if there is a secure way to let automation services and scheduled updates run on an analyses with a connection to Snowflake without having to update the file above.

Thanks!

[Olivier Keugue Tadaa]

Hi @Andrew McGowan
when you edited the Spotfire.Dxp.Worker.Host.exe.config file you might have noticed the below section. 

<setting name="DataAdapterCredentialsFilesDirectory" serializeAs="String">
  <value>../../secrets/credentials-profiles</value>
</setting>

To avoid editing that file, you can save your credential profiles at this location   <INSTALLED_FOLDER>\nm\secrets\credentials-profiles (e.g. C:\spotfire\nodemanager\14.3.0\nm\secrets\credentials-profiles)

The credential profile file should have the XML structure, the same name as the credentials profile, and no extension.

See below an example of a Google Big Query credentials profile

<entry profile="myGBQCredentials">
	<allowed-usages>
		<entry connector-id="Spotfire.GoogleBigQueryAdapter" />
		<entry connector-id="Spotfire.GoogleAnalyticsAdapter" />
	</allowed-usages>
	<username>bqtesting@my-group.iam.gserviceaccount.com</username>
	<password>{
  "type": "service_account",
  "project_id": "my-group",
  "private_key_id": "xxxxxxx",
  "private_key": xxxxxxxxxxxx</password>
</entry>

 

for more information, visit the following section of the documentation: https://docs.tibco.com/pub/spotfire_server/14.4.0/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/spotfire.dxp.worker.host.dll.config_file.html