easthomeRT 发表于 2015-4-20 13:22:17

【东方瑞通】利用SharePoint中的BDC服务，连接并展示外部业务数据

SharePoint Server 2013中的BDC（Business Data Connectivity Service）服务，为企业提供了连接外部数据的功能。企业通过SharePoint企业门户，对第三方系统业务数据进行直接操作。例如：添加、修改、删除等一系列操作。下面我们来看一下，如何配置外部业务数据的连接与展示。1、在SharePoint管理中心中，启动BDC服务。http://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/6831ef35-c6f4-4ddc-9bcc-ab9d0099961e.png2、确认数据库系统中，需要连接的第三方业务数据。http://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/415368c6-5c7c-480c-967f-f3db8e6c575e.png3、使用SharePoint Designer 2013连接SharePoint站点，并打开“外部内容类型”选项，单击“外部内容类型”。http://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/0314774c-20bd-443e-82db-a30c9e20127a.png4、填写外部内容类型“名称”，随后单击“外部内容类型操作”窗口中的“单击此处发现外部数据并定义操作”。http://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/a450ec15-6283-4a0b-affd-7b2c394a5c5f.png5、单击“添加连接”http://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/ae6da09c-82c6-4449-81b5-864d4efb0cb4.png6、选择“SQL Server”http://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/5cd88a97-b6ed-4686-a496-ec63cebfbd97.png7、填写“数据库服务器”和“数据库名称”，完成数据库连接配置。http://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/56ed10e7-6c29-446b-abbd-56f143a72f70.png8、右键单击要连接的数据表，选择“创建所有操作“。http://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/207b5d03-a176-49ac-ad1c-d565a1c1b28e.png9、选择相应数据字段，勾选定义为“标识符“，单击“完成”。http://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/a92fb2e4-b8ea-4997-a47e-fa37ae089282.png10、单击保存，完成外部内容类型的添加。http://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/4aff1fcc-ddad-4595-91fa-81f65ca46d56.png11、访问SharePoint管理中心，进入“管理服务应用程序”，单击“Business Data Connectivity Service“。http://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/f91d837c-494d-4bbe-8609-739627651f7d.pnghttp://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/135dc673-1e55-4943-8ce4-7b4c681f56fc.png12、访问SharePoint站点，添加“外部数据”应用程序，并绑定创建好的“外部内容类型”，即可通过SharePoint平台访问该第三方业务数据。http://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/1bdc40a2-1b67-4fcd-b502-742ceee550e4.png13、若遇到如下报错信息，请添加访问者对外部内容类型的访问权限。http://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/18b2c6e2-d6d1-434e-b500-e8879593f2d6.pnghttp://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/9321f795-d6cb-40b1-bf60-b8dddb4b8474.pnghttp://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/11df4a2f-db09-4461-befd-25a9b8efb95f.png14、若遇到如下报错信息，则需添加报错用户的数据库访问权限。http://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/fa0f9767-eaba-4b8a-b3cb-d4b322c2728e.pnghttp://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/8f40acb4-1bd2-455e-b528-9b4a17f0e784.pnghttp://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/ed6a85d2-2a60-4183-b606-fd13a09b76a9.pnghttp://115.28.154.201:1089/Content/ueditor/net/upload/2015-04-20/b95855d2-02b2-494e-bfa5-da5b3cecff30.png 此文出自东方瑞通孟兆文老师，转载需注明出处

tititatamu 发表于 2021-3-16 22:05:05

感谢。。。。。。。。。。。。。。。。。。。。。。。。。。。

Ethanfeng 发表于 2024-3-24 15:47:04

看不到
页: [1]
查看完整版本: 【东方瑞通】利用SharePoint中的BDC服务，连接并展示外部业务数据