Benutzer:MovGP0/70-489/BCS

MovGP0

Über mich

Hilfen

Artikel

Weblinks

Literatur

Zitate

Notizen

Programmierung

MSCert

Physik

Programmierung Programmierung Administration • Links • Vorgehensmodelle • NuGet • Transformations • MSBuild • Raspberry • Cheatsheets • Git • Mathematica C♯ Program Flow Multithreading and asynchronous processing • Multithread management • Program flow • Events and callbacks • Exception handling Types Type creation • Type consumentation • Encapsulation • Class hierarchies • Reflection • Object life cycle • String manipulation Debugging and Security Input validation • Encryption • Assembly Management • Debugging • Diagnostics Data access I/O operations • Data consumtion • LINQ • Data serialization • Collections Theory Functional • Lambda Calculus • Category Theory F♯ Basics Data Structures • Classes • Generics • Units of Measure • Exception Handling • Pipes • Recursion • Pattern Matching • Lazy Evaluation • Asynchronous and Parallel Programming • Number Representations • Arithmetic Operators • Conversion Functions • Queries Quantitative Finance Math.NET • Statistics • Root Finding Algorithmns • Data Visualisation • Option Pricing • Volatility • Order Types and Market Data • Volatility Trading Python Classes • Loops • Anonymous Types • Lambda Expressions • Queries (LINQ) • Iterators (yield) PHP   T-SQL / SQL Server T-SQL Fundamantals Select • Programming • Pitfalls • Query from Multiple Tables • Groups and Summaries • Advanced Select • Aggregation and Windowing • Insert, Update, Delete • Strings • Date and Time • Numbers • Transactions, Locking, Blocking, Deadlock • Tables • Views • Large Tables and Databases • Indexes • Stored Procedures • User-Defined Functions and Types • Triggers • Error Handling • Query Performance and Tuning • Hints • Index Tuning and Statistics • XML • Files, Filegroups, Integrity • Backup • Recovery • Principals and Users • Securables, Permissions, Auditing • Objects and Dependencies SQL Server Performance Tuning Memory Performance Analysis • Disk Performance Analysis • CPU Performance Analysis • Baseline Creation • Query Performance Metrics • Query Performance Analysis • Index Architecture and Behavior • Index Analysis • Database Engine Tuning Advisor • Key Lookups • Statistics, Data Distributuon, and Cardinality • Index Fragmentation • Execution Plan Generation • Execution Plan Cache Behavior • Parameter Sniffing • Query Recompilation • Query Design Analysis • Reduce Query Resource Use • Blocking and Blocked Processes • Causes and Solutions for Deadlocks • Row-By-Row Processing • Memory-Optimized OLTP Tables and Procedures • Database Performance Testing • Database Workload Optimization • SQL Server Optimization Checklist Service Broker Message • Contract • Queue • Service • .NET Integration • Route • Security   Datatypes • Unit Testing • Dependency Injection • Partitioning • .NET General LINQ • Reactive Extensions • Entity Framework • OData • Windows Workflow Foundation • Threading • Logging • Unit Testing • Dependency Injection • Documentation • WinForms Performance Locking • Coding Style and Class Design • .NET Framework • Performance Counters • Event Tracing (ETW) • Windows Phone • Code Safety • Team ASP.NET Common OWIN • Razor • WebForms • MVC • WebAPI Core Configuration • Data Protection API • Dependency Injection • Routing Attack Vectors HTTPS • HSTS • HPKP • CSP • CSRF • Anti-XSS • CORS • Open Redirection • Click-Jacking Libraries OpenID • Azure AD Messaging WCF Basics Services • Addresses • Contracts • Hosting • Bindings • Endpoints • Metadata Exchange • Behaviour Configuration • Client-Side Programming • Architecture • Channels • Transport-Level Sessions • Reliability Advanced WCF Service Contract • Data Contract • Instance Management • Operations • Faults • Transactions • Concurrency Management • Queued Services • Security • Service Bus • Basic HTTP Auth Andere .NET Remoting • Message Queuing (MSMQ) • Protocol Buffers • ActiveMQ • Disruptor.NET • TIBCO Rendezvous • CQRS • Rebus User Interface WPF Data Binding • Resources • Transforms and Effects • 2D Drawing • 3D Drawing • Routed Events • Routed Commands • ICommandSource • Triggers • Behaviors • Visual State Manager • Theming • Layout • Templates • Popups • Dependency Object • Fonts • Composition API • MVVM Frameworks • Navigation Windows Forms INotifyPropertyChanged • DataBinding • Validation • PRISM DevExpress DataAnnotation • TaskbarButtonService, ApplicationJumpListService, NotificationService • Asynchronous Commands Xamarin DependencyService • Custom Renderer • Shaped Buttons Parallel Programming Common Processor • Locking Data Parallelism Parallel Loops • Parallel Aggregation Task Parallelism Parallel Tasks • Futures • Dynamic Task Parallelism • Pipelines Akka.NET Logging • Persistence • Dependency Injection • Cluster • Remote ECMAScript Languages ECMAScript • TypeScript • Elm • LESS Infrastruktur Node • Yeoman • Bower • Grunt • Jasmine • Karma • Protractor • Hapi • Redux AngularJS Validation • Testing Angular Modules • Animations • Attributes • Styles • Deployment • Dependency Injection • HTTP Client • Lifecycle • Pipes • Routing and Navigation • Security • Structural Directives (ngIf, ngFor, ngSwitch) • Testing • Forms Validation Other Knockout • RequireJS • PhoneGap/Cordova • React • fantasy-land • typed-contract • parsimmon SharePoint Notes Fields • Lists • Content Types • Workflow • Business Connectivity Services • Search • Managed Metadata • AngularJS • Publishing/Approval • LINQ to SharePoint Nintex Custom Activities 70-488 • 70-489 Design and Implement Search • Implement Business Connectivity Services (BCS) • Implement Implement User Profiles and Customize Social Workload • Implement ECM and WCM • Design for Performance and Troubleshooting • Implement Managed Metadata Service (MMS) Microsoft CRM Reporting and Dashboards • SharePoint Integration • Authentication • Entity Handling • Workflows • Queries Security Forms Authentication • Membership and Role Provider • Zertifikate • OAuth • OpenID • Windows Identity Foundation Dateiformate CSV • Excel • Word • PDF • Email Azure Notes Azure Pack • Single Sign-on • Data Storage • Logging • Tracing • Service Bus • HDInsight • Orleans Infrastructure Services Virtual Machines • Virtual Machine Networking • Virtual Machine Storage • Virtual Networks 70-533  • 70-534 Active Directory • Static IP Adresses • ACLs • Network Security Groups • Availability Sets • VPN • Load Balancing • CDN • Media Services • Multi-Factor Auth. Muster Architektur Entwurfsmuster • Architekturmuster • Patterns of Enterprise Application Architecture Daten Analysemuster • Datenbank-Muster Verteilte Systeme Enterprise Integration Patterns • SOA • Big Data • Cloud • Stability & Capacity Management Organisationsmuster • Refactoring • Lizenzmuster Antimuster Antimuster • Dark Patterns • SQL Antipatterns Powershell Grundlagen Subversion (SVN) • CmdletBinding • Parameter (Sets) • Return Type • Module • Exception Handling DSC Common Information Model (CIM) • Resources • Configuration and Parameters • Local Configuration Manager (LCM) • Credentials • SMB Pull Server • HTTP Pull Server Android ROM Flashen • Unit Testing • Assistant Machine Learning Neuronale Netze Propagierungsfunktionen • Aktivitätsfunktionen • Lernmethoden • Pattern Associator • Rekurrente Netze • Kompetitive Netze • Kohonennetze • Constrain Statisfaction Netze Tensorflow Linear Regression • Logistic Regression • Softmax Regression • Hidden Markov • K-Means Clustering • Self-Organizing Map • Autoencoder • Q-policy neural network • Perceptron • Convolutional Neuronal Network • Recurrent Neuronal Network • Seq2Seq • Ranking Core Server Hyper-V • Active Directory User Groups • Active Directory Domain Services • Active Directory Federation Services • DHCP • IIS • DNS • RDP • WSUS • User Permissions • IP • SMB • DHCP • IPAM • Sonstige Bot Framework Rich Messages • Implement Business Connectivity Services (BCS) Create External Content Types External content types are used to connect to: SQL data source WCF services (SOAP Web Service) OData Services custom sources using a .NET Connector Create Content Type using SharePoint Designer External Content Types External Content Type (creates new external content type) name the connection Add connection SQL Connection uses the SQL Connection Wizard Create User Impersonation using the Secure Store Service Create CRUD functionality OData OData supports connections to SQL Server SharePoint Windows/SQL Azure Online Services Use OData in SharePoint App open Visual Studio create App for SharePoint 2013 project right click on the project → Add → Content Types for an External Data Source... enter the URL to the OData service select the entities Visual Studio creates a Content Type that maps to the OData Service edit the content type create a filter to limit the max number of results Create a Model Optimize Queries for Performance and Throttling SharePoint limits to 5000 records by default; throws ExceededLimitException Limit on external content type can be set in SharePoint Designer using Filter Parameters Configuration in Visual Studio using Filter on External Content Type Limit can be changed using Set-SPBusinessDataCatalogThrottleConfig $BCSProxy = Get-SPServiceApplicationProxy | wehre { $_.GetType().FullName -eq ('Microsoft.SharePoint.BusineesData.SharedService.BDCServiceApplicationProxy') } Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $BCSProxy | Set-SPBusinessCatalogThrottleConfig -Maximum 20000 -Default 25000 Use Naming Convention Users should adhere to a naming convention. Example User Account Names User Meaning SP_Admin SharePoint Administrator Account SP_Farm SharePoint Farm Instance Account SP_Crawl SharePoint Crawler Instance Account SP_UserSync SharePoint User Profile Synchronization Account BCS_SQL_AdventureWorks Connection to AdventureWorks database using SQL Connection BCS_OData_Northwind Connection to Northwind OData Service Use Batching Requires custom method created in Visual Studio Create Filters Filter can be added to External Content Type (.ecs) file in Visual Studio Implement Methods BCS Models define CRUD operations on external data source BCS Indexing Connector is used to support crawling and indexing of external data sources Model File - Provide connection information to the external system and the structure of the data Connector - Contains the code that connects to the external system and parses data Create Associations Relationship between external data entities in SharePoint Designer External Content Types select data source right-click table New Association ... in Visual Studio see code example Implement Autorization and Authentication BCS Supports the following authentication modes: Pass-through Revert to Self Windows Credentials Credentials RDB Credentials Digest Credentials Custom Authentication Pass-through, BCS Identity and User Identity Credential Username and Password. Might include additional data based on system. Authentication can occur via: Windows Authentication Forms Based Authentication Digest Basic Claims SAML Token (see also: SAML 2.0) for claims-aware services with Single Sign-on Authentication Modes Authentication Mode Description Pass-Through (User's Identity) passes the credentials of the current user Revert to self passes the credentials of the application pool Windows Credentials (Impersonate Windows Identity) uses the Secure Store Service to map the SharePoint User's Credentials to Windows Credentials Credentials (Impersonate Custom Identity) uses the Secure Store Service to map the SharePoint User's Credentials to Web Service Credentials (WCF) RDB Credentials uses the Secure Store Service to map the SharePoint User's Credentials to Database Credentials Digest Credentials (Impersonate Custom Identity) uses the Secure Store Service to map the SharePoint User's Credentials to Digest Credentials (Basic Authentication, Digest Access Authentication) siehe auch: HTTP-Authentifizierung User Permission Levels Permission Level Description Edit user can propagate permissions to child objects Execute user can execute operations on the external content types Selectable in Clients user can create lists based on the external content type Set Permissions user can set permissions on the external content type Use a Custom Model Implement ODataExtensionProvider: using Microsoft.BusinessData.SystemSpecific.OData; using System.Net; public class MyBCSAuthenticationProvier : ODataExtensionProvider { public override void AfterReceiveResponse(HttpWebResponse response) { ... } public override void BeforeSendRequest(HttpWebRequest request) { ... } } Deploy to GAC Register Provider using New-SPODataConnectionSetting in PowerShell. Add LobSystemInstance element to the BCS Model (.ect file) <LobSystemInstances> <LobSystemInstance Name="Northwind BCS"> <Properties> <Property Name="ODataServiceUrl" Type="System.String">http://services.odata.org/Northwind/Northwind.svc</Property> <Property Name="ODataServiceAuthenticationMode" Type="System.String">PassThrough</Property> <Property Name="ODataFormat" Type="System.String">application/atom+xml</Property> <Property Name="HttpHeaderSetAcceptLanguage" Type="System.Boolean">true</Property> </Properties> </LobSystemInstance> </LobSystemInstances> Create Custom Connectors Create BCS Model file in Visual Studio open the .bdcm file to view it in the designer add additional methods in the BDC explorer plane implement the methods (optional) implement Security Trimming by implementing the BinarySecurityDescriptorAccessor method (optional) implement Caching (optional) implement External Event Receiver. SharePoint requires the following components: Polling Service Subscription Store REST Notification Endpoints Stereotyped Methods Method Description Creator create a new entity Deleter deletes an existing entitiy Updater updates an existing entity Finder (ReadList) returns a list of entities Specific Finder (ReadItem) returns a single instance of an entity EventSubscriber subscribe to an custom event source EventUnsubscriber unsubscribe from an custom event source Access BCS Data Use BCS Web Parts BCS Web Parts Business Data List list of BCS items Business Data Item detail view of an item that is selected in the list Connections → Get Item From → select list Business Data Actions Business Data Connectivity Filter filters the data in an connected list Business Data Item Builder URL with query string to retrieve a business data item; not visible to the end user Business Data Related List list of related items from an association Use BCS Data in Workflows works like a normal list Workflow cannot be attached to BCS list, because the list is not in SharePoint and cannot notify the WF of changes Use BCS CSOM Namespaces using Microsoft.SharePoint.Client; using Microsoft.BusinessData.Runtime; using Microsoft.BusinessData.MetadataModel; using Microsoft.BusinessData.MetadataModel.Collections; Create using(var context = new ClientContext("http://<server>/<site>")) { var externalList = context.Web.Lists.GetByTitle("<list name>"); var newListItem = externalList.AddItem(new ListItemCreationInformation()); newItem["Key"] = "Key"; newItem["FirstName"] = "First"; newItem["LastName"] = "Last"; newItem.Update(); context.ExecuteQuery(); } Read var siteUrl = "http://<server>/<site>/"; using(var context = new ClientContext(siteUrl)) { // get reference to LOB object var web = context.Web; context.Load(web); var entity = context.Web.GetEntity(siteUrl, "ListName"); context.Load(entity); lobSystem = entity.GetLobSystem(); context.Load(lobSystem); var lobSystemInstanceCollection = lobSystem.GetLobSystemInstances(); context.Load(lobSystemInstanceCollection); context.ExecuteQuery(); // get BCS entity var entityId = new EntityIdentity(context, new object[] { 11000 }); context.Load(entityId); var entityInstance = entity.FindSpecific(identity, "Read Item", lobSystemInstanceCollection[0]); context.Load(instance); context.ExecuteQuery(); // read values from entity Console.WriteLine("Customer Key: {0}", entityInstance["Customer Key"]); Console.WriteLine("Name: {0} {1}", entityInstance["FirstName"], entityInstance["LastName"]); Console.WriteLine("Birthday: {0}", entityInstance["BirthDate"]); Console.WriteLine("Email Address: {0}", entityInstance["EmailAddress"]); } Find information for the BCS Client Object Model Model XML in Visual Studio names of methods and fields SharePoint Designer → Operations View Central Administration → Business Data Connectivity Service shows namespace and entity names Use the BCS SSOM Namespaces using Microsoft.SharePoint; using Microsoft.SharePoint.Administration; using Microsoft.BusinessData.Runtime; using Microsoft.BusinessData.MetadataModel; using Microsoft.SharePoint.BusinessData.SharedService; Query using SSOM var list = SPContext.Current.Web.Lists.TryGetList("List Name"); if(list == null) return; var query = new SPQuery(); query.ViewFields = @"<FieldRef Name='CustomerKey' /><FieldRef Name='Email Address' />"; query.RowLimit = 10; var listItems = list.GetItems(query); foreach(var item in listItems) { Console.WriteLine("{0}", item["EmailAddress"]); } Query using BDC Object Model // get reference to LOB list var siteUrl = "http://<server>/<site>/"; var bdcService = SPFarm.Local.Services.GetValue<BdcService>(); IMetadataCatalog catalog = bdcService.GetDatabaseBackedMetadataCatelog(SPServiceContext.Current); IEntity entity = catalog.GetEntity(siteUrl); // get entity ILobSystem lobSystem = entity.GetLobSystem(); ILobSystemInstance lobSystemInstance = lobSystem.GetLobSystemInstances()[0].Value; var identity = new Identity(11000); IEntityInstance entityInstance = entity.FindSpecific(identity, lobSystemInstance); // read entity properties Console.WriteLine("Customer Key: {0}", entityInstance["CustomerKey"]); Console.WriteLine("Name: {0} {1}", entityInstance["FirstName"], entityInstance["LastName"]); Console.WriteLine("Birthday: {0}", entityInstance["BirthDate"]); Console.WriteLine("Email Address: {0}", entityInstance["EmailAddress"]); Important Classes Entity LobSystem LobSystemInstance EntityIdentity, Identity Use BCS REST Needs a BCS List Creating a BCS List ist not possible via REST Supported Verbs are: GET, PUT, POST, DELETE Access Data with REST Call URL Description _api/list/getbytitle('listname') get the metadata for the list _api/lists/getbytitle('listname')/items get all items from the list _api/lists/getbytitle('listname')?select=Title get the title of the list _api/lists/getbytitle('listname')/items?$select=Title get the titles from the items in the list _api/lists/getbytitle('listname')/items?$select=Title&$filter=ID eq 35 get the title of item with id 35 var url = "/sites/examprep/_api/lists/getbytitle('Adventure%20Works%20Customers')/items?" + "$select=CustomerKey,FirstName,LastName,BirthData,EmailAddress&Filter=CustomerKey eq 11000"; $(function(){ $.ajax({ url: url, method: "GET", headers: { "Accept": "application/json; odata=verbose" }, success: function(data) { var results = "Customer Key: " + data.d.results[0].CustomerKey + "<br />" + "Name: " + data.d.results[0].FirstName + " " + data.d.results[0].LastName + "<br />" + "Birthday: " + data.d.results[0].BirthData + "<br />" + "Email Address: " + data.d.results[0].EmailAddress + "br />"; $("#BcsRestDiv").html(results); } }); }); See also: REST API reference and samples. In: Office Dev Center. Microsoft, 17. April 2014, abgerufen am 17. Juni 2014 (englisch).  Implement Client-side BCS Use Microsoft Office Apps, Microsoft Visual Studio Tools for Office Microsoft Office App can access SharePoit Data via REST API or JavaScript Object Model (JSOM) Microsoft Office can be extended via a add-in Use Caching, Use SQL Replication, Implement Authorization and Authentication BCS uses a client cache based on SQL Server Compact Edition. Will be installed with Microsoft Office. BCSSync.exe is responsible for sync operations. consider: Performance Security References