Gartner magic quadrant for metadata management solutions:
find better solutions for analytics world
Gartner magic quadrant for metadata management solutions:
Augmented Data Catalogs: Now an Enterprise Must-Have for Data and Analytics Leaders
https://www.gartner.com/doc/reprints?id=1-1OI94B0U&ct=190917&st=sb
This article is a good read.
Top 10 Strategic Technology Trends for 2020
A Gartner Special Report
https://www.gartner.com/en/doc/432920-top-10-strategic-technology-trends-for-2020
Currently Tableau doesn’t have personal folders kind of structure. With below steps you could create a personal folders for your organization.
1. Create a new project – Personal folders
2. at permissions – For “All Users” set project permissions as – Publisher. Leave rest all to none
3. click on “Edit Content Permissions” and then select “Locked to the project”
personal folders are ready. Content is only visible to publishers and admins only.
Source:
Keywords:
How to create personal folders in tableau.
Though using Tableau UI we can schedule pdf email but it doesn’t give us the flexibility in setting up page layout, scaling, sending email outside of tableau users, etc.,
I used below script to achieve this
Assumptions:
Tableau url: tableau.abc.com
Tableau workbook url: tableau.abc.com /#/site/sitename1/views/DashboardName_1/ViewName_1
Tableau logon user name: user_1 , password: Password_1
Email address to use for sending email: user_1@abc.com
Email recipients: user_2@abc.com; user_3@abc.com
Tableau tabcmd installed path: E:\Tableau\Command Line Utility\tabcmd.exe
Power shell installation path: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
Power shell script path: E:\Tableau\Command Line Utility\ps_tableau_script.ps1
Pdf output location: E:\TableaurRportOutput\DashboardPdf_1
Below is the power shell script.
Smtp server: smtpxy.abc.gov
Before writing power shell script make sure you are able to send email using command prompt.
You can schedule power script using windows scheduler.
Powershell script: save below code as .ps1 format.
try
{
$file = “E:\TableaurRportOutput\DashboardPdf_1″+ “_” + $(get-date -f yyyy-MM-dd) + “.pdf”
#login to tableau and export pdf to a location.
./tabcmd.exe login -s https:// tableau.abc.com -t sitename1-u user_1 -p Password_1 $ –no-prompt
#-h –no-prompt
#–timeout 5
./tabcmd export ” DashboardName_1/ViewName_1″ –fullpdf –pagelayout landscape –pagesize letter -f $file –no-prompt
./tabcmd logout
#sending email
$FromEmail = “user_1@abc.com”
[string[]]$ToEmail = @(“user_2@abc.com”,”user_3@abc.com”)
$smtpserver = ” smtpxy.abc.gov ”
$Subject=”PDF Dashboard Report”
$message=”
Good morning,
`n
Please see attached the Dashboard daily report.
”
send-mailmessage -from (“$FromEmail”) -to ($ToEmail) -subject “$Subject” -Attachment $file -body “$message ” -BodyAsHtml -smtpServer $smtpserver
}
#failure email
catch [Exception]
{
Write-Host (“Errorcount $errorcount”)
Write-Host (“Error: {0}” -f $_.Exception.Message)
$errorcount = $errorcount + 1
$message = $_.Exception.Message
if ( $errorcount -eq 1)
{
send-mailmessage -from (“$FromEmail”) -to ($FromEmail) -subject “$Subject failed” -body “$message” -smtpServer $smtpserver
}
Start-Sleep -s 600
}
sql server disk space used by database.
You need to run following query on each database to get information by tables and its size on disk with number of rows.
SELECT
t.NAME AS TableName,
s.Name AS SchemaName,
p.rows,
SUM(a.total_pages) * 8 AS TotalSpaceKB,
CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB,
SUM(a.used_pages) * 8 AS UsedSpaceKB,
CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS UsedSpaceMB,
(SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB,
CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS UnusedSpaceMB
FROM
sys.tables t
INNER JOIN
sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN
sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN
sys.allocation_units a ON p.partition_id = a.container_id
LEFT OUTER JOIN
sys.schemas s ON t.schema_id = s.schema_id
WHERE
t.NAME NOT LIKE 'dt%'
AND t.is_ms_shipped = 0
AND i.OBJECT_ID > 255
GROUP BY
t.Name, s.Name, p.Rows
ORDER BY
SCHEMANAME,TotalSpaceMB DESC, t.Name
ibm i2 ibase
few referral documents:
i2 ibm documentation:
https://www.ibm.com/support/knowledgecenter/SSXVXZ_2.3.0/com.ibm.i2.landing.doc/eia_welcome.html
https://www.ibm.com/support/knowledgecenter/SSXVXZ_2.3.0/com.ibm.i2.landing.doc/enterprise_insight_analysis.html
ibm i2 ibase
https://www.securitylearningacademy.com/local/navigator/index.php?level=spaa04&courseTypes=Video%20Course
IBM i2 EIA Lab enviroment:
https://www.securitylearningacademy.com/mod/hvp/view.php?id=6513#
https://labs.edu.ihost.com/sec9769.a1ba8c1383f7@1f80433ec391a3e43.b2b.foo/0eed
ibm i2 videos
https://www.ibm.com/support/pages/i2-youtube-video-index
https://www.youtube.com/user/IBMSecuritySupport/playlists?sort=dd&shelf_id=13&view=50
Default pdf output from tableau would have a huge margin. Currently using tableau server I don’t see a solution. But using Tableau desktop i was able to fix this.
in tableau desktop
1. go to file–> page setup–> remove margins
2. go to file–> print to pdf –> paper size – Unspecified.
Below URL’s provide very good understanding of spatial joins in sql server
https://docs.google.com/file/d/0B0hWbrRTteuIekZtQ0NqWTBoNVk/edit