Description
In this scenario, we will illustrate the customization of the generated code from the IM template to accomplish some additional functionality not supported by the templates. In our new scenario, we have two distinct customizations:
First, we have a CSV file coming from the customer and we use it to import data for a single company parameter table. However, the requirement is that this same file could be used for other integrations, for example customer extension table.
Second, do not delete the input CSV file
Third, keep an archive and provide a date and timestamp for each archive.
The following are the list of steps for this scenario:
Prerequisites
In order to be able to complete this exercise, we will need the following prerequisites before proceeding.
PlatformManager access
An existing IM instance
Access privileges for:
Partition creation
Git repository
Pricefx Maven repository
Partition Connection
SFTP Connection
One functioning Route
WinSCP FTP Client or equivalent
Cloned IntelliJ project
Step 1: Connect to IM Instance
Prior to local development, we will need to follow the path from the IM instance within PlatformManager to the Git repository that contains the contents of our integration project. Our goal will be the to open the Git repository linked to our IM instance.
Go to platform.pricefx.com and choose the Login with O365 option:
2. Click on the Integrations option (left-hand side):
3. From the list of integration instances, create a filter to locate your IM instance:
4. Locate your IM instance and click on it, this will open the IM instance page:
On the left-hand navigation, we will see all options related to this instance:
NOTE: We have selected our single IM instance and all of this options (Routes, Mappers, Connections, etc) are reflective of this single instance.
6. Next, we will open the Git repository linked to this IM instance:
NOTE: The creation of IM instance will automatically build a corresponding Git repository that will then contain all of the generated elements that are linked to this instance.
7. Click on the Git repository link to open the Git project:
Examine what is provided, click on the src/main folder.
Step 2: Clone to Local
Our objective in this step is to customize the generated XML and Json code associated with our IM instance and the first step in that process is to clone this project to our local machine.
Click on the Clone option:
2. Next, click on the Copy URL option to copy the URL path.
3. Then, we will open IntelliJ and use the File | New | Project from Version Control to connect to our remote Git repository:
4. Next, this will display the Get from Version Control panel and we will paste the URL path:
Click on the Clone button.
5. The project has now been cloned to our local machine and this local instance is connected to our remote repository in gitlab.pricefx.eu.
6. Next, we need to switch to the dev branch within Git and in that branch we will perform all of our updates and modifications to the code. In the lower right-hand corner we can select the remote dev branch:
Then we will choose the Checkout option.
7. Next, lets verify that we have successfully cloned the dev branch from the remote repository to our local machines. So, within Intellij lets open folder path of src/resources/repo and it will appear as:
8/. Next, open the Connections folder to view our connection files:
9. As an example, we can open one of the connection Json files. It will appear as:
10. Next, open the Routes folder to view our route files:
11. It does appear that we have successfully cloned our IM instance Git project to our local machine. We can verify this by comparing the Git folders in src/main/resources/repo to those in Git:
Step 3: Password Updates
Before we can run our integration processes locally, we will need to update the encrypted passwords with actual clear text passwords.
1. First, we will need to locate the connections being used by our integration instance. Open the folder path src/main/resources/repo/connections:
2. There are two different types of connection files that will need to be updated. One for the SFTP connection and the other for the partition.
3. When we open our connection JSON file we should find an encrypted password:
4. We will need to update the connection passwords with the clear text versions that were provided (via email) when the integration instance was created.
Step 4: Start Local Application
After the updates to our connections, we can start the local process via IntelliJ that will allow us to execute our routes through our local machine.
First, open the folder main/java/pricefx and locate the LocalAppRunner application:
2. Open the LocalAppRunner file:
NOTE: This is a Spring Boot application runnning within a Tomcat instance that is then running on our local machines and connecting to our partition and SFTP instance and folders.
3. Prior to launching our local instance, we will need to ensure that any Routes connected to this IM instance have been stopped. Go to Routes for our IM instance:
We should verify that the Status for our routes has been changed to Stopped:
4. Next, we will launch the LocalAppRunner application. Right click on LocalAppRunner and choose the Run option:
5. In the log file, we are looking for the messages related to the successful launch of any routes that are linked to the IM instance:
NOTE: The local instance of the IM instance is now ready for route executions and we will be able to watch the route execution via the log entries.
Step 5: Manage Archive File
One of our requirements was to create an archived copy of the incoming CSV file and then to provide a date/timestamp for that file.
First, we will need to establish an archive folder within SFTP. Therefore, within /filearea folder of our SFTP server we need to create an archive folder.