cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tomaslp13 Frequent Visitor
Frequent Visitor

Retrive only some tables from DATASET with SQL

Hi, I´m trying to retrive only some tables from a large ERP database with lots of tables (hundreds).I want to do it with the SQL Editor because they are a ton..  I tried to use diferent SELECT SQL queries. I don´t want to open multiple connections to the same database. Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Retrive only some tables from DATASET with SQL

@tomaslp13  Hi Tom I am afraid SQL editor isn't available, i think you need to figure it out in SQL first if you dont know what you want to bring back.


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
3 REPLIES 3
Super User
Super User

Re: Retrive only some tables from DATASET with SQL

@tomaslp13  Hi Tom I am afraid SQL editor isn't available, i think you need to figure it out in SQL first if you dont know what you want to bring back.


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
JimOnTheAve New Member
New Member

Re: Retrive only some tables from DATASET with SQL

I have a similar need.  I am looking to create multiple datasets using multiple queries with one connection.  For Example, Click "Get Data" and write 2 SQL statement to end up with 2 enitities when I look at them in the Model or Data section.  It seems like I have to "Get Data" for Each Sql statement.  Is this true?

tomaslp13 Frequent Visitor
Frequent Visitor

Re: Retrive only some tables from DATASET with SQL

It seems that there is no way to open 2 specific tables in same connection with the SQL editor