Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
waleeed_mahmood
Creator
Creator

Does Column size in SF matter when reading data in QlikSense?

Hello all,

 

We are reading data from SF and our app runs for a day and still fails to complete.

Upon investigation, we saw that the default column length in SF (set by SF) is ridiculous. A column that fits max 100 chars is of ~11K length.

 

So, my question is, do we need to remap or adjust the column lengths in SF to improve our loading speed in QlikSense?

 

How does qliksense determines the column length and if there is such a thing in Qlik?

 

Thanks,

 

Labels (4)
1 Solution

Accepted Solutions
henrikalmen
Specialist
Specialist

Qlik Sense will handle the data that comes in. You could say that the longest actual content of a field will be the length of the field in Qlik. So if a field is defined as 11000 chars in the source database but all fields just holds the value A or B, Qlik does not care that the definition of the source database was a much bigger field.

So in the Qlik Sense end there should be no worries. But I can't say if SF performance somehow is affectected by the field length so that it takes longer for SF to deliver the data when it's requested.

View solution in original post

1 Reply
henrikalmen
Specialist
Specialist

Qlik Sense will handle the data that comes in. You could say that the longest actual content of a field will be the length of the field in Qlik. So if a field is defined as 11000 chars in the source database but all fields just holds the value A or B, Qlik does not care that the definition of the source database was a much bigger field.

So in the Qlik Sense end there should be no worries. But I can't say if SF performance somehow is affectected by the field length so that it takes longer for SF to deliver the data when it's requested.