How to import IQD in Transformer as data source that is created in Framework Manager

Steps to import an IQD file for Transformer from FM

1. In FM, right-click one of the Query Subjects
2. Properties, Externalize method, choose 'iqd'
3. Create a new package, select only the Query subject that you have externalized as iqd
4. Create the package, publish
5. When publish, check the "Generate the files for externalized query subjects" under Externalized query subjects
6. note the location of the iqd file

In Access Manager, need to add this Database and create the singon.

1. Open namespace, Data Sources, Databases
2. Add a new database
3. Insert name, then on Connection tab
4. Choose type, Microsoft SQL server OLE-DB, click Edit
5. In database Definition, put in the Logical database name, as exactly on SQL Server
6. Provider: SQLOLEDB
7. Data Source: machinename, e.g. wottcs-wong-xp
8. click 'Test', supply username and password to this data source
9. Message "Successfully attached to database Northwind"

In Transformer, create model, add new Data Source

1. Model name
2. Data Source name, Data Source type as 'Impromptu Query Definition'
3. File location, where you saved it in FM
4. Run AutoDesign, clcik Finish
5. When prompt, provide database login information
6. Successfully login and retrieve data source