Oracle Transactional Business Intelligence

Products Banner

Generate .DAT output file from an OTBI Report

128
Views
11
Comments

Summary

Generate .DAT output file from an OTBI Report

Content

Hello All,

We have got a requirement to generate .DAT as a output file format for an OTBI Report.

Can you please let me know whether it is achieveable or not using OTBI?

Any help on this is much appreciated.

Regards

Suveer

Comments

  • Hi Suveer,

    Are you using SFTP to deliver the file? You can specify filename in the output when using SFTP.

    Regards.

  • AshishERPCloud
    AshishERPCloud ✭✭✭✭

    Hi Suveer,

    Which one of the below is your requirement:

    a) Are you only looking for a file extension (.DAT)

    b) Are you looking for a specific pipe delimited format file

    c) Both a) and b)

    d) Anything else.

    I am asking these questions as while there isn't a direct way of generating .Dat extension file in HCM Cloud Application (Till Release 11 , not sure whether .dat file extension is supported in Rel12) but you may still generate a .csv file with pipe as delimiter.

    Let-me know if that interests you.

     

    Kind Regards

    Ashish

     

  • Hello Ashish,

    We are looking for Option C. Do you suggest creating a .csv file with pipe delimiter and then save the file as.DAT?

    Regards

    Suveer

  • Hello Wade,

    I think we cant output the file to SFTP using OTBI. This feature is available from Rel 12/13 I guess.

    Regards

    Suveer

  • AshishERPCloud
    AshishERPCloud ✭✭✭✭

    Yes. That's the easiest option available.

    When you schedule the program the default extension is .txt ( so do check if that works at the consumer end).

    And even if the consuming application is only comfortable with .dat extension then do the following:

    a) Get the .txt file from Cloud HCM as is

    b) Migrate via some mechanism ( I hope some automated way) and transfer to Unix Box of downstream/ consuming application

    c) Rename using Unix commands in the target environment.

    This way you may still avoid manual intervention.

    Kind Regards

    Ashish

  • Thanks for your response Ashish much appreciated.

    Regards

    Suveer

  • Using the Report functionality with Subject Area, you should be able to SFTP a .DAT file. I'm not sure I'd recommend that because there are better, more efficient ways to do this. We use the data model or extract/report combination for integrations with requirements similar to this where we also need full automation.

    Reading the other responses and not knowing what resources are available to you, it seems like you have some options at least (even if it requires some manual effort).

  • Hi Ashish

    In case I want to automate a HDL load with BI Publisher as a source (instead of HCM Extract) then how do we do it? I don't want to take the files out of HCM. Just want to get everything done with HCM SaaS itself.

    Regards

    Santhosh

  • Yes you should be able to do so.You would need to create a Dummy Extract which would load your file to HCM Cloud and a BI data source which will generate the file to be loaded.

    I was able to generate ".dat" file from BI publisher data source and inbound interface delivery option of dummy extract. Am working on a complete step by step article and would share the link soon.

    Kind Regards
    Ashish

  • Much appreciated Ashish. Looking forward to your article.

    I did try that option today and it seems to work. Personally it just feels like a work around solution and not a proper solution. Was just wondering how do I stream line this as an overall solution.

    Would you be passing parameters also from your HCM extract to the BI Publisher report in your article? Would love to see that.

  • Hi Santosh,

    Glad to know it worked.

    As of now I have not passed parameters and not sure I can bind the parameter piece with the extract.

    Currently both BI and HCM Extract work independently nd we just give the reference of BI Report in Extract Delivery Options.

    Will have to see if we can pass parameters. As of now NO.

    Kind Regards

    Ashish