Is it possible to to use SQlite database as an External Content type?

Question

_{Thursday, November 8, 2012 3:53 AM}

Hi guys,

    I need some help in accessing data from an external database(SQlite) and use it in sharepoint 2010.  I have a list in sharepoint 2010 but some of the fields must come from SQlite database.  Whenever the list is updated, the corresponding fields from SQlite database should also be updated. 

   I've been looking on some examples on using external content types but I've only encountered examples using SQL server. I'm new to sharepoint 2010 and I have little idea to get this done.  Can someone kindly assist me on this? 

Thank you very much.

Regards,

Peter

All replies (3)

_{Saturday, November 10, 2012 12:54 PM ✅Answered | 1 vote}

Hi Peter,

SharePoint is designed to use Business Connectivity Services when talking to external data sources.

The Microsoft Business Connectivity Services (BCS) can connect to external data from the following types of databases:

• Microsoft SQL Server
• Oracle
• OLE DB
• ODBC

So you may connect to SQLite through ODBC. Take a look at this example how to connect to MySQL through ODBC Connecting MySQL using BCS. You may create an External Content Type for SQLite the same way.

Dmitry

Lightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog | Мой Блог

_{Tuesday, November 20, 2012 8:55 AM}

Thank you Dmitry.  I started creating a BDC model for it, but then we decided to just migrate the tables form SQLite to SQL server 2008 r2 which is a lot more easier.  Thank you.

_{Friday, January 10, 2014 12:46 PM}

Дмитрий можете помочь с SQLite?