You can translate the question and the replies:

Unable to see tables VDP when connecting to a SQL Server

I'm currently able to connect to SQL server databases in my environement using the JDBC connector, when I want to create base views I expand the data source where it's only displaying SQL security roles and not any orther objects like tables and views etc. When clicking in the role it sometimes expands and I can see all the objects that the role has access to but mostly nothing happens when I expand the role even if I have sysadmin privilages. Am I doing something wrong when connecting to the data sources or should I be using a different connector?
user
29-03-2017 07:49:56 -0400

2 Answers

I didn't realiase I was looking at the schemas... doh
user
29-03-2017 12:23:31 -0400
Hi, I think you've already realised that what you see in the tree are the schemas introspected from the SQL Server data dictionary, rather than roles. If the schema does not have any tables in it, you won't see any in the tree when you expand the schema. In your case f the 'dbo' schema will most probably have some tables associated with it that will be shown in the tree when you expand the schema. If the schema isn't associated with any tables however, you won't see any in the tree. Hope this helps!
Denodo Team
31-03-2017 09:42:22 -0400
You must sign in to add an answer. If you do not have an account, you can register here