MANTA Releases

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.

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.