ZenOfBI

• Jun 13th, 2006

 

Steps1. Right-click in the Data Sources list of your model and select Insert Data Source.2. In the New Data Source wizard, enter the name of the data source in the Data Source Name box.3. In the Source Type box, select the type of data source that corresponds to your source type and click Next.4. In the Local Data File box, enter the name of the source file.5. Enter the remaining parameters appropriate to your selected source, and then click Finish.Note: Depending on the type of data source, Transformer shows different options. For example, if your source is an Excel database, you must provide the named range of cells from the Excel worksheet.6. Transformer adds your specified source to the existing model, and you see your new source in the Data Sources list.