There have been a lot of updates to Smart Data Access and a lot of bugs have been fixed in newer revisions.
** As an alternative, you can create a remote source through SQL using the following command: CREATE REMOTE SOURCE ĪDAPTER “odbc” CONFIGURATION FILE ‘property_orcl.ini’ CONFIGURATION ‘DSN=’ WITH CREDENTIAL TYPE ‘PASSWORD’ USING ‘user= password=’ Press the execute button to save this connection.Fill in connection properties and credentials.Netezza – Netezza version 7 added in SP8.MSSQL – Microsoft SQL Server ver11 support added in SP7.Oracle – Oracle 12c support added in SP7.Generic ODBC – This to connect to other databases that support ODBC protocol, however we do not guarantee that it will.ASE – Adaptive Service Enterprise: version 15.7 ESD#4.You to enter in the connection information
Click on the Adapter Name drop down select the appropriate adapter (for this example we will select Oracle).The main window pane will request you to enter in the connection information.Right click on the Remote Sources folder and select New Remote Source….Studio by doing the following (we are using Oracle in our example) Once you have configured your ODBC files to the external data source of your choosing you can setup a connection to that source in ** Please note that you could connect to other databases via ODBC, but please note that we cannot guarantee that it will work. What Remote Sources Are Supported (As of SP8)?
ForĪssistance on how to install the Database drivers on how to install the database drivers for SAP HANA Smart Data Access please refer to SAP noteġ868702 and refer to the SAP HANA Learning Academy videosĭocumentation on SDA can be found in the SAP HANA Admin guide chapter 6įor information on what upgrades to SDA has occurred with each revision of SAP HANA please feel free to review the following Prior to connecting to a remote database you will need to configure an ODBC connection from the server to the remote database. Smart Data Access was introduced in SAP HANA SP6, so if you intend on using SDA be on at least this revision. This allows it so customers do not have to migrate or copy their data from other databases into a SAP HANA database. Once a remoteĬonnection to a data source is done we can virtually connect to the tables and query against is or use in data models as if it were data that resides in a SAP
SDA allows customers to access data virtually from remote sources such as Hadoop, Oracle, Teradata, SQL Server, and more. Throughout the blog, I will reference links to other documentation that can cover the topics in more detail. There is already a lot of information on Smart Data Access which this blog does not aim to replace. Some of the issues outlined in the troubleshooting section come directly from incidents that were created. This blog will focus on basic setup of Smart Data Access (SDA) and then outline some problems that customers have encountered. Please have a look as it’s a great resource! SDA Modeling Recommendations 2016 Purpose I’ve attached a guide that outlines general best practices with Smart Data Access.