SharePoint employee database integration
-
Hello everyone, I have a question regarding database like use within SharePoint. The current set-up is like this; SQL Server contains users (just personal information) Web-application accesses the SQL server and requests the information from the database. However this needs to change. The SQL database has to be removed, and the data should become integrated in SharePoint. I have done some minor research, which led me to the fact that i can use LISTS in sharepoint for this. However my question is, are there any other options (any, doesn't matter if they are not good performance/accessability wise) by not using an external database like SQL (Obviously not including the SharePoint database). The point is, the system should be integrated in SharePoint in some way, so you can basically roll it out over multiple SharePoint servers without having to run all kinds SQL scripts and set up a difficult infrastructure to support it. If so, what would be the best option for the system i want to build? SPLISTS or something else? Keep in mind, the database is fairly simple. I hope anyone is willing to help me out trying to figure out the best way to approach this. Greetings and thanks in advance, Bart
-
Hello everyone, I have a question regarding database like use within SharePoint. The current set-up is like this; SQL Server contains users (just personal information) Web-application accesses the SQL server and requests the information from the database. However this needs to change. The SQL database has to be removed, and the data should become integrated in SharePoint. I have done some minor research, which led me to the fact that i can use LISTS in sharepoint for this. However my question is, are there any other options (any, doesn't matter if they are not good performance/accessability wise) by not using an external database like SQL (Obviously not including the SharePoint database). The point is, the system should be integrated in SharePoint in some way, so you can basically roll it out over multiple SharePoint servers without having to run all kinds SQL scripts and set up a difficult infrastructure to support it. If so, what would be the best option for the system i want to build? SPLISTS or something else? Keep in mind, the database is fairly simple. I hope anyone is willing to help me out trying to figure out the best way to approach this. Greetings and thanks in advance, Bart
If you don't want to use an external data connection and instead store everything in SharePoint then Lists are your only choice. WSS List and Database Synchronization[^]
I know the language. I've read a book. - _Madmatt
-
If you don't want to use an external data connection and instead store everything in SharePoint then Lists are your only choice. WSS List and Database Synchronization[^]
I know the language. I've read a book. - _Madmatt
Thank you Mark Nischalke for your reply. I found some information about Business Data Catalog (SharePoint Enterprice). I'll be looking in to that, to see if that has any use for what i need/want. I'm currently doing some research on what options i have, if you have any other information then the page you linked everything is welcome! Either way, thanks again for your response. Edit: I just saw that the page you linked was about BDC, i'll have a look at that! Thank you! Bart
-
Thank you Mark Nischalke for your reply. I found some information about Business Data Catalog (SharePoint Enterprice). I'll be looking in to that, to see if that has any use for what i need/want. I'm currently doing some research on what options i have, if you have any other information then the page you linked everything is welcome! Either way, thanks again for your response. Edit: I just saw that the page you linked was about BDC, i'll have a look at that! Thank you! Bart
The Business Data Catalog (BDC) is a means to display external data in SharePoint, but you said you do not want to use an external data source.
I know the language. I've read a book. - _Madmatt
-
The Business Data Catalog (BDC) is a means to display external data in SharePoint, but you said you do not want to use an external data source.
I know the language. I've read a book. - _Madmatt
Exactly, It could be used (from what i read from your artical), is that you can use it to "insert" everything in to sharepoint, but yes. I guess, Lists are the way to go then, which as i read somewhere else, could be a problem if you have over 2k records in a list. However, the list itself would be cross-selected by webparts so the whole list would never be exposed. I'll see how this works out, once more Mark, thank you for your help/advice! Greetings Bart
-
Hello everyone, I have a question regarding database like use within SharePoint. The current set-up is like this; SQL Server contains users (just personal information) Web-application accesses the SQL server and requests the information from the database. However this needs to change. The SQL database has to be removed, and the data should become integrated in SharePoint. I have done some minor research, which led me to the fact that i can use LISTS in sharepoint for this. However my question is, are there any other options (any, doesn't matter if they are not good performance/accessability wise) by not using an external database like SQL (Obviously not including the SharePoint database). The point is, the system should be integrated in SharePoint in some way, so you can basically roll it out over multiple SharePoint servers without having to run all kinds SQL scripts and set up a difficult infrastructure to support it. If so, what would be the best option for the system i want to build? SPLISTS or something else? Keep in mind, the database is fairly simple. I hope anyone is willing to help me out trying to figure out the best way to approach this. Greetings and thanks in advance, Bart
BDC is the most flexible as you can point that to any database. Sharepoint works very well with Active directory. I like the way you can search on a user and then see the heirarchy of the organization. You must keep AD up to date as to who works for who. On the user properties under organizition tab keep the manager up to date and you have an instant org chart. Visio can be used to create an org chart from AD that you can then publish to SP.
WPWood