Xtraction Database and User Setup
To make the reports in Xtraction Application, you need Xtraction Database and target database (e.g. Service Desk, LDMS). Below you will find how to create and configure properly Xtraction database and users to connect to Xtraction and target database(s).
Pic.1. Diagram showing the Xtraction application using Xtraction and target Application database and the users to connect to each database
Xtraction database setup
Before installing the Xtraction application, manually create an empty Xtraction database to store the Xtraction data. You will also need two user accounts to access Xtraction and target database.
The first account needs read-only access to the target application database(s) on which Xtraction reports (this usually is not the Xtraction database itself).
Once you create Xtraction database, you will need second account with rights to create tables in the Xtraction database. After installing Xtraction, you’ll run the Xtraction Settings application for the first time. The Xtraction Settings application will use this account to create the required tables in the Xtraction database. This user should have db_owner, db_datareader, and db_datawriter rights.
Note: If the accounts in steps 1 and 3 of the following procedure both use Windows authentication, they MUST be the same account.
1. Manually create a user account, or ascertain if a suitable account already exists, with read-only permissions to the target database(s). The username(s) can be any valid name, but Ivanti recommends using “Xtraction_RO” for consistency. If this account uses Windows authentication, be sure to include the domain name (e.g. MYDOMAIN\myuser).
For MS SQL, it should be sufficient to grant db_data_reader access.
2. Manually create the Xtraction database on an MS SQL server to store the Xtraction data. The database name can be any valid name, but Ivanti recommends using “Xtraction” for consistency.
3. Manually create a user account to enable Xtraction to connect to the Xtraction database with read, write, and owner permissions. The username can be any valid name, but Ivanti recommends using “Xtraction” for consistency. If the account uses Windows authentication, be sure to also include the domain name (e.g. MYDOMAIN\myuser).
For MS SQL, it should be sufficient to grant db_owner, db_datareader, and db_datawriter access once the tables are created.
If you would like to report on the Xtraction database as well (Xtraction_RO user connection to Xtraction database as on the diagram from Pic.1.), please create another account (user) with db_datareader privileges on SQL server holding Xtraction database or map already existing account with read-only access to Xtraction database (in case where your Xtraction and target database are placed on one server, you just need create one Xtracion_RO user and map it to the Xtraction database and to the target database e.g. Service Desk).
I created two Xtraction_RO users as I have two SQL Servers - one user on the server holding Xtraction database and the other user on the server holding Service Desk databases.
Pic.2. Xtraction_RO user created on SQL Server holding Service Desk databases - with db_datareader privileges
Pic.3. Xtraction_RO user created on SQL Server holding Xtraction database - with db_datareader privileges
Pic.4. Xtraction user created on SQL Server holding Xtraction database - with db_owner, db_datareader, and db_datawriter privileges
Xtraction Settings Application Configuration
To configure Xtraction Application to connect to Xtraction database, run XtractionSettings.exe application. Type Xtraction Settings in Start Menu of Windows Server or you can also go to C:\Program Files (x86)\Xtraction Software\Xtraction\Tools and double-click XtractionSettings.exe application. The below window will be shown:
Pic.5. Open Xtraction settings
Pic.6. Use Create/Update button to configure the connection between Xtraction Application and Xtraction Database. After installing Xtraction, you’ll run the Xtraction Settings application for the first time. The Xtraction Settings application will use this account to create the required tables in the Xtraction database.
Pic.7. Xtraction Database connection setup - Xtraction User
Xtraction is made up of a number of components, the two main ones being a web-accessible front end and the Xtraction server application. You can create dashboards with information from one or more of your organization’s application databases. Each database is referred to as a data source within Xtraction. A basic representation of this infrastructure is illustrated below:
Pic.8. Xtraction - overview
The data sources accessed by Xtraction are defined in a DataModel.dat file, which is constructed and maintained with the Data Model Editor tool provided by Ivanti Software.
Data Model Configuration
Before running Xtraction, configure the data model selected earlier for your environment by using the Xtraction Data Model Editor application that was installed with Xtraction. There are a number of settings you need to change to get the data model up and running.
In a default installation, the Datamodel.dat file is located at C:\Program Files\Xtraction Software\Xtraction\Data\Configuration\.
Pic.9. Open Xtraction Data Model from Start Menu
For each data source in your data model, you need to provide a connection string so that Xtraction can connect to that data source. Open the connection string editor by clicking Tools > Connection String Editor.
This dialog displays all of the data sources within your data model. To edit a connection string, click the appropriate connection item and then click the ellipsis button.
If your data model contains data sources that connect to the same physical database, after setting up the first connection string, you can copy them by selecting the appropriate items, right-clicking the connection to copy, and selecting Copy to selected from the context menu.
Pic.10. Data Model Editor - Connection String Editor
Pic.11. Data Model Editor - Connection Details
Configuring Xtraction to use AD Account to connect to Xtraction and Source Databases
When you would like to use the AD user account to connect to Xtraction and Source Databases (e.g. Ivanti Service Desk), you can map this user account to connect to Xtraction database with db_owner, db_datareader, and db_datawriter permissions and at the same time use the same user account and map it to source database with read only permissions (db_datareader). The next step would require changing the Identity setting in IIS -> Application Pools -> Xtraction Application Pool and setting AD User Account (Identity Setting) used to connect to Xtraction and Source Database as mentioned in previous sentence. Once this has been set, please do IISReset. Once done, please open Xtraction Settings application, add the Server name, Database name and tick Integrated Security (if connection has been configured previously with SQL User Account, remove User ID and Password and tick Integrated Security), Test the connection and if connection succeeds, press OK and Update Database and when done press OK. Then open Xtraction Data Model Editor -> Connection String Editor -> Connection Details and add the Server name, Database name and tick Integrated Security (if connection has been configured previously with SQL User Account, remove User ID and Password and tick Integrated Security), Test the connection and if connection succeeds, press OK twice and save the Data Model. Then, open Xtraction Web Client, reload the Data Model in Administration component and refresh the page.
Verifying configuration with Xtraction Settings Check application
To check if everything has been configured properly on the Server, please fire Xtraction Settings Check, please open C:\Program Files (x86)\Xtraction Software\Xtraction\Tools and double-click XtractionSettingsCheck.exe or in the Server, Start and type Xtraction Settings Check.
Pic.12. Open Xtraction Settings Check
Pic.13. Xtraction Settings Check - Xtraction Application - IIS - LDMS connection string in data model was not configured
Pic.14. Xtraction Settings Check - XtractionWinAuth Application - IIS - LDMS connection string in data model was not configured
If you are a Cloud Customer, Xtraction server should be setup up as on premise, Xtraction database should be hosted on local SQL Server on your side. To access Source Database (e.g. Ivanti Service Desk or Ivanti Service Manager), please log a support case adding which database you would like to access (Production, Development or Test) and Cloud Team will create User Account to access the database in Cloud with read only (db_datareader) permissions. You will then need to configure the connection on Xtraction server in Xtraction Data Model -> Connection String Editor -> Connection Details (as on Pic. 10) to source database with the SQL Server name (or IP Address or/and Port), database name, user account and password, provided by Cloud Team.