How to publish Access 2013 database on a SharePoint 2013 Enterprise site

We show you how to publish Access 2013 database on your SharePoint 2013 Enterprise site.

Start Access 2013. Open an existing database or create a new database. To create new database go to the New tab in the left navigation pane and then select Blank desktop database from the templates

How_to_publish_Access_2013_database_on_a_SharePoint_2013_Enterprise_site_1

2. Specify the name of the database and click Create

How_to_publish_Access_2013_database_on_a_SharePoint_2013_Enterprise_site_2

3. Edit your database tables as required

How_to_publish_Access_2013_database_on_a_SharePoint_2013_Enterprise_site_3

4. Select the table name and right mouse click. Select Export at the drop-down menu and then select SharePoint List

How_to_publish_Access_2013_database_on_a_SharePoint_2013_Enterprise_site_4

5. Specify a SharePoint site URL. Specify a name for a new list, check the box Open the list when finished and then click OK

How_to_publish_Access_2013_database_on_a_SharePoint_2013_Enterprise_site_5

6. Your new database list will open in browser. Click on Stop to stop editing this list and to finish publishing the database

How_to_publish_Access_2013_database_on_a_SharePoint_2013_Enterprise_site_6

To start using it check our Sharepoint Enterprise Plan (Public Sites Included):

https://plexhosted.com/services/hosted-sharepoint-2013/hosted-sharepoint-enterprise-2013.html

 

Microsoft SharePoint 2013. Creating a PowerPivot gallery

Hi, You may be interested to know how to create PivotPivot gallery.

  1. Login to the SharePoint 2013 site as an administrator
  2. Click on the Settings icon and choose Site Settings from the drop-down menu

BI_gallery_1

3.  Navigate to the Site collection features under Site Collection Administration header

BI_gallery_2

4. Make sure that PowerPivot Integration for Site Collections feature is activated. If not, activate this feature

BI_gallery_3

 

5. Click on the Settings icon and choose Add an app from the menu

BI_gallery_4

6. Choose PowerPivot Gallery app

BI_gallery_5

 

7. Provide the name for your PowerPivot Gallery and click Create

BI_gallery_6

 

8. Now you can see that PowerPivot Gallery has been added to your SharePoint site

BI_gallery_7

 

Integrating SharePoint 2013 sites with external environment

Today we’ll talk about integration between SharePoint 2013 site and external non-SharePoint sites. A lot of our customers would like to provide their users with smooth access to specific documents or BI reports directly from external site bypassing default SharePoint authentication settings.

By default, there is the only way to share your site with external users – “Anonymous access” feature, which will make your SP site public. But this approach is not very good for security reasons. Besides, this option is quite expensive for sites with SharePoint 2013 Server edition.

Our team made some research and finally found an efficient and cost saving solution, we can offer our customers. One of the benefits of our solution is the fact, that our custom code is simple and flexible, you can easily change it to fit your requirements. Another good news are that all initial setup and configuration will be done by our team on our side as a part of our service :)

We offer:
* Ability to show SharePoint content on external site via iFrame
* Ability to access SharePoint sites without login prompt via direct link
* Simple and flexible code that you can use to show only required information
* Ability to implement SSL certificate for SharePoint site
* Custom login form with Form Based Authentication for your SharePoint environment

Interesting, isn’t it?

Now I will show a couple of examples of solution’s behavior.

Bypassing SharePoint authentication:
1. If User Name, Password and Destination URL are sent in URL as parameters, user will be authenticated automatically and redirected to destination URL.
2. If User Name or Password or Destination URL parameters do not exist in URL, user will be redirected to default authentication form.

Showing your SharePoint resources on external portal:
To show part of the site via iframe (i.e. BI reports), just put the following code to your page as iframe window:
<iframe width=”100%” height=”100%” src=”URL-OF-YOUR-REPORT-OR-PAGE” #CustomPart code part#>
You can change the “src” part to show another part of your site.

So, how can you start using this solution?

https://plexhosted.com/business-intelligence/multi-tenant-solutions.html

The minimal requirements are:
* 1 SharePoint 2013 service with PlexHosted.
* 2 SharePoint user accounts
* 1 Dedicated SharePoint Web application
* 1 dedicated IPv4 address
* If you already have a SharePoint 2013 site you can easily migrate it to PlexHosted. This option is free of charge.

If you are interested in this service, please contact us we are online 24/7/365.

Simple tricks for BI site visualization

Some of our clients use their BI sites to develop PowerView reports for more than one user with different permissions.

For example, BI site for company, which has 5 different sales department.
SharePoint BI sites have a good feature, called PowerPivot gallery, which you can use to host your reports. Today we’ll speak about interesting approach, how we can extend its capabilities, using simple “Promoted Links” app.

Imagine the situation.
We have:
1. Single SharePoint 2013 BI site.
2. 5 different departments which should access BI reports only for their department. As example “RegionName Sales Departments”.

The simple solution is to create 5 separate sub-sites and put links to the main site. But if you want to create an illustrative site this is not enough. We can use “Promoted Links” app to make BI site more expressive and focus users directly on the required information to increase their efficiency.

“Promoted Links” app allows you to show links to other location on the page, but the main point is the possibility to assign pictures and description to these links. So the end user will see the nice logo with floating description instead of a strict link.

Let’s start:
1. Open your BI site.
2. Click Settings icon and click add an app, select “Promoted Links” app.
3. Click new item. Here you can specify the Title, the link to preferred logo, and a brief description for the link.

Picture1Pretty simple, isn’t it?
Now the interesting part goes.
Here we can put not only the links to the sub-sites, but direct links to the PowerPivot galleries of the department or even links to the single reports. This is good, because you can show the entire sub-site for the user from the larger department (with bigger amount of data) and show only one needed report for the smaller one.
This is the good way to focus the attention of the end users just on their information.

Also we can use RSDS reports to hide all “excel signs” if necessary. You can read previous post about it.

Let’s proceed and setup links.
4. Create 5 items for 5 departments. In our example they are “RegionName Sales Departments”

Picture2Nice view, isn’t it? I think that this approach will make your BI site more “human friendly” and at the same time more efficient.
5. Now let’s define the “Landing Page”, where we want to show these items. For example, let’s show it on our home page.
Also we can hide this app from the quick launch menu. To do so go to -> list -> List settings -> List name, description and navigation.
6. Open home page and click edit page. Click “Insert”, then “App part”.

Picture37. Select “Promoted Links” app.
8. Set the proper title size etc. for this web part.
9. Click Save, and Stop editing on the upper ribbon.
We’re done, you will see the webpart on your home page.

Picture4The last part is to configure the proper permissions for users and grant them access to their pieces of information. This is something that depends on your company structure.

Hope this article was interesting for you.

How to hide all signs of “MS Excel” on your Business Intelligence reports

Sometimes our clients want to hide all signs of “MS Excel” on their BI reports, or just show the report on the full screen.

How to hide all signs of “MS Excel” from your Business Intelligence reports

The reasons are different, but in most cases they don’t want end users to know, that reports were made in MS Excel application. After some research and practical attempts we’ve found that this is not possible, even using custom code. The good news are that there is a good built-in “workaround” inside a SharePoint, the bad news – this option is not showing on the site by default.

This “workaround” is RSDS (shared data source) connection file. Reports based on the RSDS connections provide all PowerPivot/BI capabilities, but without any signs of “MS Excel”. Today we’ll tell you how to enable the RSDS connections and use them to create reports.

By default the *.Rsds file content type does not appear as a new item dropdown in the Data Connection library. So our first step will be to configure the Data Connection library to include the Report Data Source Content type.
1. Navigate to the document library in which you are going to create your RSDS connection file and Power View report
2. Go to the Library tab and click on Library Settings.
3. Navigate to the Advanced Settings.
4. Choose Yes under Allow management of content types, and click OK.
5. Under the Content Types click on the Add from the existing site content types hyperlink.
6. Choose Report Data Source from the available site content types, click Add and then OK.

So, the first part is over. We’ve enabled the RSDS connections for the Data Connection library. Let’s proceed and create RSDS connection file.

1. Return to your document library, in the Files tab click New Document and choose Report Data Source.
2. Enter the name for your RSDS file and choose Microsoft BI Semantic Model for Power View from the Data Source Type menu.
3. In the Connection String field enter a pointer to the data source in the following format: (Data Source=http://yourdomain.com/Shared Documents/YourWorkbook.xlsx).
Optional: If you are using a workbook from the PowerPivot Gallery the pointer will be like: (Data Source=http://yourdomain.com/PowerPivot%20Gallery/YourWorkbook.xlsx).
4. In Credentials leave Windows authentication (integrated) or SharePoint user option selected and click on Test Connection. If connection created successfully, click OK.
5. Now you can see your shared data source (RSDS) connection file.

We’ve successfully enabled and created a first RSDS connection file. So, let’s proceed and create our PowerView report.

1. Return to your document library where RSDS connection file was created.
2. Click on the RSDS connection file to start creation of the Power View report.
3. Customize your report according to your goals.
4. Create your report and click on Save as in the File menu.
5. Now you are prompted to save report to the document library. Provide the name for your report and click Save.
6. Return to the document library and refresh the page. You can see your Power View report created using the shared data source (RSDS) connection file.

That is it. We’ve created a PowerView report with no signs of “MS Excel”, only your beautiful data :)
Hope this post will help you to improve your SharePoint skills.

New Cloud Offerings from PlexHosted

PlexHosted Unveils New Cloud Offerings to Enhance Collaboration and Improve Productivity Across the Enterprise

Company’s managed hosting solutions make the cloud practical and affordable to businesses of all sizes; no more one-size-fits-all cloud at sky-high prices.

Jamestown, R.I. – March 10, 2015 – PlexHosted, a developer of robust managed cloud-hosting solutions for better enterprise collaboration, today unveiled enhanced cloud offerings solutions for business, ensuring the cloud is both practical and affordable to organizations of all sizes.Cloud migration can be daunting for small and mid-sized businesses, especially when faced with expensive service offerings from large vendors and filled with capabilities they don’t need. PlexHosted’s new hosting solutions provide the same quality of management as larger vendors, but at a much more attractive price.

PlexHosted’s new standalone farms start at $279 per month, which is 10% less than its nearest competitor. It’s two-tier farms (from $628), three-tier farms (from $877), and HA farms (from $1,799) also all show significant savings from average market prices. Those fees include 24/7 server(s) and services monitoring as part of the service – there are no additional set-up and hourly support fees as found at many other vendors. PlexHosted delivers cloud IaaS solutions and manages the farm all at one low monthly price.

In order to ensure optimal performance for businesses utilizing enterprise software platforms, PlexHosted has implemented Microsoft’s recommendations for the hardware used to support software like SharePoint, Exchange, and Lync. The result is a platform that performs better and works faster, ensuring customers are able to continue to achieve the business productivity they require.

Some of the technical improvements include faster RAM; a CPU core ratio now dedicated as 1vcpu = 1 physical core; increased HDD IO speed; and cloud machines that can now utilize a 1GB network for both public and private transfers. All of this allows for an almost immediate customer deployment and speedy hardware upgrades.
PlexHosted also utilizes geo-location in order to deploy servers both in the United States and globally, including Washington D.C., Houston, Dallas, San Jose, Seattle, Montreal, Toronto, Mexico, Tokyo, Shanghai, Hong Kong, Singapore, Sydney, Melbourne, London, Amsterdam, Paris, and Frankfurt.

For a complete breakout of the new offerings and service plans please visit PlexHosted’s website

SharePoint 2013 BI and MySQL

SharePoint 2013 BI and MySQL, Multi-Tenant PowerPivot 2013 Hosting, PowerPivot data refresh in SharePoint 2013

 SharePoint 2013 BI and MySQL
SharePoint BI and MySQL
SharePoint 2013 BI and MySQL, Hosted SharePoint 2013 BI, SharePoint and MySQL, Multi-Tenant PowerPivot 2013 Hosting, PowerPivot data refresh in SharePoint 2013, Real time BI

PlexHosted is pleased to announce support for the connectivity of SharePoint hosted workbooks to open source MySQL database server. Now our customers are free to use MySQL as an external data source in their PowerPivot and PowerView reports with our multi-tenant SharePoint 2013 BI service.

PowerPivot data refresh in SharePoint 2013

PlexHosted PowerPivot solutions provide interactive and scheduled data refresh of PowerPivot workbooks from the latest information and data sources. The importance of receiving information in a timely fashion is obvious for business owners, isn`t it?

SharePoint 2013 Business Intelligence and MySQL database server

As always PlexHosted continues to improve the quality and scalability of its services as well as its expertise in the SharePoint Hosting industry. Previously, data refresh from MySQL was available only in dedicated SharePoint environments. Now you can easily connect a workbook to your MySQL database, upload it to your hosted SharePoint site, and have your business critical data always up to date.

Real-time Business Intelligence 2013, integration of data from various data sources, analyzing large amounts of information, effective sharing and collaborating with the most recent data, great data visualization, exceptional performance, and customer support available 24/7/365 are among the capabilities available with PlexHosted and its SharePoint 2013 BI services.

Use SharePoint 2013 Business Intelligence with PlexHosted – improve your business!

References:

SharePoint 2013 Business Intelligence Overview
SharePoint 2013 Business Intelligence

SharePoint 2013 BI and MySQL
SharePoint 2013 BI and MySQL, PlexHosted – Hosted PowerPivot Data in SharePoint 2013

What is SharePoint? SharePoint sites and SharePoint project management

What is SharePoint? Five Common Ways to use SharePoint sites

PlexHosted SharePoint
PlexHosted SharePoint site
What is SharePoint, SharePoint project management, Intranet SharePoint sites, Public SharePoint sites, SharePoint site
Hello,
Today I would like to talk about common ways to use SharePoint.

What is SharePoint? SharePoint history

SharePoint was launched by Microsoft in 2001 and it was called “SharePoint Portal Server 2001”. The first release of SharePoint was supposed to be a platform for document and content management. Over a decade has passed since that time and SharePoint has undergone multiple changes. The latest release of SharePoint has far more functionality. Nowadays it is usually called a business collaboration platform or application platform. Since SharePoint combines in itself various technologies, solutions and numerous features, it is extremely difficult to give an exact definition to what SharePoint is and what it is used for. In the internet you can find dozens of definitions and explanations.
Depending on the type of business, a SharePoint platform can serve different purposes. It is a centralized system that can be accessed through multiple devices connected to the internet, therefore the most significant function of SharePoint is to join all your employees from different departments, offices, buildings, cities or even countries, and provide them with a single place to complete their daily jobs and communicate with each other.
SharePoint brings benefits not only to large companies with multiple users, but also to small businesses of any type.

Common ways to use SharePoint sites

We can distinguish the following most common ways to use SharePoint:

Document and content management system – from the very beginning until the present day, SharePoint platforms are continuously used by many companies as a file share system with advanced settings. A centralized place where documents and files can be securely stored and easily accessed by end users, a role based security system and other powerful content management features draws the most attention from customers.

Company intranet SharePoint – most successful company intranet portals are built on a SharePoint platform. SharePoint provides tools for social networking, creating blog sites and company wikis. It provides an environment convenient for receiving the latest company news, announcements, scheduling and managing personal tasks, contacts and verifying the statuses of the latest projects.

Public facing website – SharePoint can also be used as a platform for a company’s website. It allows the creation of multiple publicly available pages with company information, text, images and graphics. SharePoint supports advanced HTML editing and all modern web technologies. This results in the ability to run a 100% custom branded site. SharePoint publishing features enable administrators to control the content, design and update pages, as well as manage permissions for the site.

Team collaboration – SharePoint is a perfect tool for your teams to coordinate on projects, connect to sites from different devices and receive notifications about updates. SharePoint allows team members to stay connected to the process, check project statuses, schedules, communicate with each other and access all information related to the project.

Business Analytics – SharePoint Business Intelligence features provide the ability to get critical information from the insights and, subsequently, to enhance productivity, improve decision-making and increase profits for the company. SharePoint allows the creation rich dashboards, graphs and charts, display trends, setup key performance indicators and a lot more to analyze company data.

And last but not the least, SharePoint can be customized for a company`s specific use. It can be adapted to perform functions that meet the needs of your business and are critical for your company’s success.

Start with the PlexHosted SharePoint hosting today and improve your business tomorrow!

References:

PlexHosted SharePoint sites

PlexHosted SharePoint. What is SharePoint
PlexHosted SharePoint. What is SharePoint

PlexHosted team wishes you Merry Christmas!

PlexHosted SharePoint Merry Christmas
PlexHosted SharePoint Merry Christmas

There’s no more right time as these days in December to thank you for reading PlexHosted official blog, your interest in PlexHosted managed hosting services and wish you much peace and great joy during this holiday season.

At the end of 2013 year, we realize this milestone was made possible by the support of clients, friends, and associates like you. As we face these changing times together, we look forward to a partnership of continuing success.

PlexHosted wishes you the greatest professional and personal accomplishments, health and prosperity! Merry Christmas!

With love your PlexHosted team!