data lineage and metadata over thousands of queries
interactive syntax highlighting with diagrams of table joins
A data warehouse team of 5 developers spends on average 75 man-days a year doing work which could be fully automated. Each of them spends on average half an hour a day to reveal data lineage and data dependencies. With SQLdep they would only need to spend 5 minutes a day interpreting SQL data visualisations. Learn more!
The graph illustrates savings per year. A BI specialist usually spends a couple of 15 minute periods a day doing impact analysis, whether to support a new feature launch, or to track down the origin of an error. SQLdep reduces the impact analysis time by 84% by fully automating the data lineage documentation process. Learn more!
Over the years developers acquired knowledge about the data lineage in your DWH. Two problems exists: (a) they cannot easily share what is hidden in their heads (b) when they leave the company the lineage leaves as well. SQLdep mitigates effect of brain-drain and speeds up onboarding process: 24 weeks are cut down to 6 weeks. Learn more!
Through reverse engineering we transform SQL code into an interactive map with data lineage / data flows. Everyday we analyse millions of lines of SQL code and procedural scripts. Data flows and impact analysis is provided across multiple databases.
SQLdep is a cloud based service. No hardware needed, no installation needed. Everything runs in your browser out of the box. To interact with our service use REST API or for you convenience we have released a small app to extract the SQL code from the database.
Get access to the text based metadata we have computed. Download them, play with them. Useful when you need to detect unused tables/columns or when you need to cross verify your existing documentation. A must have for an advanced ETL tuning. Download as CSV or through our API.
You can visually compare the changes between the lineage across different environments like staging versus production. Or you can compare how the data lineage differs before and after the release on production. That also comes in handy if guys from the audit department stop by and start asking questions on how the data were calculated 2 months ago. You are a couple of clicks away to give a precise answer.
With team management you can easily invite your colleagues and share the documentation with them. Your documentation is safe with us and any new user needs to be authenticated first. For your convenience we have also added login through Google accounts.
Tracing data lineage manually between multiple databases is a complete nightmare. At SQLdep we automatically trace your data flows between any number of data marts or intertwined data warehouses. Support for database links is included as well.
We compute the metadata and provide you with neatly done visualisations. Yet you might find helpful to download such metadata in textual form. You can perform your own ad hoc analysis or even further optimise your ETL processes. It is also very helpful when you have existing documentation and you need to verify it against actual code.
Metadata management is about empowering you and your users with an option to describe your data lineage / flow. For example calculations to compute product profitability are among the most complex within the company. Any user can now place a comment and explain any transformation which is then easily shared among the team.
Unify formatting standards in your team with a single click. You will be able to switch between original formatting and the standartised one.