Flow Exchange

Expand all | Collapse all

SQL Server Connector - Collect data from views

  • 1.  SQL Server Connector - Collect data from views

    Posted 26 days ago
    Edited by Marko Batur 25 days ago
    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
    ------------------------------


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

    Posted 25 days ago
    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
    ------------------------------



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

    Posted 20 days ago
    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
    ------------------------------