Key features of MANTA

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

Key Features of MANTA: Integration

July 12, 2018 by

If there is one thing I have noticed in my many years working for MANTA, it is that MANTA’s integration capabilities are highly appreciated. Customers worldwide notice that what MANTA has to offer in terms of connectivity is high above the average standard of other metadata management solutions.

If there is one thing I have noticed in my many years working for MANTA, it is that MANTA’s integration capabilities are highly appreciated. Customers worldwide notice that what MANTA has to offer in terms of connectivity is high above the average standard of other metadata management solutions.

There are several ways MANTA can connect to other pieces of software. MANTA has pre-built integrations for a number of specific data governance solutions, scanners for a variety of databases and data management platforms, and two types of APIs. Then, on top of that, there are a few other ways to push data into MANTA, if none of the above fit your needs. Here is a closer look at each of the options.

1. Integrations

MANTA has specific, pre-built integrations for complex data governance platforms that can use MANTA’s help when it comes to reading complex code structures and other features important for creating end-to-end data lineage. MANTA connects with them, scans their database resources, and then pushes the final data lineage into their own environments or visualizations. Some of MANTA’s integrations are Informatica EDC and IMM, Collibra DGC, IBM IGC, TopQuadrant EDG, and more. 

2. Scanners

MANTA also has its own visualization, where it can show you data lineage and allow you to work with it. MANTA can parse metadata from several databases and other tools, some of which are Teradata Database, Oracle Database, Microsoft SQL Server, SAP ASE, Hive, both IBM Netezza and IBM DB2, Impala, PostgreSQL, and many, many more. 

3. APIs

If you don’t use any of the solutions MANTA integrates with, there are other ways to get data lineage. MANTA can connect to basically any piece of software through its two APIs: the Service API and the Repository API. You can get detailed insight into both in our API blog post: here. 

4. Other ways

If you could not find “your” solution in any of the options mentioned above, no need to panic. MANTA always finds a way to create data lineage for our customers. MANTA can visualize data lineage based on imported files, Excel tables, data in CSV format, or just externally provided mapping and metadata from the database.

MANTA the mighty

To sum it up, MANTA can connect to basically any piece of software. If you need data lineage, MANTA can give it to you and provide the best quality, the most accurate lineage you can get on the market. Our developers are always adding more supported technologies to the list, and now you know that there are many other ways to push data besides just those. This makes MANTA the absolute leader in connectivity and integration capabilities.

Is there anything else you would like to know? More technical details perhaps? Then contact one of our tech guys at manta@getmanta.com

 

Key Features of MANTA: Current and Past Revisions

Due to popular demand, we bring you another episode from our series “Key Features of MANTA”. This time, we will take a look at MANTA’s ability to automatically report the differences between current and last revisions.

Due to popular demand, we bring you another episode from our series “Key Features of MANTA”. This time, we will take a look at MANTA’s ability to automatically report the differences between current and last revisions.

Exactly which differences are reported?

Usually, you are not the only user in your bu¨siness intelligence environment. Many employees and groups of employees within the company access specific resources, edit database schemas, or just upload new information, e.g.:  add new customer records, edit customer information such as addresses or phone numbers, and so on.

When various changes are made in your database, it is possible that some relations within tables are changed or deleted, and that can lead to spare tables suddenly getting “lost” in traffic or being modified, resulting in a change in the course of the data lineage itself.

Suddenly, the data lineage you have been exporting from MANTA doesn’t fit in the database anymore. This could mean that you no longer have an accurate overview of the data being used in your database, or even, in the worst case scenario, that you are no longer compliant with regulations.

Practical explanation of how revisions work can be found in our technical demo of MANTA + Microsoft SQL Server. Take a look (video will start at 5:09, where Lukas starts to explain how revision system works):

We’ve got you covered!

Because MANTA is specifically tailored to meet customers’ needs, we have noticed this point of frustration and have developed a specific feature that allows you to avoid any unpleasant situations in connection with changes to your database. Every time you log in to MANTA, it will let you know what has changed since it last exported data to your metadata management solution. We’ve simply got you covered!

Is there anything else you’d like to know about MANTA? We are always available at manta@getmanta.com.

 

Key Features of MANTA: Automation

Our slogan is literally “Automate your data lineage”. But what does this actually mean?

Our slogan is literally “Automate your data lineage”. But what does this actually mean?

MANTA is a fully automated tool. This means that after the initial setup, which is usually finished after the POC process but in general doesn’t take much longer than doing your laundry, MANTA works on its own:

Once it’s successfully connected, the software automatically reads your BI environment and provides you with detailed end-to-end data lineage based on our powerful scanners. No editing, no manual metadata injections or excel table uploads, just pure automation (you are obviously welcome to push something in manually as well, but our scanners work automagically automatically).

Automated mapping for agile or else

We wanted to spread this message because it is still a wonder to us how many tools out there claim to be automated when they actually are not. They usually require you to carry out a vast number of manual tasks prior to giving you answers. Some are actually so non-automated that they basically just throw the data you enter there into a nice graphic design and call it lineage!

But why should you want to automate the process of collecting data lineage anyway? Well, there are many reasons why it is beneficial for a company to be able to automate this task.

Automation not only saves you time and resources in the form of employee work hours, but it also helps your company be more versatile in development. If you are trying to keep up with an agile development plan or prefer sandboxing your environment, without automating the process of mapping your data, it is not only inefficient but almost impossible! Automation is the future. All industries and tasks are being adjusted to achieve a certain level of automation. Why shouldn’t your DWH mapping process be automated as well?

MANTA is a powerful tool with features crafted by our developers to meet our customers’ needs. Since we realize that you might not know about every single one of them or you might just want to get a better overview of what MANTA can do for you, we have prepared this blog series. The next one is coming in a few weeks!

Let us know what you think and if you want more posts like this! We are always available at manta@getmanta.com

We cherish your privacy.

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