akshatadeshpande Tracker

Re: Accessing Salesforce data from SAS

akshatadeshpande — Wed, 20 Aug 2014 19:18:20 GMT

Has anybody accessed SalesForce.com from SAS?

Accessing Salesforce data from SAS

akshatadeshpande — Tue, 19 Aug 2014 19:30:29 GMT

I would like to establish the ODBC connection to Salesforce from SAS. We have SAS/Access interface to ODBC installed at our site.

By reading the documentation,SAS(R) 9.3 Intelligence Platform: Data Administration Guide, Second Edition i understood that it requires the composite server to be installed.

I do not have the ODBC driver for salesforce installed on the SAS server. Does anybody know which ODBC driver is to be installed for this?

Also, once the driver is installed should i be following the below steps to access the salesforce data?

1)Establish ODBC connection to Salesforce

2)Create a connection to the server from SAS management console using New Server wizard

3)Create a ODBC library in SAS Management console using the New Library Wizard

4)Import the metadata

Are the above steps correct or will it require other tools to be installed (Like Composite studio) for accessing Salesforce data.

Re: Synchronization code

akshatadeshpande — Wed, 23 Jul 2014 19:32:04 GMT

The last step in the synchronization job is adding the updates to the metadata. The code worked fine, the metadata has been synchronized but i get an error as below in the log:

'ERROR: The object reference to Person was requested without an identifier'.

ERROR: Errors returned from Proc Metadata prevented objects from being Added, Updated, or Deleted. Table: work.mduchglb_failedobjs

identifies 79 such objects. Consult the SAS Log for the specific Metadata Server errors returned.

Even having this error, the objects from the AD group have been added to the metadata.

I am not able to understand this error.

Re: Synchronization code

akshatadeshpande — Wed, 23 Jul 2014 19:19:19 GMT

Do you have any idea about the error i mentioned?

Synchronization code

akshatadeshpande — Wed, 23 Jul 2014 18:21:35 GMT

I get this error when i am running the synchronization code on the metadata server:

'ERROR: The object reference to Person was requested without an identifier'.

So, all the objects which are to be written back to the metadata are written to the failed_objects dataset and the job fails.

Do you have any idea what is causing this error?

23599 - Why do I get an object identity error when I run LoadPortalStructure.sas?

Re: Applying hotfixes on SAS deployment on multiple machines

akshatadeshpande — Thu, 17 Jul 2014 15:48:16 GMT

Hi,

I am running on SAS 9.3 on Windows and i recently installed the hot fixes on the three tiers (metadata, process and mid-tier). I carried out the following steps:

1. I downloaded all the hot fixes on three tiers and placed it in SASHome\InstallMisc\HotFixes\New directory.

2.I brought down the services in the correct order.

3.Ran the deployment manager to apply the hot fixes.

First i applied on mid-tier, then process and then metadata tier

4.Then i brought the services up in the correct order.

My concern here is:

1.What is the order in which the delpoyement manager should be run on the three tiers?(Is the order that mentioned in step 3 correct?)

2.Will running the deployment manager on the three tiers will start the services (like object spawner, metadata , framework server) automatically or should we start the services manually?

Re: Metadata backup and recovery

akshatadeshpande — Wed, 21 May 2014 18:11:34 GMT

I am doing it using the SAS Management Console. The version of SAS is 9.3

For taking the backup, i am using the Run Backup Now option in the metadata manager plug-in.

Re: Metadata backup and recovery

akshatadeshpande — Wed, 21 May 2014 16:18:59 GMT

Hi Ukie,

Thanks for your reply. These are the steps that i carried out:

Take the backup of metadata, the number of users were 13
Delete one user, now the number of users is 12
Restore from the metadata backup which i took before deleting
After restore i still found that there are only 12 users

Since at the time of taking the backup i had 13 users, ideally restoring the metadata should have 13 users, Right?

Metadata backup and recovery

akshatadeshpande — Wed, 21 May 2014 15:45:38 GMT

Hello,

I wanted to test the metadata recovery. So, i first ran the backup of the metadata in the test environment. Then, i deleted a user and then recovered from the backup.

But i still cant find the user. Is that not what recovery has to do? Why am i not able to see the user?

Re: Applying hotfixes on SAS deployment on multiple machines

akshatadeshpande — Tue, 29 Apr 2014 20:50:47 GMT

Hi Jag,

If i am not wrong, can we use the SAS deployment manager to rebuild web applications. The post install steps will include the redeploy web application steps as well.

What would redeploy actually do? How complex are the steps? And is it necessary to redeploy everytime hot fixes are applied? If it is possible can you please jot down he steps. We are currently using IBM websphere server.

Your advice will be appreciated.Thanks !!!

LDAP / AD group implementation on Windows

akshatadeshpande — Tue, 29 Apr 2014 16:00:23 GMT

ctiveHi ,

I would like to know about LDAP authentication and AD usage. I am currently on Windows and use the network credentials for authentication.

Please let me know if any one of you have implemented LDAP/AD group on windows.