MANTA Releases

MANTA 3.26: IBM DataStage, erwin, and Detailed Lineage in EDC!

Leaves are gently falling to the ground in front of MANTA’s engineering office here in Prague as autumn arrives together with Software Release 3.26. What masterpiece have our developers put together this time? Read all about it in our release blog post.

Leaves are gently falling to the ground in front of MANTA’s engineering office here in Prague as autumn arrives together with Software Release 3.26. What masterpiece have our developers put together this time? Read all about it in our release blog post.

Not Just Any Ol’ Scanners

As always, we bring you the new and greatly improved as well as the old BUT tuned and tweaked. In this release, we have added two new scanners. The first one is an experimental version of the ETL tool from the IBM InfoSphere family, IBM InfoSphere DataStage. Experimental means that we are looking for pioneers for testing. But you had better be quick because the waiting list for this scanner was quite long, and so is the list of prospective testers!

MANTA analyzes DataStage parallel jobs provided by users, then creates a detailed visualization of the data lineage that can be pushed into any third-party metadata management solution or viewed in MANTA’s native visualization. This allows you to plug information such as data validation rules and other data from separate databases into DataStage, all visualized in the lineage showing the complete end-to-end journey of your data.

The second scanner we’ve added is erwin Data Modeler. MANTA can scan erwin and automatically pull physical and logical models that can then be added to your data lineage. This can come in extremely handy when it comes to your database architecture projects, as you can add complex data models from erwin to MANTA and use them to accurately project a situation—an enormously valuable asset for your database engineers.

Up a Notch

We have worked hard to perfect our Cognos scanner. MANTA’s scanner now processes Framework Manager report specifications retrieved from Cognos’ report storage (Content Store). Using the extracted information and other scanners, MANTA can create complete end-to-end data lineage (from database data sources through analytical models to reports in Cognos Analytics).

We are also happy to inform you that we have stepped our Informatica EDC integration up a notch. We have added more filtering options to detailed lineage in EDC, allowing you to see both the big picture as well as the finest details all the way down to the column level, and you can filter dataflows based on what information you want in your final lineage map. Now, MANTA helps you see not only complex SQL code in your EDC Catalog but also information from all the other scanners and integrations that MANTA supports—all ETL, analytics, and reporting tools. This causes user productivity and workflow efficiency to skyrocket!

Last but Not Least

Last but not least, we have made some improvements to the install and update process. Now, the magic happens automatically. When you download a new update packet and the installer notices that you need to update MANTA, it can automatically run your updater when needed, saving you a wrinkle or two in the process!

That’s all for MANTA 3.26. Any questions? Want to become a pioneer? Write to us at manta@getmanta.com.

MANTA 3.25: Microsoft Excel, IBM Cognos, SAP PowerDesigner, and more!

It has been a long time since we swore our 3-new-supported-technologies-every-release oath, and we have kept it every new software release since. And this version of MANTA is no different. In Release 3.25, we bring you support for Microsoft Excel (yes, Excel!), IBM Cognos, and SAP (Sybase) PowerDesigner. Read more in our regular blog post.

It has been a long time since we swore our 3-new-supported-technologies-every-release oath, and we have kept it every new software release since. And this version of MANTA is no different. In Release 3.25, we bring you support for Microsoft Excel (yes, Excel!), IBM Cognos, and SAP (Sybase) PowerDesigner. Read more in our regular blog post.

No time to read? Watch a video or dip into the details below:

Data Lineage for Excel? From Excel? With Excel? YES

No, this is not a drill. We have just released support for Microsoft Office’s Excel. The reason for this, which may seem like a weird flex to some, is that many of our customers still have disturbing amounts of data in Excel databases, which was more challenging for our customers to include in their data lineage.

MANTA now tracks data lineage in Excel, being able to read multiple sheets, pivot tables, slides, and graphs. We also have a detection algorithm with which MANTA can automatically reveal aggregated lists and tables that have formula relations among each other. MANTA is able to track data lineage from database tables and CSV files through tables and graphs among multiple Excel workbooks and push the whole picture into MANTA’s native visualization, as well as into third-party solutions.

Reporting Tools Are Our Friends…

The next connector that MANTA added to its technology portfolio is Cognos, a reporting tool from IBM. MANTA is able to create complete end-to-end data lineage from the database data sources, analytical models, and reports in Cognos Analytics by scanning:

• Reports (including queries)
• Interactive reports
• Framework Manager models
• Database connections

MANTA then pushes them into its own data visualization as well as into third-party solutions. (Visit our Tech Hub to learn more.)

Modeling Tools Too!

The third connector we have added is the modeling tool SAP (Sybase) PowerDesigner, our second after adding ER/Studio in Release 3.24. MANTA can scan PowerDesigner and automatically pull physical, logical, and conceptual models that can then be added to your data lineage to create end-to-end logical data lineage.

Behind the Scenes

Besides broadening MANTA’s Tech Hub, we have also made some improvements to existing supported technologies. The most work was probably done on SSAS, where we have added support to the newer version (level 1200) of the tabular models.

We also detect a connection between SSAS and SSRS from our Microsoft family, and these technologies are currently sharp crisp alfa versions. MANTA is also able to export more and more technologies into third-party solutions, including transformation logic.

And, as of MANTA 3.25, ETL Tools (SSIS, ODI, Talend) and reporting tools (SSAS, SSRS) from our tech hub are now exported into IBM IGC, Informatica EDC. and other third-party solutions.

Anything you want to ask us? Go ahead and write to us at manta@getmanta.com or chat with our friendly MANTA Bot. 

MANTA 3.24: New scanners for ODI, SSRS, ER/Studio and More!

March 27, 2019 by

Here in Prague, where MANTA’s engineering office is located, the snow has melted and sunny spring has arrived. As the first baby otters are born, we are delivering a new little baby of our own: MANTA 3.24. Read about it in our blog post below or check out the two-minute video where Jan Ulrych summarizes all the changes and updates.

Here in Prague, where MANTA’s engineering office is located, the snow has melted and sunny spring has arrived. As the first baby otters are born, we are delivering a new little baby of our own: MANTA 3.24. Read about it in our blog post below or check out the two-minute video where Jan Ulrych summarizes all the changes and updates.

What’s new this time? After finalizing our Microsoft SSRS connector, we have added two more new connectors. The first one is a scanner for Oracle Data Integrator (ODI); the second is for ER/Studio, which expands our influence in the realm of data modelling tools so that we can now create logical lineage automatically, making data lineage from MANTA more accessible for users who aren’t database tech pros.

However, the biggest success in this release is the direct integration with Collibra via API. We have been partnering with Collibra on the development of this synchronization API for quite some time now. So, we are pleased to inform you that we can now introduce the final version.

How is it different from the old integration?

  1. Direct integration. We are so integrated that we are basically part of Collibra DGC. This makes your work with Collibra and MANTA so much faster and easier.
  2. Automatic metadata update. Collibra can fully use this MANTA feature now.
  3. Table synchronization. We are the first ones on the planet able to update your Collibra DGC with your database 1:1, meaning you can now get rid of non-existent tables in DGC and make room for new ones.
  4. All in one. We are able to export all MANTA data lineage to Collibra, including the newly supported Microsoft SSRS.
  5. Logical Lineage. Since we support metadata extraction from E/R models and mappings between physical and logical layers, we can provide this information to Collibra so it can provide logical data lineage.
  6. Installation. It is just so much easier now.

Besides the hot stuff mentioned above, MANTA 3.24 finally offers transformation logic in Teradata and a long-awaited experimental Java version. We are currently doing closed beta testing with some of our customers, and from the next software release onward, we will be doing open testing.

Interested? Got questions? We are here for you. Throw a message into our trusty mailbox at manta@getmanta.com. We will reply!

MANTA 3.23: Talend, Sqoop, Microsoft SSAS, and More!

December 18, 2018 by

Depending on where you are, either snow is slowly covering the ground and rooftops or, well, not. Here in Prague where MANTA’s development center is, it’s freezing outside. Let’s grab a hot chocolate and dive into our last software release of 2018.

Depending on where you are, either snow is slowly covering the ground and rooftops or, well, not. Here in Prague where MANTA’s development center is, it’s freezing outside. Let’s grab a hot chocolate and dive into our last software release of 2018.

Each new version of MANTA supports a new technology. In the last release of this year, we are bringing you not one, but two! They are connectors for Talend Data Integration and Sqoop, and from Microsoft’s SQL Server toolbox, we now fully support SSAS. If your BI environment includes Talend projects, jobs, and subjobs with SQL code, you can now include them in your data lineage in MANTA’s native visualization, IBM IGC, Collibra DGC, and TopQuadrant.

For now, SSAS is only supported in MANTA’s native visualization. In the previous release, we added support for tabular models. Now, we support all SSAS models, including multidimensional models with cubes. MANTA now has the ability to automatically read SSAS dimensions and measure groups with all their hierarchies and sets.

The second big hit in this release is a Sqoop connector. If you have Sqoop scripts written in shell, MANTA can now add them to the data lineage in its native visualization, IBM IGC, Collibra DGC, and TopQuadrant. Before the end of the year, we will add a detailed Sqoop page to the Scanners & Integrations section on our website, so keep an eye open for that!

Our development teams have also improved existing connectors. The Apache Pig connector can now read macros, and the connectors for PostgreSQL, Amazon Redshift and Greenplum can now read stored procedures. The biggest improvements, however, have been made to our Informatica EDC connector. MANTA can now upload data into EDC fully automatically. This is possible mostly thanks to Informatica’s new API. Besides automated upload, we are now also able to load metadata from Teradata Parallel Transporter (TPT) scripts.

Last but not least, our installer, configurator, and updater now work for all integrations in our tech hub. You can now integrate each and every one of your connectors from the comfort of your own user interface – preferably from your own couch with cookies and hot chocolate. Happy Holidays!

Don’t forget that MANTA does a more detailed technological breakdown for every release together with screenshots and more, made especially for our partners & customers. If you haven’t gotten yours, contact us at manta@getmanta.com and we will make sure it arrives in your inbox.

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.

We cherish your privacy.

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