You can fix this issue by adding Global before all calls giving the error. This has happened cos of system namespace in BAPI and Windows.ExampleAnother possible solution of this is by adding an alias for System.XML and change System.XML with SysXml as below:using SysXml = System.Xml; /// [System.Xml.Serialization.XmlElementAttribute(Form=SysXml.Schema.XmlSchemaForm.Unqualified)] public string Type {    get {       return this.typeField;       set {          this.typeField = value;       }    } }

As per my understanding of your question, the better option for you will be to code the selection in ABAP. Then you can wrap this selection in a function module which will be remote function call enabled. Then go ahead and use this module.But let’s say you are not able to use it, then only remaining option for you will be ‘RFC_READ_TABLE’ but it has got its own problems.

I am wondering why you are planning to opt for SSIS for this. It would not be that easy and compatible. Instead, I will suggest you to for any of the below two optionsUse SAP BW standard anyDB source systemBO Data servicesBoth of the options are well compatible and do the data load well and in a native manner.

To get the server name of SAP HANA server, you need to check the virtual machine (VM) list.You can find this list under Virtual machine details of your corresponding HANA SPS5 server’s External Address property.Usually, the port number is 30015.For the problem that you are facing regarding the connection set up, you can refer below link for more details.https://blogs.sap.com/2013/06/17/connecting-to-your-hana-database-from-php-using-odbc/

I think you knew the answer beforehand as you already mentioned it in your question. You need to set an SAP user for every user to work the SAP prescribed way otherwise you are violating the service agreement of SAP and hence support will be void.

I must say, you got a pretty odd scenario of permission retraction but it is feasible.Create a stored procedure with entire onus of activating/deactivating the user or you can say authorize and de-authorize user.Create a batch user with privilege to execute the above-created procedures,Then you can set up a job to run the procedures with the help of hdbsql.

SAP NetWeaver is just a term used for SAP system. All SAP systems are mostly running on NetWeaver. SAP PI is one of common integration tool like Biztalk and it is not necessary that all clients has SAP PI system for integration.You should use Remote Function Call RFC in SAP system for integration. RFC is an interface provided by ABAP server and can be used for both synchronous and asynchronous data transfer. Remote Function Call (RFC Connection) between two systems. By creating a trusted RFC connection between two systems, it allows you to create trusted-trusting relationship between systems wherein, you ... Read More

You can use a SWITCH CASE statement to handle your scenario. This is a good choice if you know well in advance what all properties are required and what is not required. Also, it will let you to unit test your code.Otherwise, you can go for a collection like a dictionary.You can think of using HashSet or hashtable as well, it entirely depends upon the usage of the list created.

You can use SAP GUI. It has built-in tool which can record and playback activity that can be utilized for automation and automated jobs. In case, the values or inputs are not changing then you can use the same script on each occasion.It lies within the main menu of the GUI window, within Customize layout -> Script recording and playback.

Before I make any proposal, I am assuming that you understand both oData and REST very well. REST is a well-known and accomplished architecture style whereas oData is a protocol for communication.OData resides on top of Atompub protocol which in turn is based on REST so overall oData seems to follow REST path only and it is implemented in a similar manner.The advantage that you get with oData is that it saves a lot of effort and time in handling client side either by writing Javascript code or something else. I agree that the support in JAVA for oData will ... Read More