InfoSphere Optim

 View Only
Expand all | Collapse all

Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

  • 1.  Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Wed April 10, 2019 09:37 AM
    Hi All,

    Has anyone successfully deployed an Optim Server on Linux and used the DataDirect drivers to connect to SQLServer.

    My customer has a PMR open for this but I was wondering if anyone out there has done this successfully?

    Thanks,
    Barbara

    ------------------------------
    Barbara Brown
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Thu April 11, 2019 08:02 AM

    We are successfully archiving MSSQL from Linux. Masking is limited to INSERT processing, the Linux MSSQL Loader is not supported yet (if ever?)

     

     

     

    Thanks,

    Ed Lipson

    Director

    BNY Mellon | 2 Hanson Pl AIM 111-0800 | Brooklyn NY 11217

    Information Lifecycle Management

    T 718.315.4763 |  F 724.540.6622 | C 917.859.5180 | ed.lipson@bnymellon.com

     


    The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.

    Please refer to https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of www.bnymellon.com.





  • 3.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Fri April 12, 2019 06:29 AM
    Thanks Ed,

    Good to know it's been done! I may be back to ask some specifics ;)

    Barbara

    ------------------------------
    Barbara Brown
    ------------------------------



  • 4.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Fri April 12, 2019 07:28 AM
    Hi Ed,

    Have you used DataDirect ODBC drivers for MS SQL server shipped with Optim Server or have you bought (Progress) DataDirect ODBC drivers (SQL Server ODBC Driver for Linux | Tutorial ) separately?

    If former, is there any interface to connect DSN and fetch data from command line shipped with Optim Server on Linux (before designing extract process)?

    I know there is a connection testing utility called testODBC (??) but it returns only whether odbc.ini is successful or not.

    Thanks in advance,

    Ozgur​

    ------------------------------
    Ozgur Gul
    ------------------------------



  • 5.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Fri April 12, 2019 07:38 AM

    We are using what IBM shipped to us, not any other third party product.

     

     

     

    Thanks,

    Ed Lipson

    Director

    BNY Mellon | 2 Hanson Pl AIM 111-0800 | Brooklyn NY 11217

    Information Lifecycle Management

    T 718.315.4763 |  F 724.540.6622 | C 917.859.5180 | ed.lipson@bnymellon.com

     


    The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.

    Please refer to https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of www.bnymellon.com.





  • 6.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Wed April 17, 2019 11:51 AM
    Edited by System Fri January 20, 2023 04:21 PM

    Hi Ed et al,

    Like Barbara mentioned before, Optim classical GUI just stalls and causes the server crash after some time.

    We have tried to run (extract process which runs all right locally btw) service via Optim Designer and Optim revealed a bit more info lines in log file.  

    Would you mind taking a look at our configuration (below) in Linux? Optim Server doesn't find anything wrong with pstserv.cfg when we run 
    pr0svce -v pstserv.cfg
    to validate 

    Yet we experience below whilst

    Running batch in Optim designer – error in log

    Apr 17, 2019 3:40:56 PM org.apache.commons.httpclient.SimpleHttpConnectionManager getConnectionWithTimeout

    WARNING: SimpleHttpConnectionManager being used incorrectly.  Be sure that HttpMethod.releaseConnection() is always called and that only one thread and/or method is using this connection manager at a time.

    Apr 17, 2019 3:40:56 PM org.apache.commons.httpclient.HttpMethodDirector isRedirectNeeded

    INFO: Redirect requested but followRedirects is disabled

    Apr 17, 2019 3:40:56 PM org.apache.commons.httpclient.SimpleHttpConnectionManager getConnectionWithTimeout

    WARNING: SimpleHttpConnectionManager being used incorrectly.  Be sure that HttpMethod.releaseConnection() is always called and that only one thread and/or method is using this connection manager at a time.

    Apr 17, 2019 3:41:39 PM com.ibm.nex.core.util.logging.AbstractLoggable info

    INFO: Launching Service Execution Monitor job...

    Apr 17, 2019 3:41:39 PM com.ibm.nex.core.util.logging.AbstractLoggable info

    INFO: Dispatching service with execution id '466bc48c-1c2b-4a76-8ed9-045d44d48c4b'

    Apr 17, 2019 3:41:40 PM com.ibm.nex.core.util.logging.AbstractLoggable info

    INFO: Setting working directory to %s/opt/IBM/InfoSphere/Optim/rsiwork

    Apr 17, 2019 3:41:40 PM com.ibm.nex.core.util.logging.AbstractLoggable info

    INFO: Launching pr0cmnd for run...

    Apr 17, 2019 3:41:40 PM com.ibm.nex.core.util.logging.AbstractLoggable info

    INFO: Launching 'pr0cmnd -R TYPE=EXTRACT REQUEST=MSADDR.ALL DIRECTORY=OPTIMDIR QUIET+ MONITOR- INSTANCE_ID=466BC48C-1C2B-4A76-8ED9-045D44D48C4B OUTPUT=/opt/IBM/InfoSphere/Optim/rsiwork/466bc48c-1c2b-4a76-8ed9-045d44d48c4b/run.log'.

    Apr 17, 2019 3:41:40 PM com.ibm.nex.core.util.logging.AbstractLoggable info

    INFO: Pr0cmnd process '466bc48c-1c2b-4a76-8ed9-045d44d48c4b' started

    Apr 17, 2019 3:41:40 PM com.ibm.nex.core.util.logging.AbstractLoggable info

    INFO: No valid PST Directories have been specified

    Apr 17, 2019 3:41:40 PM com.ibm.nex.core.util.logging.AbstractLoggable info

    INFO: No valid DB Aliases have been specified

    Apr 17, 2019 3:41:41 PM com.ibm.nex.core.util.logging.AbstractLoggable info

    INFO: Pr0cmnd process '466bc48c-1c2b-4a76-8ed9-045d44d48c4b' for job '466bc48c-1c2b-4a76-8ed9-045d44d48c4b' ended with return code 28

     

    I am not quite sure since I couldnt find ERRORLEVEL 28 in KC but this is the closest I got to

    RETURN CODE 28
    Cannot load pstlocal.cfg. (See the Installation and Configuration Guide for more information.)

    NB: We haven't set up pstlocal.cfg yet. I don't understand why it is needed if we aren't going to run from Linux Server any CLI to run optim jobs.

    Anyhow here you are...

    rtsetenv

    ODBCINI=/opt/IBM/InfoSphere/Optim/rt/bin/odbc.ini

    export ODBCINI

     

    pstserv.cfg

    dbalias OPTIMDIR MSAW_SQL83 MSAW_SQL83 SVC_xxxxxxx "dLU@xxxxxxxxxxxx"

     

     

    odbc.ini

    MSAW_SQL83=IBM 7.1 SQL Server Wire Protocol

     

    [MSAW_SQL83]

    Driver=/opt/IBM/InfoSphere/Optim/rt/bin/OOsqls27.so

    Description=IBM 7.1 SQL Server Wire Protocol

    AlternateServers=

    AlwaysReportTriggerResults=0

    AnsiNPW=1

    ApplicationName=

    ApplicationUsingThreads=1

    AuthenticationMethod=1

    BulkBinaryThreshold=32

    BulkCharacterThreshold=-1

    BulkLoadBatchSize=1024

    BulkLoadFieldDelimiter=

    BulkLoadOptions=2

    BulkLoadRecordDelimiter=

    ConnectionReset=0

    ConnectionRetryCount=0

    ConnectionRetryDelay=3

    Database=MSAdventureWorks

    EnableBulkLoad=0

    EnableQuotedIdentifiers=0

    EncryptionMethod=0

    FailoverGranularity=0

    FailoverMode=0

    FailoverPreconnect=0

    FetchTSWTZasTimestamp=0

    FetchTWFSasTime=1

    GSSClient=native

    HostName=wscxxxxx.subdomain.domain

    HostNameInCertificate=

    InitializationString=

    Language=

    LoadBalanceTimeout=0

    LoadBalancing=0

    LoginTimeout=15

    LogonID=SVC_xxxxxxx

    MaxPoolSize=100

    MinPoolSize=0

    PacketSize=-1

    Password=dLU@xxxxxxxxxxxx

    Pooling=0

    PortNumber=1433

    QueryTimeout=0

    ReportCodePageConversionErrors=0

    SnapshotSerializable=0

    TrustStore=

    TrustStorePassword=

    ValidateServerCertificate=1

    WorkStationID=

    XMLDescribeType=-10


    PS: I've checked by listing dynamic dependencies ($>ldd) and everything is alright for  OOsqls27.so

     

    # ./testodbc MSAW_SQL83

    Enter the data source name : MSAW_SQL83

    Enter the user name        : SVC_optim_db

    Enter the user password    :

    SQLConnectW returned: 1

    Connection successful

     

    Regards,
    Ozgur 



    ------------------------------
    Ozgur Gul
    ------------------------------



  • 7.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Wed April 17, 2019 12:35 PM

    I have asked our Pune team lead, who has set this up. We only run from Linux, so we have both the pstlocal and the pstserv files.

     

     

     

    Thanks,

    Ed Lipson

    Director

    BNY Mellon | 2 Hanson Pl AIM 111-0800 | Brooklyn NY 11217

    Information Lifecycle Management

    T 718.315.4763 |  F 724.540.6622 | C 917.859.5180 | ed.lipson@bnymellon.com

     


    The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.

    Please refer to https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of www.bnymellon.com.





  • 8.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Wed April 24, 2019 07:28 AM
    Hi,

    I have looked at most of the discussion. My preliminary analysis tells me that some where some configuration is missing. Please note that if you submit job from Designer associating to Linux Optim server, then internally pr0cmnd job would be submitted on Linux Optim server. Hence it is required properly configure pstlocal.cfg file.

    Can you please verify by manually submitting same job on Optim linux server using pr0cmnd. If it fails then please send me pstlocal.cfg and pr0cmnd trace file.

    Thanks,

    ------------------------------
    Tulasi Uppu
    ------------------------------



  • 9.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Thu April 25, 2019 04:06 AM
    ​Hi, we dont use sql server databases, but oracle databases,  i think the principle is the same.
    We launch pr0cmnd commands on AIX server to
          extract, insert data
      and
         export and import optim objects.
    and we use the old GUI
    We didnt need to start the optim server (rtserver) and so we didnt need pstserv.cfg until we use  archive request to delete data before reinserting (with the archive request you can choose the tables you want to delete, it is not the case with  the delete request). The pr0cmnd command on aix only needs pstlocal.cfg to be defined for extract, insert, delete. and there is no need to start the server. only the archive request needs the rtserver to be started.  so the dbaliases must be defined in the pstlocal.cfg to extract, insert, load and delete and in the pstserv.cfg if the archive requests are used.

    ------------------------------
    Michel Robichon
    ------------------------------



  • 10.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Fri November 22, 2019 12:35 AM
    Hello Ozgur,

    I ran in to this exact issue recently and would like to know if you were able to resolve this ?
    Please let me know.

    Regards,
    Suraj


    ------------------------------
    Suraj Shingri
    ------------------------------



  • 11.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    IBM Champion
    Posted Fri November 22, 2019 12:53 AM
    In the PSTSERV.cfg file, I think, Server parameter is set to Local so it is going to PSTLOCAL.cfg file.

    Thanks and regards,
    Vishwas Balakrishna
    Estuate, Inc. Princeton, NJ

    This email contains confidential material prepared for the intended addressees only and it may contain intellectual property of Estuate, Inc, its affiliates or a third party. This material may not be suitable for, and we accept no responsibility for, use in any context or for any purpose other than for the intended context and purpose. If you are not the intended recipient or if we did not authorize your receipt of this material, any use, distribution or copying of this material is strictly prohibited and may be unlawful. If you have received this communication in error, please return it to the original sender with the subject heading "Received in error," then delete any copies.





  • 12.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Fri November 22, 2019 01:23 AM

    Hello Vishwas,

    Thank you for a quick reply on this.
    We are trying to extract data from MS SQL Server and have the same configuration as mentioned by Ozgur Gul (ODBC for Linux), pstserv.cfg and pstlocal.cfg are configured as well.

    Note that we are using Optim classic and we are able to achieve this using Optim client (Windows).
    We tried to run this using Optim Server (Installed on Linux) and the server just hangs.
     - Use Optim client and delegate request to Optim Server (using "Server" drop down)
     - submit pr0cmnd locally on the linux box
     
    Tested this Issue with the below Optim Versions :-
    11.3.0.4
    11.3.0.5
    11.3.0.6
    11.3.0.7 

    Any help would be appreciated.

    Thanks,
    Suraj



    ------------------------------
    Suraj Shingri
    ------------------------------



  • 13.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Fri November 22, 2019 03:36 AM

    Hi Suraj – Unfortunately we had to re-platform our Optim Server to Windows Server. We couldn't bring up the Linux server up & running for Optim Server.

     

    Regards,

    Ozgur

     






  • 14.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Fri November 22, 2019 03:45 AM

    What is the MSSQL version? 2016+ is only supported on Windows, you can't use Linux. Earlier MSSQL versions can be done (we have a few applications using it that way too).

     

     

     

    Thanks,

    Ed Lipson

    Director

    BNY Mellon | 2 Hanson Pl AIM 111-0800 | Brooklyn NY 11217

    Information Lifecycle Management

    T 718.315.4763 |  F 724.540.6622 | C 917.859.5180 | ed.lipson@bnymellon.com

     


    The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.

    Please refer to https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of www.bnymellon.com.





  • 15.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Fri November 22, 2019 03:59 AM
    Ed - Thanks for your note. For our implementation, Optim Directory was on DB2 and our source & target dbs were on MS SQL Server 2014.

    BTW on April 17th you said that you would get feedback from your Pune Team Lead regarding some linux configuration details for Optim but (Barbara and) I haven't heard back from you unfortunately. Just a gentle reminder.. :o)

    Kind regards,  

    Özgür Gül

    The DOT Group Ltd | 23 Chealsea Wharf, Lots Road, Chelsea, London, SW10 0QJ | M: +44 (0) 7968 888152 | T: +44 (0) 20 7352 8423 | F: +44 (0) 20 7376 3089 | email: o.gul@dotgroup.co.uk






  • 16.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Fri November 22, 2019 04:06 AM

    Long time ago, we have moved to new servers and have lots of 11.3.0.7 under our belts.

    What was the information you were looking for, I'll follow up and get them to send it.

     

     

     

    Thanks,

    Ed Lipson

    Director

    BNY Mellon | 2 Hanson Pl AIM 111-0800 | Brooklyn NY 11217

    Information Lifecycle Management

    T 718.315.4763 |  F 724.540.6622 | C 917.859.5180 | ed.lipson@bnymellon.com

     


    The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.

    Please refer to https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of www.bnymellon.com.





  • 17.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Fri November 22, 2019 04:01 AM
    Thanks Ozgur for an update.

    Hello Ed Lipson,

    MS SQL Server Version : Microsoft SQL Server 2008 R2 (SP3-GDR) (KB4057113) - 10.50.6560.0 (X64) 
    Host Machine's OS : Windows 2012 R2

    We have taken care of the below setup considerations from IBM documentation for SQL Server :-

    https://www.ibm.com/support/pages/detailed-system-requirements-v113-ibm-infosphere-optim-solutions-and-sql-server-data-source-dbms

    Below is for SQL Server 2008 which we are using with my comments:-

    The following considerations apply when using an Optim server to access SQL Server on Linux or UNIX:
    • SQL Versions higher than 2014 are NOT currently supported on Linux or UNIX - OK , we use 2008
    • You must use the DataDirect ODBC driver manager distributed with your Optim solution to configure the server on a Linux or UNIX machine. For information needed to install and configure the DataDirect ODBC driver manager, see the Progress DataDirect "DataDirect Connect® Series for ODBC Users Guide". - We are using OOsqls27.so shipped with Optim, TESTODBC returns "Success"
    • The Optim directory cannot reside on Linux or UNIX. - Optim Direcory (DB2) is on Windows

    Could you please help me with the ODBC.ini file that you are using ? I would like to have a look at it

    Thanks,
    Suraj



    ------------------------------
    Suraj Shingri
    ------------------------------



  • 18.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Fri November 22, 2019 04:16 AM

    This is the SQL section from the ODBC.INI in Optim's .../rt/etc folder

     

    [<obfuscated DBAlias>]

    Driver=<obfuscated path>rt/bin/OOsqls27.so

    Description=IBM 7.1 SQL Server Wire Protocol

    AlternateServers=

    AlwaysRepPortNumber=

    QueryTimeout=0

    ReportCodePageConversionErrors=0

    SnapshotSerializable=0

    TrustStore=

    TrustStorePassword=

    ValidateServerCertificate=1

    WorkStationID=

    XMLDescribeType=-10

    ortTriggerResults=0

    AnsiNPW=1

    ApplicationName=

    ApplicationUsingThreads=1

    AuthenticationMethod=1

    BulkBinaryThreshold=32

    BulkCharacterThreshold=-1

    BulkLoadBatchSize=1024

    BulkLoadFieldDelimiter=

    BulkLoadOptions=2

    BulkLoadRecordDelimiter=

    ConnectionReset=0

    ConnectionRetryCount=0

    ConnectionRetryDelay=3

    Database=mddbqcbs

    EnableBulkLoad=0

    EnableQuotedIdentifiers=1

    EncryptionMethod=0

    FailoverGranularity=0

    FailoverMode=0

    FailoverPreconnect=0

    FetchTSWTZasTimestamp=0

    FetchTWFSasTime=1

    GSSClient=native

    HostName=<obfuscated server>\<obfuscated instance>

    HostNameInCertificate=

    InitializationString=

    Language=

    LoadBalanceTimeout=0

    LoadBalancing=0

    LoginTimeout=15

    LogonID=<obfuscated>

    MaxPoolSize=100

    MinPoolSize=0

    PacketSize=-1

    Password=<obfuscated>

    Pooling=0

    PortNumber=

    QueryTimeout=0

    ReportCodePageConversionErrors=0

    SnapshotSerializable=0

    TrustStore=

    TrustStorePassword=

    ValidateServerCertificate=1

    WorkStationID=

    XMLDescribeType=-1

     

     

     

    Thanks,

    Ed Lipson

    Director

    BNY Mellon | 2 Hanson Pl AIM 111-0800 | Brooklyn NY 11217

    Information Lifecycle Management

    T 718.315.4763 |  F 724.540.6622 | C 917.859.5180 | ed.lipson@bnymellon.com

     


    The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.

    Please refer to https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of www.bnymellon.com.





  • 19.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Fri November 22, 2019 06:37 AM
    Hello Ed,

    Thanks for sharing this, we have the same configuration. Could you please post pstserv.cfg and pstlocal.cfg files.

    Also, couple of questions below :

    1) Which version of Optim are you using to perform this task ?
    2) How are you setting up the environmental variables ? Example : ODBCINI, LD_LIBRARY_PATH etc ?
    3) Whether SQL Server is 64 or 32 bit ? 
    4) SQL Server uses Dynamic port ?

    Really appreciate your time on this

    Thanks,
    Suraj


    ------------------------------
    Suraj Shingri
    ------------------------------



  • 20.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Fri November 22, 2019 07:21 AM

    I can't really share all that, I would have to rip it apart to obfuscate anything about the environment, possibly masking something you need

     

     

     

    Thanks,

    Ed Lipson

    Director

    BNY Mellon | 2 Hanson Pl AIM 111-0800 | Brooklyn NY 11217

    Information Lifecycle Management

    T 718.315.4763 |  F 724.540.6622 | C 917.859.5180 | ed.lipson@bnymellon.com

     


    The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.

    Please refer to https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of www.bnymellon.com.





  • 21.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Fri November 22, 2019 01:55 PM

    I masked the data in the files which is considered sensitive internal only. I hope this helps. I'll be off next week, so I will not respond until then.

     

     

     

    Thanks,

    Ed Lipson

    Director

    BNY Mellon | 2 Hanson Pl AIM 111-0800 | Brooklyn NY 11217

    Information Lifecycle Management

    T 718.315.4763 |  F 724.540.6622 | C 917.859.5180 | ed.lipson@bnymellon.com

     


    The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.

    Please refer to https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of www.bnymellon.com.





  • 22.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Fri November 22, 2019 01:58 PM
      |   view attached
    Some file was rejected. I'll try uploading a zip​

    ------------------------------
    Ed Lipson
    BNYMellon
    Brooklyn NY
    718 315 4763
    ------------------------------

    Attachment(s)

    zip
    ODBC.zip   21 KB 1 version


  • 23.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Mon December 02, 2019 05:30 AM
    Hello Ed,

    Great help ! Thank you for sharing this.
    I had a look at your files and see that your Optim directory is hosted on Oracle.
    We have hosted our Optim directory on DB2 LUW and that is where the issue exists.
    I tried to switch our Optim directory to MS SQL and everything just works well.

    I will keep this thread updated if at all I find a solution to this.

    Thanks,
    Suraj

    ------------------------------
    Suraj Shingri
    ------------------------------



  • 24.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Mon December 02, 2019 05:41 AM

    Glad you got this to a resolution.

     

     

     

    Thanks,

    Ed Lipson

    Director

    BNY Mellon | 2 Hanson Pl AIM 111-0800 | Brooklyn NY 11217

    Information Lifecycle Management

    T 718.315.4763 |  F 724.540.6622 | C 917.859.5180 | ed.lipson@bnymellon.com

     


    The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.

    Please refer to https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of www.bnymellon.com.





  • 25.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Mon December 02, 2019 06:32 AM
    Hi Suraj - Just out of curiosity, does your Optim Directory on SQL Server is running on Windows server or Linux server?

    Regards,


    Özgür Gül

    The DOT Group Ltd | 23 Chelsea Wharf, Lots Road, Chelsea, London, SW10 0QJ | M: +44 (0) 7968 888152 | T: +44 (0) 20 7352 8423 | F: +44 (0) 20 7376 3089 | email: o.gul@dotgroup.co.uk






  • 26.  RE: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers

    Posted Mon December 02, 2019 08:23 AM
    Hello Ozgur,

    Our Optim directory is hosted on Microsoft SQL Server -Windows 2012 R2

    Thanks,
    Suraj

    ------------------------------
    Suraj Shingri
    ------------------------------