How to extract non-MVX table , dynamic table from M3 to Data Lake

Hello,

I want to know non-MVX table like ZJPVAT in following Image

Both tables is in "BUsiness Engine Data Management", but the are not displayed Data Lake Publisher.

If possible, I want to extract those tables from M3 to Data Lake.
Please advice me.

Best regards.

Find more posts tagged with

Infor Data Fabric

Accepted answers

All comments

Legacy Contributor

You can raise the request with Infor

Legacy Contributor

Hello,
I will leave it to those more knowledgeable to confirm. but if the ZJPVAT is an XtendM3 table, an update to Cloudsuite late last year provided this functionality to be able to publish those to the Data Lake (and also to initially load via the EVS002MI api).
The dynamic tables are not available to be published to the DataLake, however the data they contain is based on other tables in the system. So it should be possible to extract the same information via those tables, but may need some manipulation to get it into the same format, either by creating views in the DataLake, or by extracting it from the DataLake, and translating it downstream.

Legacy Contributor

ZJPVAT is not XtendM3 table, all XTendM3 table starts with EXT*. This table is part of MJP component. For tables not listing in Data Lake publisher request has to be raised with Infor.

Legacy Contributor

I'm Naoto , Japanese consultant.
Thank you for your advice Kumar-san and Devin-san.

Kumur-san, I understand I should raise request in this case.
Is this correct ?
If so, can I request to be able to select MJP component table in Data Lake Publisher from Infor concierge?

Copyright © 2025 Infor. All rights reserved.