Transcribing services in cloud platforms like Amazon Web Services (AWS) and Microsoft Azure allow you to convert audio content into written text. This guide will walk you through the steps to enable and configure these services in Venio.
Warning: These operations require database access and should be executed by a database administrator or someone familiar with SQL. If you are uncomfortable with or unsure about these steps, please contact Venio's support team for further assistance.
Enable Transcribing: First, enable the transcription feature in Venio by executing the following SQL query within the VenioPCD:
update Tbl_Pj_ControlSetting set [Value] =1 where [Key] = 'ENABLE_TRANSCRIPT'
Configure AWS and Azure Keys: Execute the queries below in VenioPCD. These will insert the necessary keys into the table, after which you can insert the respective values for AWS and Azure:
<key-id>, <secret-key>, and <region> with your actual AWS or Azure access keys and regions respectively. Always handle access keys securely and avoid sharing them unnecessarily.-- AWS Access Key ID
IF NOT EXISTS (
SELECT TOP 1 1
FROM [tbl_pj_ControlSetting]
WHERE [key] = 'AWS_ACCESS_KEY_ID'
)
INSERT [tbl_pj_ControlSetting] (
[KEY]
,[VALUE]
,AdditionalNotes
)
VALUES (
'AWS_ACCESS_KEY_ID'
,'<key-id>'
,'AWS access key id'
)
-- AWS Secret Access Key
IF NOT EXISTS (
SELECT TOP 1 1
FROM [tbl_pj_ControlSetting]
WHERE [key] = 'AWS_SECRET_ACCESS_KEY'
)
INSERT [tbl_pj_ControlSetting] (
[KEY]
,[VALUE]
,AdditionalNotes
)
VALUES (
'AWS_SECRET_ACCESS_KEY'
,'<secret-key>'
,'AWS secret access key'
)
-- AWS Region
IF NOT EXISTS (
SELECT TOP 1 1
FROM [tbl_pj_ControlSetting]
WHERE [key] = 'AWS_REGION'
)
INSERT [tbl_pj_ControlSetting] (
[KEY]
,[VALUE]
,AdditionalNotes
)
VALUES (
'AWS_REGION'
,'<region>'
,'Region for AWS'
)
-- S3 Bucket Expiration in Hours
IF NOT EXISTS (
SELECT TOP 1 1
FROM [tbl_pj_ControlSetting]
WHERE [key] = 'S3_BUCKET_EXPIRATION_IN_HOURS'
)
INSERT [tbl_pj_ControlSetting] (
[KEY]
,[VALUE]
,AdditionalNotes
)
VALUES(
'S3_BUCKET_EXPIRATION_IN_HOURS'
,'24'
,'Expiration time in hour for s3 bucket objects'
)
<key-id>, <secret-key>, and <region> with your actual AWS or Azure access keys and regions respectively. Always handle access keys securely and avoid sharing them unnecessarily. -- Azure Access Key
IF NOT EXISTS (
SELECT TOP 1 1
FROM [tbl_pj_ControlSetting]
WHERE [key] = 'AZURE_ACCESS_KEY_ID'
)
INSERT [tbl_pj_ControlSetting] (
[KEY]
,[VALUE]
,AdditionalNotes
)
VALUES (
'AZURE_ACCESS_KEY_ID'
,'<key-id>'
,'Azure Access Key'
)
-- Azure Region
IF NOT EXISTS (
SELECT TOP 1 1
FROM [tbl_pj_ControlSetting]
WHERE [key] = 'AZURE_REGION'
)
INSERT [tbl_pj_ControlSetting] (
[KEY]
,[VALUE]
,AdditionalNotes
)
VALUES (
'AZURE_REGION'
,'<region>'
,'Azure Region'
)
Warning: These operations require database access and should be executed by a database administrator or someone familiar with SQL. If you are uncomfortable with or unsure about these steps, please contact Venio's support team for further assistance.