Kunena Site Syndication http://dbsoftlab.com Thu, 17 May 2012 05:35:19 +0000 Kunena 1.6 http://dbsoftlab.com/components/com_kunena/template/default/images/icons/rss.png http://dbsoftlab.com/ en-gb http://dbsoftlab.com/advanced-etl-processor/5158-excel-sheet2-is-empty.html#5158 http://dbsoftlab.com/advanced-etl-processor/5158-excel-sheet2-is-empty.html#5158
I have the following situation:

Excel workbook with 2 Sheets or more:

Let’s say Sheet1 for current items, Sheet2 for new items (same structure for both).

After running a job with Sheet1 , I cannot get Sheet2 to appear in the Reader grid view in order to load the new items from this separate sheet. (EG it is empty)

Regan]]> Advanced ETL Processor Wed, 16 May 2012 18:15:37 +0000 http://dbsoftlab.com/advanced-etl-processor/5158-excel-sheet2-is-empty.html#5158 http://dbsoftlab.com/data-warehousing-and-data-integration/5151-formatting-excel-date-issue.html#5151 http://dbsoftlab.com/data-warehousing-and-data-integration/5151-formatting-excel-date-issue.html#5151
I tried formatting the date another way through the Transformer (“Reformat Date”). It also comes across within Excel as a “General “ format type. Everything else in the new options under Writer comes over with proper formatting within Excel (numbers with commas and decimals, percentages, whole numbers, etc.).

Rene]]> Data Warehousing and Data integration Wed, 16 May 2012 15:22:10 +0000 http://dbsoftlab.com/data-warehousing-and-data-integration/5151-formatting-excel-date-issue.html#5151 http://dbsoftlab.com/advanced-etl-processor/5145-setting-excel-date-format-in-advanced-etl-processor.html#5145 http://dbsoftlab.com/advanced-etl-processor/5145-setting-excel-date-format-in-advanced-etl-processor.html#5145
I spent a fair amount of time this weekend working on various Advanced ETL Processor transformations.

The data type options work great for the most part. The biggest issue has been with the limited date formats.

Dates are limited to the European format i.e. dd/mm/yyy rather than also having the option for mm/dd/yyy. It also seem to cause issues when imported into Excel. Zero dates come over as 00/01/1900 and are right aligned which is standard for numbers (conversion makes sense given the dd/mm/yyyy option within ETL). All other values come over left aligned and it appears as though Excel attempts to convert everything to mm/dd/yyyy since there are no numbers greater than “12” within the “mm” part of mm/dd/yyyy. When I check the formatting it shows Custom format dd/mm/yyyy.

I noticed that when I was working within the Enterprise version dealing with negative number that the Reader values look good, the Transformation view looks good, but the Writer view shows positive numbers despite the fact that the value saved to the new file are negative numbers. Everything looks good in the new version of Professional.

I’m having some other issues with the new Professional version. I have two transformations that that for the most part use the same Transformation. I’ve gotten intermediate errors opening the Loan Trans, but have had consistent errors with the LOC Trans (even just opening the file). I’ve deleted the Trans and recreated everything a couple of times with the same issue. No problems with either file while using the Enterprise version.

Rene]]> Advanced ETL Processor Wed, 16 May 2012 15:13:40 +0000 http://dbsoftlab.com/advanced-etl-processor/5145-setting-excel-date-format-in-advanced-etl-processor.html#5145 http://dbsoftlab.com/advanced-etl-processor/5134-setting-excel-data-types.html#5134 http://dbsoftlab.com/advanced-etl-processor/5134-setting-excel-data-types.html#5134
I'm evaluating your ETL products and I don't seem to be able to define the various data types when a text file is imported (be it a fixed width or delimited file). This is something that can be defined within MS Access, CloverETL, Talend and other ETL programs.

Everything comes in as a String and within the Reader, Show Definition View, the data type can't be changed. I'd like to change the data types in various fields before the file is converted to an Excel Spreadsheet. I don't see options within the various Transformation options.

What am I missing?

Thanks,
Rene]]> Advanced ETL Processor Wed, 16 May 2012 14:45:36 +0000 http://dbsoftlab.com/advanced-etl-processor/5134-setting-excel-data-types.html#5134 http://dbsoftlab.com/data-warehousing-and-data-integration/5128-importing-data-from-access-database.html#5128 http://dbsoftlab.com/data-warehousing-and-data-integration/5128-importing-data-from-access-database.html#5128
For some reason I am not able to load data from some of the tables.
I thought maybe it is related to security settings but everything is fine.

Any suggestions?

Oliver]]> Data Warehousing and Data integration Wed, 16 May 2012 14:38:20 +0000 http://dbsoftlab.com/data-warehousing-and-data-integration/5128-importing-data-from-access-database.html#5128 http://dbsoftlab.com/data-warehousing-and-data-integration/5122-creating-excel-files.html#5122 http://dbsoftlab.com/data-warehousing-and-data-integration/5122-creating-excel-files.html#5122
I've been working on the trial version for several days now and I'm having a problem getting the writer to provide the output to a directory within my Library (Using Windows 7 Professional).

The writer view seems to read from the path if I place the excel file there. So I thought the path was properly defined, yet when it tries to write to it the an error happens. The log shows that it's trying to write to the proper location.

If I just show the file name in the Writer Excel File tab, the excel file will write, but to the default installation directory.

I'm sure it's a user interface issue, though I've read through the user manual several times and have attempted several different configurations.

Oscar]]> Data Warehousing and Data integration Wed, 16 May 2012 14:26:01 +0000 http://dbsoftlab.com/data-warehousing-and-data-integration/5122-creating-excel-files.html#5122 http://dbsoftlab.com/advanced-etl-processor/5119-reading-empty-file.html#5119 http://dbsoftlab.com/advanced-etl-processor/5119-reading-empty-file.html#5119
Will reading empty flat file cause error in AETL?

Thanks,
Rahul]]> Advanced ETL Processor Tue, 15 May 2012 13:14:46 +0000 http://dbsoftlab.com/advanced-etl-processor/5119-reading-empty-file.html#5119 http://dbsoftlab.com/data-warehousing-and-data-integration/5108-merge-x-rows-with-one-column-in-to-one-column.html#5108 http://dbsoftlab.com/data-warehousing-and-data-integration/5108-merge-x-rows-with-one-column-in-to-one-column.html#5108
Below is what my source looks like.

Col_name
1
2
3
4
5

Need output as (1,2,3,4,5)

Any help would be greatly appreciated.

Thanks]]> Data Warehousing and Data integration Mon, 14 May 2012 15:51:09 +0000 http://dbsoftlab.com/data-warehousing-and-data-integration/5108-merge-x-rows-with-one-column-in-to-one-column.html#5108 http://dbsoftlab.com/data-warehousing-and-data-integration/5105-how-to-handle-special-characters.html#5105 http://dbsoftlab.com/data-warehousing-and-data-integration/5105-how-to-handle-special-characters.html#5105
I am getting plenty of special characters like below the data in flat files.

¡ inverted exclamation
¢ cent sign
£ pound sterling
¤ general currency sign
¥ yen sign
¦ broken vertical bar
§ section sign
ETC

Stephen]]> Data Warehousing and Data integration Sun, 13 May 2012 21:57:15 +0000 http://dbsoftlab.com/data-warehousing-and-data-integration/5105-how-to-handle-special-characters.html#5105 http://dbsoftlab.com/advanced-etl-processor/5102-assigning-line-numbers-in-the-target-table.html#5102 http://dbsoftlab.com/advanced-etl-processor/5102-assigning-line-numbers-in-the-target-table.html#5102 I have the following situation:
I am using a flat file source and loading into 2 target tables. Table 1 is a header table and Table 2 is a detail table and there is a one to many relationship between table 1 and table 2. Table 1 and table 2 both contain a column which will contain a common transaction number that ties them together. I need to produce a line number for table 2 which would start at 1 and increment by 1 for each unique transaction number, so every time the transaction number changes my sequence number needs to begin at 1.

How can I achieve this?
Thanks.
Chris]]> Advanced ETL Processor Sun, 13 May 2012 10:18:33 +0000 http://dbsoftlab.com/advanced-etl-processor/5102-assigning-line-numbers-in-the-target-table.html#5102 http://dbsoftlab.com/advanced-etl-processor/5099-issue-with-ftps-and-pasv.html#5099 http://dbsoftlab.com/advanced-etl-processor/5099-issue-with-ftps-and-pasv.html#5099 the issue is that when using a ftps connection I can connect to the server and receive dir information however ETL will not accept a port command from the server and wants to establish its own data connection on its own port. viewing the logs it appears as though etl is not entering into pasv mode with the server even though pasv is checked off in the ftp settings. I have also tested the connection with the pasv set to on and off and there is no change.
as you look at the two logs below you can see that the client does not enter into pasv mode.

any help would be appreciated.

thanks

mike


ETL client log excerpt:
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> 230 Logged on
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> FEAT
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> 211-Features:
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> MDTM
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> REST STREAM
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> SIZE
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> MLST type*;size*;modify*;
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> MLSD
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> AUTH SSL
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> AUTH TLS
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> PROT
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> PBSZ
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> UTF8
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> CLNT
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> MFMT
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> 211 End
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> CLNT Indy 10.5.8.0
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> 200 Don't care
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> OPTS UTF8 ON
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> 200 UTF8 mode enabled
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> TYPE I
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> 200 Type set to I
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> CWD /guests
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> 250 CWD successful. "/guests" is current directory.
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> SIZE guest-10052012.csv
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> 550 File not found
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> PBSZ 0
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> 200 PBSZ=0
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> PROT P
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> 200 Protection level set to P
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> PORT 10,0,4,23,7,142
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> 200 Port command successful
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> STOR guest-10052012.csv
(000359)5/10/2012 10:08:51 AM - honuakai (209.52.95.27)> 150 Opening data channel for file transfer.
(000359)5/10/2012 10:08:52 AM - honuakai (209.52.95.27)> 425 Can't open data connection.
(000359)5/10/2012 10:08:52 AM - honuakai (209.52.95.27)> QUIT
(000359)5/10/2012 10:08:52 AM - honuakai (209.52.95.27)> 221 Goodbye
(000359)5/10/2012 10:08:52 AM - honuakai (209.52.95.27)> disconnected.


Server log excerpt:
Information 5/10/2012 7:08:51 AM Recv : 230 Logged on
Information 5/10/2012 7:08:51 AM Sent : FEAT
Information 5/10/2012 7:08:51 AM Recv : 211-Features:
Information 5/10/2012 7:08:51 AM Recv : MDTM
Information 5/10/2012 7:08:51 AM Recv : REST STREAM
Information 5/10/2012 7:08:51 AM Recv : SIZE
Information 5/10/2012 7:08:51 AM Recv : MLST type*;size*;modify*;
Information 5/10/2012 7:08:51 AM Recv : MLSD
Information 5/10/2012 7:08:51 AM Recv : AUTH SSL
Information 5/10/2012 7:08:51 AM Recv : AUTH TLS
Information 5/10/2012 7:08:51 AM Recv : PROT
Information 5/10/2012 7:08:51 AM Recv : PBSZ
Information 5/10/2012 7:08:51 AM Recv : UTF8
Information 5/10/2012 7:08:51 AM Recv : CLNT
Information 5/10/2012 7:08:51 AM Recv : MFMT
Information 5/10/2012 7:08:51 AM Recv : 211 End
Information 5/10/2012 7:08:51 AM Sent : CLNT Indy 10.5.8.0
Information 5/10/2012 7:08:51 AM Recv : 200 Don't care
Information 5/10/2012 7:08:51 AM Sent : OPTS UTF8 ON
Information 5/10/2012 7:08:51 AM Recv : 200 UTF8 mode enabled
Information 5/10/2012 7:08:51 AM Sent : TYPE I
Information 5/10/2012 7:08:51 AM Recv : 200 Type set to I
Information 5/10/2012 7:08:51 AM Sent : CWD /guests
Information 5/10/2012 7:08:51 AM Recv : 250 CWD successful. "/guests" is current directory.
Information 5/10/2012 7:08:51 AM Sent : SIZE guest-10052012.csv
Information 5/10/2012 7:08:51 AM Recv : 550 File not found
Information 5/10/2012 7:08:51 AM Sent : PBSZ 0
Information 5/10/2012 7:08:51 AM Recv : 200 PBSZ=0
Information 5/10/2012 7:08:51 AM Sent : PROT P
Information 5/10/2012 7:08:51 AM Recv : 200 Protection level set to P
Information 5/10/2012 7:08:51 AM Sent : PORT 10,0,4,23,7,142
Information 5/10/2012 7:08:51 AM Recv : 200 Port command successful
Information 5/10/2012 7:08:51 AM Sent : STOR guest-10052012.csv
Information 5/10/2012 7:08:51 AM Recv : 150 Opening data channel for file transfer.
Information 5/10/2012 7:08:52 AM Recv : 425 Can't open data connection.
Information 5/10/2012 7:08:52 AM Sent : QUIT
Information 5/10/2012 7:08:52 AM Recv : 221 Goodbye
Information 5/10/2012 7:08:52 AM Stat Disconnected.Information 5/10/2012 7:08:52 AM Stat Connected.Information 5/10/2012 7:08:52 AM Recv : 220-FileZilla Server version 0.9.37 beta]]> Advanced ETL Processor Thu, 10 May 2012 19:07:09 +0000 http://dbsoftlab.com/advanced-etl-processor/5099-issue-with-ftps-and-pasv.html#5099 http://dbsoftlab.com/visual-importer/5093-visual-importer-problems-with-windows-7.html#5093 http://dbsoftlab.com/visual-importer/5093-visual-importer-problems-with-windows-7.html#5093
I have 2 questions for the forum:
1. Has anybody else had this problem with Windows 7, and if yes, any hints for resolving it?
2. VI will eventual run on Windows 2000 Server on the Live environment. Has anybody had similar issues there?

Thanks]]> Visual Importer Tue, 08 May 2012 07:58:05 +0000 http://dbsoftlab.com/visual-importer/5093-visual-importer-problems-with-windows-7.html#5093 http://dbsoftlab.com/data-warehousing-and-data-integration/5090-processing-current-file-only.html#5090 http://dbsoftlab.com/data-warehousing-and-data-integration/5090-processing-current-file-only.html#5090
I have a situation where in I receive, flat files daily in the date format (eg: ddmmyyyy.txt).

Now, whenever I run the mappings it should pick only the current date (sysdate) file from the source path and should load that file.

Regards,
Warren]]> Data Warehousing and Data integration Wed, 02 May 2012 18:50:57 +0000 http://dbsoftlab.com/data-warehousing-and-data-integration/5090-processing-current-file-only.html#5090 http://dbsoftlab.com/advanced-etl-processor/5088-how-to-split-a-huge-source-xml-into-multiple-target-xml-s-dynamically.html#5088 http://dbsoftlab.com/advanced-etl-processor/5088-how-to-split-a-huge-source-xml-into-multiple-target-xml-s-dynamically.html#5088
I have the following requirement. I have 5 tables in my database where Customer is the parent table and there are 12 associated child tables. Daily the tables gets updated and at end of day I need to create an XML with all the updates which then needs to be send to clients network.

I have created transformation using Advabced ETL Processor and it is working fine but now I need to change the design as the XML being generated is too huge. Client has asked us to split the XML based on no.of Customers (100 Customers each).

J.West]]> Advanced ETL Processor Wed, 02 May 2012 18:45:32 +0000 http://dbsoftlab.com/advanced-etl-processor/5088-how-to-split-a-huge-source-xml-into-multiple-target-xml-s-dynamically.html#5088 http://dbsoftlab.com/advanced-etl-processor/5086-how-to-remove-the-new-line-character.html#5086 http://dbsoftlab.com/advanced-etl-processor/5086-how-to-remove-the-new-line-character.html#5086
I have SQL Server table as source and flat file as target.

While reading from source, there are some new line characters in one the column description:

While loading into Flat file, this record is getting split to two records.

How can I remove the new line character in the Column

Christian]]> Advanced ETL Processor Mon, 30 Apr 2012 19:56:06 +0000 http://dbsoftlab.com/advanced-etl-processor/5086-how-to-remove-the-new-line-character.html#5086 http://dbsoftlab.com/data-warehousing-and-data-integration/5083-transformation-is-taking-long-time-to-execute.html#5083 http://dbsoftlab.com/data-warehousing-and-data-integration/5083-transformation-is-taking-long-time-to-execute.html#5083
I have a ETL transformation in my production environment which takes long time to fetch data from database and once it starts getting data from the database it finishes of in seconds. At times the transformation spent 2-3 hr waiting for the data. And the session log say Query issued to database.

Hull]]> Data Warehousing and Data integration Mon, 30 Apr 2012 11:12:55 +0000 http://dbsoftlab.com/data-warehousing-and-data-integration/5083-transformation-is-taking-long-time-to-execute.html#5083 http://dbsoftlab.com/advanced-etl-processor/5081-compaing-two-very-wide-tables.html#5081 http://dbsoftlab.com/advanced-etl-processor/5081-compaing-two-very-wide-tables.html#5081
I have two tables in Oracle with 200+ fields and I am trying to compare them using lookup function.

It took me a while to create mapping It works now but it is extremely slow.

Any tips on how can I speed it up?

H.Grant]]> Advanced ETL Processor Mon, 30 Apr 2012 10:49:59 +0000 http://dbsoftlab.com/advanced-etl-processor/5081-compaing-two-very-wide-tables.html#5081 http://dbsoftlab.com/visual-importer/5079-how-to-insert-and-update-same-record-later.html#5079 http://dbsoftlab.com/visual-importer/5079-how-to-insert-and-update-same-record-later.html#5079
I have the following situation

Source Data::

Code Description
A 1
A 2

Above data is coming on the same day.
I want to insert the records into the target at the same time and update with the second record.
Code is an Unique key in the Target.
Target Data::
Table 1::
SK(System Generated Key) Code Description
1 A 2
Table 2(Having History)
Table 2::
SK CODE Description
1 A 1
1 A 2

Thank you in advance,
Dean]]> Visual Importer Mon, 30 Apr 2012 10:41:43 +0000 http://dbsoftlab.com/visual-importer/5079-how-to-insert-and-update-same-record-later.html#5079 http://dbsoftlab.com/advanced-etl-processor/5077-generating-excel-file-for-different-users.html#5077 http://dbsoftlab.com/advanced-etl-processor/5077-generating-excel-file-for-different-users.html#5077
Here is my current logic:

Every day for each customer one file is getting generated and they all are in one Package and the file is sent in mail.

Now the client wants that there should not be single Excel file for each user rather there should be single Excel sheet worth one sheet inside that excel in the corresponding user's name.

Thanks,
Holman]]> Advanced ETL Processor Sat, 28 Apr 2012 19:50:36 +0000 http://dbsoftlab.com/advanced-etl-processor/5077-generating-excel-file-for-different-users.html#5077 http://dbsoftlab.com/data-warehousing-and-data-integration/5075-create-multiple-headers-detail-lines-and-footers-into-a-flat-file.html#5075 http://dbsoftlab.com/data-warehousing-and-data-integration/5075-create-multiple-headers-detail-lines-and-footers-into-a-flat-file.html#5075
I am reading Invoice Header and Detail tables and want to create a flat file file (pipe delimited) with a Header Record for each Invoice, then create detail lines, then create a footer. Is it possible to implement something like this using your ETL software

The flat file should look like this after running the transformation:

H|001|2012-04-01
D|001|01ITEM_A|25
D|001|02ITEM_B|44
D|001|03ITEM_C|33
F|001|2012-04-01|0003
H|002|2012-04-01
D|002|01ITEM_X|1125
D|002|02ITEM_Y|2344
F|001|2012-04-01|0002
H|003|2012-04-01
D|003|01ITEM_A|2522
F|003|2012-04-01|0001

Thank you,
Fernando]]> Data Warehousing and Data integration Sat, 28 Apr 2012 19:30:10 +0000 http://dbsoftlab.com/data-warehousing-and-data-integration/5075-create-multiple-headers-detail-lines-and-footers-into-a-flat-file.html#5075 http://dbsoftlab.com/advanced-etl-processor/5071-trying-to-connect-to-visual-foxpro-8-dbf-file.html#5071 http://dbsoftlab.com/advanced-etl-processor/5071-trying-to-connect-to-visual-foxpro-8-dbf-file.html#5071
I am trying to connect to the attached Visual Foxpro 8.0 dbf file with no luck. Have tried to create a connection string that I found online, and also tried to connect as a dbf file.

Please help.]]> Advanced ETL Processor Fri, 27 Apr 2012 20:54:36 +0000 http://dbsoftlab.com/advanced-etl-processor/5071-trying-to-connect-to-visual-foxpro-8-dbf-file.html#5071 http://dbsoftlab.com/data-warehousing-and-data-integration/5069-load-xml-file-to-clob-column-of-the-target.html#5069 http://dbsoftlab.com/data-warehousing-and-data-integration/5069-load-xml-file-to-clob-column-of-the-target.html#5069
I need to load a XML file to a Clob column of a target table. I need some guidance regarding that.

Thanks and regards,
David]]> Data Warehousing and Data integration Fri, 27 Apr 2012 17:33:56 +0000 http://dbsoftlab.com/data-warehousing-and-data-integration/5069-load-xml-file-to-clob-column-of-the-target.html#5069 http://dbsoftlab.com/data-warehousing-and-data-integration/5067-creating-new-trasformation.html#5067 http://dbsoftlab.com/data-warehousing-and-data-integration/5067-creating-new-trasformation.html#5067
I have a small suggestion.

Open existing data transformation.
Click new.
I can still see the old data in source grid

Apart from that excellent peace of software.

Dean]]> Data Warehousing and Data integration Fri, 27 Apr 2012 14:14:17 +0000 http://dbsoftlab.com/data-warehousing-and-data-integration/5067-creating-new-trasformation.html#5067 http://dbsoftlab.com/all-other-etl-and-activex-products/5065-rss-and-qlikview-connector.html#5065 http://dbsoftlab.com/all-other-etl-and-activex-products/5065-rss-and-qlikview-connector.html#5065
Is it possible to read RSS feed using ETL-Tools QlikView connector?

Carl]]> All other ETL and ActiveX Products Fri, 27 Apr 2012 13:30:50 +0000 http://dbsoftlab.com/all-other-etl-and-activex-products/5065-rss-and-qlikview-connector.html#5065 http://dbsoftlab.com/all-other-etl-and-activex-products/5061-masking-data-with-qlikview-connector.html#5061 http://dbsoftlab.com/all-other-etl-and-activex-products/5061-masking-data-with-qlikview-connector.html#5061
I have just started working with QlikView connector and I am very impressed with it's functionality.
I have a question though, Is there a way to mask the data so all sensitive information will be hidden?

Thank you ,
C]]> All other ETL and ActiveX Products Fri, 27 Apr 2012 12:12:47 +0000 http://dbsoftlab.com/all-other-etl-and-activex-products/5061-masking-data-with-qlikview-connector.html#5061