Data360 Analyze

Hello, I need to read all the tables inside a database to search for sensitive data

Data360analyze can do read all tables from a database or source with just one node or some group nodes without make to do manually  a connection or query for each table?

If yes, how can I do this ?

now I have a data flow that generates all the selects from the tables inside a database and with a while node and a jdbc query node the data flow reads all the queries

Attached files

dataflow_read_allDatabase.jpg

The Database Profiler node and Database Metadata node can be used to obtain the metadata from a database, see the node Help documentation. 

The JDBC Query node can be parameterized to source the value of the 'SqlQuery' property from an input field. The results sets for each input query are concatenanted using the method specified by the 'ConcatenationMode' property. When the property value is set to 'Union' the resulting output of the node will be combine all the fields from each of the queries, with Null values for fields not present in a given result set.