TARGIT InMemory database in Cloud

[Version: 2024 - April]
[Build: 24.05.03003] 

Your TARGIT InMemory database may be hosted in the Cloud.

Note: You should contact your TARGIT account manager for the initial setup of an InMemory database in the Cloud. 

Once you have been allocated a Cloud based InMemory database, it can be managed through the TARGIT Cloud Control Panel.

Cloud Control Panel - InMemory database properties

To access the Cloud Control Panel, log in via this URL: https://targit.cloud, and go to the 'InMemory' section:

In the InMemory section, you can select the InMemory database:

This will bring up the properties of the selected InMemory database:

• Name: You can change the name of the InMemory database as it should appear in the Cloud Control Panel. Changing the name of the database will not have an impact on existing connections, existing dashboards or existing reports made from this database.
• State: Active or Suspended. A suspended database will become unavailable for any TARGIT Server connections. Re-activate a suspended database to make it available for connections and for end-users again.
• Mode: Automatic or Manual. In Automatic mode, the most recent revision of the database will be the Running database. In Manual mode, you get an option to select among the five most recent revisions which one should be the Running revision.
• Id: This is the ID of the database which is used as a unique identifier when connecting to this database. Hence, the name of the database can be changed without consequences since the ID is used when connecting to the database.
• Revision History: Default '5'. This is the number of Revisions that are being kept in the Revisions list below. If you should need a higher number of revisions (e.g., in case of a high database update frequency), you should contact your TARGIT Account Manager to raise this number.
• Connect Url: This is the URL you will need when creating a connection to the Cloud based InMemory database from the TARGIT Management Client.
• Connect Password: You will need this password if you want to connect to the Cloud based InMemory database from, e.g., the InMemory Query tool. Use the 'Copy' button to copy/paste the password from the Control Panel.
• Upload key: You will need the upload key to be able to 'Publish Database to Cloud' in your InMemory ETL project. Use the 'Copy' button to copy/paste the upload key from the Control Panel.
• Delete Database: Use this option to completely delete the database. Once deleted, you will not be able to restore it. If deleted unintentionally, you will need to contact you TARGIT Account Manager to get a new Cloud based InMemory database created for you.
• Revisions: 
  • Number: Any new revision (= new upload of database) is given a new incremental number.
  • Current: The on/off slider tells you which one of the listed revisions is the current active one. If your Mode is set to 'Automatic', the latest revision will always be the active revision. If your Mode is set to 'Manual', you will be able to select one of the other revisions to become the current active one. As long as a revision has been manually selected, it will stay on the revision list - even if 5 or more revisions have been added to the list afterwards.
  • State: Ideally, you should see 'Running' on only one of the revisions. During the switch over from one revision to another revision, you may see other states such as 'Starting' and 'Terminating' until the new revision is 'Running'. Switch over between revisions is without downtime - data can always be accessed.

Connecting from TARGIT Management client to Cloud InMemory Database

From your TARGIT Management client, log in to your Cloud based TARGIT installation ([YourDNSname].targit.cloud):

Go to the 'Connections' tab to add a new Relational InMemory connection. All you have to do, is to select the 'Cloud server' option and then select the Cloud based InMemory database:

Username, Password and Connection string are automatically filled in:

At this point, you have established the connection to the Cloud based InMemory database. Next step might be to define a Data Model for this database. See this article: Data Model Editor, explained

Publishing data from InMemory ETL project to Cloud InMemory Database

In the InMemory ETL project properties, you should select the 'Publish Database to Cloud' option. Copy /paste the Upload key from the Cloud Control Panel:

When the ETL project is executed, manually or automatically, it will upload the new database to the Cloud, where it will become a new revision on the Revisions list. If Mode is set to 'Automatic', the Cloud environment will then set this revision to the 'Current' revision.

Connecting to Cloud InMemory Database from other tools

You can connect to the Cloud InMemory database from other tools, e.g., from TARGIT InMemory Query Tool of from Visual Studio Code (with the TARGIT extension installed).

To connect through these tools, you will need the Connect URL and the Connect Password from the Cloud Control Panel.

In TARGIT InMemory Query tool, paste the Connect URL into the Server Name property and the Connect Password into the Password property:

Use the same principles when adding the connection in Visual Studio Code:

Link to article on Visual Studio Code extension: Visual Studio Code extension for TARGIT InMemory SQL

Note: In these tools, the database will always appear as 'database' only.

Uploading InMemory Database via Command Line Tool

If you have a local InMemory database file (*.targitdb) that you would like to upload to your Cloud environment, you can do this with the InMemoryUpload.exe command line tool.

Download the .exe file and place it in a folder from where you intend to run it via a Command prompt: InMemoryUpload.exe

Syntax for running InMemoryUpload.exe in a Command prompt:

InMemoryUpload.exe [InMemory Database Filename] [Upload Key from Cloud Control Panel]