Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why not just create a ColdFusion datasource and connect directly to the SAP database?

April 26, 2017ColdFusion Connect create database DataSource directly SAP

0

Posted

Why not just create a ColdFusion datasource and connect directly to the SAP database?

1 Answer

0

Posted

SAP does not allow external users or applications to connect directly to its underlying database. This could result in a breach of security or loss of data integrity and would probably make your system ‘not supported’ by SAP. In addition there are many thousands of tables in the SAP database and you may find it difficult to work out which ones to use. Some tables in the database cannot be read directly because the fields are packed or stored in unreadable ‘internal’ formats. Therefore all interactions with the SAP database should be moderated by the SAP application server. SAP provides BAPIs and RFCs for external developers to access SAP data via the SAP application server. CF2SAP works with these APIs.