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

  • Question

  • 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


    • Edited by mr_peterB Thursday, November 8, 2012 4:15 AM
    Thursday, November 8, 2012 3:53 AM

Answers

  • 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

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

    Saturday, November 10, 2012 12:54 PM

All replies

  • 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

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

    Saturday, November 10, 2012 12:54 PM
  • 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.

    Tuesday, November 20, 2012 8:55 AM
  • Дмитрий можете помочь с SQLite?
    Friday, January 10, 2014 12:46 PM