Skip to main content
Solved

Import Information Source IFS Apps 10


Forum|alt.badge.img+6

Hi,

There is an option already to export information source as .ins file. But I couldn’t find any option to import that file into same or another environment. 

I’m very grateful if anyone have idea for that.

 

Thank you.

 

 

Best answer by SandT

Hi @TopDeepaW ,

 

Please try following steps and the check the information source window.

  1. Open PL/SQL Developer
  2. File → Open → SQL Script
  3. Select the Exported “MetaData_GenledBIFactGlBalance.ins” file. (if it is invisible please choose file type as All Files”)
  4. Execute
  5. Commit
View original
Did this topic help you find an answer to your question?

8 replies

SandT
Hero (Partner)
Forum|alt.badge.img+6
  • Hero (Partner)
  • 30 replies
  • October 17, 2023

Hi @TopDeepaW,

 

If you have all the connected dimension in the target environment, by deploying that exported “.ins” file in underline database you will be able to restore the same in the target environment.

 


Forum|alt.badge.img+6
  • Author
  • Sidekick (Partner)
  • 14 replies
  • October 17, 2023

Hi @SandT ,

 

Thank you for the answer. Kindly let me know the steps for the import/restore process?

 

Best Regards,

Deepal


SandT
Hero (Partner)
Forum|alt.badge.img+6
  • Hero (Partner)
  • 30 replies
  • October 17, 2023

Hi @TopDeepaW ,

 

My suggestion is to get support from a developer who has access to the database and deploy the file in the database.

 

Is it a standard information source? if so what is the reason that you want to import it on another environment?

Please note that all the custom attributes and custom dimension connections can be exported and imported from IEE itself instead of move entire information source.

 


Forum|alt.badge.img+6
  • Author
  • Sidekick (Partner)
  • 14 replies
  • October 17, 2023

HI @SandT ,

 

I’m not developer but I can access database as well as PL/SQL developer. So, if you know the process, I can try it.

The source is slandered one called GL Balance. The reason to restore is I had to deleted it by mistake.

 

Thank You.


SandT
Hero (Partner)
Forum|alt.badge.img+6
  • Hero (Partner)
  • 30 replies
  • Answer
  • October 17, 2023

Hi @TopDeepaW ,

 

Please try following steps and the check the information source window.

  1. Open PL/SQL Developer
  2. File → Open → SQL Script
  3. Select the Exported “MetaData_GenledBIFactGlBalance.ins” file. (if it is invisible please choose file type as All Files”)
  4. Execute
  5. Commit

Forum|alt.badge.img+6
  • Author
  • Sidekick (Partner)
  • 14 replies
  • October 17, 2023

Hi @SandT,

 

I followed your instructions and now can see GL Balance source in Information source window. But it is not appearing while selecting the source in IFS Business Reporter. Do you have any idea for this?

 


SandT
Hero (Partner)
Forum|alt.badge.img+6
  • Hero (Partner)
  • 30 replies
  • October 18, 2023

Hi @TopDeepaW,

 

Sorry, just saw your comment. Were you able to fix the issue? or is it still available?


Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1169 replies
  • November 23, 2023
SandT wrote:

Hi @TopDeepaW ,

 

Please try following steps and the check the information source window.

  1. Open PL/SQL Developer
  2. File → Open → SQL Script
  3. Select the Exported “MetaData_GenledBIFactGlBalance.ins” file. (if it is invisible please choose file type as All Files”)
  4. Execute
  5. Commit

Hi @SandT 

do I need the IFSAPP user for importing of information sources via PL/SQL Developer?

Thank you.


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