Forum Discussion

darpan13's avatar
darpan13
Contributor
3 years ago

Can Tableau Connects to One Stream ?

Hi Team, Can Tableau Connects to One Stream ( on Azure Cloud ) ? Best Regards and Thanks Darpan Bhansali
Data Integration
darpan13's avatar
darpan13
Contributor
3 years ago

Hi Team,

Let me Re-iterate the sentence again.

Does any Data Visualization tools (Tableau / MicroStrategy / Power BI ) can connect One stream over azure cloud ?

Best Regards and Thanks

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor II
    3 years ago

    Yes you can connect from Tableau to Onestream Azure DB with out of the box sql server connector or you can build custom connector using SDK.

    - Khirod Palai

    • darpan13's avatar
      darpan13
      Contributor
      3 years ago

      Hi Khirod, can we create the Out of Box SQL server connector, or we need to get it done by One stream ?

      Regards and Thanks

      Darpan

  • TerryLedet's avatar
    TerryLedet
    New Contributor III
    3 years ago

    Darpan

    I believe KB0011051 - Requesting a SQL Read-Only Account will assist with your question.

    Terry

    • darpan13's avatar
      darpan13
      Contributor
      3 years ago

       

      KB0011051

      We were actually looking for the same.

      Many Thanks

      Darpan

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor II
    3 years ago

    Hi Darpan,
    Were you able to implement the SQL Read-Only connector ? is it out of the box ?
    I’m interested in following up, we have a project to connect OneStream with a Global Data Platform, this solution could be helpful.
    Thank you
    Etienne Durafour

    • darpan13's avatar
      darpan13
      Contributor
      3 years ago

      Hi Etienne,

      we can connect get a read only account on SQL Server (on Azure Cloud), and you can query all the tables at the back end.

      but what you cannot do is

      1. Cube Data Cannot be differentiated and query upon.
      2. Standard Function / Classes will not work here.
      3. If any performance issues with respect to the Code written, it can never be tracked.

      Best Regards and Thanks

      Darpan Bhansali
      +91-7720051310