0 Replies Latest reply: Feb 4, 2013 9:49 PM by Michael Fenton RSS

    Reuse same script to get data from multiple sources

      I am developing an App that is extracting data from a financial system. There are 3 different databases for 3 business entities. I want to reuse the same script for each data source as they have an identical schema.

       

      I am thinking of writing the common LOAD/SELECT statements in an include file and load it three times.  Something like the following:

      
      ODBC CONNECT32 To [<connection string 1>];
      
      
      $(Include=script.txt);
      
      
      
      
      ODBC CONNECT32 To [<connection string 2>];
      
      
      $(Include=script.txt);
      
      
      
      
      ODBC CONNECT32 To [<connection string 3>];
      
      
      $(Include=script.txt);
      
      

       

       

      Is this a sensible approach?  Is there any best practice for handling this situation?