none
SQL Server R Services: Are more input datasets planned or under development?

    Question

  • In some web application scenarios it is not possible to gather data through ODBC connection.

    A web application that uses R-services through sp_execute_external_procedure runs on an web application server.

    The application generates the data - let's say through data import and some calculations - and inserts the data into the database tables. Next step should be the processing of this data in R. You want to get more data than possible through only one SQL statement (input dataset).

    If You are able to get an ODBC connect (this is more a question of security) You will find the needed tables locked because You open a new connection and the web application's one isn't committed or closed yet. This is because the web application is in a request processing.

    Assuming input_data_2, input_data_3, ... :  Are more input datasets planned or under development?

    Are there reasons to restrict the number to 1?

    Regards,

    Joachim


    Thursday, December 20, 2018 11:37 AM

All replies