DSXchange

Python script is connecting to LDAP and run LDAPSEARCH command to get the data from the directories. I am trying to do the same using datastage.
Not sure how to use them? Scripting is the only way ? or is there any otherway to do in datastage

Hi Ray, I couldn't read your message fully. but I am trying to get the data from LDAP Active Directory only . Right now my team is using python script to do LDAPSEARCH and get the data. I am looking for an option whether datastage can connect directly to the LDAP active directory and get the data.co...

I am also getting the same warning after the partion set as CLEAR also.

any solution please

Hi

I am trying to connect to LDAP server as a source. I would like to retrieve the data from LDAP and doing transformation

I would like to know which stage I can use and what are the information required to connect to LDAP.

Thanks

Input File : FileName.xls Range Option: Specify the start row Range expression: Sheet1!A1:K23 Sheet names to skip: 'Sheet2','Sheet3' Column header: First Row of data ranges when I click load it is giving error "An error occurred when reading the specified file" View is opening the empty ex...

I am trying to read multiple spreadsheet using unstructured stage but I am getting an error."Unstructured_Data_0: An error occurred when reading the specified file" If I click view it is opening blank page if I have single spreadsheet excel. It is reading fine. any set up is missing? Pleas...

yeah it Is working. is there any other approach we can follow?

I have two files and I am getting few columns based on one common column.. but I want the unique records not based on the key column. right now I am using sort stage and passing all the column name as key column in the hash partition. is this the right approach or do we have any better approach to g...

source is ODBC connector we select the source data and oracle connector is the target where we insert the data. we pass the insert query through parameter since we are using the same for to load 10 tables each will have different columns. so select and insert query are parameters. Thanks for your qu...

when i pass the query as parameter to the oracle stage I am getting these error. could you please help Unrecognized argument: HH24:MI:SS.FF) in oracle stage db_TGT_STG: SAX parser exception thrown: The input ended before all started tags were ended. Last tag started was 'InsertStatement' (CC_Propert...