Difference between revisions of "Information Required to Install DataSelf BI"

From DataSelf Knowledge Base
Jump to navigation Jump to search
(Dedicated User to Run Windows' Services)
 
(25 intermediate revisions by 3 users not shown)
Line 2: Line 2:
 
[[Category:Installation]]
 
[[Category:Installation]]
  
== Information Required to Install DataSelf BI ==
+
 
 +
 
 
A checklist of information required in order to install DataSelf BI at a new client site.
 
A checklist of information required in order to install DataSelf BI at a new client site.
  
=== DataSelf BI Solutions to Install ===
 
  
* DataSelf Reporting Packages we are installing at this time.
 
** Prioritized list of DataSelf Reporting Packages, listed in order of installation.
 
  
=== Client Contacts ===
+
= DataSelf Server =
* Client Team members. &nbsp; &nbsp;  For team each member please provide name, title/role, email address, phone number(s).<br />
+
* The DataSelf Server is a Windows Server environment to host the DataSelf server-side software (DataSelf ETL, SQL Server data warehouse and DataSelf Analytics Web Server). This might be a single or multi-server environment.
** Project Manager For each member please provide name, title/role, email address, phone number(s).<br />
+
* Click '''[[DataSelf System Requirements]]''' for details.
** Project Manager
+
 
** IT support
+
 
 +
=== Remote Connection to DataSelf Server ===
 +
* Remote login. User name, password and other information required to make a remote connection to the server platform hosting the DataSelf solution. The Windows user to log on to the DataSelf Server should be an '''Active Directory''' user (when applicable) and have:
 +
** '''Local administrator''' right on the DataSelf server.
 +
** If your are providing MS SQL Server, '''Sysadmin''' role in the MS SQL Server instance to host DataSelf's data warehouse.
 +
** '''Reading rights''' from all source databases.
 +
 
 +
 
 +
=== Service Account to Run Windows Services ===
 +
Create a service account (a new dedicated user) for running DataSelf Analytics software components. This dedicated user will only be used by Windows' services (such as SQL Server and SQL Agent Windows services), not by a "real person":
 +
* It is easiest to work with a '''domain user''' (a local Windows user can be used, but it might have limited access to read data from other servers).
 +
* This user should have '''Windows Local Administrator''' rights.
 +
* This user's password should be set to '''"Password never expires"'''. If the client assists in setting up the following logons, the client does NOT have to tell the installer the password.  
 +
 
 +
During or after the installation of the DataSelf Analytics software components, the dedicated user needs to be added to the following:
 +
* As the '''SQL Server Agent''' service logon user 
 +
* As the '''SQL Server''' service logon user
 +
* When SSAS Cube reporting will be used: as the '''SQL Server Analysis Services''' logon user
 +
* As MS SQL user with '''sysadmin''' role for the '''DataSelf data warehouse'''
 +
* '''Network and reading rights''' to any source data that will need to be automatically refreshed
 +
* The '''run as''' user for Tableau/DSA Web Server in its Configuration utility
 +
* Optional: also consider using it as the email user for Tableau/DSA Web Server in its Configuration utility, if in-house email credentials are being used
 +
 
 +
=== If You're Providing MS SQL Server to Host the DataSelf Data Warehouse ===
 +
Please provide the SQL Server instance name to installation team.
 +
Also, grant the Windows users discussed above '''sysadmin''' role on this MS SQL instance.
 +
 
 +
 
 +
 
 +
=== Importing Data from Source Databases ===
 +
Please provide the information below according to your source database(s):
 +
* '''MS SQL Server''': 1. SQL Instance name, 2. database name, 3. set the users described above to have reading rights from that database(s).
 +
* '''MS Excel''': 1. Excel file name and path, 2. set the users described above to have reading rights from that path.
 +
* '''MS Access''': 1. MS Access file name and file path, 2. set the users described above to have reading rights from that path.
 +
* '''Providex''': 1. 32-bit ODBC driver (by running the Workstation Setup for Sage 100 using our remote access Windows user), 2. database directory, 3. company code, 4. Username, 5. password.
 +
* '''Other ODBC''': 1. 32-bit ODBC driver, 2 other information and credentials required to read data from the data source.
 +
 
 +
 
 +
 
 +
=== Access to Port 80 and no IIS ===
 +
DSA Web Server works best on a dedicated box that '''doesn't''' have IIS or other applications using port 80. Read [[Internet Information Services (IIS)]] for further details. 
 +
 
  
=== Technical Information ===
 
* Will DSA Web Server's user login be Local or Active Directory? Most intranet installations on networks that use Active Directory use the Active Directory option. Internet installations will need further discussion.
 
  
===== Connecting to Host Computer Server =====
+
=== Other Host Server Configuration ===
 +
* A web browser (IE Explorer, Google Chrome, or Firefox) configured to allow file downloads. 
  
* Remote login. (As applicable)  User name, password and other information required to make a remote connection to the server platform hosting the DataSelf BI solution.
 
* Windows account name and password to logon to the host server.    Account should be an '''Active Directory''' user (when applicable) and a '''local administrator''' on the host server.
 
===== Data Sources =====
 
* Source company code used by source database as required. Requirement depends upon the {{egx|business system}} providing the data extracted by the ETL.
 
* Source database location information such as SQL instance, SQL db name, passwords.
 
===== Disk Drives and Directories =====
 
* Disk drives on which to install DataSelf BI programs and databases.
 
  
  
 +
=== Good to Have ===
 +
Configuration not required but recommended.
 +
* Copy of Microsoft Excel installed.  Alternative: Access to a copy on another server on the network.
  
----
 
  
'''See also [[Preparing the Host Server: CheckList]]'''
+
= DataSelf Client =
 +
* Users can access DataSelf data from desktop, web and mobile devices. 
 +
* Click '''[[DataSelf System Requirements]]''' for details.
 +
* Click [[DSA Desktop and Server Installation]] for the desktop client installation instructions.

Latest revision as of 17:20, 7 October 2016

A checklist of information required in order to install DataSelf BI at a new client site.


DataSelf Server

  • The DataSelf Server is a Windows Server environment to host the DataSelf server-side software (DataSelf ETL, SQL Server data warehouse and DataSelf Analytics Web Server). This might be a single or multi-server environment.
  • Click DataSelf System Requirements for details.


Remote Connection to DataSelf Server

  • Remote login. User name, password and other information required to make a remote connection to the server platform hosting the DataSelf solution. The Windows user to log on to the DataSelf Server should be an Active Directory user (when applicable) and have:
    • Local administrator right on the DataSelf server.
    • If your are providing MS SQL Server, Sysadmin role in the MS SQL Server instance to host DataSelf's data warehouse.
    • Reading rights from all source databases.


Service Account to Run Windows Services

Create a service account (a new dedicated user) for running DataSelf Analytics software components. This dedicated user will only be used by Windows' services (such as SQL Server and SQL Agent Windows services), not by a "real person":

  • It is easiest to work with a domain user (a local Windows user can be used, but it might have limited access to read data from other servers).
  • This user should have Windows Local Administrator rights.
  • This user's password should be set to "Password never expires". If the client assists in setting up the following logons, the client does NOT have to tell the installer the password.

During or after the installation of the DataSelf Analytics software components, the dedicated user needs to be added to the following:

  • As the SQL Server Agent service logon user
  • As the SQL Server service logon user
  • When SSAS Cube reporting will be used: as the SQL Server Analysis Services logon user
  • As MS SQL user with sysadmin role for the DataSelf data warehouse
  • Network and reading rights to any source data that will need to be automatically refreshed
  • The run as user for Tableau/DSA Web Server in its Configuration utility
  • Optional: also consider using it as the email user for Tableau/DSA Web Server in its Configuration utility, if in-house email credentials are being used

If You're Providing MS SQL Server to Host the DataSelf Data Warehouse

Please provide the SQL Server instance name to installation team. Also, grant the Windows users discussed above sysadmin role on this MS SQL instance.


Importing Data from Source Databases

Please provide the information below according to your source database(s):

  • MS SQL Server: 1. SQL Instance name, 2. database name, 3. set the users described above to have reading rights from that database(s).
  • MS Excel: 1. Excel file name and path, 2. set the users described above to have reading rights from that path.
  • MS Access: 1. MS Access file name and file path, 2. set the users described above to have reading rights from that path.
  • Providex: 1. 32-bit ODBC driver (by running the Workstation Setup for Sage 100 using our remote access Windows user), 2. database directory, 3. company code, 4. Username, 5. password.
  • Other ODBC: 1. 32-bit ODBC driver, 2 other information and credentials required to read data from the data source.


Access to Port 80 and no IIS

DSA Web Server works best on a dedicated box that doesn't have IIS or other applications using port 80. Read Internet Information Services (IIS) for further details.


Other Host Server Configuration

  • A web browser (IE Explorer, Google Chrome, or Firefox) configured to allow file downloads.


Good to Have

Configuration not required but recommended.

  • Copy of Microsoft Excel installed. Alternative: Access to a copy on another server on the network.


DataSelf Client