You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • data load optimization from Ms SQL Server to Free form

    edited Apr 15, 2024 7:47PM in EPM Platform and Freeform 3 comments

    Summary:

    Free form appllication has interfaced data from MS SQL server via EPM Agent method(Simple Mode).

    MS SQL has around 25 million records and during data load it takes around 2 hours.

    Total Break Down of Data load

    1) Data extract from MS SQL to Physical Server - 20 min

    2) Import File to Data management - 50+ Min

    3) Transform - 17+ Minutes

    4) DM Export - 15 Minute

    Would like to understand how to reduce this time by changing Agent/Physical Server setting or EPM Agent Target/Mode or Data Management options etc.

    Content (required):

    Need suggestion on Data load optimization

    Version (include the version you are using, if applicable):

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!