Engineer’s Notes

MANTA is Built to Last

Did you know that MANTA is built to last a company’s lifetime? If you update it periodically, you only need to adjust your monthly subscription plan based on how your BI and environment grow in capacity. Other than that, MANTA is a keeper.

Did you know that MANTA is built to last a company’s lifetime? If you update it periodically, you only need to adjust your monthly subscription plan based on how your BI and environment grow in capacity. Other than that, MANTA is a keeper.

But like with everything, there are a few simple rules you have to follow to make sure MANTA is in the best possible condition. Here are the two (yes, only two!) secrets to ensuring your MANTA will last till you retire:

1. Update

2. Upgrade

So, without further delays, lets get to it.

Update

If you are following us on all corners of the internet, you may have noticed that MANTA is constantly coming up with new connectors for different metadata management solutions and platforms. It’s not always because we didn’t connect with them before—it’s because they didn’t exist! That’s right, other companies are continuously releasing new solutions and developing new environments as well. And MANTA constantly develops connectors to support them.

Developing new connectors allows MANTA to be seamlessly reborn into new BI environments. This can save companies thousands of dollars! If you have already bought MANTA and you decide to upgrade the technologies we already support in your environment, you can be sure that MANTA’s newest version will support your newest version. Many of the companies that develop the solutions we support, such as IBM, Informatica, Teradata, and Collibra, are even MANTA’s partners. This means we often develop our connectors using and doing continuous testing on their own software, usually months before they release it. So, when something like EDC comes out, you can be sure we already integrate with it.

If you pay your subscription fees, you just need to check and make sure you have the newest version of the software installed. We make this easy for you by releasing new updates quarterly so you know when to watch out for an upgrade. Currently, we are also testing a new MANTA updater in beta, to make MANTA software updates even more user friendly.

Upgrade

As you know from our pricing, MANTA is priced according to the number of scripts in your data warehouse environment. The fact that you have upgraded to a new technology doesn’t necessarily mean that you have more scripts in your environment than you did before.

If you can fit into the “script budget” that you are currently in, then you might not need to pay even a dollar more, even after changing the software in your BI environment! So, if you change your technology but your data environment stays the same size, MANTA will adjust to your needs and simply be reborn in the new technological environment.

If you have any questions about how to get the most out of MANTA, feel free to contact us at manta@getmanta.com.

MANTA + Informatica EDC Tech Bond

MANTA can complete the Enterprise Data Catalog data governance solution from Informatica with some really tough programming code. In the following article we will let you zoom in on all the details of this technical bond. (INCLUDING A NEW VIDEO!)

MANTA can complete the Enterprise Data Catalog data governance solution from Informatica with some really tough programming code. In the following article we will let you zoom in on all the details of this technical bond. (INCLUDING A NEW VIDEO!)

MANTA connects to Informatica EDC and enhances all of its data lineag:

  1. MANTA connects to the same sources as EDC, and scans all the scripts.
  2. Then, it automatically provides data lineage from those scripts and integrates it with EDC’s native resources.
  3. Finally, MANTA analyzes programming code that is out of EDC’s native scope, e.g. stored procedures, views, triggers and other scripts.

With MANTA, every Informatica customer can see how every procedure works, find out how the data is transformed between tables, and get complete end-to-end data lineage down to the column level.

Here you can watch our brand new video where Lukas explains how the technical bond works:

Like our videos? There are more where that came from! Check out our video section right here. And don’t forget to subscribe to our YouTube channel! 

As you have heard in the video above, MANTA can enrich Informatica’s Enterprise Data Catalog with a number of SQL scripts, that allow EDC to show much more depth and detail than it normally could. Here is a list of scripts that MANTA currently pushes into Informatica.

What MANTA currently pushes into Informatica’s Enterprise Data Catalog:

  • 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
  • PostgreSQL scripts, views and more from PostgreSQL, Amazon Redshift and Greenplum

It’s all about the details

MANTA’s key feature is its understanding superpower. The ability to read even the most complex custom code is crucial for obtaining detailed and complete end-to-end data lineage. This can also be used for real data protection analysis, automated business lineage extraction, migration of your DWH to a different platform or the cloud, and to comply with regulations such as GDPR, Basil II/III, and many more.

For customers who have EDC’s older brother, Informatica Metadata Manager, we have a connector for IMM as well. And for customers who have neither, but enjoy the advanced ETL capabilities of Informatica PowerCenter, we are also able to provide data lineage in our own visualization.

All our supported technologies, both scanners and integrations can be found here. If there is anything else you would like to talk to us about, don’t hesitate to contact us at manta@getmanta.com

MANTA 3.22: Support for PostgreSQL & More.

MANTA’s Devs have done it again! They have integrated MANTA with a whole new technology. We are excited to welcome PostgreSQL into our scanners & integrations family! Read on to get the full scoop on release 3.22.

MANTA’s Devs have done it again! They have integrated MANTA with a whole new technology. We are excited to welcome PostgreSQL into our scanners & integrations family! Read on to get the full scoop on release 3.22.

From version 3.22 onward, MANTA is capable of reading scripts and views in PostgreSQL. This means that opensource databases such as Greenplum, the cloud database Amazon Redshift, and other technologies running on PostgreSQL can now be integrated with MANTA as well.

Now, the second best thing that comes with MANTA 3.22 is custom metadata. The custom metadata feature allows you to create mappings between two systems where it otherwise wouldn’t be possible (e.g., MANTA is not able to scan one or both of the systems). With this feature, you can now easily create your own mappings on column, table, and scheme levels, to help you get accurate data lineage in any and every system.

The second version of the EDC connector is now available. The main changes pertain to the visualization of transformations from MANTA inside EDC. Also, with MANTA 3.22 the Apache Pig connector is in alpha version. (Yay!)

We have started implementing a new connector feature. We have added visible attributes of transformation logic to data lineage at the column level. This means that our customers won’t have to search through all the command results to find transformations for one specific column. As of MANTA 3.22, this feature applies to the Oracle connector, but we will add it to more connectors in the near future.

All this and more can be expected in the next release! What can we say? It’s a work in progress. If you have any more questions about MANTA 3.22, feel free to contact us at manta@getmanta.com. We are always happy to talk to you.

Key Features of MANTA: Its Understanding Superpower

Welcome to another episode of “Key Features of MANTA”. This time, we are focusing on a feature so mighty, we don’t hesitate to call it a superpower. An understanding superpower, that is!

Welcome to another episode of “Key Features of MANTA”. This time, we are focusing on a feature so mighty, we don’t hesitate to call it a superpower. An understanding superpower, that is!

Many, many vendors sell solutions for metadata management solutions that have many great features that MANTA can’t match. But luckily, we do have a superpower that we lend to other solutions and partners and make use of ourselves, or all of the above. It is the ability to parse tough, scary, custom programming code.

MANTA made itself in SQL, because it can read the most complex segments of SQL, including but not limited to: PL/SQL scripts, BTEQ Scripts, T-SQL scripts, TPT scripts, NZPLSQL scripts,  stored procedures, SQL overrides, Informatica PowerCenter Workflows… The list goes on and on, depending on which technology you use.

But since over time MANTA has been supporting more and more scanners and integrations, we’ve needed to adjust over time to other just as complex programming languages. With MANTA 3.22, we will release support for PostgreSQL (which means Amazon Redshift and Greenplum as well, yay!).

This not the only new language we will add to our family of supported technologies. In 2019, as you have read in the roadmap article we released, MANTA will add Java support, which will open up a whole new world of MANTA + Cloud integrations.

Besides being able to read the actual language, MANTA can differentiate between languages and parse multi-language environments automatically. Automation in combination with our code-parsing, understanding superpower automation and our code parsing, understanding superpower is what makes MANTA unlike any other solution on the market.

Is there something you would like to ask us? We are available at manta@getmanta.com

MANTA 3.21: Support for Informatica EDC, Microsoft SSAS & more!

April 30, 2018 by

It’s release time! We have just launched MANTA version 3.21, and there are some pretty nice improvements and two new integrations! Read more to see what’s new!

It’s release time! We have just launched MANTA version 3.21, and there are some pretty nice improvements and two new integrations! Read more to see what’s new!

The New Informatica EDC Is Now Supported

MANTA has released its first version of the integration with Informatica Enterprise Data Catalog 10.2. MANTA can:

  1. Connect to the same databases as EDC and scan all DDL scripts stored there
  2. Automatically push in data lineage that integrates with EDC’s native resources, enriching the previous data lineage with stored procedures, pieces of SQL code that were hidden before because EDC has a hard time reading them, and other pieces of programming code
  3. Make every Informatica EDC + MANTA customer happy!

Expanding Our Microsoft SSAS Support

The next big integration that this release brings you, is support for the tabular models of Microsoft SQL Server Analysis Services (SSAS) 2012 or newer.  SSAS allows the customer to define the dimensions (master tables) and the facts (measurable details) in the data mart and is then able to measure and process them, helping the customer create reports. MANTA can now access the analytical level of your business intelligence environment to create complete end-to-end data lineage for your Microsoft environment.

MANTA’s developers have also spent a great deal of time on other Microsoft technologies. (SPOILER ALERT: Our next release in Q3 will support SSRS, making MANTA fully on board with all Microsoft SQL Server technologies!)

Other technological improvements include large Oracle updates, updates for IBM DB2 and IBM Netezza (now known as IBM PureData for Analytics Powered by Netezza), and some tweaks and fixes to our native visualization.

Version 3.21 also supports what we call enterprise features, which allow the assignment of individual repository access rights to certain groups of employees for accessing specific resources, databases, or even schemas.  And last but not least, automatic differences between revisions are also available in our native visualization from now on.

Is there anything else you would like to know about MANTA 3.21? Don’t hesitate to contact us at manta@getmanta.com (or use the form). We are always glad to help!

We cherish your privacy.

And we need to tell you that this site uses cookies. Learn more in our Privacy Policy.