LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: khopkins

Hello,

Could anyone tell me what the actual raw file format of a BRD file is.
We have a department who are trying to import a brd file into a netezza database.

Looking at a BRD in a text editor whilst the string fields are ok anything else EG blong seem to be either encrypted or converted to another format which is causing problems.

They would like to know so that they can transform the data correctly as changing the export of these files to CSV is not an option at present.

Regards,

Keith

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

The .brd file format is internal and should not be coded against; it should only be used in the context of the input and output BRD nodes.

If you need to process the data externally, you should use one of our other output nodes, such as CSV, XML, etc. If those formats don't meet your needs, please let us know, so we can understand your business problem, and either suggest an alternative or make note for future product enhancements.

Cheers
Rich

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

You can also write directly to Neteeza from LAE instead of doing an import. You can do so by setting up a JDBC driver on the server and using the JDBC Store node to write do the database.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: khopkins

Hi Rich,

Apologies i should of explained further as we are currently exporting a large number of data extracts into BRD format from Dise so that the LAE users do not directly query a live system which was an approach recommended by MDS/Lavastorm themselves.

Now we have a request to import this data into a netezza database so recreating all of the extracts to export into CSV and therefore change all of the users graphs to use the CSV files instead of the BRD files is not really an option we want to go down.

I will however discuss with the netezza guys how to dump the data directly via the jdbc store node but i will have to raise a ticket with the service desk as our LAE server will need the firewall opened to the netezza server
Also this may not be possible as it is outside of our internal network at present.

Regards,

Keith

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

Keith, I understand. Unfortunately, the BRD format is not a standard format, so to read them would require writing specific code (likely much more work than changing those graphs), and that would of course be fragile and likely to break if (when) we change our format.

Another thought, could you just write a simple graph that takes a brd input file and writes a CSV output file, and convert them all that way?

Cheers
Rich

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: khopkins

HI Rich,

Yes I think that's what I am going to have to do.

Regards

Keith