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.

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

SharePoint Hosting. SharePoint 2013 and Yammer – best social tools for your company.

SharePoint 2013 and Yammer – best social tools for your company

SharePoint 2013 Yammer
SharePoint 2013 Yammer
SharePoint 2013 Yammer, Yammer SharePoint 2013, Yammer SharePoint, SharePoint 2013 Yammer, Yammer SharePoint integration, Yammer and SharePoint
Hello,
As you know, the future of big projects is in social collaboration. All large companies try to make communications inside of the organization simple and productive. So, the question is “Which tool should we use for social collaboration – Yammer or SharePoint 2013?” is the one most asked and discussed. Let`s try to understand this question and answer it in this post.

Yammer

Yammer is a private social network for your company. Please see the following list of the main Yammer features:

  • Yammer groups. You can setup a Group for all teams, projects or interests. There are two great features such as Quick Access and Announcements you can use in Groups.
  • Yammer user profiles. Share your knowledge or find the experts you need more easily. Add managers and reports to create a company chat together with your employees. Leader boards display people with the most messages, replied-to messages, and liked messages.
  • Yammer conversations. You can share an update, add documents, post pools and notify other co-workers by looping them into a conversation using @their_name. See who’s online now and start a private discussion with one or more employees.
  • Yammer document collaboration. Share MS Office documents, PDFs, images and videos across team and get feedback from them. Collect notes and view all the edits made to a document. Additionally you can email a file and mark files as official and read-only.
  • Yammer external communication. Great option! You can create a dedicated online workspace to collaborate with business contacts outside of your company and you can easily switch between internal and external networks.
  • Yammer security. Bring the look and feel of your company. Easily manage access to your Yammer network, sync directories, manage and export network data according to company policies. Set password policies and use the session management to see users devices are logged into with possibility to log them out.
  • Yammer Apps. Connect all of your business applications with Yammer.
  • Yammer devices. Access Yammer on Web, Mobile, Desktop.

Read more at Yammer features.

SharePoint 2013

SharePoint is a platform for a social intranet portals collaboration. Please read more about SharePoint 2013 features.

SharePoint 2013 vs Yammer. Microsoft social tools comparison.

Microsoft continues to release updates to both social tools and will continue to innovate no matter which platform you chose and use. As for the question I mentioned above, here is the most popular answer on it:

  • If you have no restrictions, use Yammer.
  • If your organization needs to use a dedicated hosting tool, using SharePoint 2013 social features is the best way to meet it.

Yammer is more flexible for collaboration with external partners or customers. If you want to initiate real-time participation and sharing events, meetings or reviews use Yammer with its out-of-box options. But if you want create an intranet portal with the same templates, structured information and web parts – the best tool for you is SharePoint 2013 with social features. SharePoint content is more structured and there are additional options you can use, like workflows, forms, web parts.

Currently, Microsoft is working on the integration between Yammer and SharePoint. After it is finished you would be able to get all best from these two social tools. But now, let your teams decide which of these social platforms is best to use. Please keep in mind that your team is the best decision maker of technologies for your organization.

PlexHosted has a great option for you! You can integrate Yammer with PlexHosted Dedicated SharePoint servers.

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

References:

Yammer features
Dedicated SharePoint tool

SharePoint 2013 and Yammer integration
SharePoint 2013 and Yammer integration

SharePoint Hosting. Data visualization in SharePoint 2013

SharePoint 2013, SharePoint data visualization, SharePoint hosting, data visualization in SharePoint 2013

SharePoint data visualization
SharePoint data visualization
SharePoint 2013, SharePoint data visualization, SharePoint hosting, data visualization in SharePoint 2013
Hello,
Probably you know that SharePoint is a platform that can help you share and organize your company’s reports, documents, etc. But did you know SharePoint can also help you visualize data for your employees.

SharePoint 2013 Power View

You can use PowerView to build and share a dashboard that visualizes your data for your team. You publish the dashboard to your company’s site, so you don’t need to setup any additional security. Please see more details at the following Microsoft video:

Video: Discover – visualize data

PlexHosted’s demo site with PowerView and SharePoint data visualization

Please see PlexHosted’s demo site with PowerView and SharePoint data visualization using the following credentials
URL: http://powerpivot.plexhosted.net
Username: demo@plexhosted.net
Password: p@ssword1

PlexHosted free trial of SharePoint Enterprise with PowerPivot and Power View

Sign up today for a 1-month free trial of SharePoint Enterprise with PowerPivot and Power View data visualization to test all SharePoint business intelligence features for yourself.

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

References:

PlexHosted’s demo site with Power View and SharePoint data visualization
Free trial of SharePoint Enterprise with PowerPivot and Power View data visualization
Video: Discover – visualize data

Data visualization in SharePoint 2013
Data visualization in SharePoint 2013