CONNECTORS for SQL Server/Oracle to pull data to portal.

[Former Member]

Hi,

Can anyone please tell me how I can connect to SQL Server or Oracle to pull data to display in portal. According to Will Carlton's elearning session - he said we can download the connectors(trial version) from

http://www.iwaysoftware.com/products/adapter_factory/jca_trial.html

Well, I went to this website and did not find any information about installing the connector and if it is possible with SQL Server. Can anyone please tell me how I can do this?

Thanks.

[Former Member]

Hi Shankar,

I have been trying to do this...based on your high level directions.

But I have not been successful...would it be possible for you to spell out the exact steps involved

or point me to a resource / document that lists the steps.

I appreciate your help.

Regards,

Shanker

[Former Member]

Hi Jyothirmai,

You can use the connector framework available in EP to connect to the backend database. The connector service API should be used to fetch the connection to the databases.

Regards,

Shankar

[Former Member]

Thankyou very much Shankar for your response.

I did not understood what you meant by "<b>connector framework available in EP</b>"?. I know the connector service API that we have to use for pulling data, but don't I need the connectors to talk to SQL Server?

Please let me know.

[Former Member]

The connector service is part of the connector framework. You can create system aliases for the backend databases and connect to them using the connector services. I hope this answers your query.

Shankar