Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create list boxes with the list of Tables and associated fields

I am connecting to a SalesForce DB. Done.

Now, I want to load all fields from all tables:

What is the script that I need to use ?

After that, I want to create two list boxes showing the Tables (1) and the Fields (2) so I can expose which field is associated to which Table.

Who can help me doing that ?

Thanks in advance !

10 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

With the standard database, you would use commands SQLTABLES and SQLCOLUMNS. Try them - I'm not sure Salesforce.com connector supports those commands.

if you don't mind sharing - it would be extremely interesting to see 🙂

Oleg

Anonymous
Not applicable
Author

The answer to your first question about what to load from the database, depends on the specific requirements. You certainly don't want load everything...

The second question is easy. When you select fields to show on the sheet, check "Show System Fields", and select $Table and $Field. You'll get exactly these list boxes.
In addition, you can create System Table - it is available from the "New Sheet Object" menu, the last one. And use the table viewer - CTRL+T.

Not applicable
Author

sqltables does not work...

As I am really nowhere in QlikView or sql programming, may be you can further help me...

I do have the following script:

CUSTOMCONNECT TO Database, username and password

SELECT

$Table

$Field

FROM ???

What shall the xact script look like ??? Thanks for your help !

Anonymous
Not applicable
Author

Jeff,
It's a different question. To read a database table from the database, you use
SQL SELECT
<your database fields here, comma separated>
FROM <a table>
But first of all you need some basic training. You can't create a load script without at least some initial knowledge of SQL. Try using wizard - see "Select" button belo "Connect" in the "Edit Script" window.

Not applicable
Author

Ok Tanks, I'll do basic training. I promise !

But i would really appreciate if you can help me... So let's do it this way:

First line connect me to the Salesforce db, it works. My problem is that I'd lihe two list boxes with the fields contained in each table so I can identify which ones I need.

When I SELECT in the load section of the script, I can view one list on the left with the tables contained in my db and if I click on one table, the list of fields of that table.

Now, to reproduce that in QlikView, How do I do ?

CUSTOMECONNECT TO XXXXX

SQL SELECT

$Fields

FROM $table

??? (thanks a lot for your help !)

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Jeff,

Salesforce.com is a "different animal"... we all depend on what features do they support with their connector...

Maybe you can get started with pulling some basic data from specific tables, and not try to build a metadata application right away/

I believe you should be able to use "Select" wizard once you connect to the database - you will see all the tables and fields there.

I honestly don't know how to pull the list of tables and fields from Salesforce.com.

Did anybody out there ever pulled the full list of tables and fields from Salesforce.com ? Please respond!

Oleg

Not applicable
Author

Thanks Oleg. In fact, I do not think this is linked to SalesForce.

I would find it logical, when you create a new application, by starting to load the 'tables titles' and related 'fields tables' to get familiar with the DB, without looking at the value !

Let's wait if anyone can answer this.

Cheers !

Not applicable
Author

I believe there's a QV file for Salesforce that might be give you some direction.

Regards

Eraaj

Anonymous
Not applicable
Author

There is application "QlikView for SalesForce" on http://demo.qlik.com/