SAC: Automatic flat file import

[jrebsamen_sto]

Hello Experts,

is there one or several options to automatically upload data from a flat file into an existing data model in SAP Analytics Cloud?
I created a data model (new model type) and imported some data into it via the data management tap in the modeler. When the new data arrives next month, i would like to update the existing data.
Do i have to manually create a new import job, doing the same data preparations and mappings again, even if the flat file structure stays the same?
Which options are there to automize the import and solve this use case more efficient?

Highly appreciating your answer, best Regards!

Jana

[William_Yu1 · Accepted solution]

jrebsamen_sto

Like Nikhil mentioned, put the file into file server and schedule an import job from file server would be the best solution. But just let you know, starting from 2023 QRC3 you should be able to import from a new flat file using an exiting job without redo the mapping and wrangling if the structure is identical.

https://blogs.sap.com/2023/07/11/whats-new-in-sap-analytics-cloud-release-2023.14/?source=email-glob...