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

Utility to update souce database

Received Response
1
Views
1
Comments
user12863665
user12863665 Rank 6 - Analytics Lead
edited Aug 13, 2024 6:17PM in Oracle Analytics Cloud and Server

Hi,

WE are moving some tables from one server to other server with same table names.

is there any utility to change column mapping with updated datasorce?

EX: database A

A1

A2

A3

database B

B1

B2

i have tables like above , i need to move A3 from database A to database B.

EX: database A

A1

A2

database B

B1

B2

A3

is there any utility to update column mappings for table A3. Suggest me any other aimple methods?

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    For the BMM you have an utility in the Admin tool for that:

    Capture.PNG

    For the Physical layer I would say you have to import your new table (A3 from database B) or copy/paste it from database A to database B and double check the physical joins (you will have to redefine them) and once done you can use the tool to replace the table in all the business models using it.