I've attached a guide that outlines general best practices with Smart Data Access. Please have a look as it's a great resource!
This blog will focus on basic setup of Smart Data Access (SDA) and then outline some problems that customers have encountered. Some of the issues outlined in the troubleshooting section come directly from incidents that were created.
There is already a lot of information on Smart Data Access which this blog does not aim to replace. Throughout the blog, I will reference links to other documentation that can cover the topics in more detail.
SDA allows customers to access data virtually from remote sources such as Hadoop, Oracle, Teradata, SQL Server, and more. Once a remote
connection 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
HANA database.
This allows it so customers do not have to migrate or copy their data from other databases into a SAP HANA database.
Smart Data Access was introduced in SAP HANA SP6, so if you intend on using SDA be on at least this revision.
Prior to connecting to a remote database you will need to configure an ODBC connection from the server to the remote database. For
assistance 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
1868702 and refer to the SAP HANA Learning Academy videos
https://www.youtube.com/watch?v=BomjFbJ25vo&index=16&list=PLkzo92owKnVx_X9Qp-jonm3FCmo41Fkzm
Documentation on SDA can be found in the SAP HANA Admin guide chapter 6
http://help.sap.com/hana/SAP_HANA_Administration_Guide_en.pdf
For information on what upgrades to SDA has occurred with each revision of SAP HANA please feel free to review the following
SP6 -> SP 7 delta
http://www.saphana.com/servlet/JiveServlet/previewBody/4296-102-7-9005/HANA_SPS07_NEW_SDA.pdf
SP7 -> SP 8 delta
http://www.saphana.com/docs/DOC-4681
Hadoop
Teradata
SAP HANA
Oracle 12c
Sybase ASE
Sybase IQ
DB2 (SP8)
Microsoft SQL Server 2012
Apache Spark (SP8)
** Please note that you could connect to other databases via ODBC, but please note that we cannot guarantee that it will work. **
Once you have configured your ODBC files to the external data source of your choosing you can setup a connection to that source in
Studio by doing the following (we are using Oracle in our example)
There have been a lot of updates to Smart Data Access and a lot of bugs have been fixed in newer revisions.
Here are some key links you should read for that information:
1868209 - SAP HANA Smart Data Access: Central Note
2180119 - FAQ: SAP HANA Smart Data Access
** MORE issues will be updated at the bottom **
man-ted.chan
jimmy.yang2
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
10 | |
10 | |
9 | |
8 | |
7 | |
7 | |
7 | |
7 | |
6 |