Home / SAP Advantage Database Server (page 2)

SAP Advantage Database Server

Using ProcMon

First we are going to need to download Process Monitor. Start up ProcMon and it will start showing you information. We are going to want to apply a filter. We want to find out where it is attempting to find our ADS.ini file, so to do so we are going …

Read More »

Advantage Features for High Availability

Advantage Database Server has many features that provide high availability to end-users all while preserving our core ideals of low administration and ease of use. These features include Server-Side Aliases, Online Backup and Replication. Each of these features can be used to preserve data and allow for access to this …

Read More »

Web API Server 2008

If the statement is too long (browsers or web servers have a limit to how long the URI can be) you should send the statement and any parameters in the data payload of the request. Simply use http://server/adsweb/location/__query as the URI and then specify the query and parameters in the …

Read More »

Moving data in ARC

Create a link in the new dictionary that point to the old one (e.g. name it olddata) and then use SQL:     INSERT INTO mytable SELECT * FROM olddata.mytable If you don’t use data dctionaries, you can select from the relative path:     INSERT INTO mytable SELECT * FROM [.olddatamytable]

Read More »

ADS on Windows Cluster

Installing and Running the Advantage Database Server on a Windows Cluster. The Advantage Database Server can be installed on a Microsoft Cluster Server (MSCS) to provide fail-over capabilities. Advantage does not currently support Network Load Balancing, which distributes incoming IP traffic among multi-node clusters. Additionally, the Advantage Database Server does …

Read More »

Open an ADS support incident

Open https://support.sap.com Click to the “Keys, Systems & Installations” option on the top Select the System Data on the left side Click on the “create System without license key” Proceed with the “Click here” button in the middle of the screen Now you will get a login screen for the …

Read More »

Advantage How To Articles

I am currently working on several How To articles for Advantage. I have posted the first one How To: Troubleshoot an Advantage Connection Issue. I am working on several more on various topics. Here are some of my ideas so far.   Setup Replication   Configure a WAN Connection   …

Read More »

Webcast Recording Available

Last week I did a webcast with the help from other members of the Advantage team. During the webcast I discussed some of the new items included in version 11.1, using Advantage on a Amazon EC2 image and using the Advantage Web Administrator. The webcast was well attended and I …

Read More »