{"id":67,"date":"2010-08-30T10:33:43","date_gmt":"2010-08-30T16:33:43","guid":{"rendered":"http:\/\/localhost\/todd_wp\/sharepoint-business-connectivity-services-faq\/"},"modified":"2013-07-01T10:55:18","modified_gmt":"2013-07-01T16:55:18","slug":"sharepoint-business-connectivity-services-faq","status":"publish","type":"post","link":"https:\/\/toddbaginski.com\/blog\/sharepoint-business-connectivity-services-faq\/","title":{"rendered":"SharePoint Business Connectivity Services FAQ"},"content":{"rendered":"<p>This FAQ is a collection of answers to questions submitted by my blog readers.\u00a0 Check back often as it will grow over time.<\/p>\n<p><span><strong>Q:<\/strong> <\/span><span>I&#8217;m using the BDC to connect to a MySQL database.\u00a0 I&#8217;ve connected successfully, and generated a nice little dataview to display some basic information.\u00a0 Unfortunately, the MySQL database is storing dates as regular strings, instead of datetimes.\u00a0 Of course, I want to sort, filter, and perform calculations on those dates, so this is problematic for me.\u00a0 So, my question is: since I can&#8217;t update the database schema and convert the dates to true datetimes, there, is there a way to convert them &#8220;on-the-fly&#8221; when I pull them into SharePoint?<\/span><\/p>\n<p><span><strong>A: <\/strong>You<span> can convert data types between an external system and the BDC with the use of a .NET assembly connector.\u00a0 This would work for the scenario you describe.<\/span><\/span><\/p>\n<p><strong>Q: <\/strong>Is there a way to test BCS Models, ECTs, and ECT methods without creating external lists?<\/p>\n<p><strong>A: <\/strong>Yes, there is!\u00a0 Go get <a href=\"http:\/\/www.lightningtools.com\/bcs-tester-man.aspx\" target=\"_blank\">BCS Tester Man<\/a>.<\/p>\n<p><strong>Q:<\/strong> Can BCS connect to an Oracle database?<\/p>\n<p><strong>A:<\/strong> Yes, it can.\u00a0 See this article for more information.<\/p>\n<p><span style=\"font-family: Arial;\"><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ff464424.aspx\">http:\/\/msdn.microsoft.com\/en-us\/library\/ff464424.aspx<\/a><\/span><\/p>\n<p><strong>Q: <\/strong>How can I represent BCS data in a calendar view?<\/p>\n<p><strong>A:<\/strong>\u00a0You have a few options.<\/p>\n<p>1. Use Outlook to display the data by connecting it to the External Content Type.<\/p>\n<p>2. Create your own custom web part and replace the XLV Web Part that comes with the view associated with your external list connected to the External Content Type.<\/p>\n<p>3. Purchase a third party web part which is designed to do this.<\/p>\n<p><strong>Q:<\/strong> Can I reuse the existing calendar view on a list view web part to display BCS data?<\/p>\n<p><strong>A: <\/strong>No, the calendar view is not an XLV Web Part and hence it doe snot use XSLT.\u00a0 If you try to connect the out of the box calendar view to external lists it will not work and furthermore it is not a supported scenario.<\/p>\n<p><strong>Q: <\/strong>If you have a <span style=\"font-family: &quot;Calibri&quot;, &quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;\">server farm with several WFEs and Application Servers where do .NET Assembly Connectors and custom <\/span><span style=\"font-family: &quot;Calibri&quot;, &quot;sans-serif&quot;; font-size: 11pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;\">connectors execute?<strong> <\/strong><\/span><\/p>\n<p><strong>A: <\/strong>Data access code for any BCS connector, always executes on the WFEs.<\/p>\n<p><strong>Q: <\/strong>If you are sharing the VCS service as a cross-farm service where do you install .NET Assembly Connectors and Custom Connectors?<\/p>\n<p><strong>A: <\/strong>You install the connectors to the BCS service.\u00a0 The connector assemblies are stored in the database and pulled by whichever farm needs to use them.\u00a0 At runtime they are executed on the farm which consumes the BCS service.<\/p>\n<p><strong>Q: <\/strong>Where do connectors execute for search crawls and BCS based search query pluggable security trimmers?<\/p>\n<p><strong>A: <\/strong>The connectors execute in one of two places.\u00a0 Either in the search crawler daemon process or in the search query service app pool.<\/p>\n<p><strong>Q: <\/strong>How does BCS metadata get populate don client machines?<\/p>\n<p><strong>A:<\/strong> In a declarative solution, upgrades are manually initiated from the client machines.<\/p>\n<p>In Outlook the Sync Now button does two things.\u00a0 It syncs data and does a check for metadata updates in the same step.<\/p>\n<p>In SharePoint Workspace one menu item syncs data while another checks for metadata updates.<\/p>\n<p>In a custom solution, you can take advantage of automatic updates which the ClickOnce deployment framework provides.<\/p>\n<p>In a simple solution the packages are generated on the server.\u00a0 For declarative or custom solutions the packages must be manually generated.<\/p>\n<p><strong>Q:<\/strong>\u00a0How do I deploy a BCS Model to SharePoint?<\/p>\n<p><strong>A:<\/strong> See <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ff798309.aspx\" target=\"_blank\">this article<\/a>\u00a0we created in the SharePoint 2010 Patterns and Practices Guidance.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This FAQ is a collection of answers to questions submitted by my blog readers.\u00a0 Check back often as it will grow over time. Q: I&#8217;m using<span class=\"excerpt-hellip\"> [\u2026]<\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[100,102,97],"tags":[36,4],"class_list":["post-67","post","type-post","status-publish","format-standard","hentry","category-bcs","category-community","category-sharepoint","tag-bcs-faq","tag-bdc"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/posts\/67","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/comments?post=67"}],"version-history":[{"count":7,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/posts\/67\/revisions"}],"predecessor-version":[{"id":803,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/posts\/67\/revisions\/803"}],"wp:attachment":[{"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/media?parent=67"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/categories?post=67"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/tags?post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}