it

Get to know TARGIT InMemory

dicembre 13, 2018

If you’re new to TARGIT InMemory or unsure about the value it would bring to your business intelligence and analytics strategy, watch the webinar here. It’s a one-hour deep dive that explains the concept behind in-memory and what makes our platform different from what you might expect.

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. 

While the TARGIT® Decision Suite front end runs seamlessly on all data sources, TARGIT® InMemory is specially designed for your TARGIT front end. Consider the suit on the store rack. We’re not saying that suit doesn’t look great on you. We’re just saying the suit specially tailored for you looks even better.

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.

TARGIT® InMemory works great in two key scenarios: high overviews of data like traditional cube technology and highly detailed views on transaction level. You get the best of both worlds with this technology. 

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.
Blog - Image - InMemory

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: TARGIT® InMemory 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.

Blog - Image - InMemory

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.

If you thought TARGIT® InMemory wasn’t for you, this video is a must watch. Tune in today!

Jesper da Silva Endelt - Headshot

Jesper da Silva Endelt

Senior Solution Architect
I've been working at TARGIT for more than a decade now, and I am currently working as a Senior Solution Architect.
Continue Reading...

We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.

ok