Loome Integrate Online incorporates numerous improvements which provide an overall enhanced user experience.
Notable improvements include:
Perhaps the biggest change is that Loome Integrate Online is Loomes first Software as a Service (SaaS) product. Thanks to the creation of the Loome Integrate Agent, Online can run as a cloud-based SaaS whilst still able to access data sources that are stored on-premises.
Creating a Tenant is your first step of Loome Integrate Online setup, followed by the Agent installation.
Loome Integrate consists of Projects, which contains many Jobs. These Jobs consist of a series of Tasks, which could be any number of the below:
Projects might belong to separate departments within your business - for example, Accounting, Marketing, Development etc.
Jobs can be named after the things you want to achieve within each Project, and the tasks within Jobs are the technical steps to achieve this goal. Tasks can belong to multiple Jobs, and each can be configured to be dependant on another if necessary. For example, If Task A fails from within Job A, then Job B will not run. You cannot however, run a single Task on its own, all Tasks are run within their parent Job. Jobs can be scheduled to occur in an automated fashion.
Think of the agent as the “worker” in Loome Integrate Online – it contains all the code which allows jobs to run. This is to replace the back end process of previous version; we now allow easier data warehousing on multiple servers and hosts, due to the Agent’s ability to be installed on one tenant but across multiple locations.
The Agent runs cross platform, meaning that users can leverage data from sources running on both Windows and Linux. Loome Integrate is now able to provide Big Data connectivity such as Apache Hadoop as a connection type - a feature only possible thanks to the Agent’s Linux Support.
The Agent should be installed on a host which has access to your data sources, such as a server. Think of it as just another program which runs in the background - listening in real time, for job and task executions from Loome Integrate Online in the cloud.
Easy to Install & Update
Connections in Loome Integrate are your data sources - where you can pull data from - for migration tasks. These can be on-premises, such as a SQL server, or any number of cloud-based connections.
Loome Integrate also allows for the migration of data to and from file-based data stores. For example, Loome Integrate treats flat files like any other connection - each file in a directory is essentially a table in a database. Loome Integrate also supports both local files and Azure blob. Loome Integrate is also able to leverage the power of its flat file processor to support Azure Blob Storage Containers as a source and target connection.
Loome Integrate has the ability to replace the traditionally arduous task of staging raw data from the operational system with a quick, code-free process requiring minimal technical expertise. We call it a Data Migration Task.
Loome Integrate continues to minimise the amount of work required to consolidate data from multiple operational or source systems into one central place for querying and reporting.
First we need to create a new Task. To do this click ‘Add Task’ from within your selected Job.
A screen will appear that will ask you to fill in your Task Name, select an Agent and choose your Task Type – in this case, Data Migration.
Tip : Having a ‘healthy’ agent means that Loome Integrate is ready to run tasks without any start up issues. To check an agent’s health at any time, use the Agent Status bar at the bottom of your screen.
Next we need to choose where the source data will be imported from and the target location we will copy into. To do this, select your Source and Target connections, and your Source and Target schemas. Choosing your Source Connection and Schema will define which tables you are able to select for migration in the next step.
This next step makes the tables within the schema - that you chose on the last screen, - visible. Use the plus button on the right of the screen to select the tables you wish to migrate from the Source Connection.
Tip: If you change your mind, removing a table is as easy as clicking the minus button on the right side of the ‘Target’ section. Once you are happy with the tables you’ve selected, click ‘Submit’ to save the task. You can edit this saved task at any time using the edit button on the Job screen.
Your task is now created and the next step is to execute. Your Data Migration task will now appear in your ‘Sequenced Tasks’ list, and you will be able to run the task as part of the Job at anytime with the ‘Run Now’ button - located in the top right. Be aware that this will run all Sequenced Tasks as part of the job. Checking the ‘Show Logs after Execution’ box will now take you to a live job execution page.
Loome Integrate will show the logs and status of your job in real time - updating the status icon to a green tick on completion, or a red flame on failure.