1 Reply Latest reply: Nov 27, 2013 9:25 AM by Nicole Smith RSS

    Using variables in a QVSource GA Feed URL

      I'm trying to loop through a load script from QVSource Google Analytics connector.

      The script looks like the following:




          dim_dateHour as DataFromQueryURI_dim_dateHour,

          dim_eventLabel as DataFromQueryURI_dim_eventLabel,

          dim_eventAction as DataFromQueryURI_dim_eventAction,

          metric_totalEvents as DataFromQueryURI_metric_totalEvents






      I'd like to loop through the bolded part of the connection string; it's an 8 digit number.

      How can I put a variable into the connection string?

        • Re: Using variables in a QVSource GA Feed URL
          Nicole Smith

          Here is an example of how I connect to my database using variables:


          OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=$(vDBName);Data Source=$(vDBServer);Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=$(vWorkstation);Use Encryption for Data=False;Tag with column collation when possible=False];


          Note that vDBName, vDBServer, and vWorkstation are all variables that I had populated earlier in my load script.