This walkthrough demonstrates how to integrate MySQL database with Microsoft® SharePoint® 2013 using ODBC by creating a new external content type for MySQL using BCS Meta Man for Windows.

The walkthrough will then get you to display the data from the MySQL database on a SharePoint 2013 page. If you have any questions please submit them on our web site page: Support Request.

This walkthrough demonstrates the following tasks:


You need the following components to complete this walkthrough:

  • SharePoint Server 2013
  • BCS Meta Man – it doesn’t necessarily need to be installed on the SharePoint server but it requires .NET Framework 4.5 installed on the machine where you are using BCS Meta Man.
  • MySQL database server with any sample database
  • Windows 64-bit, Connector/ODBC must be installed on the machine where SharePoint 2013 is running and on the machine where you use BCS Meta Man.

Create an External Content Type

  1. Start BCS Meta Man.

  2. Under data source, click ODBC.

    Click ODBC

  3. Select MySQL from the data source type list.

  4. In the connection string text box, type an ODBC connection string, for example,
     "Driver={MySQL ODBC 5.1 Driver};Server=canopus;Port=3306;
  5. Click the blue arrow Next to move to the next step.

    Connect to MySQL
    BCS Meta Man connects to the MySQL server, and then displays the model diagram page.

  6. Click Tables.
    Click Tables

    A list of all the tables in your MySQL database are displayed.
    List of tables in the MySQL database

  7. Drag and drop a table onto the model design area.
    Drag a table onnto the design surface

    BCS Meta Man again connects to the data source and displays a preview of the external content type. You may modify the external content type name, change identifier and add the methods to the external content type.
    Configure the external content type

  8. Click Create.

    The external content type is displayed on the design surface.
    Created external content type

Go to top →

Deploy the BDC Model

  1. On the title bar, click Settings.
    Meta Man setting

  2. In the Model deployment URL text box, type the URL of the SharePoint 2013 Central Administration web site.
    Set BDC model deployment URL

  3. Click Save to close the Settings dialog box.

    Deploy BDC model file

  4. Click Deploy.

    SharePoint validates your BDC model, and then the Information dialog box is displayed.
    BDC model was successful imported

  5. Click OK.

Go to top →

Create an External List based on your BDC model

  1. Navigate to a SharePoint site where you want to display the contents from your MySQL database.
  2. Click Settings, Site Contents and then on the Site Contents page, click add an app.
    Add an app to a SharePoint site

  3. Click External List, you may need to scroll down the page or page the second page.

    The Adding External List page is displayed.
    Select 'External List'

  4. In the Name text box, type the name for your list.

  5. To the right of the External Content Type text box, click the External Content Type picker.
    Click the External Content Type picker icon

    The External Content Type Picker page is displayed.
    Select the external content type

  6. Select the BDC model you generated for you MySQL data source, and then click OK, to return to the Adding External List page.
    Click Create

  7. Click Create.

    The external data from your MySQL database is displayed in the External List.
    The contents of the MySQL table are displayed within the view of the External List

Go to top →
Walkthrough: Creating an External Item Picker for Foreign Keys →


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Please do not use this for support questions.
For customer support, please contact us here.

Post Comment