Skip to main content

Hi everyone,

 

I have a problem in which I'm absolutely stuck in. I will try to be as complete as possible in describing the issue and all the solutions that I have tried to implement without reaching the expected result. I will be GLAD and I could even pay for a consultancy to someone who could help me in figuring this out.

 

I work in a company specialized in Salesforce implementations. In one of our projects, one of the requirements was to embed in Salesforce some dashboards that the customer access from "Tableau Server". It seemed quite easy and straightforward.

In order to make this embedding, I installed in Salesforce a package: "Tableau Viz Lightning Component". This was necessary in order to embed the link of Tableau's dashboards inside of Salesforce.

 

But, in order to reach the scope, data has to be shown dynamically when embedded in Salesforce. I mean, these dashboards will be consulted from Sales Agents and each Sales Agent needs to visualize his/her data AS in Tableau.

To satisfy this requirement, it was necessary setting up SSO, enabling Salesforce as the Idp and Tableau as the Service Provider.

 

First thing I did was enabling Salesforce as the Idp. At this point, I downloaded the certificate .crt file and the metadata .xml file (from Salesforce). Initially, Tableau Admin gave me access to a workbook related to one of the company's Sales Agents. Consequently, the embedding procedure didn't show data dinamically.

 

Yesterday, I contacted the Tableau Administrator of the customer's company and he organized the folder's structure setting "User specific view" for the dashboards. He gave me a new "Tableau" link to log in with my dedicated credentials (I can't see authorizations he has configured) in order to copy new dashboard's links and embedding them, but in Tableau, on the cover of the dashboards that you see before opening them, I saw "User specific view" on a blank background and if I open one of the dashboards I'd see only the title and related filters. The same visualization applied to Salesforce, having embedded this new links (I saw only title and dashboard's filters). So, me and the Tableau admin followed this documentation in order to set up SSO.

 

https://help.tableau.com/current/server/en-us/config_saml.htm

 

At a certain point, it mentions a SAML certificate and key file.

I have found nothing on the entire web that could have helped me in order to extract or recover this .key file that additionally, after the uploading of the .crt and .xml files in TSM has resulted "mandatory" in order to save and enabling SAML from Tableau side.

In the link that I've attached, it assumed that you already have this .key file. But there's nothing helpful in order to find it (or extract it from the .crt?), in Tableau/Salesforce documentation neither. But, when I created the Salesforce certificate .crt, it showed a checkbox "Exportable private key" (could be that?) with the possibility to extract it to a JKS inserting a password that I'don't know where to find and I don't know if it's the one that the documentation is referring to.

 

It could be helpful to underline that at the moment, if I open Salesforce in Chrome, I see a Sign-In option on every embedded dashboard. If I attempt to click it and login, everything remain static and it's still shown the "Sign-IN" button. Instead, in Firefox, the browser in which "worked" before this folder's structure modification (if I clicked Sign-IN from Firefox and inserted the credentials, I was able to see data, but obviously not dinamically, in Chrome I had the same actual problem that the Sign-IN procedure doesn't work), I see only dashboard's title and related filters AFTER log-in.

 

The one step that I haven't already set up concerns the creation of a "Connected App" in Salesforce, in order to register Tableau as the service provider.. but this comes a step later on the documentation..

 

The requirement in one phrase: embed some Tableau Server views for the company's "Sales Agents" that will be login ONCE and ONLY to Salesforce from Safari browser (which I'm unable to test during the day because I am using Windows). The Single Sign-ON should solve every browser problem related to loadings error/missing data/sign-in problems).. but until it will be done, I'll never know.

 

This is very frustrating for me, I have followed every Tableau's official documentation, contacted every Fiver expert putting my own money, watched Youtube videos related to this set up. It was everything useless in order to solve. And I still think, this is a "short" procedure, when you have found everything you need in order to make it work, but I haven't..

I'll update some screenshots that could be helpful.

 

If you think you could help me, or if you think it could optimize times spent finding a solution having a call, please get in touch. There is no assistance from Salesforce/Tableau for this type of technical issues.. I need this burden to be solved ASAP in order to deliver a working project.

답변 14개
  1. 2023년 2월 2일 오후 5:35

    @Giambattista Vico​ 

    Hi, you have several questions. Probably I am not going to answer all of them:

     

    At a certain point, it mentions a SAML certificate and key file.

    Hi, in this case Salesforce does not provide the .cer (.pem - .crt) file. Also it does not provide the (.key) file.

     

    In this case you can use the certificate you used in the ssl configuration:

    @Giambattista Vico​ Hi, you have several questions. Probably I am not going to answer all of them: At a certain point, it mentions a SAML certificate and key file.And you could use the key if it is a RSA key. How to know if is it a RSA key?, well, you can open the key file in notepad, and the first line is: -----BEGIN RSA PRIVATE KEY-----

     

    If it is a pem key, it will begin with -----BEGIN PRIVATE KEY-----. If that is the case, you can convert it with openssl:

    openssl rsa -in private.pem -out private.key

    or you can do it online (not my recommended option, but possible): 

    https://decoder.link/rsa_converter

     

    Finally, you can use the pem certificate and the RSA key to configure the SAML.

     

    About configuring the SAML:

    In this case, I would suggest to use a site-SAML (why? probably there are only Tableau Server Users, and some Tableau Server-Salesforce Users)

    So to achieve this, you would need to disable the server wide SAML, but preserve the entries of the step 1 (yes you can do this!!!)

    a. Disable server wide SAML (probably this will require to apply changes and restart tableau server in TSM).imageb. You would need to activate SAML per site:

    1. tsm authentication sitesaml enable
    2. tsm pending-changes apply

    c. Next, you will need to configure SAML in each site, so go to settings, then authentication Tab

    imageThe process is similar to the one of configuring server wide saml, instead this is done directly in Tableau Server UI

    d. Finally, you can go to the users tab, and you would be able to select SAML or Tableau Local authentication for users:

    imageimageConfigure your site saml:

    https://help.salesforce.com/s/articleView?id=sf.identity_provider_examples_tableau_online.htm&type=5

    https://www.linkedin.com/pulse/embedding-tableau-salesforce-setup-saml-using-sf-idp-under-shih/

     

    The video (until 2:15s) and the article were very useful ton configure the sitesaml.

     

    About Lightning component:

    https://www.tableau.com/blog/introducing-tableau-viz-lightning-web-component-salesforce

     

    If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

     

    Regards,

     

    Diego Martinez

    Tableau Visionary and Forums Ambassador