Data Lake via ION to Enterprise Connector Database endpoint

Greetings;

As part of my program to understand all things data, I was trying to setup a Document Flow or Data Lake Flow to take incoming M3 updates records, like the MITMAS document, and forward the content (JSON/XML) to a local database for parsing. This works fine for normal BODs.

When I use the Data Lake Retrieve function, I can build the Flow, and add the test document, MITMAS

But in the Database Connection point, the Document Type is locked to BOD and can't be changed to JSON. This prevents me from adding MITMAS to the connection to be consumed.

I tried connecting directly to the M3 IMS connection in a document flow just as an alternative, but it has the same issue with the Document Type being locked to BOD.

Is there another way I'm missing ?

Example of Sync.ItemMaster BOD data after hitting the database.

Thanks;

Billy

Find more posts tagged with

Infor Data Fabric

Accepted answers

All comments

unknown

Greetings;

Since there is a lack of feedback, is there a better forum I should post this question, or get it moved to? Maybe a Forum Admin could move to the ION Connect forum?

Thanks;

Billy

unknown

I think this is the correct forum for your questions.

1. The Stored Procedure based Any SQL connector (formerly Database connection point) still only supports BOD. This explains why you are unable to send it there.

2. The documents that can be received by the (Infor Provisioned) M3 IMS connection point is governed by the Discovery API of IMS endpoint. So effectively M3 should tell ION what documents it can receive. Since it is unlikely that standard M3 is configured to receive the ND-JSONs, it is also correct that you are unable to send it there.

Your best bet is as follows:

1. Write the ND JSONs to a local file folder (Either via Enterprise connector or via the direct sFTP connection point). You should be able to make a doc flow for this.

2. Or if you want to send it to a ANY SQL connection point as a BOD, then you can include a scripting step - where you can write Python code to convert an ND JSON into a BOD XML of your choice.

Best Regards

Vignesh

Copyright © 2025 Infor. All rights reserved.