AppEngine Process to Update EPM Integration tables by Information in Staging Data Base (Multi-Tenant

Hi,

I'm working in MT, and tied import information in relational data Base EPM Integration, in table dEPM_BudgetingMain from a table in Staging Data base.

But in MT, we cannot create a connection to relational data Base EPM Integration, the only connection that use in this case in AppEngine is Staging.

I tried use the function ModelingExecuteTableDataLoadQueryto execute and query create in table dEPM_BudgetingMain, inside the script of AppEngine but i think that this function only work to Staging data base tables.

Do you know some alternative?

Regards

Rui

Find more posts tagged with

Infor EPM Discussions

Comments

Robert Thomas

Use the AppEngine functions releated to the Integration tables:
ModelingExecuteBusinessObjectDataLoadQuery
ModelingExecuteFactDataDataLoadQuery

rdias

Hi Bod,

Thanks for your replay.

Tried de function ModelingExecuteFactDataDataLoadQuery to import data in dEPM_BudgetingMain and works.

Do you no if ModelingExecuteIntegrationTableLoadQuery function works like ModelingExecuteFactDataDataLoadQuery, buts use queries with parameters? Tried the follow statment but both give me a error

ModelingExecuteIntegrationTableLoadQuery("dEPM_BudgetingMain", "DEPMAPPS", "teste", true, {vBPDORGAN: "Administracion"});
ModelingExecuteIntegrationTableLoadQuery(IntegrationDataImportTypeFinancialData, "DEPMAPPS", "teste", true, {vBPDORGAN: "Administracion"});

Regards

Rui

Copyright © 2025 Infor. All rights reserved.