1 / 47

Installation Instructions

Installation Instructions. Jet Enterprise. V4.10.07. Installation Process for Partners. This document describes the process for installing, executing and deploying a Jet Enterprise project. Hyperlinks like this one are used throughout to allow the user

murphy-williams
Download Presentation

Installation Instructions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Installation Instructions Jet Enterprise V4.10.07

  2. Installation Process for Partners This document describes the process for installing, executing and deploying a Jet Enterprise project. Hyperlinks like this one are used throughout to allow the user to move through the document in an effective manner. These will function when the presentation is viewed in ‘slideshow’ mode or ‘reading view’ The latest version of this document is included with the Jet Enterprise Download file If you have any questions or concerns please contact Support@jetreports.com Go to overview page Go to Download Page

  3. Overview of Installation Process Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter Tabs across the top of each page show the installation procedure. When viewed in “slideshow” mode or “reading view” these tabs can be clicked to navigate through the process. The process is intended to be completed by proceeding from left-to-right through the Execution of the project. After this step, the order of the process doesn’t matter. Some tabs have multiple slides. Arrow icons below the tabs can be clicked to navigate to the next slide Some tabs are specific to an ERP system (NAV, AX or GP). Follow these steps only if you are connecting to the specified ERP system. • Schedule project to be automatically refreshed

  4. Pre-Installation Checklist 1 of 2 To ensure a fast and successful deployment, please complete the following checklist Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter Details

  5. Pre-Installation Checklist 2 of 2 To ensure a fast and successful deployment, please complete the following checklist Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter Details

  6. Download files Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter The Jet Enterprise product download is available at http://www.jetreports.com/download/download.php • Select the link to “Download Jet Enterprise”. • Save the file and then unzip it. • This file includes two folders. The items needed for this installation are included in the Jet Enterprise - REQUIRED folder. • The Jet Essentials folder includes installation items for the Excel add-on product (Jet Essentials). Directions for installing this product are found at http://www.jetreports.com/download/download.php • Installer for 32-bit Jet Data Manager • Installer for 64 bit Jet Data Manager • Adapter for Microsoft Dynamics AX • Adapter for Microsoft Dynamics NAV (version 2009 and older) • Adapter for Microsoft Dynamics NAV 2013 • Business Function Library Note: Partners can download sample databases for demonstration purposes from the Partner Portal at: http://www.jetreports.com/partnerportalusa/partner-portal.php

  7. How to Install the Adapter for Dynamics NAV 4.0 SP1 through 2009 R2 1 of 2 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • This section provides details on how to install the Adapter for Dynamics NAV editions 4.0 SP1 through 2009 R2. • 2. Load Objects into NAV • Open NAV using a login that has access to the Object Designer • Open the Object Designer: "Tools -> Object Designer" • (If the button is greyed out you do not have permissions to use the Object Designer) • Open the Import Objects window: "File -> Import“ • Select the .fob file from step 1 and Open. • If the following dialog box appears, select Yes. • If the dialog box reports a conflict please contact Jet Reports before proceeding. Conflicts arise only when there is a newer or modified version of the adapter already present. Filepath Identify the location of the NAVAdapterSetup1.50 (14125100 Range).fob file from your Jet Enterprise Installation files

  8. How to Install the Adapter for Dynamics NAV 4.0 SP1 through 2009 R2 2 of 2 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • 3. Configure the Adapter • Select the "Form" button on the left side of the Object Designer and find the row named “Adapter Setup” • Click Run • In the "Standard Setup File" point to the text file from Step 1 that matches current NAV version (“AdapterSetup500.txt” for NAV 5.0, for example) • In the "Update Time", type in 1:00 and then click the mouse on the “Standard Setup File” field. This will format the time properly • Click the Functionsbutton and select Create Data • A window will appear that will allow you to bypass particular objects • Click Ok • If the process completes successfully without error close the “Adapter Setup” window. • If an error occurs see the Knowledge Base article on NAV Adapter Licensing

  9. How to Install the Adapter for Dynamics NAV 2013 1 of 3 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter This section provides details on how to install the Adapter for Microsoft Dynamics NAV 2013 Identify the location of the appropriate NAV Adapter.fobfile for your version of NAV 2013. Select the .fob file from the folder that matches your build of NAV2013 File Path • 2. Load Objects into NAV • Open Microsoft Dynamics NAV Developers Environment • Open the Import Objects window: Select File > Import • Select the file NAV Adapter.fobfrom Step 1. • A screen should appear stating “All objects have been examines and no conflicts were found”. Click Yes. • When the objects have been imported, click OK If the Import box states that conflicts were found click Cancel to cancel the import. This implies that there are already objects that exist in the range that will be imported. Contact your Jet dealer for further assistance.

  10. How to Install the Adapter for Dynamics NAV 2013 2 of 3 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • 3. Run the Jet Adapter Setup report • Select the Reportbutton on the left side of the Object Designer, click “Jet Adapter Setup” and click Run • In the File Name selection box point to the AdapterSetupNAV2013.txt file from Step 1 and click OK If an error occurs see the Knowledge Base article on NAV Adapter Licensing

  11. How to Install the Adapter for Dynamics NAV 2013 3 of 3 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • A window may appear stating that you need permissions to run an external component • Select “Allow for this client session” and click OK • A progress window will appear notifying you of the current process • This step may take several minutes to complete • When the process has finished a window will appear that says “Update complete” • ClickOK • The NAV Adapter has now ben successfully imported and executed and can now be used by the Jet Data Manager.

  12. How to Install the Adapter for Dynamics NAV 2015 1 of 4 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter This section provides details on how to install the Adapter for Microsoft Dynamics NAV 2015 . Identify the location of the NAV Adapter for NAV 2015.fob file in the Jet Enterprise Installation Files folder File path • 2. Load Objects into NAV • Open Microsoft Dynamics NAV Developers Environment • Open the Import Objects window: Select File > Import • Select the file NAV Adapter for NAV 2015.fob from Step 1. • A screen should appear stating “All objects have been examines and no conflicts were found”. Click Yes.

  13. How to Install the Adapter for Dynamics NAV 2015 2 of 4 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • 2. Load the objects into NAV (Continued) • A window will appear advising that there will be data upgrades. • Set the Synchronization to Now – with validation and click OK • A second window will appear advising you that NAV will perform validation on all table changes and synchronize them. Click Yes • This step usually takes a few seconds at most. • Click Close • Click OK

  14. How to Install the Adapter for Dynamics NAV 2013 3 of 4 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • 3. Run the Jet Adapter Setup report • Select the Reportbutton on the left side of the Object Designer, click “Jet Adapter Setup” and click Run • In the File Name selection box point to the AdapterSetupNAV2013.txt file from Step 1 and click OK

  15. How to Install the Adapter for Dynamics NAV 2015 4 of 4 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • A progress window will appear notifying you of the current process • This step may take several minutes to complete • When the process has finished a window will appear that says “Update complete” • ClickOK • The NAV Adapter has now ben successfully imported and executed and can now be used by the Jet Data Manager.

  16. How to Install the Adapter for Dynamics AX 1 of 2 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter Import AX Project Note: this step is not required for partners who are using the demo database from the Partner Portal • 1) Start AX and open the “Projects” window (CTRL+SHIFT+P) • 2) Click “Import” (CTRL+SHIFT+I) • 3) Click “Browse” and locate the Jet Enterprise AX Adapter v4.4.xpofile from the Download file. (This is located within the Server Components folder) • Make sure that “Import with ID values” are unchecked. • 4) Click “OK” to start the import. After the import the project is compiled • The compiler output should show No Errors, No Warnings, No Best Practice Deviations and No Tasks • If it shows errors or warnings, recompile the project

  17. How to Install the Adapter for Dynamics AX 2 of 2 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter Execute the AX Adapter Classes • Open the “Projects” window • Expand the Shared Project Folder • Locate the project called TimeXtenderAdapter_V44_<AX Version> and open. • Right click the first of the Classes and select “Open” • Click OK to run the class immediately. • Note - some classes will take minutes to run • Repeat the previous two steps for the other three classes in the project • You can now close Dynamics AX. You are ready to connect the Jet Data Manager to your AX database • Repeat all execution steps if changes are made to your AX data structure (e.g. new or changed tables, enums, relations or virtual companies). • The Classes can be scheduled for recurring batch executions.

  18. How to Install the Jet Data Manager 1 of 2 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • Ensure the pre-installation checklist has been completed (really… it’s worth the effort). • On your Server which has been prepared with SQL Server, SSIS, SSAS, etc., extract the Jet Data Manager 12.7.xx.zip file. • Run the Setup.exe file. Follow the steps in the installation wizard. This will install the Jet Data Manager onto your computer and add a shortcut icon to the desktop. • Select the Jet Data Manager Icon from your desktop to start the application. • 5a. If you are a new customer, select “Internet – I have a license code” and enter the license code listed in your Jet Enterprise welcome letter. It will appear something like D7DC242D-A120-4817-8D6C-FD2641B33421 • 5b. If you are installing the product for demonstration purposes, select “Internet – I am requesting a new trial license” .Provide your contact information on the form and select Send and OK • 6. You will see a warning stating that your project repository setting are invalid – select OK

  19. How to Install the Jet Data Manager 2 of 2 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter 7. Type the name of your local Server and Database for your Project Repository The default names of (local) and projectRepository are usually acceptable. 8. Select Create 9. Select OK and OK again. The Jet Data Manager has now been installed and a Project repository has been created.

  20. Determine SQL Collation Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter Versions 12.4.8 and later of the Jet Data manager allow the user to specify data collations when setting up the staging database and data warehouse. • 1) Determine the collation of your Analysis Services • In SQL Server Management Studio log into Analysis Services, right click on the top node and select “Properties” • Select Language/Collation • 2) Determine the coding that corresponds to your collation • Begin with the language then add a two letter code based on the check boxes Unchecked Checked CI CS AI AS blank KS blank WS The language coding for this example is Latin1_General_CI_AS This information will be needed to execute the project. Please note SQL_ Latin1_General_CI_AS is not the same as Latin1_General_CI_AS

  21. How to download, deploy and execute the Project NAV SQL Server1 of 5 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • Select the blue cube icon in the upper left-hand corner of the Jet Data Manager, then select CubeStore • Select the project you wish to download and click Download • When asked if you want to run the Connection Manager select Yes then Run Wizard

  22. How to download, deploy and execute the Project NAV SQL Server2 of 5 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter The Connection Wizard will show four work panes sequentially. You will need to set up connections in each. 4) 5) • Create the Staging Database • Type a server and database name • Select your collation • Click Create • Click OK • Connect to your NAV database • Type the name of the server where your NAV database is located • Select your NAV database • Click OK Select Server where your NAV database is located It’s recommended to create staging database on the local server Select your NAV database using down arrow Recommend naming the staging database “JetNavStage” Select the collation that corresponds to your SQL Collation

  23. How to download, deploy and execute the Project NAV SQL Server3 of 5 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter 7) • Create the OLAP Server • Type a server and database name • Select your collation • Click OK 6) • Create the Data Warehouse • Type a server and database name • Select your collation • Click Create • Click OK Users will connect to this database to access Data Warehouse data Users will connect to this database to access Cube data It’s recommended to create the data warehouse on the local server It’s recommended to create OLAP server on the local server Recommend naming the Data Warehouse “JetNavDWH” Recommend naming this “JetNavOLAP” Select the collation that corresponds to your SQL Collation Select the collation that corresponds to your SQL Collation

  24. How to download, deploy and execute the Project NAV SQL Server4 of 5 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter Click Test Connections and make sure all Connection State indicators turn green. If not, re-run the Wizard and review the connections. Click the blue ‘synchronization’ icon to synchronize your database Select Yes when asked if you want to set up the enhancements for the Dynamics NAV Adapter Select OK when asked about Navision Enhancement Settings– do not change the default values Select Yes when asked if you want to synchronize the accounts Check the boxes of the databases which you want to have included in the Cubes and data warehouse. Select a company to use as the template (this is usually the database with the most data) and select OK The tables and fields in your database will now be synchronized against those in the project (which was based on a Cronus NA database). All differences will be presented to you.

  25. How to download, deploy and execute the Project NAV SQL Server5 of 5 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter Review the list of Updated Tables and Fields. The downloaded project was based on the tables and fields in a Cronus demo database. Your database will include different tables and fields. Usually these differences will not impact the deployment or performance of the project. If all the fields are red this signifies that a prior step was missed. 15) Select OK 16) Select Project and Manual Deployment and Execution This step generates the Data Warehouse and Cubes. This step will take a few minutes to a few hours to execute depending primarily on the size of the database and the speed of the server and connections. If you encounter errors at this point please refer to Jet Report’s support site at http://support.jetreports.com/ or contact EnterpriseSupport@JetReports.com for assistance. When this step is completed your project is executed and you are ready to set security, connect to Excel or schedule the project for automatic updates

  26. How to download, deploy and execute the Project On Dynamics AX1 of 5 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • Select the blue cube icon in the upper left-hand corner of the Jet Data Manager, then select CubeStore • Select the appropriate project and click Download • When asked if you want to run the Connection Manager select Yes then Run Wizard

  27. How to download, deploy and execute the Project On Dynamics AX2 of 5 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter The Connection Wizard will show four work panes sequentially. You will need to set up connections in each. 4) • Connect to your AX database • Type the name of the server where your AX database is located • Select your AX database • Click OK 5) • Create the Staging Database • Type a server and database name • Select your collation • Click Create • Click OK Select Server where your AX database is located It’s recommended to create staging database on the local server Select your AX database using down arrow Recommend naming the staging database “JetAxStage” Select the collation that corresponds to your SQL Collation

  28. How to download, deploy and execute the Project On Dynamics AX3 of 5 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • Create the Data Warehouse • Type a server and database name • Select your collation • Click Create • Click OK • Create the OLAP Server • Type a server and database name • Select your collation • Click OK 6) 7) Users will connect to this database to access Cube data Users will connect to this database to access Data Warehouse data It’s recommended to create the data warehouse on the local server It’s recommended to create OLAP server on the local server Recommend naming this “JetAxOlap” Recommend naming the Data Warehouse “JetAxDwh” Select the collation that corresponds to your SQL Collation Select the collation that corresponds to your SQL Collation

  29. How to download, deploy and execute the Project On Dynamics AX4 of 5 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter Click Test Connections and make sure all Connection State indicators turn green. If not, re-run the Wizard and review the connections. Click the blue ‘synchronization’ icon to synchronize your database Select Yes when asked if you want to synchronize the accounts Check the boxes of the databases which you want to have included in the Cubes and data warehouse. Don’t select the “Company accounts data” The tables and fields in your database will now be synchronized against those in the project (which was based on a Contoso 2009 database). All differences will be presented to you.

  30. How to download, deploy and execute the Project On Dynamics AX5 of 5 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter Review the list of Updated Tables and Fields. The downloaded project was based on the tables and fields in a Contoso demo database. Your database will include different tables and fields. Usually these differences will not impact the deployment or performance of the project. If all the fields are red this signifies that a prior step was missed. 15) Select OK 16) Select Project and Manual Deployment and Execution This step generates the Data Warehouse and Cubes. This step will take a few minutes to a few hours to execute depending primarily on the size of the database and the speed of the server and connections. If you encounter errors at this point please refer to Jet Report’s support site at http://support.jetreports.com/ or contact EnterpriseSupport@JetReports.com for assistance. When this step is completed your project is executed and you are ready to set security, connect to Excel or schedule the project for automatic updates

  31. How to download, deploy and execute the Project Dynamics GP1 of 5 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • Select the blue cube icon in the upper left-hand corner of the Jet Data Manager, then select CubeStore • Select the appropriate GP project and click Download • When asked if you want to run the Connection Manager select Yes then Run Wizard

  32. How to download, deploy and execute the Project Dynamics GP2 of 5 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter The Connection Wizard will show five work panes sequentially. You will need to set up connections in each. 4) • Create the Staging Database • Type a server and database name • Select your collation • Click Create • Click OK 5) • Connect to your GP database • Type the Server name where your GP database is located • Select your GP database • Click OK 6) • AGAIN connect to your GP database • Type the Server name where your GP database is located • Select your GP database • Click OK Select Server where your GP database is located It’s recommended to create staging database on the local server Select your GP databaseusing the dropdown arrow Recommend naming the staging database “JetGPStage” Select the collation that corresponds to your SQL Collation

  33. How to download, deploy and execute the Project Dynamics GP3 of 5 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter 7) • Create the Data Warehouse • Type a server and database name • Select your collation • Click Create • Click OK 8) • Create the OLAP Server • Type a server and database name • Select your collation • Click OK Users will connect to this database to access Cube data Users will connect to this database to access Data Warehouse data It’s recommended to create OLAP server on the local server It’s recommended to create staging database on the local server Recommend naming the data warehouse “JetGpDWH” Recommend naming this “JetGpOLAP” Select the collation that corresponds to your SQL Collation Select the collation that corresponds to your SQL Collation

  34. How to download, deploy and execute the Project Dynamics GP4 of 5 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter 9) Click Test Connections and make sure all Connection State indicators turn green. If not, re-run the Wizard and review the connections. 10) Click the blue ‘synchronization’ icon on the GP Adapter line to synchronize your database Select Yes when asked if you want to set the Dynamics GP Company Table The next screen will ask for the location of the company table in your Dynamics GP database. The defaults have already been set so it is not necessary to change anything. It is not recommended to select “Use All Companies”. Select OK

  35. How to download, deploy and execute the Project Dynamics GP5 of 5 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter 13) Leave the synchronization options set to “by Company Name” and select Synchronize 14) Click all of the companies to use in Jet Enterprise by checking the box in the “Use” column. Select OK The Connection manager screen will be displayed once again. Click the blue arrows on the SQL connection now to synchronize this connection 16) Select Project and Manual Deployment and Execution This step generates the Data Warehouse and Cubes. This step will take a few minutes to a few hours to execute depending primarily on the size of the database and the speed of the server and connections. When this step is completed your project is executed and you are ready to set security, connect to Excel or schedule the project for automatic updates

  36. OLAP (Cube) Security Initial Step Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • OLAP Security is defined within the Jet Data Manager. • By default the user ID which was used to create the project in the Data Warehouse has access to the Cube data from Excel. Permission must be granted to all other user IDs to allow access. • The steps to setting security involve: • Creating and adding users to a role • Database dimension vs Cube dimension • Configuring user rights for a specific cube • Configuring user rights for multiple cubes • Configuring user rights for named dimensions • Configuring user rights for combined security • Follow the instructions provided in our online Knowledgebase article titled: • Configuring OLAP Security

  37. How to Connect to your Data Warehouse and Cubes from Excel 1 of 2 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter Once an OLAP cube and Data Warehouse has been deployed, users will want to connect to these data sources from Jet Essentials to create reports. As a pre-requisite, users will need to have Jet Essentials installed. Creating a connection to an OLAP Cube The user must have OLAP security permissions to be able to access cube data. From the Jet Reports Ribbon select Data Source Settings, then Add, type a name for the Data source (e.g. Jet Cubes) and select the type “Cube” Type in the name of your OLAP Server, select a database and click OK Creating a connection to a Data Warehouse The process is the similar, however you need to select the type “Jet Data Warehouse” instead.

  38. How to Connect to your Data Warehouse and Cubes from Excel 2 of 2 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • Creating a PivotTable from a Cube • Users can create Pivot Tables and Pivot Charts in Jet Essentials to create reports, dashboards and analyze their business data. • Start by selecting the PivotTable icon from the Jet ribbon and selecting either Pivot Table or Pivot Chart. • Then select: • The desired data source (if more than one exists) • The desired cube • The desired location where the Pivot Table will be created • And select OK

  39. Scheduling an Automatic Execution Package 1 of 5 Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter Your project can be scheduled to automatically update with the most recent information from your data source. This update will refresh the data in your Cubes, Data Warehouse and Staging Database. The update strategy outlined in these slides will have the entire project be refreshed every night. This is one of the simplest and the most common update strategy used. During the time that the Cubes are being refreshed they will not be available to the users. • Prior to setting up an Execution package the first time you will need to start the Jet Data Manager Server Scheduler service. • There are three steps to create an Execution package: • Define Notifications - Notifications are a way to send an email to advise a whether the project has successfully executed on schedule. • Define Execution Package– All or part of the project can be updated in a package. Sophisticated update strategies may include multiple Execution packages • Schedule

  40. Scheduling an Automatic Execution Package 2 of 5 Starting the Jet Data Manager Scheduler Service Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter During the installation process there is a service installed on the local machine that controls the execution packages. These execution packages handle the regular updates made to the data warehouse and the cubes. To configure the service, open the Services window for the server. This can generally be accessed through the Start menu by typing Services in the search bar and selecting Services from the list that is returned. Right click the Jet Data Manager Server Scheduler service and select “Properties”. On the General tab the Startup Type should be set to “Automatic (Delayed Start)”. If this is not available due to older versions of Windows Server then “Automatic” should be selected. Select the Log Ontab, click the button for This account, and enter a service account and password. Right click the Jet Data Manager Server Scheduler service and click Start. The service should start normally If you receive a message that the service started and then stopped the most common cause is that the JDM configuration files have not been created for service account that was specified to start the service. The solution is to log on to the server using this service account, open the Jet Data Manager, and point to the project repository when prompted. This will create the configuration files required by the service account. You can now log off and log back on as the original user. You should now be able to Right click the Jet Data Manager Server Scheduler service and click Start. The service should start normally properly start the service.

  41. Scheduling an Automatic Execution Package 3 of 5 - Define Notifications Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • The Execution package is defined under the Execution tab in the Jet Data Manager • To Define a Notification: • Right-click Notification and select Add Notification • Type a name for the notification • Execution Failed and Execution Success are commonly used here • Select whether to notify via Mail, EventLog or Both • Specify the server name that the email will go out on • This is generally an smtp server or an exchange server • Specify who the email will come from • Specify who the email will go to (and any cc’s) • Select Test Notification to ensure the process is working • Select OK when finished

  42. Scheduling an Automatic Execution Package 4 of 5 - Define Execution Package Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • To Define an Execution Package: • Right-click Execution Packages and select Add Execution Package • Type a name for the Execution Package • Select a Notification to be sent when a project successfully executes or fails • You will be offered a choice of the Notifications which were defined in the prior step • Select OK and Yes • Drag-and-Drop Execute Project to the “Selected Steps” and select OK • This will update the entire project. • It is possible to identify specific steps for the execution package if you need to create a more sophisticated execution package.

  43. Scheduling an Automatic Execution Package 5 of 5 - Schedule Package Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • To Schedule: • Right-click your execution project and select Add Schedule • Schedule your execution project. • Make sure Enabled box is checked and select OK • Now Manually Deploy and Execute the project to deploy the execution package The most common scheduling method is to execute the project daily at a specified time when there are few users (i.e. overnight)

  44. Sample Reports and other useful Resources Pre-Installation Checklist Download Files NAV Adapter 4.0 to 2009 R2 Install Jet Data Manager Determine SQL Collation Execute Project – NAV SQL Set OLAP Security Connect from Excel Schedule Package Sample Reports / Resources NAV 2013 Execute - AX NAV 2015 Execute - GP AX Adapter • Jet Enterprise Resource sitehttp://www.jetreports.com/welcome-enterprise/ • This site contains installation files, tutorial videos and other documents which are helpful for installing the server based Jet Data Manager. • Jet Essentials Resource sitehttp://www.jetreports.com/welcome/ • This site contains an assortment of files, tutorial videos and other documents which are helpful for installing Jet Essentials on a client machine and getting the most out of it. • This site contains of sample Jet Enterprise and Jet Essentials reports available in our “Jet Report Player”. This application stores Excel reports in a carousel format for easy pre-viewing. You can add, modify or delete the files in this application to customize to your own needs. • Support sitehttp://support.jetreports.com/ • Our support site is our ‘go-to’ resource for addressing support issues. It contains the latest Jet Essentials download files, knowledgebase articles, support tickets and more. • Jet Reports Community sitehttp://community.jetreports.com/ • This is a community site for end users who are passionate about Jet Reports to share reports, ideas, and talk about Jet Reports. • Knowledge Base http://kb.jetreports.com/ • Knowledge base articles on installation, how-to, troubleshooting, videos and more are available here.

  45. Details, details, details… All slides after this provide additional details regarding the installation process.

  46. How to determine if your SQL Server is 32bit or 64bit In SQL Server Management Studio create a new query - Select @@Version Review the results X64 is 64bit X86 is 32bit Return

  47. How to set your SSIS and SSAS Services to the correct “Log On As” The Services window can be found under Control Panel > Administrative Tools > Services • The “Log On As” properties for SSAS and SSIS must be set to be the same Local System Administrator as will be used when installing the Jet Data Manager (ideally the utility user defined in the previous step). These services can’t be running as “Network” or “Local” services. Right Click Return

More Related