Contents
Click on the hyperlink ”Click here to discover external data sources and define operations”. Click on the “Add Connection” button to create a new connection. We have three options, either to select . NET type, SQL Server or WCF Service.
To create a BDC project The New Project dialog box opens. Under either Visual Basic or Visual C#, choose Office/SharePoint, SharePoint Solutions. In the Templates pane, choose the SharePoint 2013 – Empty Project item, and then choose the OK button. The SharePoint Customization Wizard opens.
Overview. Access 2010 and Access Services provide a platform for you to create databases that you can use on a SharePoint site. You design and publish a web database by using Access 2010 and Access Services, and people who have accounts on the SharePoint site use the web database in a web browser.
How to connect MySQL to SharePoint Server 2010?
The information below is for SharePoint Server 2010 (32-Bit). To connect to SharePoint Server 2013 (64-Bit) please use ODBC and the MySQL ODBC Data Provider (64-Bit). In the Layer2 Business Data List Connector the data source must be configured as follows to connect to MySQL.
How can I use SQL Server with SharePoint?
You can make use of all SQL queries your data provider supports. You can also use stored procedures that returns records, exec myStoredProcedure (). You can make use of aliases in query to force auto-mapping in the BDLC, e.g. select customername as title, to auto-map to a SharePoint title column.
One-way and optional two-way connection: You can write-back the changes made in SharePoint to the external data source automatically with full CRUD (Create / Update / Delete) functionality. The SharePoint list can act as a full-featured front-end for external systems.
Where can I find the MySQL connectors component?
You can find the component on the MySQL Connectors page. Install the 32-bit provider. 64-bit does not appear to be supported for this provider. Please select the MySQL Data Provider from the list of installed providers. Data Source=MyServerAddress; Database=MyDB; User Id=myUser; Password=myPassword.