Get to know TARGIT InMemory

Originally published January 29, 2020. Updated March 26, 2020
TopBlogImage

If you're new to TARGIT InMemory or want to know more about the value it would bring to your BI and Analytics strategy, you're in the right place. TARGIT InMemory is a column-based, high data compression, in-memory database in the sense that every query is running on in-memory for blisteringly fast query speeds.

We've taken our decades of experience, thousands of projects, and innumerable consulting hours to create the perfect user experience. We’ve eliminated everything our customers dislike most about data integration. Simply put, this is the fastest, most elegant ETL process.

 

Get the best of both worlds with this technology

 

TARGIT InMemory works great in two key scenarios:

  1. high overviews of data like traditional cube technology
  2. highly detailed views on transaction level.

At the same time, you get intense, fast load of your data, which makes the platform great for large data load scenarios and near real-time scenarios. Since the ETL process is running in-memory as well, you experience that transformation of data is many times faster than with traditional OLTP databases.

 

How does TARGIT InMemory compare to the Microsoft SQL Platform?

 

Cost efficiency

There’s no extra licensing for RAM or CPU Core counts. Microsoft requires costly CAL licenses for every client that connects or a hardware-based model, making large solutions extremely costly.Rapid deployment: TARGIT InMemory is rapidly deployed. A startup solution can be up and running in hours. Conversely, Microsoft platforms require significant development to get off the ground for both data warehouse creation and data modeling.

 

Simplicity

TARGIT InMemory is designed with an easy-to-understand ETL language. Administrators can increase the complexity as they need. For users, there’s a flat learning curve. Even non-technical users are sufficient in the platform with a one-day training course. Microsoft, on the other hand, requires knowledge of many components in the SQL stack including Database Engine, SQL, SSIS, and MDX or DAX. It would take a full week of courses for non-technical or new users to become self-sufficient.

 

Speed

TARGIT InMemory blows other database solutions out of the water when it comes to speed. In one particular customer case, the customer with a SQL data warehouse was loading 800 GB of data on properly sized hardware with an Analysis Services database on top. With Microsoft SQL, it took 72 hours to load. With TARGIT® InMemory, the same amount of data took two hours to load!

 

Flexibility

TARGITInMemory comes with drivers for many data sources so users can query with SQL statements for data sources that typically require expert knowledge of specific query languages. You’ll find Microsoft SQL Server, Mongo DB, OData, CSV, Excel, and many more right at your fingertips. TARGIT also supports most standard ODBC, OLEDB, and ADO.NET drivers, delivering ultimate flexibility in data source choice.

 

See it in action

 

TARGIT InMemory comes with a range of database components, including the TARGIT ETL Studio for both basic and advanced data modeling. The ETL toolset allows for easy drag-and-drop connections to a wide range of data sources as well as the full power for complex data abstraction with TARGIT’s easy-to-learn scripting language. Users with SQL skills already have everything they need to master TARGIT’s advanced scripting options.

You can see how it all comes together in our on-demand webinar. Then, watch us build a small solution from source data right on the spot.

See TARGIT InMemory in action

WATCH WEBINAR
Originally published December 13, 2018. Updated March 26, 2020

Jesper da Silva Endelt
Written by

Jesper da Silva Endelt

Senior Solution Architect