Flow Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
Expand all | Collapse all

SQL Server Connector - Collect data from views

  • 1.  SQL Server Connector - Collect data from views

    Posted Jan 23, 2019 10:39 AM
    Edited by Marko Batur Jan 24, 2019 06:32 AM
    Hi,

    At the moment, we can only see the tables when we connect to the SQL server.

    Is it possible to extract/read data from the views?

    Thank you in advance.

    /*EDIT*/

    It was error on server side. Get rows function works fine.



    ------------------------------
    Marko Batur | Consultant, Span Software Solutions
    marko.batur@span.eu | M +385 95 845 8519 | T +385 1 2075 427,
    Span Ltd., Koturaška 47, 10000 Zagreb, Croatia
    ------------------------------
    Power Summit (Flow) - Post


  • 2.  RE: SQL Server Connector - Collect data from views

    Posted Jan 24, 2019 10:49 AM
    Hi Marko,

    I run into this too.  Can you share what the error was on the server side?
    It might help me (or others) when they have to talk with a database administrator (dba).

    ------------------------------
    Mick Thornton
    Program Manager
    Bellevue WA
    4255196463
    ------------------------------

    Power Summit (Flow) - Post


  • 3.  RE: SQL Server Connector - Collect data from views

    Posted Jan 29, 2019 10:12 AM
    Hi Mick,

    In our case it was due security roles of a user on a database. We reconnected to the SQL gateway one more time and we were able to collect the data from the views.

    One downside regarding installation of gateways is that they have to be stored under default environment. :(

    ------------------------------
    Marko Batur
    Span d.o.o
    Zagreb
    385981795122
    ------------------------------

    Power Summit (Flow) - Post