Deleting data from a defined table in a MicrosoftAX server - 7.1

Microsoft Dynamics AX

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Business applications > Microsoft Dynamics AX components
Data Quality and Preparation > Third-party systems > Business applications > Microsoft Dynamics AX components
Design and Development > Third-party systems > Business applications > Microsoft Dynamics AX components
EnrichPlatform
Talend Studio
Warning:

Before being able to use this component, make sure that you install and launch the MicrosoftAX server correctly.

For more technologies supported by Talend, see Talend components.

This Java scenario describes a two-component Job that uses tMSAXOutput to delete from a defined table in a MicrosoftAX server all rows that do not match the data included in a key column.

In this example, the input schema we use is an address column that holds the following data: New York-Midtown Manhattan. We want to delete from the MicrosoftAX server all addresses that are not identical with this one.