Like all projects, they must have a beginning and an end. Using the TARGIT InMemory ETL Studio is no different. To create a New TARGIT InMemory Database, first start by Clicking "New" project, the button with the Red Cross on the Ribbon Bar.
The New Project dialog appears, as shown below:
You will need to NAME your project, ensure the correct LOCATION is chosen, and select the Add button.
Your project is added, and you see you have a selection of Data Sources now, a Project Workspace and Project Explorer shows the new Project and Name, as well as the Import File you are about to define.
Note: If you need to rename your project, it is as simple as right clicking on the "Project Name" and chose "Rename".
When you click the Import File (.impm), then the Properties will be shown. The user can setup the Build Action, Copy to Output Directory, and Schedule for the newly created script.The user can also define the File name, InMemory Database Name, and Publish to Server.
- Build Action allows you two options Compile or None.
- Copy to Output Directory allows the user to, while troubleshooting, disable copying the file out to the Output Directory.
- Schedule allows the user to define the schedule for importing the data. Click the "…" icon to define the scheduling, the user will see the following dialog, which is standard scheduling details.
The user is able to change:
File Name of the Import file
- InMemory Database Name, which is what is referred to in TARGIT Management portion of the TARGIT Decision Suite, to make it distinct or according to specific naming conventions.
- Publish to the Server or not by selecting the check box. In the case that you might have one import that needs to be run daily and another that is historical and only runs monthly. This will allow you to determine, based on your Schedule, to allow this publish to the server or not as necessary.
