Topic
4 replies Latest Post - ‏2012-01-11T19:37:05Z by XHJV_Pramod_J
XHJV_Pramod_J
XHJV_Pramod_J
9 Posts
ACCEPTED ANSWER

Pinned topic Adding Microsoft SQL Server datasource

‏2012-01-11T17:58:51Z |
Hello All,

I need some help in setting up Microsoft SQL Server 2005 as the data source for the IBM Mashup Center.

I have installed JDBC Drivers for SQL Server and tried to add the data source from WAS admin console. Please let me know if any one has successfully implemented this.
Thanks
Updated on 2012-01-11T19:37:05Z at 2012-01-11T19:37:05Z by XHJV_Pramod_J
  • SystemAdmin
    SystemAdmin
    391 Posts
    ACCEPTED ANSWER

    Re: Adding Microsoft SQL Server datasource

    ‏2012-01-11T19:10:13Z  in response to XHJV_Pramod_J
    Note that IBM MashupCenter uses two databases one for the Hub and another for Lotus Mashups (often called the Builder)

    The instructions for configuring SQL Server for Lotus Mashups can be found here: http://www-10.lotus.com/ldd/mashupswiki.nsf/dx/Configuring_Microsoft_SQL_Server_for_Lotus_Mashups_imc3

    The config task config.bat action-create-db-mashup-sqlserver will do this
    1) Create or recreate the datasource in WebSphere
    2) Generate a set of SQL scripts which will allow the proper initialization of the Database

    After this completes you will have a new empty Mashups database.

    The instructions for migrating the Hub to use SQL Server are here: http://www-10.lotus.com/ldd/mashupswiki.nsf/dx/Database_migration_setup_imc3.

    The steps here do specify that you must create the database first and it should be empty (The schema you wish to use must not be present)
    The migration task will create the datasource and then migrate the Hub contents to the new DB

    Regards,

    Dirk Tysmans
    Lotus Mashups Development
    • XHJV_Pramod_J
      XHJV_Pramod_J
      9 Posts
      ACCEPTED ANSWER

      Re: Adding Microsoft SQL Server datasource

      ‏2012-01-11T19:18:07Z  in response to SystemAdmin
      Thanks for your help Dirk.

      Used similar procedure which you have mentioned
      http://publib.boulder.ibm.com/infocenter/mashhelp/v3/index.jsp?topic=%2Fcom.ibm.examples.doc%2Fdatabase_feed.htm
  • Stan
    Stan
    340 Posts
    ACCEPTED ANSWER

    Re: Adding Microsoft SQL Server datasource

    ‏2012-01-11T19:20:35Z  in response to XHJV_Pramod_J
    Many people have RDBMs feeds for Microsoft SQL server. Installing the driver is like any other third-party JDBC driver.

    The driver files need to be placed in the install tree for each of the two server components making up Mashup Center (Mashup Builder and MashupHub). This architecutre allows the components to be distributed across on seperate machines.

    See the following page for information on the driver versions supported and the install location for MashupHub:
    http://www-10.lotus.com/ldd/mashupswiki.nsf/dx/Configuring_MashupHub_for_enterprise_database_feeds_imc3001

    MashupHub install loacation:
    <install-root>\Hub\installedApps\Mashup Hub.ear\mashuphub-enterprise.war\WEB-INF\lib

    For Mashup Builder place the driver file in:
    <install-root>\Config\lib\sqlserver
    • XHJV_Pramod_J
      XHJV_Pramod_J
      9 Posts
      ACCEPTED ANSWER

      Re: Adding Microsoft SQL Server datasource

      ‏2012-01-11T19:37:05Z  in response to Stan
      Thanks for your reference Stan