Generate .DAT output file from an OTBI Report

Suveer Tn

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

Wade Wilson

Hi Suveer,

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

Regards.

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

 

Suveer Tn

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

Suveer Tn

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

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

Suveer Tn

Thanks for your response Ashish much appreciated.

Regards

Suveer

Wade Wilson

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).

Santhosh Murthy-135762

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

AshishERPCloud

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

Santhosh Murthy-92456

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.