How To: Import a Data Source / Views / Tables / Fields from another Data Model files into another one like datamodel.dat?

Version 3


    All Xtraction versions


    How to:


    If you need to use Xtraction for a new product or if you want to do some testing of a new configuration, you might need to import a data source from a data model file to another one, like datamodel.dat


    Step by Step:


    In this scenario, you will import a new LANDesk Management Suite v9.5 data source into datamodel.dat where a Data Source for LANdesk Service Desk v7.8 is already there.


         1- Windows Start > All Programs > Xtractions > Click on "Xtraction Data Model Editor"

         2- From there, go in File > Open > Choose "C:\Program Files (x86)\Xtraction Software\Xtraction\Data\Configuration\Datamodel.dat" (see below)


         3- Go in Tools > Click on "Copy Objects"

         4- On the new window "Copy Objects", right click on Data Model under section "Copy Source (Current Data Model)" > Click on "Load External Data Model"

         5- Choose the .dat file where the LANDesk Management Suite v9.5 data source is and click on Open (See printscreen below)


         6- Drag&Drop the Data Source into the other section "Destination (Current Data Model)"

         7- Click Yes on the window "Copy Data Source" to confirm it

         8- Click on Close button

         9- You will see appearing the new Data Source, here called "LanDesk Management Suite" (See printscreen below)


         10- Select the Data Source "LanDesk Management Suite" and double-click it, a new window Data Source will open (See printscreen)


         11-  From there, you can edit the Text box and change its name to LDMS v9.5, edit the Connection box to point to the right DB, and tick the box Active, then click OK (See result below)

         12- To save your changes from this datamodel.dat, click on Files > Save and Reload the Data Model from the Web Interface on Xtraction then refresh the page


    Other possibilities:


         1- You can also, in Copy Objects, export from a test Data Model file, some more precise objects like Views, Tables or Fields instead of the whole Data Source

         2- You can also export, in Copy Objects, some Objects from the Datamodel.dat to other environments (NOTE: Of course, it has to be applicable on other Source DBs)