top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

How to read data from password protected excel file with informatica

+1 vote
195 views

Please help me to read data from a password protected excel file with informatica

Basically i need to convert excel to csv and read with informatica

Thanks

posted Mar 25, 2014 by Madhavi Kumari

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

Excel is accessible using ODBC. So define a ODBC data source in the server (you would probably have to define a NAME in excel to delimitate the area you want imported).

Using (in Designer). Source->Import from database you can then create the Source and specify the password.

answer Mar 25, 2014 by Shweta Singh
Similar Questions
0 votes

I want to copy the data into one excel file, while the mapping has been running in informatica.

0 votes

I have 20 records in a file and I don't need the first and the last line, I need data from 2 through 19 lines only.
How can I achieve this?

+1 vote

I have a Comp3 file as a source in my mapping. How do I load data in the target. The source defination has fixed length and the Code Page is '7-bit ASCII'. The data is not populated properly. Please help.

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...