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.
This topic has been locked.
4 replies Latest Post - 2012-01-11T19:37:05Z by XHJV_Pramod_J
Pinned topic Adding Microsoft SQL Server datasource
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-01-11T19:37:05Z at 2012-01-11T19:37:05Z by XHJV_Pramod_J
SystemAdmin 110000D4XK391 PostsACCEPTED ANSWER
Re: Adding Microsoft SQL Server datasource2012-01-11T19:10:13Z in response to XHJV_Pramod_JNote 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
Lotus Mashups Development
Re: Adding Microsoft SQL Server datasource2012-01-11T19:18:07Z in response to SystemAdminThanks for your help Dirk.
Used similar procedure which you have mentioned
Stan 120000HAGM340 PostsACCEPTED ANSWER
Re: Adding Microsoft SQL Server datasource2012-01-11T19:20:35Z in response to XHJV_Pramod_JMany 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:
MashupHub install loacation:
For Mashup Builder place the driver file in: