cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BW Connection to Sybase IQ

former_member217141
Active Participant
0 Kudos

Dear IQ Gurus,

We want to make connection SAP BW system to SYBASE IQ 16.0. Those are on different servers.

Bw

Server : Windows Server 2008

SAP_BW731 SP0011

------------------------

Sybase IQ

Version 16, SP04

Windows Server 2008

“SQL Anywhere ODBC driver”


I think we should install “SQL Anywhere ODBC driver” on the BW machine, could you please guide me ?


Best Regards

Accepted Solutions (1)

Accepted Solutions (1)

hemanth2
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Kemal,

Hope you are doing good.

Nice to hear from you again.

Yes, that is correct. Please see note 1788794 - How to install SQL AnyWhere ODBC driver on client PC which will help you with the installation.

Hope this helps.

_ _ _ _ _ _ _ _ _

Kind Regards,

Hemanth
SAP AGS
_ _ _ _ _ _ _ _ _
 

former_member217141
Active Participant
0 Kudos

Dear kumar,

Nice to see you too mate.

I have already installed Sybase Client 16.0, now i can see the odbc driver, but how i can make connection between from BW to Sybase IQ ?

former_member217141
Active Participant
0 Kudos

Dear Kumar,

On the other hand, i made connection in odbc, but in DBCO tcode i take error like this ;

NOTE : ODBC connection test is  SUCCESSFULLY

Gisung
Advisor
Advisor
0 Kudos

Hi

Please see the below Note.

Note 1737415 - SAP IQ: Enable remote/secondary connect to SAP IQ

http://service.sap.com/sap/support/notes/1737415

--

Gi-Sung Jang

former_member217141
Active Participant
0 Kudos

Dear Gi-Sung,

I have made configuration related to "Note 1737415 - SAP IQ: Enable remote/secondary connect to SAP IQ"

1- Downloaded and implemented SYBASE IQ ODBC NLS 16.0 to ( /usr/sap/SID/DVEBMGS00/exe ).

2- The lib_dbsl for SAP ASE (dbsybslib.so/dll) implemented to the standard exe directory AND the instance exe directory.

still same issue :

Testing a Database Connection Defined in DBCON

Could not open connection SYBPROD                        .

SYBPROD                        is not defined in DBCON

Regards

Gisung
Advisor
Advisor
0 Kudos

Hi

When I have tested, I succeeded to connect to IQ with below steps.

1. Driver and Libarary

  - Sybase IQ ODBC Driver/Client for 15.4 and IQ 16.0 (lightweight client)

     at http://service.sap.com/patches Note 1951041 - SybaseIQNetClient 16.0 SP03 Release Notes Information     

   - LibDBSL for Sybase IQ for 7.20/7.21 EXT-UC Kernel (included in the Sybase ASE DB Version) at http://service.sap.com/patches

2. Install the SAP components for Sybase IQ

1) Add the ODBC IQ driver to the SAP Kernel

      

   Unpack the SAR file to a temporary directory and copy the files to the SAP Kernel directory located at /usr/sap/<SID>/DVEBMGS<nr>/exe

  A restart of the SAP System is not necessary and the libraries must have 775 as file permission.

  sybase@lt5006: /data/software/sybase/IQ16.0/Note1737415> SAPCAR -xvf _sar\IQCLIENT160SP0x_0.SAR

                                                                                         

2)Add the IQ LibDBSL to the SAP Kernel

  SAPCAR -xvf _sar\lib_dbsl_xxx-10010165.sar

copy * /usr/sap/<SID>/DVEBMGS<nr>/exe                 /C:\usr\sap\NLT\ASCS01\exeC:\usr\sap\NLT\ASCS01\exe

You can see the details as follows.

** SAP First Guidance - SAP-NLS Solution with Sybase IQ

http://scn.sap.com/docs/DOC-39627

HTH

==

Gi-Sung Jang

former_member217141
Active Participant
0 Kudos

Dear jang,

These are on the different servers, BW is running on MSSQL , and Sybase IQ 16.0 SP04 on the other ip server.

What am i missing ;

1- Downloaded and implemented SYBASE IQ ODBC NLS 16.0 to ( /usr/sap/SID/DVEBMGS00/exe ).

2- The lib_dbsl(lib_dbsl_411-10011372.sar) for SAP ASE (dbsybslib.dll) implemented to the standard exe directory (C:\usr\sap\IBD\DVEBMGS00\exe) AND the instance exe directory(C:\usr\sap\IBD\ASCS01\exe).


What am i missing ???

Gisung
Advisor
Advisor
0 Kudos

Hi

Have you ever applied the latest correction to BW system such as following notes?

[Example of Notes]

Note 1966432 - Event-based Backup Automation does not work anymore with IQ 16.0 SP 3

Note 1796393 - SAP BW near-line solution with SAP IQ

Note 1971524 - BW auf HANA: SQL Fehler 464 bei Archivierung eines IMOCubes (II)

Note 2023695 - SAP IQ NLS: Data corruption after upgrading from SAP IQ 16 sp01 to sp03

Note 1782744 - SAPBWNews NW BW 7.31 ABAP SP07

Note 1737415 - SAP IQ: Enable remote/secondary connect to SAP IQ

...


Are there any progress on BW system?


==

Gi-Sung Jang


former_member217141
Active Participant
0 Kudos

Dear Jang,

After applying latest kernel patch of 7.21 it is worked. Thanks for your helping !

Regards

Gisung
Advisor
Advisor
0 Kudos

Hi

That's good news!!

I'm glad to hear that.

==

Gi-Sung Jang

Answers (0)