Jet from insightsoftware

Configuring Multiple Environments
Configuring Multiple Environments Complete the following steps to configure multiple environment transfer. Create a Repository Database for each Environment Create a Service User for Each Environment Configure the Server Service for each Environment Assign Each Service User to the Associated Environment's Project Repository Configure the Firewall Configure the Environments Crea...
Migrating Jet Analytics to a New Server
Migrating Jet Analytics to a New Server Overivew This article details the process one must take to migrate Jet Analytics to a new server. Migration Procedure Project Repository The project repository contains all of the necessary instructions to rebuild the infrastructure critical to the Jet Analytics platform.  This information lives in a SQL database that will generally ...
Enabling Data Warehouse Access through Windows Firewall
Enabling Data Warehouse Access through Windows Firewall Overview Windows Firewall helps prevent unauthorized access to computers in the network. By default, Windows Firewall will be turned ON once the operating is installed. If a firewall is turned ON and if it is not configured correctly then attempts made by the users to connect to SQL Server database engine will be blocked. In order to a...
Backing Up a SQL Database
Backing Up a SQL Database Overview This article details the required steps to create a full backup of a database using SQL Server Management Studio. To back up a database Connect to the appropriate instance of the Microsoft SQL Server Database Engine, and in Object Explorer, click the server name to expand the server tree. Expand Database...
Locating SQL Server Version
Locating SQL Server Version The process of determining your version of SQL Server requires the following two components SQL Server Management Studio The ability to connect to the database engine of the SQL instance you wish to check the version of Process Open SQL Server Management Studio, and connect to the database engine of the instance for which you ne...
SQL Server Maximum Memory
SQL Server Maximum Memory Overview Microsoft SQL Server is known to consume all of the memory available on a machine, allowing little to none available for other processes.  This article details the process in which you can adjust the maximum amount that SQL Server will be able to use, therefore allowing other tasks and processes to run as intended. This article detail...
SSIS Logging
SSIS Logging Overview In the Jet Data Manager , it is possible to enable SSIS logging in order to see detailed information that is recorded during the deployment and execution of SSIS packages. This data is then stored in the project repository for easy access. Process In order for SSIS logging data to be captured SSIS Logging must first be enabled in the project. ...
Remote Execution of SSIS Packages
Remote Execution of SSIS Packages Overview When the Jet Data Manager is installed on a separate server and not on the actual SQL Server, then all network traffic when transferring data to the staging database(s) and data warehouse(s) is routed through the server where the Jet Data Manager is installed.  This is due to the fact that SSIS packages are being opened and executed by the Jet Data...
Using the SQL Import Wizard with the JDM
Using the SQL Import Wizard with the JDM Overview There are occasions where it may be desirable to import data from an external data source on a single use basis and use this data in the Jet Data Manager . An example of this would be a regional sales template that exists in Excel that has a mapping of all salespeople to particular regions.  Since this will rarely be update...
SQL & Analysis Management Objects
SQL & Analysis Management Objects Overview When trying to connect the Jet Data Manager to a database on a remote server the following error message may appear: Could not load file or assembly 'Microsoft SqlServer.ConnectionInfo, Version=9.0.242.0, Culture=neutral,PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. ...
First Page
Back
For an optimal Community experience, Please view on Desktop