Mappings
DataMart mappings provide a connection between the incoming data and the SQL Server Database your organization has created to store your Lucernex data.
Data model
Create a mapping
Create mappings for each type of record you want to pull and run them when needed, or create one mapping for all record types.
Do not modify a single mapping to change the types of records it includes. If you do, the next delta run does not pick up changes to records that occurred in the time frame when those record types weren’t included in the mapping.
Example scenario:
-
First run: On Monday, the mapping has Projects and Sites selected,
-
Second run: Wednesday, the mapping has only Sites selected,
-
Third run: On Friday, the mapping has Projects and Sites selected again.
In this scenario, the third run will pick the time stamp from the run on Wednesday. This means if there are any changes for Projects between Monday and Wednesday, they will not be reflected in the database. Only changes between Wednesday and Friday are reflected on Projects table.
A mapping specifies the source and target of the DataMart information flow.
-
Click Create Mapping in the toolbar below the Mapping Schedules section.
Step 1 of the New Mapping wizard opens.
-
Complete these fields:
-
URL: DataMart enabled Lucernex URL you want to download data from. This URL must be SSL, for example: https://dm-lxretail.lucernex.com. The URL must contain https, not http.
-
Firm: Enter up to 20 characters for your firm name.
-
Username: Enter up to 20 characters for the Username on this environment.
-
Password: Password for your username.
-
-
Click Continue.
Step 2 of the New Mapping wizard opens.
-
Complete these fields:
-
Host: Server name for the database.
-
Port: Port where your SQL server lives.
-
Name: Enter up to 20 characters for your database target name.
Your Database Target name should be all one word, or separated by underscores or hyphens.
-
Instance: Enter up to 20 characters for your database instance.
-
Username: Enter up to 20 characters for your database username.
-
Password: Your database password.
If your firm has password security settings that require passwords to expire periodically, you will need to change your password in the mapping to accommodate the change.
-
-
Click Continue.
Step 3 of the New Mapping wizard opens.
-
Click the schedule you want.
-
Hourly: Enter the number of hours between each run in Every X Hours.
-
Daily: Enter:
-
Every X Days: Number of days between each run.
-
At: Time you want the run to occur.
-
-
Weekly: Enter:
-
Days of the Week: Days of the week the run is to occur.
-
At: Time the run is to occur.
-
-
Times / Day: Enter the times during each day that you want to schedule the run for in the 24 hour clock format HH:mm. After each time, hit Enter. Available in DataMart Version 7.0.176 and later.
-
-
Click Continue.
Step 4 of the New Mapping wizard opens.
-
Complete these fields:
-
Name: Enter up to 20 characters for the mapping name.
-
Record Types: Select the record types you want this mapping to pull from.
By default, the mapping pulls all record types.
-
PGP Encrypt: Use PGP encryption for this mapping. PGP encryption is applied to the stream of bytes sent from IWMS to DataMart. DataMart writes decrypted XML as it reads the encrypted stream from the IWMS RESTful endpoint.
-
Global Fields First: Retrieve global fields before retrieving user defined fields.
This causes the global fields to be added to the first partitioned table. User defined fields always start on the second partitioned table.
-
Only Global Fields: Only retrieve global fields for the mapping.
If you modify the Global Fields First or Only Global Fields settings on an existing mapping, the Trigger Full Run warning displays. If you click Save in the warning message. The next run is a full run, and DataMart re-partitions your tables.
-
Auto Schema: Enable incremental updates. These updates include schema changes so that your DataMart instance includes both user defined fields and new global fields without having to do a full brush rebuild of the target database from scratch.
DataMart checks the number of fields which exist on a database table. If the maximum number has been exceeded, new fields are added to a subsequent table.
-
-
Click Finish.
The mapping is created.