BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

MD5 hash in BODS

Search this topic... | Search Data Integrator... | Search Box
Register or Login to Post    Forum Index -> Data Integrator  Previous TopicPrint TopicNext Topic
Author Message
Senior Member
Senior Member

Joined: 12 Apr 2006

Posts: 39
Location: the Netherlands

PostPosted: Fri Jan 04, 2019 1:53 am 
Post subject: MD5 hash in BODS

Can anybody tell me how I can calculate a MD5 hash over a table in BODS?
And I want to make a custom function of it.

Thank you very much for helping me!
Back to top
Forum Member
Forum Member

Joined: 10 Jan 2019

Posts: 1

PostPosted: Thu Jan 10, 2019 6:09 am 
Post subject: Re: MD5 hash in BODS

Hi peilert!
As far as I konow BODS does not have built-in function to calculate MD5 of the table. One of the solutions I've used in the past is to create stored proc in Database (HANA in my case) and execute this proc from BODS via sql() function.

In general - create cursor and loop over all rows in the table with HASH_MD5() function while concatenating your processed row with previous row hash. Though usage of cursors in HANA is not recommend by experts, it working quite fast and stable for me (HANA 1.0 SP12, my tables are relatively small - up to 10 millions rows / 20 column max.).
If you want to calculate hash of the data during load you can use User_Defined transform with md5 python module.

Back to top
Senior Member
Senior Member

Joined: 28 Feb 2014

Posts: 30

PostPosted: Fri Jun 28, 2019 4:51 am 
Post subject: Re: MD5 hash in BODS

Use the built in python editor in BODS to create an MD5 Hashing.

You can read more about BODS and Python support her:

Python md5 hashing code example:

import hashlib
hash_object = hashlib.md5(b'Hello World')
hex_dig = hash_object.hexdigest().upper()

You can test the Python below:

Maybe anyone can help me with my question below regarding Data Vault and BODS + other ways of doing hashing in BODS other then Python.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0287 seconds using 17 queries. (SQL 0.0023 Parse 0.0009 Other 0.0255)
CCBot/2.0 (
Hosted by | Terms of Service
phpBB Customizations by the
Shameless plug for Moments of Light Logo