Skip to main content
Question

IFS Cloud 24R1 - Data Migration Manager - Database Link


Forum|alt.badge.img+9
  • Sidekick (Partner)
  • 85 replies

Hi All,

I created a Database Link in DEV (Build Place) to link to CFG environment using an end user in CFG.
I can see a valid Database Link in DEV.
However I cannot see created DB link in the application (DEV environment).
Location 
Solution Manager > Data Management > Data Migration Manager > Project Basic Data Setup/Connected environments tab/Database Link name.
Any idea as to why I cannot see the DB link from the application

 


 

2 replies

InfFilipV
Hero (Partner)
Forum|alt.badge.img+12
  • Hero (Partner)
  • 203 replies
  • October 24, 2024

Hi,
used LOV is based on this view: 

CREATE OR REPLACE VIEW DATABASE_LINKS_LOV AS
SELECT a.db_link    database_link_name
FROM   dba_db_links a
WHERE  a.username = 'IFSMIG'
WITH   READ ONLY;

So you have to create that DB link under user IFSMIG.
When is app IFS hosted, then it should be done by IFS.

BR
Filip


Forum|alt.badge.img+9
  • Author
  • Sidekick (Partner)
  • 85 replies
  • October 24, 2024

Hi @InfFilipV ,

You are correct. IFS should do it. However, IFS insist they can only create a DB link from a Prod to a non Prod environment.
but my requirement is to push data from a non Prod to a non Prod for testing.
Without this , Data Migration Manager is useless.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings