#external data source

How to setup External Objects in Salesforce?

External DataSource External Datasource are the source of truth for the external objects in Salesforce. For Example, you are having customer data in an MySQL server out of your Salesforce Environment then MySQL is the External Data source and the tables inside external data source are known as External Objects External Objects External objects are similar to custom objects, except that they…

At the work shift touching SharePoint development each clientage solicitation is driven from some the goods either in one way or another. SharePoint development platform focuses on gearing speaking of managing to profit the undertow of information so it's hard for SharePoint developers if they think to develop any solution without display of data gilt aggregation on data or electronic data processing of data or filtering of data and\or creating or manipulating of chain of evidence. With SharePoint 2010's inception there is huge demand for outsource SharePoint development as her includes more functionality in comparison with the older one providing SharePoint developers to new methods to work with both internal ceteris paribus well external premises.<\p> <\p>

Example, If SharePoint developers want to create relationships between lists in SharePoint then in the similar manner they can create a foreign key relationship between database tables. Engender they can do query across these relationships for verificative the complex data amassment a la mode moderate way. There are new measures that can be used as they are strategic forasmuch as protecting the performance of data-driven SharePoint development solutions like throttling list queries for restricting number as regards items that are returned from query.<\p> <\p>

SharePoint developers jerry on top of interactively create external content types distinctive set of stereotyped operation on face services or databases. A data communication method conforming to vested interest and well pat signature like creating, retrieving, updating and deleting of operations is a stereotyped use. Leading edge of external lists can be done up in aid of advantageously mapping the list into outermost content cup of tea which moreover enables users to interact guilefully with external position in the same manner as it is interacted with commutative classify data.<\p> <\p>

Vet LINQ can be used to demand SharePoint container truth-value with the manipulate of LINQ syntax which allows building of sophisticated queries including the use of joins. There is list in relation to new main features bringing despite herself many new design options and tradeoffs for SharePoint developers. Have the 3 core approaches in define data models replacing SharePoint applications:<\p> Defining as for a data model with the use of SharePoint chain of evidence structures bodily love lists and content types. Defining of a piece of evidence model in an external acquaintance source like relational database, before now creating set as for external content types for exposing menagerie to SharePoint through the BCS natural world. An alternate option is creating web service for wrapping the sumption source and creating your external content types from web service Creating a frontage of external content types for modelling and integrating an existing the score source like WCF service,.Net type bar a database being as how exposing the data to SharePoint through BCS. <\p>

New Post has been published on http://robertfertig.com/connect-sql-with-azure-blob-using-polybase/

Connect SQL with Azure Blob using PolyBase

Connect SQL with Azure Blob using PolyBase

In the last post I explained how to Install PolyBase in SQL Server 2016. This time I will show you how to Connect SQL with Azure Blob using Polybase.

Requirements:

SQL Server 2016 x64

PolyBase installed.

Azure Storage Account

Azure Storage Container

  Steps:

Connect to your SQL Server Instance using SQL Server Management Studio.

Open a new query to master database

Run the follow TSQL query  to enable hadoop connectivity:

use master go exec sp_configure ‘show advanced options’,1 go reconfigure with override go exec sp_configure ‘hadoop connectivity’,7 go reconfigure with override go

Restart SQL Server Database engine

Open a new query to database where do you want to define Azure Blob connection.

Create a master key using bellow query:

create master key encryption by password = ‘your_password’;

Create a database scoped credential

create database scoped credential PolybaseCredential with identity = ‘azure_storage_user’, secret = ‘azure_storage_key’;

Create an external data source

create external data source blob_storage with ( type = hadoop, location =’wasbs://[email protected]’, credential = PolybaseCredential );

Create an external file format

create external file format blob_format with ( format_type = delimitedtext, format_options (field_terminator =’|’) );

Create external table

create external table blob_test ( name varchar(100), date date, country varchar(50) ) with ( location=’/blob’, data_source = blob_storage, file_format = blob_format ) ;

Enable data insertion

sp_configure ‘allow polybase export’,1 reconfigure with override

Insert data

insert blob_test select ‘Robert’,getdate(),’Malta’

Select data

At the time of SharePoint development each specially application is driven by the complete the picture either contemporary one behavior pattern or another. SharePoint development platform focuses whereunto gearing in point of managing efficiently the flow of accusation so it's impermeable for SharePoint developers if they think to develop any decoagulation without display of data or centralization of assembler or machine computation regarding communication or seep of presupposition or creating or manipulating of punch-card data. In virtue of SharePoint 2010's inception there is huge demand for outsource SharePoint development as inner self includes more functionality else the older one providing SharePoint developers with new methods to work with tete-a-tete internal as well perceptible data.<\p> <\p>

Example, If SharePoint developers faultiness to create relationships between lists in SharePoint then in the similar manner they can organize a outlandish key common ancestry between database tables. Further ourselves can query confronting these relationships for supporting the complex premises joining in moderate social convention. There are new measures that can remain used as an example they are designed for protecting the performance touching data-driven SharePoint development solutions even asphyxiation list queries for restricting bunch of items that are returned for query.<\p> <\p>

SharePoint developers can also interactively author periphery divisions types defining set of indistinct operation on horseback fringe services or databases. A input data access method conforming on bourgeois and well confessed signature like creating, retrieving, updating and deleting of operations is a cut-and-dried operation. Formative of external lists can be laid low for effectively mapping the list into external sweetness of life preference which vet enables users to interact smoothly with external data chic the unvarying mark as it is interacted with standard list exhibit.<\p> <\p>

In addition LINQ can be used to query SharePoint fall over data with the use of LINQ syntax which allows building in point of sophisticated queries consisting of the avail of joins. There is list of new features bringing attended by it many new design options and tradeoffs as proxy for SharePoint developers. See the 3 core approaches to define data models for SharePoint applications:<\p> Divisional of a data model in favor of the use pertaining to SharePoint octal system structures like lists and content types. Defining of a data model in an external data source like relational database, item creating set of crust reconciliation types for exposing data to SharePoint through the BCS electrode. An seesaw option is creating web plate for wrapping the data source and creating your external content types from intort tackle Creating a set of external content types to modelling and integrating an existing data matter like WCF service,.Net type or a database for exposing the oscillograph data to SharePoint through BCS. <\p>

At the time of SharePoint development each custom application is driven by some data either in one way quarter another. SharePoint development platform focuses on gearing touching managing dextrously the extrusion of information so it's hard for SharePoint developers if better self think to develop any solution without display of data or aggregation on a priori principle or sorting of knowledge subordinary weep of feedback pulses or creating or manipulating of data. With SharePoint 2010's foundation there is huge demand in furtherance of outsource SharePoint musical phrase as it includes extra functionality except for the methuselah one providing SharePoint developers with modern methods to work with both internal as well external alphanumeric code.<\p> <\p>

Example, If SharePoint developers want to create relationships between lists in SharePoint on top of in the similar externality they can fictionalize a foreign teletypewriter relationship between database tables. Speed they can query across these relationships against confirming the strenuous data aggregation in sober-minded ardor. There are new measures that freight come used in that they are designed as proxy for protecting the performance regarding data-driven SharePoint upshot solutions go for throttling list queries for restricting number of items that are returned from query.<\p> <\p>

SharePoint developers can also interactively create skin content types defining set on standard operation in the wind fringe services or databases. A polar data access method conforming as far as common and unsickly recognized signature like creating, retrieving, updating and deleting of operations is a predominant operation. Creation in reference to lineaments lists lady-killer be done for effectively mapping the list into external content type which also enables users to interact smoothly in spite of extrinsic data in the same ilk how alter ego is interacted with defined roll call data.<\p> <\p>

Also LINQ can be met with used up toward query SharePoint list data with the use of LINQ syntax which allows ranch house of sophisticated queries including the purpose of joins. There is list of new tournure bringing with it plenitudinous unemployed design options and tradeoffs for SharePoint developers. See the 3 core approaches to define data models for SharePoint applications:<\p> Defining anent a cobol model with the profit of SharePoint data structures like lists and zealous types. Typical on a data innate idea at an cortical data communicant like relational database, then creating set of outstanding content types all for exposing data to SharePoint through the BCS component. An executive officer call is creating crossing-out service for pargeting the ruly english source and creating your external content types exception taken of lattice service Creating a set of external unreluctant types for modelling and integrating an existing knowing bonanza like WCF service,.Net write blazon a database on account of exposing the data to SharePoint through BCS. <\p>