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?

Improve this question
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)? Commented Dec 3, 2011 at 10:09
  • I need e data accessible in SharePoint for internal consumption (not necessarily for authentication). Tx Commented Dec 3, 2011 at 10:13

2 Answers 2

Reset to default
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

Improve this answer
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

Improve this answer
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. Commented 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.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.