Topic
  • 8 replies
  • Latest Post - ‏2018-01-29T09:54:54Z by PratikBG
PratikBG
PratikBG
10 Posts

Pinned topic Import SSRS Metadata into IMAM and depict in IGC

‏2018-01-25T04:50:11Z | infoshere ssrs; v11.5.0.2

Hi All, 

Really need your help for a POC that we are doing.

Tool Stack and Version: IBM IIS v11.5.0.2 and SSRS 2014, Azure VM

During the SSRS metadata import, IMAM could only depict and import BI report section containing the report Page and no other assets, such as the Data Asset and Data Connection, were imported from SSRS. Please note that Data Assets and Data Connection are not empty, as each of them has xml file having metadata of the BI report. Also, this report is generated on Adventure Works DB 2012. It has been ODBC configured on services tier and used for Identity parameter. Please see the below pics for reference

1. Assets_to_Import

 

2. IMAM_Staging_Area

After sharing the SSRS metadata staging area to metadata repository, IGC is unable to depict the BI report fields of the report Page which IMAM has extracted. Please see the below pic for reference. Please see the below pics for reference

1. IGC_Implemented_Assets

 

Also, the log file states that the import is successfully completed. Attached the log file.

Could you please let us know:

  1. Does IIS v11.5.0.2 IMAM supports complete metadata extraction from SSRS 2014 and depict the same in IGC?
  2. If yes, could you please guide us on what are we missing in the above steps?

Your support is highly appreciated :) 

 

Thanks in Adavance,

Pratik

Attachments

  • pierreVRCL
    pierreVRCL
    2 Posts

    Re: Import SSRS Metadata into IMAM and depict in IGC

    ‏2018-01-25T08:48:25Z  

    Hi Pratik,

    You might want to log a ticket with IBM Support at the following address for this one, it may require in-depth analysis and Lab assistance.

    www.ibm.com/mysupport

     

    Regards,

    pierre

  • PratikBG
    PratikBG
    10 Posts

    Re: Import SSRS Metadata into IMAM and depict in IGC

    ‏2018-01-25T09:21:38Z  

    Hi Pratik,

    You might want to log a ticket with IBM Support at the following address for this one, it may require in-depth analysis and Lab assistance.

    www.ibm.com/mysupport

     

    Regards,

    pierre

    Thanks for your reply,

    Will surely contact IBM support for this issue. What is your first hand take on this? What are we missing here?

    Regards.
    Pratik

  • pierreVRCL
    pierreVRCL
    2 Posts

    Re: Import SSRS Metadata into IMAM and depict in IGC

    ‏2018-01-25T09:24:44Z  
    • PratikBG
    • ‏2018-01-25T09:21:38Z

    Thanks for your reply,

    Will surely contact IBM support for this issue. What is your first hand take on this? What are we missing here?

    Regards.
    Pratik

    We just had a quick look to check if this is supported, which seems to be the case. 

  • PratikBG
    PratikBG
    10 Posts

    Re: Import SSRS Metadata into IMAM and depict in IGC

    ‏2018-01-25T09:30:24Z  

    We just had a quick look to check if this is supported, which seems to be the case. 

    Yes, after the FP2 for IBM IIS v11.5, IMAM does supports SSRS 2014. We have had confirmation from IBM and then we were successfully able to connect to the reporting server URL. Now it seems that its extracting limited metadata from SSRS.

    If it helps, I'm referring to this link (https://it.toolbox.com/blogs/vincentmcburney/how-to-import-microsoft-ssrs-metadata-into-the-ibm-business-information-exchange-103013)

    Note that the article is referring to previous version of IMAM

     

    Let me know,

    Pratik

    Updated on 2018-01-25T09:32:50Z at 2018-01-25T09:32:50Z by PratikBG
  • satyamadhav@IBM
    satyamadhav@IBM
    4 Posts

    Re: Import SSRS Metadata into IMAM and depict in IGC

    ‏2018-01-26T03:16:24Z  
    • PratikBG
    • ‏2018-01-25T09:30:24Z

    Yes, after the FP2 for IBM IIS v11.5, IMAM does supports SSRS 2014. We have had confirmation from IBM and then we were successfully able to connect to the reporting server URL. Now it seems that its extracting limited metadata from SSRS.

    If it helps, I'm referring to this link (https://it.toolbox.com/blogs/vincentmcburney/how-to-import-microsoft-ssrs-metadata-into-the-ibm-business-information-exchange-103013)

    Note that the article is referring to previous version of IMAM

     

    Let me know,

    Pratik

    Hi Pratik

    from the console it appears that  you have not selected the import joins and levels. these 2 options would get all the related joins and related metadata.

    tory (IBM InfoSphere Information Server installation directory) = C:\IBM\InformationServer
    2018-01-24 09:23:12 [INFO] MIMB_I0031:     Import joins = False
    2018-01-24 09:23:12 [INFO] MIMB_I0031:     Import levels = False

    2018-01-24 09:23:12 [INFO] MIMB_I0031:     Qualify table names = False
    2018-01-24 09:23:12 [INFO] MIMB_I0031:     Model namespace =

     

  • PratikBG
    PratikBG
    10 Posts

    Re: Import SSRS Metadata into IMAM and depict in IGC

    ‏2018-01-29T09:34:32Z  

    Hi Pratik

    from the console it appears that  you have not selected the import joins and levels. these 2 options would get all the related joins and related metadata.

    tory (IBM InfoSphere Information Server installation directory) = C:\IBM\InformationServer
    2018-01-24 09:23:12 [INFO] MIMB_I0031:     Import joins = False
    2018-01-24 09:23:12 [INFO] MIMB_I0031:     Import levels = False

    2018-01-24 09:23:12 [INFO] MIMB_I0031:     Qualify table names = False
    2018-01-24 09:23:12 [INFO] MIMB_I0031:     Model namespace =

     

    Thanks for your reply,

     

    I tried via selecting the import joins, and level. It still gave me the same error.

     

    However, my query is that: I can see BI report field in IMAM under pages>body>tablix and the same I cannot see in IGC after sharing the staged import to metadata repository. Do you know why is that the case?

     

    Much Thanks,

    Pratik

  • satyamadhav@IBM
    satyamadhav@IBM
    4 Posts

    Re: Import SSRS Metadata into IMAM and depict in IGC

    ‏2018-01-29T09:50:40Z  
    • PratikBG
    • ‏2018-01-29T09:34:32Z

    Thanks for your reply,

     

    I tried via selecting the import joins, and level. It still gave me the same error.

     

    However, my query is that: I can see BI report field in IMAM under pages>body>tablix and the same I cannot see in IGC after sharing the staged import to metadata repository. Do you know why is that the case?

     

    Much Thanks,

    Pratik

    please open a customer ticket or if it is opened please update the logs and sample file for which it is  bringing the incomplete data

  • PratikBG
    PratikBG
    10 Posts

    Re: Import SSRS Metadata into IMAM and depict in IGC

    ‏2018-01-29T09:54:54Z  

    please open a customer ticket or if it is opened please update the logs and sample file for which it is  bringing the incomplete data

    Yes, the ticket is open.

    However, I am not able to view my case (View your case)

    Also, where do I upload the recent logs?

     

    Let me know.

     

    Regards,

    Pratik