Hi everyone,
My company AGEO (insurance broker) is to be investing in new platform on SAS (Data Manager, Enterprise Guide, Visual Analytics). This plateform needs to have a connector to discuss with the Sybase (SAP Product) database, our partner Business&Decision said and advise us to use SAP ASE, but which ASE product will be convenience to Sybase database beacause there are sereral SAP ASE products, so could please advice us to choose the good one?
Kind regards,
Steeve Jacquin
+33 326 261 259
Hi Steeve,
I'm not sure to understand correctly your question, but let's try:
- if you already have an ASE database installed and you just need the connector, you will require SAP SDK for SAP ASE product.
- for a complete ASE database installation, you should use the "SAP ADAPTIVE SERVER ENTERPRISE" product (https://launchpad.support.sap.com/#/softwarecenter/template/products/_APP=00200682500000001943&_EVENT=DISPHIER&HEADER=N&FUNCTIONBAR=Y&EVENT=TREE&NE=NAVIGATE&ENR=01200314694400000722&V=INST&ROUTENAME=products/Database%20and%20Database%20Patches%20-%20SAP%20Adaptive%20Server%20Enterprise), and by preference the last version of the 16.0 release (SAP ASE 16.0), but maybe your software vendor has some requirements regarding which version is the recommended for their software. Connectors are included with SAP ASE product.
HTH,
Best regards,
Victoria.
Hi,
For the most part you will need the SDK for SAP ASE to connect to the ASE database.
You will most likely use ODBC, JDBC, or Open Client/ct-library to connect to the ASE.
The product SAS will require you to load the drivers above from the SDK install so it can connect.
Simple example is MS Excel.
Excel uses SDK for SAP ASE ODBC driver. Excel loads the driver and uses host and port information to connect to ASE.
Your sales rep may have a better idea on how to integrate different products together as well.
Regards,
Ryan