1 Reply Latest reply: Nov 19, 2013 7:10 AM by Jonathan Dienst RSS

    Extract data from multiple data sources

      Hi all,

       

      I have a data in excel ,sql server and other database.i have different tables in different dats source...now i want to make reports based on that..so how to do it,can any help me in detail@@@@

        • Re: Extract data from multiple data sources
          Jonathan Dienst

          Hi

           

          First design the data model for your document taking into account the field names and tables, and specify the fact table(s) and dimensions.

           

          Then load from each source in turn:

          • set the connection string for the first source using CONNECT
          • load the data from this source, organised per your analysis.
          • connect to the second source (this automatically disconnects the first)
          • load the data from this source
          • and so on for all your sources ...
          • perform any final transformations  etc

           

          HTH

          Jonathan