Uploaded image for project: 'MongoDB Database Tools'
  1. MongoDB Database Tools
  2. TOOLS-2861

BI Connector 2.4.x does not support parametrized SQL queries?

    • Type: Icon: Bug Bug
    • Resolution: Won't Do
    • Priority: Icon: Critical - P2 Critical - P2
    • None
    • Affects Version/s: 4.4.4
    • Component/s: common
    • None
    • Not Needed

      We are using BI Connector v2.4.x including latest v2.4.3, with SSRS for structured reporting purposes.

      When we try to use a parametrized SQL query in SSRS, where values in the "where" clause are dynamically set, the parameters are not evaluated by the BI Connector.

      For example, in SSRS we set a query like:

      SELECT *

      FROM my_collection

      WHERE id = @selected_id

      @selected_id should be evaluated by the ODBC connector, but is accepted as is, and thus returns no data.

      This exact same scenario and SSRS query works fine with the CData MongoDB driver/connector, so we strongly suspect it's an issue with the BI Connector.

      It is possible that under the covers a prepared SQL query is being used, but that the BI Connector does not support prepared queries with their attendant value binding.

       

            Assignee:
            Unassigned Unassigned
            Reporter:
            ataramina@shorecg.com Andrzej Taramina
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: