6

I have a SQL and a Access database which I need to import to SharePoint. These database contains information collected from my Internet site like registration info, usernames etc.

Is this possible to do it? I have read somewhere that it can be done using BCS. But I am unable to find more information on it.

Can someone please help me out?

2
  • Do you want your users to authenticate into SharePoint using these data? Or do you just want the data accessible in SharePoint for internal consumption (not necessarily for authentication)?
    – James Love
    Dec 3, 2011 at 10:09
  • I need e data accessible in SharePoint for internal consumption (not necessarily for authentication). Tx
    – neo269
    Dec 3, 2011 at 10:13

2 Answers 2

3

A few things come to mind, using BCS and external lists to bring the content in, creating a DVWP with the database as a data source, using SSRS to bring the data into SharePoint.

Some references on the BCS, Link 1, Link 2, Link 3

3

You can write your own authentification provaider. I think this articles will helpful:

Forms Authentication in SharePoint Products and Technologies (Part 1): Introduction

Forms Authentication in SharePoint Products and Technologies (Part 2): Membership and Role Provider Samples

1
  • Based on the comments above, this isn't what the user wants, although it is a good answer for setting up forms authentication. He just wants to expose that data in SharePoint. Dec 3, 2011 at 11:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.