Page Comparison

...

Note: The instructions on this page primarily apply to_hosted_PCR-360 Customers who want to access their data using third-party software. This does_not_discuss the PCR-360 feature to import and run Crystal Report RPT files. That feature is found at Crystal Reports (Deprecated). More specific discussion of developing Crystal Reports in particular is found at Crystal Development.

PCR-360 for Hosted Customers runs on a protected server that doesn't allow direct access to the data service. You must have a SSH login to connect to the server, and "tunnel" your database connection through that SSH connection. For purposes of instruction, this discussion will focus on Crystal Reports, but generally applies to any Windows software that uses ODBC to connect to data sources.

...

If you've been instructed to use a SSH Key to connect, you should have your private key available, and it must be in PuTTY format (has a .ppk file extension). See below for additional instruction. Once you're prepared, import your Key into the profile:

1. Click the Client Key Manager link as indicated in the illustration.

2. Click the [Import] button.

3. Provide your Key's passphrase if prompted.
4. On the import dialog, you can choose to make the key Global - it will be available for any profile you create - or Profile only.
5. Finish the import, and a row is added to your Client Key Manager. Close that form.
6. Select the imported Key ID from the list.
7. If you provide your Key's passphrase in the space provided, it may not be saved with the profile (for security reasons), meaning you will need to provide it each time you want to connect so Bitvise can unlock your Key.

Image Modified

Client-to-Server Forwarding

...

1. On the C2S Tab of the profile, click [Add] to set up a traffic relay.

2. Enter 127.0.0.1 as the Listen Interface, localhost as the Destination Host, and the port appropriate to your database platform as the Dest. Port

   • For Hosted Customers, MySQL is configured to use 3306 - if your organization is running PCR-360 internally with MySQL, your network administrator can provide this info.

   • For Instance Customers running Oracle, the typical port is 1521 or 1526. Confirm with your network administrator what port to enter here.

3. The List. Port setting is a little bit special. For most cases, it's safe to use the same value here as the Dest. Port. Make note of the value you set here - you'll need it further down.

Image Modified

Save your profile.

...

1. After installing the PuTTY Toolkit noted above, open PuTTYgen from your Start Menu
2. Open the Conversions Menu, and click Import keyfile.
3. If your key is protected with a passphrase, you'll be prompted to enter that to unlock the key.

4. PuTTYgen will load the key's signature. Click Save Private Key to save a PuTTY-formatted copy as a .ppk file. If there was a passphrase, it will be retained on the new Key file.