I needed to convert ISO 3166 3-letter Country Codes in our Oracle DB to the more common 2-letter Country Codes used by Splunk.

How it works

It's a lookup table to convert between the Country Code formats

Challenges I ran into

Getting the complete list of country codes, and how to do this in Splunk instead of Oracle!

Accomplishments that I'm proud of

The end user has no idea there was ever an issue, the conversion happens as the data is pulled from the DB by Splunk's Database Connect. It's also my first app!

What I learned

I learned just how easy making a Splunk App is, and how to package and upload it to Splunkbase to solve the problem for everyone!

What's next for ISO 3166

I'm looking at other ISO standards that have multiple equivalent data types to solve this for other areas.

Built With

Share this project: