Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

We are trying to add map layer based on IP address, but not working

26
Views
3
Comments
SBan
SBan Rank 1 - Community Starter
edited Sep 8, 2025 5:27AM in Oracle Analytics Cloud and Server

We are having login data of the users around the world, having the fields like username, login-time, IP address etc. Based on IP Address we are trying to add location details. On Map layer option we selected like Auto, World regions/cities; but it comes back with error or no match. This means System map layers does not support IP based locations. Anyone can help with Configuring custom map layer based on IP address.

Tagged:

Comments

  • Philippe Lions-Oracle
    Philippe Lions-Oracle Mod

    Hello @SBan welcome to the community and thanks for your interest with Maps capability. IP addresses are not part of OAC Vanilla default map layers, but extending with a custom layer should be reasonably easy to configure. Can you elaborate on exactly what you are trying to do : do you want to locate on a single map viz where all your users are login from, based on IP address ? Let us know

    thanks

  • SBan
    SBan Rank 1 - Community Starter

    Thanks @Philippe Lions-Oracle for your response.

    Our goal is to locate user logins in World Map and later identify logins from unusual locations.

    So, answering your query, …do you want to locate on a single map viz where all your users are login from, based on IP address…? Yes, that's what we are trying to achieve.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    As far as I know, you need to use some 3rd party services to get a location for an IP address.

    And even when doing so, it is not 100% accurate, I would even say it is only 25% accurate. If I look at my own IP address, it gets the country correct, but everything else is very wrong (never once the area or city was correct).

    That's because I believe the information of where a public IP is handed out to a device is an information internet providers willingly provide (or not) to some database somewhere. But there isn't a real strong requirement to be accurate. Even more when IP are dynamic and change every few days: the whole block of IP addresses the provider has is used, not really updating the real location all the time.

    Probably the country is accurate because that comes from who is the internet service provider having received the permission to use that IP range, and this doesn't change often.

    And of course there are mobile devices: I have been abroad most of last week, but when checking my own IP on my phone as visible to websites etc., it has always been a local IP of my home country, totally missing the fact I was abroad.