Skip to content

Commit 48b21c5

Browse files
rgwardrgward
committed
Update SAP HANA polybase files
Including saved notebook and removed creds
1 parent f905935 commit 48b21c5

8 files changed

Lines changed: 4434 additions & 16 deletions

File tree

‎sql2019lab/04_DataVirtualization/sqldatahub/saphana/createdb.sh‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1 +1 @@
1-
hdbsql -i90 -Icreatedb.sql -uSYSTEM -pCprsql2019 -dVANDELAY
1+
hdbsql -i90 -Icreatedb.sql -uSYSTEM -p<password> -dVANDELAY

‎sql2019lab/04_DataVirtualization/sqldatahub/saphana/createtab.sh‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1 +1 @@
1-
hdbsql -i90 -Icreatetab.sql -ubwsaphana -pCprsql2019 -dVANDELAY
1+
hdbsql -i90 -Icreatetab.sql -ubwsaphana -p<password> -dVANDELAY

‎sql2019lab/04_DataVirtualization/sqldatahub/saphana/createuser.sh‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1 +1 @@
1-
hdbsql -i90 -Icreateuser.sql -uSYSTEM -pCprsql2019 -dVANDELAY
1+
hdbsql -i90 -Icreateuser.sql -uSYSTEM -p<password> -dVANDELAY

‎sql2019lab/04_DataVirtualization/sqldatahub/saphana/createuser.sql‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
CREATE USER bwsaphana PASSWORD Cprsql2019 NO FORCE_FIRST_PASSWORD_CHANGE;
2-
GRANT AFLPM_CREATOR_ERASER_EXECUTE TO bwsaphana;
3-
GRANT CONTENT_ADMIN TO bwsaphana;
1+
CREATE USER bwsaphana PASSWORD Cprsql2019 NO FORCE_FIRST_PASSWORD_CHANGE;
2+
GRANT AFLPM_CREATOR_ERASER_EXECUTE TO bwsaphana;
3+
GRANT CONTENT_ADMIN TO bwsaphana;
44
GRANT MODELING to bwsaphana;

‎sql2019lab/04_DataVirtualization/sqldatahub/saphana/insertdata.sh‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1 +1 @@
1-
hdbsql -i90 -Iinsertdata.sql -ubwsaphana -pCprsql2019 -dVANDELAY
1+
hdbsql -i90 -Iinsertdata.sql -ubwsaphana -p<password> -dVANDELAY

‎sql2019lab/04_DataVirtualization/sqldatahub/saphana/insertdata.sql‎

Lines changed: 0 additions & 1 deletion
This file was deleted.

‎sql2019lab/04_DataVirtualization/sqldatahub/saphana/sap_external_table.sql‎

Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -1,21 +1,21 @@
11
-- Step 1: Create a master key to encrypt the database scoped credentials if they don't exist
22
USE [WideWorldImporters]
33
GO
4-
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'S0me!nfo'
4+
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<password>'
55
GO
66

77
-- Step 2: Create the database scoped credentials with the SAP HANA login and password
88
CREATE DATABASE SCOPED CREDENTIAL SAPHANACredentials
9-
WITH IDENTITY = '<login>', Secret = '<password>'
9+
WITH IDENTITY = 'bwsaphana', Secret = '<password>'
1010
GO
1111

1212
-- Step 3: Create a data source for the name of the server hosting SAP HANA and port
1313
-- LOCATION indicates what ODBC data source to used that you configured for the SAP driver
1414
-- CONNECTION_OPTIONS is connectiong string details to feed the driver.
1515
CREATE EXTERNAL DATA SOURCE SAPHANAServer
1616
WITH (
17-
LOCATION = 'odbc://<datasource>',
18-
CONNECTION_OPTIONS = 'Driver={HDBODBC};ServerNode=<server>:<port>',
17+
LOCATION = 'odbc://<SAP HANA Host>',
18+
CONNECTION_OPTIONS = 'Driver={HDBODBC};ServerNode=<SAP HANA Host>:<port>',
1919
PUSHDOWN = ON,
2020
CREDENTIAL = SAPHANACredentials
2121
)
@@ -29,10 +29,10 @@ GO
2929
-- The LOCATION is the <schema>.<table>
3030
CREATE EXTERNAL TABLE saphana.customers
3131
(
32-
CustomerID int,
33-
CustomerName nvarchar(100) COLLATE Latin1_General_100_CI_AS,
34-
AccountOpenedDate date,
35-
CustomerWebSite nvarchar(256) COLLATE Latin1_General_100_CI_AS
32+
CUSTOMERID int,
33+
CUSTOMERNAME nvarchar(100) COLLATE Latin1_General_100_CI_AS,
34+
ACCOUNTOPENEDDATE date,
35+
CUSTOMERWEBSITE nvarchar(256) COLLATE Latin1_General_100_CI_AS
3636
)
3737
WITH (
3838
LOCATION='[BWSAPHANA].[CUSTOMERS]',

0 commit comments

Comments
 (0)