MS SharePoint / SQL refers to Microsoft Sharepoint, a web-based collaborative platform, being used in tandem with Microsoft SQL Server to provide business intelligence analytics and reporting. They can provide BI content such as data connections, reports, scorecards, dashboards, and more.
N/A
TARGIT
Score 7.6 out of 10
N/A
TARGIT Decision Suite is a business intelligence (BI) and analytics platform used to automate reporting, boost operational visibility, and give teams insights that support data-driven decisions. The solution combines data from multiple source systems, including enterprise resource planning (ERP) software, customer relationship management (CRM) platforms, and all other data sources to give organizations a complete picture of their operations. …
SharePoint is more reliable in terms of data storage, security, and accessibility by only required users compared to ClickUp. Also, SharePoint is easier to learn and use for any user, as tutorials are easily available online. Also, SharePoint is a product of Microsoft, which …
Simple: MS Sharepoint/SQL is the best and robust databases motor now are incorporating some features in order to improve users and DB admins experience.
Box is a content storing portal where you can host and share documents/files to others. But it does not have [Sharepoint's] capabilities like... versions, automation, email approvals, etc. And Microsoft Exchange is a mailing database that can be used for exchanging data using …
Has better support than MySQL and more developers are familiar with it. Oracle syntax is more cumbersome and less developers are experienced these days with Oracle.
If you are looking for a document management and collaboration tool to use as a web portal that comes with SQL data base and easy to manage and something you can learn very quick, look no further than SharePoint but if you need a pure database then this is not for you.
We use MS SQL more just because of how widely it's used and how popular it is. It's easier to install, maintain, and support compared to the other ones we've tried.
Vice President, Chief Architect, Development Manager and Software Engineer
Chose MS SharePoint / SQL
At the time of the two large projects, SharePoint was the enterprise solution so we were required to use that. We have since lobbied the enterprise teams to review and consider Atlassian confluence and were successful. Confluence is cheaper than Sharepoint which is why we …
At its core, MS SharePoint (with SQL) is for managing document-based content. It falls just short of being a best in class records manager (it does offer some features for this though), and it isn't the easiest to solution to make great looking modern and engaging web sites. …
We looked at Google Drive but it didn't have the API and integration that SharePoint has with 3rd party software providers. Also, Google Drive has basic functionality compared to MS SharePoint and how you can customize and build-out.
I haven't used any other products that compete with it. I started my career at Microsoft and the two subsequent locations have also been Microsoft shops.
Dropbox is a user-friendly product, but Sharepoint is a native Microsoft product that can be implemented into any Microsoft products, which are used mostly in our environment. Finding solutions on the internet is much easier, as it is used commonly by other organizations as …
I have used both Google Drive and Zoho Docs which seem similar to MS SharePoint. The main differences I noticed as a user is that the user interfaces in both Google Drive and Zoho Docs were much more intuitive and they were much easier to navigate than MS SharePoint. There …
We had staff resources able to create, configure, and mange our sharepoint environment, so it made sense for us and gave us greater flexibility than these turnkey solutions. Certainly each solution has its merits and each are completely different price points. We already had …
We evaluated Atlassian Confluence and compared it to our current SharePoint implementation. We felt that the two products were quite similar in the user experience but we chose to keep our SharePoint farms up and running. This was mainly due to the cost of switching and the …
Targit's in-memory suite of tools can process data very fast. We selected it for the speed of data processing, and availability of all ETL, cube, and reporting capabilities in the same product.
While their product is top of the line and works very well for us, we ultimately selected Targit because of their team. We love working with them and they are always super helpful. Whenever we have a request or issue, they are there ready to happily help us resolve it and move …
Targit was more expensive, but it was going to be easier for us to add more data sources (Google Analytics in particular) than Jet Reports would have been. I also liked the reporting interface in Targit much better; the ability to click on elements in an object to dynamically …
It really met our business requirements when we were searching for a reporting/Bi tool and the flexible business model of being able to introduce additional functionally as your organization grows and requires it made the investment decision the right one for us. The …
TARGIT is as user friendly as SAP BW, and more user friendly than Crystal Reports. The downside of both TARGIT and BW is that you're limited to the data points provided by IT.
As I mentioned in my previous answers, MS SharePoint is very useful as a shared drive for the organization and is very easy to manage. It also helps us import data from SharePoint directly into PowerBI for creating reports. According to my understanding, only share link features should be improved.
Overall, TARGIT is a valuable tool, and more and more associates are realizing this every day. It's become our standard for sales reporting. I would recommend the software for use at other companies, and I often encourage fellow associates to gain access and basic training.
The in-memory cube in the Targit suite is an excellent tool that can replace SSAS in theMicrosoft BI suite of tools. InMemory aggregations are lightning-fast compared to Microsoft SSAS.
Targit also has a cool HTML5 reporting tool.
It is a complete suite of BI tools including ETL, cube and reports.
I think including the Data Discovery module in the base package instead of charging extra for it would go a long way to making the software better. If you don't have much background with SSIS or SSAS and you do not buy the module, it will be difficult for you to add or modify data sources.
There are a couple small tweaks to the interface that would be helpful but are far from necessary. For example, unlike an Excel pivot table, you cannot move the measures above the dimensions in a table interface. There are workarounds for this, however.
I understand the need to make their calculation language as complex as it is, but it still seems like it could be made simpler. It's helpful that it comes with several standard calculations that you can easily add to an object, but if you want to modify a calculation or create your own, it can be more complicated than I would like.
This was a long-term buy-in from a corporate perspective, to remain in the SharePoint space. Migration is certainly possible, which is good for planning and having options further out. At this point, the only planned migration is to eventually move the architecture up to SharePoint/SQL 2013. At that point, we will be able to leverage some greater efficiencies, some enhanced content design and management features, and some more current social features. It is well worth a full consideration in any shop looking at a new implementation of or migration to SharePoint (although you will probably be considering 2013 versions or beyond in those discussions), but the platform should be a strong competitor to any alternatives. Realizing the capability of a fully-branded and customized website was not part of the original choice for the architecture at Lincoln, but seeing it implemented and functioning now with this capacity far beyond original expectations has certainly cemented plans to continue using it.
The use of Targit is widespread throughout our organization. Our users are becoming comfortable with the tool and Targit has allowed our company to truly grasp the concept of Business Intelligence and making better business decisions through the analysis of our data. Our users are not waiting for IT to create reports for them, they have full rich self-service BI with Targit and are able to turn a great analytical idea or ad-hoc query hypothesis into concrete answers with actionable responses within minutes.
I gave this rating due to MS SharePoint being a big help with our userbase. We have a lot of users that are just old enough to not have much technical skills or they have been in this industry long enough to where they haven't really needed to utilize much technology. MS SharePoint helped us move beyond that barrier without too many bumps and bruises.
Everything on the back end needs to be correct, which sometimes it may not be set up or missing some variables. Some of the more difficult parts of Targit require a lot more attention and object creation to work properly
I've only had to call in to support on one occasion but they were able to work though our issue and find a solution that did fully resolve the issue in a timely manner. I can't always say the same about support from other companies so it was a refreshing change to have support that did help.
Everyone I've dealt with at Targit genuinely cares about me and my success, and they respond to questions quickly and accurately. There is literally nothing more I could ask for from their support.
Make sure all of the back end work is done prior to getting Targit set up. Every variable you may need for calculations needs to be correct and every item needs to be uniform so it is read properly.
At the time of the two large projects, SharePoint was the enterprise solution so we were required to use that. We have since lobbied the enterprise teams to review and consider Atlassian Confluence and were successful. Confluence is cheaper than Sharepoint which is why we wanted to bring that in. The enterprise has now made Confluence an enterprise solution as an alternative to SharePoint. After using both I think SharePoint has many more add-ins than Confluence. It has much more customization ability than Confluence. SharePoint is not good for mobile readiness. Confluence is so there is a difference that might lead you to Confluence over SharePoint. I would also say that SharePoint is very document-centric and that Confluence has better KM than SharePoint does. even with the use of SQL Server. We were told that we could not use Google Drive even though it had features we liked.
While their product is top of the line and works very well for us, we ultimately selected Targit because of their team. We love working with them and they are always super helpful. Whenever we have a request or issue, they are there ready to happily help us resolve it and move forward.
It really has answered questions during decision-making conversations where a task item would have been created with days of turnaround time instead of getting the necessary information within minutes during that same conversation.
Unified Reporting that maintains in alignment with business needs.