SFTP User Guide - IBM

1y ago
6 Views
2 Downloads
696.94 KB
7 Pages
Last View : 28d ago
Last Download : 3m ago
Upload by : Laura Ramon
Transcription

COGNOS ANALYTICS ON CLOUDSFTP USER GUIDE

Prerequisites1. SFTP Client (terminal or FileZilla)2. private SSH Key from the key pair that the public key was provided to IBM toconfigure sftp uploadsConnect to SFTP Server1. Using command line or terminal (recommend for Linux and mac)Use the following sftp command to connect to the upload service:sftp -i private-key-file sftpuser@upload. release url For example:sftp -i /.ssh/id rsa sftpuser@upload.abc.ca.analytics.ibm.com2. Using FileZilla (recommend for Windows)Create a new site- Choose SFTP Protocol- Input upload. environment url in host- Choose Key File as Logon Type- Input sftpuser in User- Choose private key in Key file

Directory StructureThe user upload directories are organized as shown below: user-sftp-root - dropbox - certificates - datasource - oidc - deployment - fonts - powercubes (closed by default) - report-drivers - webcontentCertificates- User can use the standard sftp put command to upload certificates onto datasource andodic directories under certificates.Data Source CertificateData source certificates uploaded onto certificates/datasource directory will be importedinto both JVM Trust Store and CAM Trust Store on all BIApp containers in order tosupport various JDBC driver implementations. Here are some technical details:1. Depends on the driver's caching strategy, restart of CA is required for drivers thatcaches the certificates without any dynamic cache-refresh mechanism in place.2. For drivers that able to react to key store updated:o If the driver uses CAM crypto's implementation of the SSLSocketFactory,then CA would need to be restarted.o If the driver uses CAM crypto's implementation via Websphere'sSSLSocketFactory, then no need to restart CA because WLP will reloadthe key store every 60 secs if it has changed.o Restart of CA is not required for driver that uses JVM trust store.If restart is required, user will need to support after uploading their data sourcecertificates.Authentication Provider Certificate

- Only OIDC authentication provider certificates are supported.- OIDC provider certificates uploaded onto certificates/oidc directory will beimported into CAM Trust Store on CM containersPlease note a restart is required contact support after certificates are uploaded.- Removing certificates from certificates/oidc directory will not delete thecorresponding certificates from the CAM Trust Store.DeploymentImport Deployment Archive- User can use the standard sftp put command to upload deployment archiveonto the deployment directory.- Deployment archive(s) uploaded to the deployment directory will be replicatedonto a shared volume consumable by CA.- After the replication process is completed, user should able to import thedeployment archive using the product UI. Depends on the size of the archive, thereplication process may take few seconds to minutes.- User can safely delete the uploaded archive once the import is completed. Whenthe uploaded archive is removed from the user home directory, the correspondingreplicated copy on the shared volume will also be removed as well.Export Deployment Archive- Deployment archive exported by the user will be available for download fromthe deployment directory once the export process is completed.- User can then use the standard sftp get command to download the archive ontoa local storage.- After the archive is downloaded, user can safely delete the archive fromthe deployment directory, which will also remove the archive from the productdirectory as well.- User can also download deployment through FileZila.

PowercubesUpload of powercubes is closed by default and enabled only on demand. Because thepowercube is not setup by default. User can contact support to setup powercube.Fonts- User can upload customize font which can be used in reports and dashboard.- User needs to contact support to restart Cognos to pick up the fontsReport-drivers- User can upload customer database JDBC drivers by using standard sftp put command- User needs to contact support to restart Cognos to pick up the driver.Webcontent- User can use the sftp's mkdir and put commands to create the desired webcontentoverlay directory structure and content. If user wants to create subfolders to help youorganize images. - webcontent - FolderA - folderA - folderB - folderC- All web artifacts (e.g. javascripts, images) uploaded to the webcontent directory will bereplicated onto a shared volume consumable by CA.- Removing web artifacts from this webcontent directory will also remove thecorresponding replicated copy on the shared volume.Dropbox compressed fileInstead of uploading files one at a time, user can upload a "dropbox compressed file"onto the dropbox directory, and it will be expanded onto all sub-directories under thedropbox directory automatically:- The compressed file must be uploaded onto the dropbox directory.- Only "zip" format is support, and the file extension must be ".zip".

- Once the compressed file is uploaded, the upload service will decompress the contentonto the dropbox directory. Therefore, all paths within the compressed file must berelative to the dropbox directory.- Only content under the predefined directories (i.e. certificates, deployment, powercubes,webcontent) will be extracted from the compressed file. Other contents will be ignored.Import images to report-Webdev is not enabled, user cannot browse imagesUser can review images by hitting:https:// release url .ca.analytics.ibm.com/ images name User needs to input PATH in the image Picker for l.pngExport Deployment to sftp server-open Administration consolechoose Conifugration Tab and click Content AdministrationUse New export to create a new deployment

-Log to sftp server and change the directory to deploymentIssue get to download deploymentBasic sftp commands that are allowedls:list the contents of the current directorycd:change the directory on the remote hostput:copy a file from local computer to the remote hostpwd:show the present directoryrm:remove file on the remote hostmkdir: create a directory on the remote hostget:copy a file from the remote host to the local computer

SFTP Client (terminal or FileZilla) 2. private SSH Key from the key pair that the public key was provided to IBM to configure sftp uploads Connect to SFTP Server 1. Using command line or terminal (recommend for Linux and mac) Use the following sftp command to connect to the upload service: sftp -i private-key-file sftpuser@upload. release url

Related Documents:

Feb 10, 2009 · Using z/OS Ported Tools SFTP server From a non-z/OS OpenSSH sftp client: Under the covers, sftp uses the ssh command to connect to z/OS SSHD's sftp subsystem. Host key was accepted and added to the client file: /.ssh/authorized_keys ssh option “-o StrictHostKeyChecking no” will automatically accept a new host key kirk@ubuntu: sftp kirk .File Size: 486KBPage Count: 31Explore furtherzos - Connect to z/OS Mainframe with SFTP - Stack Overflowstackoverflow.comc# - How to use SFTP to submit/retrieve batch jobs to .stackoverflow.comSFTP: Securing File Transfer to and from z/OS - SDS Blogwww.sdsusa.comSFTP in mainframe -IBM Mainframesibmmainframes.com7 Usefull SFTP Command Line Examples In Linuxwww.rosehosting.comRecommended to you b

SFTP webservice En webservice der udstilles på Serviceplatformen som en del af SFTP servicen. 3 SFTP Service beskrivelse Serviceplatformens SFTP Service gør det muligt for it-systemer at udveksle filer med hinanden på en kontrolleret måde. Udvekslingen af en fil sker ved at et afsendersystem uploader en fil til Serviceplatformens SFTP Server,

SFTP Users are generally permitted a maximum of 5GB per account. Users of certain Bloomberg products, such as Data License, are allowed more per account. Files stored on BB-SFTP may be deleted on a rolling 30-day basis. BB-SFTP is a store and forward system, it does not archive files; this is the responsibility of SFTP Users.

SFTP or Secure File Transfer Protocol is a secure file transfer tool between a SFTP server and user, using a SFTP client or SFTP software. The file is encrypted during the transfer, but not while it is sitting on the server. Access is facilitated by utilizing a public/private key pair exchange between client and server and user ID and password.

Modi ed IBM IBM Informix Client SDK 4.10 03/2019 Modi ed IBM KVM for IBM z Systems 1.1 03/2019 Modi ed IBM IBM Tivoli Application Dependency Discovery Manager 7.3 03/2019 New added IBM IBM Workspace Analyzer for Banking 6.0 03/2019 New added IBM IBM StoredIQ Suite 7.6 03/2019 New added IBM IBM Rational Performance Test Server 9.5 03/2019 New .

Smart Copy and Checkpoint Resume 95 SFTP Directories Pane 96 Accessible Directory Settings Dialog Box 99 Remote SFTP Server Connection Dialog Box 101 Server Tab - Remote SFTP Server Connections 101 Options Tab - Remote SFTP Server Connections 103 Web Edition Users 105 Web Edition Users Pa

Filing Bulk Returns with SFTP more than 10MB . Following is an outline of the steps needed to submit bulk returns through DOR's secure SFTP site for all WH- 1 and MVR-103 files, and WH-3 files with a file size larger than 10Mb. The file layout of the specific return being filed must be followed exactly as published. Encryption for SFTP Submission

artificial intelligence affordances: deep-fakes as exemplars of ai challenges to criminal justice systems by hin-yan liu and andrew mazibrada 7. artificial intelligence and law enforcement: the use of ai-driven analytics to combat sex trafficking by clotilde sebag 8. data regimes: an analytical guide for understanding how governments regulate data by hunter dorwart and olena mykhalchenko 7 18 .