3 Replies Latest reply: Dec 23, 2017 9:38 AM by omar bensalem RSS

    Qlik Sense Variable Catalogs in OLE DB connection

    Niclas Anderström

      Hi, I am converting a Qlikview application to Qlik Sense, and one of the steps include loading data from defined catalogs on the database server.

       

      In Qlikview I loaded all the catalogs from a separate file managed by the customer, and then I do an iteration adding the data for each of the individual catalogs listed by using a variable in the connection string: Initial Catalog=$(vCustomerNo);

       

      However in Qlik Sense since you are forced to use Libs you cannot use the variable solution like this as it verifies all connections and refuses to save the connection string if it is considered false.

       

      Anyone have a good workaround for this?