Before being able to use this component, make sure that you install and launch the MicrosoftAX server correctly.
This Java scenario describes a two-component Job that uses tMSAXOutput to insert four columns in a defined table in a MicrosoftAX server after it alters values in one of the inserted columns.
Drop tFixedFlowInput and tMSAXOutput from the Palette to the design workspace.
Connect the two components together using a Row > Main connection.
Double-click tFixedFlowInput to display its Basic settings view and define the component properties.
Set Schema type to Built-in and click the three-dot button next to Edit schema to display a dialog box where you can define the input schema.
Click the plus button and add the input schema columns, three in this example: name, city and street.
Click OK to close the dialog box and accept propagating the changes when prompted by the system.
The three schema columns display automatically in the Values list.
Click in the Value column and enter a value for each of the input columns.
Double-click tMSAXOutput to open its Basic settings view and define the component properties.
Set Property type to Built-in.
In the Host field, type in the IP address of the MicrosoftAX server and type in the domain name on which the MicrosoftAX server is hosted in the Domain field.
Enter your username and password for the server in the corresponding fields and enter the name of the table you want to write data in the Table Name field, ADDRESS in this example.
In the Action on data list, select the action you want to carry on, Insert in this example.
Click Sync columns to retrieve the schema from the preceding component.
In this example, we want to retrieve the three input columns: name, city and street and write the data included in the three input columns in the MicrosoftAX server without any changes.
If needed, click the three-dot button next to Edit Schema to verify the retrieved schema.
In the Additional columns list, click the plus button to add one line where you can define parameters for the new column to add to the row you want to write in the ADDRESS table.
Set a name, a data type, a position and a reference column in the corresponding columns for the line you added.
In this example, we want to add a new column we call "address" after the street column.
Click in the Local expression column and press Ctrl + space on your keyboard to open the context variable list and select:
StringHandling.UPCASE(row2.city)+"-"+row2.street. This expression will write the city name initially capped followed by the street name to form the address of Bryant park. Thus the address column in this example will contain the string: New York-Midtown Manhattan.