Skip to main content
Question

IFS Cloud 24R1 - Data Migration Manager - Database Link

  • July 9, 2024
  • 2 replies
  • 188 views

Forum|alt.badge.img+9
  • Sidekick (Partner)
  • 95 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)
  • 231 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)
  • 95 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.