Topic
  • 2 replies
  • Latest Post - ‏2013-08-08T04:20:53Z by MolumaTresa
MolumaTresa
MolumaTresa
23 Posts

Pinned topic Not able to import a view of a table created in the sql sever database to IA 8.5

‏2013-08-06T15:02:19Z |

I have a table "Date" in database (Sql server).

I created a view of this table in my database itself  as date_view and tried to import this to IA 8.5 using "Import metadata" option in IA (followed the steps in IBM documentation)

But only the tables were getting imported and the view  was not getting imported.

 

So can someone tell me in detail, the steps to be followed so as to import the table along with its view as soon as possible (Itz very urgent) along with supporting links

 

 

  • RobertDickson
    RobertDickson
    74 Posts

    Re: Not able to import a view of a table created in the sql sever database to IA 8.5

    ‏2013-08-07T18:08:08Z  

    Hi,

     

    Select 'Home > Metadata Management > Import Metadata'.  When importing the metadata, select 'Set Pre-Filter' (on the right).  You can then check the 'Include Views' checkbox.

    Reference: http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=%2Fcom.ibm.swg.im.iis.ia.help.doc%2Ftopics%2Fcs_mi_set_pre_filter.html

     

    --------

    Regards,

    Robert

  • MolumaTresa
    MolumaTresa
    23 Posts

    Re: Not able to import a view of a table created in the sql sever database to IA 8.5

    ‏2013-08-08T04:20:53Z  

    Hi,

     

    Select 'Home > Metadata Management > Import Metadata'.  When importing the metadata, select 'Set Pre-Filter' (on the right).  You can then check the 'Include Views' checkbox.

    Reference: http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=%2Fcom.ibm.swg.im.iis.ia.help.doc%2Ftopics%2Fcs_mi_set_pre_filter.html

     

    --------

    Regards,

    Robert

    Hi Robert,

     

    Thank you so  much for your mail . It worked perfectly fine and I am able to import views