Step 4-Define Transaction Datasource (How To-Load Transactions)
- Mike Deskis
Create the Transaction Data Source
Before we can load our data using IntegrationManager, we need to create and define the attributes for our Transaction Data Source.
From the toolbar menu, click PriceAnalyzer | Data Sources
2. The listing of current Data Sources will be displayed:
NOTE: This picture denotes the “out-of-the-box” version of Data Sources and notice that there is no Transaction Data Source. It must be created and column attributes defined by us.
3. To create a new Data Source, click on the Add Source button:
4. Fill out the following form as shown below:
5. Click Add button. New Transaction Data Source will appear:
Define Transaction Data Source Attributes
After creating our new Data Source, we will need to define the custom attribute columns that mirror the content that is being extracted from the customer’s application and uploaded via PlatformManager.
6. Click on the new Transaction Data Source and the default definition will appear:
NOTE: Unlike other table structures we may have encountered, when we build Data Sources there are no pre-built attributes that are defined. Additionally, we will only define those that are required for our DataMart, thus not all input CSV columns will be defined.
7. Rather than defining each column individually, we have the ability to import a JSON definition of our Data Source attributes. Thus, click on the Import & Export button:
This will display the following:
8. We are going to replace the entire contents of the JSON definition. So, we can delete the entire JSON contents on this panel:
9. Next, open the Transaction JSON file and copy and paste its entire contents into the JSON definition panel:
10. Click Apply button. The Transaction Data Source should now appear as:
NOTE: After the import of the JSON definition we should see all of the attribute columns defined and the primary key is defined as UniqueId column.
11. Next, we need to click on the Deploy button:
12. This should display the before and after version of our Data Source:
13. Click on the Deploy button (lower right corner).
14. Click on OK button.