Configuration of Sybase SQL Anywhere to PCo

[Former Member]

Can anyone help me configuring Sybase SQL Anywhere to PCo 2.3 ?

PCo will be connected to SAP MII 14.0.

Regards,

Mahesh

[Former Member]

Hi Mahesh,

Can you elaborate your question

Is you want to connect Sybase SQL to MII Data Server

If so, Follow below Steps

Connector: IDBC

User name: User (Sybase Admin User)

Passwrd: Pass (Sybase Admin Passwrd)

JDBC Driver: net.sybase.jtds.jdbc.Driver

Server URL: jdbc:jtds:sybase://<IP Address>:<Port>/<Server Name>

Validation query: use this "SELECT * FROM DUAL" or "SELECT count(*) FROM dbo.sysobjects"

From MII, you can connect Pco with PCo connector type in Data Server

Regards,

Praveen Reddy

[Former Member]

Hi Praveen,

Thanks for your reply..

We are trying to connect to the Sybase SQL Anywhere from PCO 2.3 and  not from MII directly.Could you please tell me steps needed while creating the source ,destination and  Agent instance in PCO

Regards,

Mahesh

[Former Member]

Hi Mahesh,

Basically Pco is used either to connect MII or directly ECC.

go through below link for connectivity from Pco to ECC 6.0:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0d32416-9575-2f10-c393-80d775efa...

As of my knowledge, there won't be direct connectivity from Pco to sybase.

If sybase DB is of either MII system or ECC, then better go through below flow

Pco --> MII --> Sybase

Pco --> ECC -->Sybase

Regards,

Praveen Reddy

[Former Member]

Hi Mahesh,

To connect PCo to Sybase SQL Anywhere you will need to create a PCo OLEDB Source Agent. You will need to install the Sybase SQL Anywhere OLE DB provider, and connect the PCo Source Agent to this driver using the Datalink properties window that is displayed when you click on the Configure Connection String button for the source agent in PCo.

Note that PCo OLEDB and (ODBC) source agents only support Query mode, so notifications and associated destinations are not supported for this type of Agent Instance.

To access the data through PCo, you will need to create a PCoConnector Data Server in MII and connect it to the PCo Agent Instance that uses the OLEDB source agent.  Follow these steps:

• Create OLEDB Source Agent and configure for Sybase connectio
• Create an Agent Instance from the source agent
• Make sure the Net TCP Port Sharing Service is enabled, set to Automatic Start, and started on the PCo server
• Make sure the SAP Plant Connectivity Management Host service is started on the PCo Server
• Start the OLEDB Agent Instance in PCo
• Create a PCoConnector Data Server in MII
  • use this url for the PCo connection: http://<PCoServer>:50050/PCoManagement?wsdl
  • provide administrator login credentials for the PCo Server when prompted for login credentials
• Make sure the Data Server is Enabled and the Dynamic Query is checked.
• Save Data Server, then use the Status tab to confirm the connection to PCo.

Regards, Steve