Manta Business

MANTA + Informatica

MANTA completes Informatica to form a comprehensive metadata management platform. But how precisely does the bond work? [VIDEO BELOW ↓ ]

MANTA completes Informatica to form a comprehensive metadata management platform. But how precisely does the bond work? [VIDEO BELOW ↓ ]

Trust Through Understanding

Our product allows you to trust the data in your BI environment, because it is specialized in cracking SQL code and helps to fill gaps in metadata management solutions. It does not matter whether they were deployed to fulfill compliance regulations or create the backbone of your data governance efforts. The Informatica Metadata Management solution has a rudimentary capability to parse SQL, but, in our experience with our customers over the years, there are still blind spots here and there.

MANTA connects to IMM through XConnect (native API plugin), and enriches the metadata model of IMM with missing pieces of data lineage:

  • BTEQ scripts, stored procedures, views, and macros from Teradata
  • PL/SQL scripts, stored procedures, packages, and more, including DB links, from Oracle DB & Exadata
  • T-SQL scripts, stored procedures and more, including linked servers, from Microsoft SQL Server, Sybase (now SAP ASE), and PDW
  • NZPLSQL scripts, stored procedures, and more from IBM Netezza
  • DB2 scripts, stored procedures, and more from IBM DB2
  • SQL overrides from Informatica PowerCenter, Cognos and Microsoft SQL Server Reporting Services

It fills in the gaps in data flows and allows our customers to get end-to-end data lineage (including those pesky indirect data flows).

Here is a live shot of MANTA + IMM,  fullscreen is recommended.

Beyond Lineage

MANTA’s ultimate goal is to understand the semantics of the code being analyzed. If you have ever thought about advanced performance tuning, real data protection analysis, automated business lineage extraction,or migration of your code base to a different platform, MANTA is exactly what you need.

For customers who do not have Informatica Metadata Manager, but do enjoy the advanced ETL capabilities of  Informatica PowerCenter, we are also able to provide data lineage in our own visualization or IBM IGC. MANTA’s open API allows customers to push metadata to 3rd-party tools such as Collibra, Adaptive, Alation, Axon, and others.

Faster and Cheaper

The impressive part is how fast MANTA works. It can map a BI environment at a speed that is incomparable with any  human workforce, which means you save quite a lot of money on man-hours.

If you would like a more detailed explanation of MANTA + Informatica, and how it can help with your current situation, be sure to contact one of our specialists! They can discuss your situation in detail and give you a better idea of how MANTA can help with your data governance efforts.

We are on Instagram!

As you all know, Manta has already expanded from Prague to Germany and then all the way to the US. Now it’s time for us to step up our social media game!

As you all know, Manta has already expanded from Prague to Germany and then all the way to the US. Now it’s time for us to step up our social media game!

We have decided to create an Instagram profile. This profile will document life in our Prague office, the “behind the scenes” of our projects and the conferences we attend. It’s a chance to see what it’s like to work for Manta, to live the “Manta Life.”

If you would like to get some insight into the people behind Manta and what they do, then follow us on our Czech Instagram profile @getmanta.

 

Follow us on Imstagram!

See you there!

Manta & Collibra: How To Get Complete Data Lineage

May 2, 2017 by

MANTA improves accuracy, completeness, effectivity, and automation to your Collibra-based data governance solution.

MANTA improves accuracy, completeness, effectivity, and automation to your Collibra-based data governance solution.

With MANTA, there is no need to worry about end-to-end data lineage to support your BASEL, CCAR, or GDPR projects because MANTA extracts technical metadata from all the databases, scripts, stored procedures, and other kinds of data processing logic in your BI environment and feeds them into Collibra so you don’t have to analyze them manually.

Why do you need data lineage in Collibra?

Because accurately documented data linage is an important source of eff ectivity in BI. It is needed for daily work as it describes business and data processing logic in a company. Data lineage is also a must-have to comply with several regulations (like BCBS or GDPR).

But Collibra already supports data lineage. So what is the difference with MANTA?

Collibra provides great features here, but any data governance solution, including Collibra, is only as good as the metadata in it. And this is where MANTA helps – brings technical metadata to Collibra in an automated way.

Data lineage provided by Manta in Collibra’s native visualization (click here to open a larger image in a new tab)

Why should we care about automation when we can get our developers and analysts to document metadata manually?

Because the manual approach is labor intensive, time consuming, and error-prone. Your guys have better things to do than manually document every detail of the logic hidden inside the millions of lines of data processing code they develop. MANTA is a better way.

But Collibra reads metadata from our databases. How does MANTA differ?

There are two critical pieces to any data environment – structures (like files, database tables, columns, and associated business entities) and logic (programs, applications, ETL workfl ows). MANTA does what others can’t – brings metadata from your business and data processing logic to Collibra.

MANTA and Collibra are best when served together.

Increase Efficiency of Your BI by 30% in 2017

April 3, 2017 by

MANTA helps enterprises get full data lineage of their business intelligence systems and achieve three basic goals:

MANTA helps enterprises get full data lineage of their business intelligence systems and achieve three basic goals:

  1. Complete regulatory output and improve data governance
  2. Eliminate manual labor and increase effectivity
  3. Unlock the potential of existing data governance solutions

But they key question always remains – how do these goals translate into actual $$$? We’ve gathered data from our existing customers both in the US and Europe and put it together:

20% – 30% increase in overall efficiency of the BI/DWH team*
*including analysts, architects, developers, testers

For a team of 20 with an average salary of $100,000 per year, MANTA provides a $400,000 – $600,000 value per year (or $20,000 – $30,000 a year per team member).

1. Full compliance with existing toolsets

Data governance has always been about making sure that all your solutions work perfectly together. Many of our customers, especially in banking and finance, are also pressured by regulators to prove they completely understand data flows in their BI. There’s usually many different (and expensive) metadata and other tools involved, and MANTA is able to connect all of them and accelerate compliance projects by up to 45%.

2. More efficient onboarding of new team members

On average, a typical onboarding process takes from 5 to 10 months before a new team member is fully up-to-speed (depending on the complexity of the environment). MANTA reduces this time by 40% by providing newcomers with complete, transparent documentation of code, even the old/legacy code, without any extra manual work needed.

3. Agile and more efficient maintenance of BI/DWH

With the growing importance of data for running a company, business departments are exerting even greater pressure than ever before to obtain insights quickly and get new features implemented as soon as possible. Analyses of the current state and the anticipated impacts of any changes (as-is analyses, impact analyses) are critical and time consuming phases of a development life cycle. Industry practice says that analysis represents 20% to 40% of the effort needed for any change request. MANTA increases the efficiency of doing as-is and impact analyses by 90% by automating them and eliminating all the manual work.

4. Less money spent correcting errors

One of the most frequent causes of errors in programming systems is the combination of missing documentation and the limited ability to foresee the impact of the changes being implemented. Also, when fixing bugs there are typically more senior team members involved which further increases the costs associated with every issue. MANTA cuts the time spent by the whole team on bug fixing by 30%.

5. Always up-to-date documentation

Most teams struggle with the right approach to documentation. They usually either spend no time doing it, which leads to enormous problems and costs associated with long term maintenance, or they spend too much time on it, trying to cover all important aspects – starting with the bigger picture (business requirements, goals, KPIs) and then diving into the details (logical, physical models). But there are more static and more dynamic parts of documentation and trying to keep them up-to-date becomes very expensive and time consuming. MANTA reduces the time needed to create and maintain documentation of code by 80%.

The Next Steps

Join Us At FIMA 2017 in Boston in May

March 20, 2017 by

Another year, another FIMA. Come with us and save money. 

Another year, another FIMA. Come with us and save money. 

We went to FIMA last year and since we’ve really felt like home there, we are going this year again! In 2017, FIMA aims for three days of content and 12+ hours of networking with total over 300 attendees. You can also take a look at sessions and discussions lead by top reference data management professionals, all covering topics that are of fundamental importance to enterprise-wide data management initiatives.

And here’s the sweet bonus – if you decide to come, you can use our code to get 25% discount on your ticket!

When: May 8-10, 2017

Where: The Westin Copley Place, Boston, MA (map)

25% Discount Code (use during the registration): FIMA17MANTA

And do not forget to stop by our stand and take a look at a couple awesome new features, technologies and our Big Data integration. See you there!

Manta Meets Big Data: The Mirror between Two Worlds

March 14, 2017 by

MANTA is entering the world of Big Data. How? We now help enterprises with migration projects and automate lineage for Big Data technology Hive (with more to come soon). 

MANTA is entering the world of Big Data. How? We now help enterprises with migration projects and automate lineage for Big Data technology Hive (with more to come soon). 

The world of business intelligence has been rocked by Big Data over the last few years and MANTA has been positioned in a bit more conservative part of it. That’s why we started with more traditional SQL-based technologies and now support all the big players in the field (Teradata, Informatica, Oracle, and IBM, to name a few).

Our ability to create complete data lineage from different sources has many unique uses for our customers. One of them is especially useful – complete data lineage proves absolutely necessary when it comes to migrating between different technologies. And that’s why we’ve set foot on this tricky path to Big Data.

How to Migrate without Losing Your Mind

Our key data lineage product, Manta Flow, can serve as a mirror between the old and the new. But that statement is a bit vague (yet poetic), so let’s illustrate it using a classic example:

A company is thinking about migrating part of their BI into a fresh new Big Data technology (like Hive) and wants to keep some parts in a solid old database (like Teradata). 

Using an all-powerful database for a routine data transfer is obvious overkill, but those heavy-duty data marts are good where they are for now. So, how exactly can Manta be beneficial during the migration?

  • You must understand the old code to migrate the logic into a new system. Manta Flow can help you with that – we’re more than capable of documenting data lineage and helping your data professionals make everything work as it is supposed to.
  • Step-by-step approach. Everything should be under control, especially when your data is in question:
    1. Manta Flow analyzes the old part of the BI and shows you all data flows.
    2. After that, your BI pros can migrate it to Hive and test it.
    3. Manta Flow analyzes Hive as well and provides you with data lineage for Hive.
    4. You can easily see how everything works and if the old and new fits mirror each other.
  • The “discovery phase” is now manageable. Even if you are not so sure about the migration, a valuation alone could cost you a fortune. But you have to know what you are migrating before you do it, right? Manta Flow can help you with migration difficulty scoring and provide you with a detailed analysis of the code and its logic.
  • We are ready for more. So far, we’ve started with Hive, but we are working on other technologies – Amazon Redshift, Google BigQuery, Spark, Pig, Google Spanner, and more.

Are you ready to discuss your plans with us? Get in touch!

 

 

 

 

Take a Peek at What’s Coming in 2017

February 10, 2017 by

MANTA is sailing west (again)!

MANTA is sailing west (again)!

The new year is undeniably here and we want to give you a chance to meet and get to know MANTA even better.

Teradata Universe is the first European conference MANTA will participate in this year. We want to show you how to maximize the value of your Tedarata-based DWH. Our product, Manta Flow, deployed in Teradata-based environments helps improve data lineage, manage off-loading projects, and much more. So, pack your bags and meet us on the beautiful beaches of Nice.

As the year goes by, we will travel across the Atlantic to take part in FIMA US in “The City on a Hill.” Boston has one of the oldest public parks in the US where we can discuss how MANTA can save you millions by completing regulatory output and eliminating manual work.

Just a couple of days later, Informatica World will open its gates and, of course, we will be there. In sunny San Francisco you can learn more about our partnership with Informatica and how Manta Flow brings additional value to IMM (Informatica Metadata Manager) and enriches its metadata model with data lineage.

But those aren’t the only places where our ship will anchor. We are going to attend a lot more conferences where you will have the opportunity to meet MANTA and chat with us. Don’t worry, we will keep you updated.

Don’t hesitate to join us on this tremendous journey!

No Manta Tools Anymore

January 3, 2017 by

Some of you may have already heard, some not, but it’s time to make it official. 

Some of you may have already heard, some not, but it’s time to make it official. 

Manta Tools, after years of using this title, is dropping the “Tools” from its name. It’s very necessary for three main reasons:

  • We are not “tools” anymore. Both Manta Flow and Checker are highly specialized products, but the “tools” in our name was hurting us in negotiations and common thinking about the brand.
  • We’ve grown to know who we are. The way we think about our product(s) and brand has changed a lot. We are more “producty” than ever before.
  • We are MANTA anyway. Everybody has always call us that. So why resist the urge?

Obviously, that comes with a few changes along the way. As you might have noticed, we have migrated to a new domain – getmanta.com. Our web address has changed and our email addresses as well.

Spread the word and have a tremendous year in 2017!

MANTA 2016: A New Home, New Challenges and a New Name

December 30, 2016 by

Only a few days are left. 2017 is knocking on our doors harder and harder. We, at MANTA, had a wonderful year, a really amazing one.

Only a few days are left. 2017 is knocking on our doors harder and harder. We, at MANTA, had a wonderful year, a really amazing one.

A New Home

So many things have happened. Let’s start where it ends. Just a few weeks ago we finally found a new office, a wonderful place on I.P. Pavlova square, very close to the historic center of Prague. It was so hard; it took more than six months to find something really appropriate. But this place is cool – under the roof, a lot of space and light and energy. It will become our new home, and we are very happy about it. It is our Christmas gift. The best place for the best team.

New Challenges

Data governance, metadata, and especially data lineage became very hot in 2016. There are many reasons why that happened, but we are excited to see how companies both in the US and Europe have started their governance programs. Also, vendors have become more active in this space and a lot has changed on the metadata market map. But what has remained the same is the need to harvest metadata in an automated way from many different kinds of systems, both old and new, most of the time implemented in the form of programming code.

And while this is a weak spot for all well-known metadata players, MANTA shines when it comes to code. So, that has led us to more and more partnerships with various technology vendors. We are well known for our integration with IMM, but as of this year we are also partners with two other market leaders – IBM and Teradata. We also support Microsoft SQL Server, and a few more additions to our technology stack are planned for the first months of 2017.

New Business and a New Name

But there are also other things that have made us happy. We have continued on our US journey and signed on several new customers there, some of them really huge like one of the TOP4 US banks and one of the TOP5 mutual funds in the world. It is not a surprise that we have been growing super fast. We tripled our revenue in 2016 and our pipeline has simply exploded.

This leads us to another major change – we have decided to drop the “Tools” from our name and became only MANTA. Everybody was calling us that anyway, so why resist the urge? We’ll tell you more about it in the first week of 2017.

But the best part was getting feedback from our customers. They like what we do and how we do it. And that has been the greatest message for the whole MANTA team. It keeps us moving forward and working hard to exceed their highest expectations.

Thank you for everything in 2016 and see you in 2017!

Manta Tools 3.16: Faster Than Ever, Extended Support for IMM, IGC and More!

December 28, 2016 by

The last release of the year should also be the best one, right? Take a look at what’s new in Manta Tools 3.16! 

The last release of the year should also be the best one, right? Take a look at what’s new in Manta Tools 3.16! 

With this release, we are preparing for a new era of our product. We’ve heavily expanded our connectors to our key partners – Informatica (and its Metadata Manager) and IBM (and its InfoSphere Information Governance Catalog). In IMM, we now support the create-rename-drop pattern and you can also add optional script addresses to the descriptions of individual elements. In IGC, we’ve introduced support for Informatica PowerCenter – so if you are among those who work with both, we’ve got you covered.

Our native visualization has been massively improved as well – we’ve focused on UI tweaks this time. You are now able to filter objects horizontally and, for those of you who have really massive visualizations, you are now able to mass collapse and expand them as a whole.

The parser team (yes, we have a parser team!) pushed some new stuff into our Oracle parser (invisible columns support), Microsoft SQL parser (better trigger option), and Teradata parser (Flow is now able to crunch INCLUDE statements in TPT).

The overall performance of Manta Tools has been pushed to the limits of human-developed software – we’ve sped up post-processing in Manta’s core so everything is smoother and you’ll get your results quicker!

Do you have any questions about the update? Just let us know at manta@mantatools.com or leave us a message in the form on the right. Also, do not forget to follow us on Twitter

Subscribe to our newsletter

We cherish your privacy.

By using this site, you agree with using our cookies.