Ad Manager Data Warehouse: Setup and configuration - Revision history

Ivan.belenski: /* External links */

2018-08-03T20:30:17Z

‎External links

2018-08-03T20:24:42Z

‎Monitor disk space

2018-08-03T20:22:02Z

2018-08-03T20:18:52Z

‎Configure the data pump

2018-08-03T20:18:31Z

‎Create the database tables and views

2018-08-03T20:18:06Z

‎Install the data pump

2018-08-03T20:16:21Z

‎Monitor disk space

2018-08-03T20:13:20Z

‎Schedule the execution of the data pump

2018-08-03T20:06:45Z

‎Examine the data

2018-08-03T20:03:37Z

‎Examine the data pump logs

← Older revision		Revision as of 20:30, 3 August 2018
Line 203:		Line 203:

	[https://docs.microsoft.com/en-us/sql/relational-databases/databases/create-a-database?view=sql-server-2017 Create a Database]		[https://docs.microsoft.com/en-us/sql/relational-databases/databases/create-a-database?view=sql-server-2017 Create a Database]
		+
		+	[https://notepad-plus-plus.org/ Notepad++]

← Older revision		Revision as of 20:24, 3 August 2018
Line 197:		Line 197:

	Snapshots with a given cut-off date will tend to get larger as time goes on and new data accumulates in Ad Manager.		Snapshots with a given cut-off date will tend to get larger as time goes on and new data accumulates in Ad Manager.
		+
		+	== External links ==
		+
		+	[https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/managing-logins-users-and-schemas-how-to-topics?view=sql-server-2017 Managing Logins, Users, and Schemas]
		+
		+	[https://docs.microsoft.com/en-us/sql/relational-databases/databases/create-a-database?view=sql-server-2017 Create a Database]

@@ Line 43: / Line 43: @@
 Open the folder containing the data pump SQL scripts in Windows explorer (Start : Dot2Dot Analytics Data Pump : Sql).
-[[File:Adp-01.png|480px]]
+[[File:Adp-01.png|600px]]
 Drag the file named "create-tables.sql" into SQL Server Management Studio and execute it against the data warehouse database.
@@ Line 57: / Line 57: @@
 Open the data pump's application data folder (Start : Dot2Dot Analytics Data Pump : Application Data) and edit the "AnalyticsDataPump.xml" in a text editor (we suggest [https://notepad-plus-plus.org/ Notepad++]).
-[[File:Adp-02.png|480px]]
+[[File:Adp-02.png|600px]]
 === Data warehouse connection ===
@@ Line 156: / Line 156: @@
 The data pump does not require elevated privileges.
-[[File:Adp-03.png|480px]]
+[[File:Adp-03.png|600px]]
 Set up the times that will trigger the task execution.
-[[File:Adp-04.png|480px]]
+[[File:Adp-04.png|600px]]
 Set up starting the "AnalyticsDataPump.exe" program (located in "C:\Program Files (x86)\Dot2Dot\Analytics Data Pump" by default) as the action of the task.
-[[File:Adp-05.png|480px]]
+[[File:Adp-05.png|600px]]
 == Monitor the data warehouse ==

← Older revision		Revision as of 20:18, 3 August 2018
Line 56:		Line 56:

	Open the data pump's application data folder (Start : Dot2Dot Analytics Data Pump : Application Data) and edit the "AnalyticsDataPump.xml" in a text editor (we suggest [https://notepad-plus-plus.org/ Notepad++]).		Open the data pump's application data folder (Start : Dot2Dot Analytics Data Pump : Application Data) and edit the "AnalyticsDataPump.xml" in a text editor (we suggest [https://notepad-plus-plus.org/ Notepad++]).
		+
		+	[[File:Adp-02.png\|480px]]

	=== Data warehouse connection ===		=== Data warehouse connection ===

← Older revision		Revision as of 20:18, 3 August 2018
Line 42:		Line 42:

	Open the folder containing the data pump SQL scripts in Windows explorer (Start : Dot2Dot Analytics Data Pump : Sql).		Open the folder containing the data pump SQL scripts in Windows explorer (Start : Dot2Dot Analytics Data Pump : Sql).
		+
		+	[[File:Adp-01.png\|480px]]

	Drag the file named "create-tables.sql" into SQL Server Management Studio and execute it against the data warehouse database.		Drag the file named "create-tables.sql" into SQL Server Management Studio and execute it against the data warehouse database.

← Older revision		Revision as of 20:18, 3 August 2018
Line 26:		Line 26:

	The installer will create a Start menu folder named "Dot2Dot Analytics Data Pump".		The installer will create a Start menu folder named "Dot2Dot Analytics Data Pump".
−
−	~~[[File:Adp-01.png\|480px]]~~

	== Create the data warehouse database ==		== Create the data warehouse database ==

← Older revision		Revision as of 20:16, 3 August 2018
Line 191:		Line 191:

	=== Monitor disk space ===		=== Monitor disk space ===
		+
		+	After each run of the data pump it's a good idea to check how much the database has grown. This can help estimate the size of a snapshot and how much room for the database to grow there is.
		+
		+	Snapshots with a given cut-off date will tend to get larger as time goes on and new data accumulates in Ad Manager.

@@ Line 155: / Line 155: @@
 === Examine the data pump logs ===
 === Examine the data ===
 === Monitor disk space ===