How can I retrieve data via SQL query in MT IP Designer from Data Lake? Is there a way around no lon

How can I retrieve data via SQL query in MT IP Designer from Data Lake?

Is there a way around no longer having SQL node in IPA?

We are just beginning the process of migrating from ST to MT and most of our IPA flows built on SQL, so looking for creative ideas of any way to get data with SQL query automated with IPA...

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

All comments

russel-cornelson

The IPA Web Run node can be used to submit a SQL Query through compass api and retrieve the results. My colleague covered an example of this in our June 2021 interactive briefing on process flow design. I believe we put a sample copy of that flow in a KB somewhere for people to look at.

Time permitting I will see if I can find that kb for you; but it may have to wait till tomorrow when he is back in the office.

shawn-haning

Thanks Russ! That KB would be greatly appreciated. -Shawn

andy

I think it's KB-2138461

0712131256598360.doc

russel-cornelson

Thanks Andy, that is indeed the correct KB.

shawn-haning

Thanks Andy!

unknown

Also take a look at KB 2196032 - Interactive Briefing: Infor Process Automation: Designing for Performance Update June 2021. This includes our entire 2021 interactive briefing along with plenty of other information that specifically focuses on querying data from the Data Lake.

Copyright © 2025 Infor. All rights reserved.