DSXchange

Hi Experts, We are planning to get the data from yelp website(all the comments) into our database through Datastage. I called yelp support and as per them we can use API to read the data from there website. Now my question is can we read the website through API in Datastage. I was looking into the d...

Thanks Paul!!
When I added the 'DriverUnicodeType=1 ' it worked!!! :D

Now the problem is for some of the columns it is adding '?' at end

Hi Experts, We are facing some issues with build-in data direct drivers for Microsoft SQl server in our Linux server. Due to this we have installed 'Microsoft ODBC Driver 11 for SQL Server on Linux' in our linux servers. I have added this driver file in odbc.ini file in $DSENV, but when I am trying ...

Hi Experts, We have set up new Datastage server for our test and QA activity. I want to import all the users(50+) from our development server to this new server with same privileges. Is there any way to import all these users along with there privileges from one server to another server or do I have...

Thanks for the help. I am using the server job to laod this file, but it is giving me error for the some of the records which are having huge xml format. below is the error message :( Sequential_File_0.DSLink2: nls_map_buffer_in() - NLS mapping error, row 96338 (approx), row ="<div><font face=&...

Hi Experts, We are reading .csv file which has multiple new-line character in multiple columns. I tried different options to read these records, but still the records are getting rejected. Below are the option I tired.. but no luck :( :? :roll: :roll: In the Format tab In the Record level 1. changed...

Thanks for the help! :D :D
Will install it as root.

Hi Experts, We are installing Infosphere suite in our Red hat linux server. Below are the details:- Infosphere(DataStage) Version:- 9.1.2 O/S Red hat linux :- 5.8 Which user shall I run 'setup' file in 'is-suite' folder? Shall I use root or dsadm? :roll: :roll: I have already created dsadm user on l...

Hi Experts, We are planning to import all the tables in one SQL database into Infosphere metadata. I have imported all the tables(it imported system tables as well ,even though the filter is turned off :roll: ) using IMAM. I have published this results in IMAM. But now when I am trying to search for...

Thanks all for the help!!
So for now we will just load the data from ISauditLog.log into table.

Appreciate your help!!

Hi Experts, As per IBM support we can get job level information from DS_AUDIT table and from the ISauditLog_0.log file which Stuart suggested. But we are looking to get the list of all users logged in to particular project, list of the users last logged in, list of the users based on access level, i...

Thanks for the information.
I have opened PMR with IBM, will update this post once I receive information from IBM.

Thanks again.

Hi Experts, Is there anyway to get the list of all the Infosphere users along with last access time? I have checked XMETA.USERS_2 but this table has only 2 records - admin and guest :roll: Currently we are having LDAP configured in our Linux servers. We have to send the list of all the users who hav...

Thanks for the help. I was running different syntax.

Thanks craig for the help! :o But the problem is we have many subfolders under the Job folder. So when I try to run the export command with "Jobs/*/*.*" option it exports the job(if any) from the 1st level of subfolder. Is there any way to select all the jobs/objects(including different le...