[go: up one dir, main page]
Scribd
Upload
36 views2 pages

Configuring Xtraction Data Model For Xtraction

Uploaded by

ahmed gaafar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
36 views2 pages

Configuring Xtraction Data Model For Xtraction

Uploaded by

ahmed gaafar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Configuring the Xtraction data model for Xtraction

Follow these instructions to configure your Xtraction data model for use with Xtraction.

To configure the Xtraction connection

1. Create a read-only user to the Xtraction database.


2. Copy the provided Xtraction data model file to the Data\Configuration directory, located by
default at:
C:\Program Files (x86)\Xtraction Software\Xtraction\Data\Configuration
3. On the Xtraction server, open the Xtraction Data Model Editor program (located by default
in the Xtraction\Tools directory).
• Click File > Open or Ctrl-O to open the data model file mentioned above.
4. If you have an existing DataModel.dat file that you’ve already configured, and want to
preserve the existing connections, you’ll need to merge the provided Xtraction data model
into DataModel.dat file using Copy Objects. You’ll need an Enterprise license to complete
this step:
• Click Tools > Copy Objects.
• Right-click under Copy Source, and select Load External Data Model.
• Select the database from Data Sources, and drag it to the Current Data Model
directory.
• Click Yes to confirm that you want to copy the data model from the external source
to the current data model.

If you’re not replacing an existing DataModel.dat file, just rename the existing file to be the
DataModel.dat file using File > Save As or Shift-Ctrl-S once you’re done configuring.

5. Enter the connection details for the Xtraction database:


• Click Tools > Connection String Editor.
• Click the Connection column next to the Xtraction data source.
• Click the ellipsis (…) for the connection and enter the connection string properties
for the Xtraction data source.
• Click the Test button to validate that the connection can be made.
6. Update the Xtraction URLs:
• Click Tools > URL Editor.
• Use Find & Replace to change [XTRACTION_SERVER] to the Xtraction host name.
7. Be sure to save your updated DataModel.dat file by selecting File > Save or Ctrl-S. The file
must be named DataModel.dat. If renaming, use Save As.
8. Execute the SQL script Xtraction <version> Code.sql against the target Xtraction database to
create the dbo.xtr_folder_lineage function.

Copyright © 2003-2017, Ivanti. All rights reserved.


9. Execute the SQL script Xtraction <version> Permissions.sql to give the read-only user
permission to execute the function:
• Open the SQL script Xtraction <version> Permissions.sql.
• Modify ‘Network Service’ in the following line to the read-only user you configured
above:

SET @XtractionUsername = 'NETWORK_SERVICE'

• Execute the script against the target Xtraction database.

For more details on using the data model editor, see the Xtraction Data Model Editor Guide on the
Ivanti user community website.

Copyright © 2003-2017, Ivanti. All rights reserved.

You might also like