Can call detail records (CDRs) be sent to an SFTP server?

46 Labs supports the transfer of customer call detail records (CDRs) to   customers.

The SFTP server can either be deployed in the 46 Labs cloud (managed by 46 Labs) or at a customer location (managed by the customer).

The frequency of transfer of CDRs from the customer’s Data Warehouse to the SFTP server can be either hourly or every 24 hours.

CDRs will be saved in a filename .csv.gzip format.

46 Labs deployed SFTP server

46 Labs requires the following information from the customer to deploy a dedicated SFTP server in the 46 Labs data center.

The IP address(es) of the SFTP client(s) accessing the SFTP server.

These IP addresses will be whitelisted in SFTP server. No other IP addresses will be able to connect to the SFTP server.

The frequency of transfer of CDRs from the Data Warehouse to the SFTP server: 1 hour or 24 hours.

Hourly CDRs will be stored in the /home_directory/year/month/day/ with a filename 00.csv.gz through 23.csv.gz.   

For example, the directory /cdr/2022/08/01/  would contain these files:

• 00.csv.gz  01.csv.gz 02.csv.gz 03.csv.gz 04.csv.gz 05.csv.gz 06.csv.gz 07.csv.gz  08.csv.gz

• 09.csv.gz 10.csv.gz 11.csv.gz 12.csv.gz 13.csv.gz 14.csv.gz  15.csv.gz 16.csv.gz  17.csv.gz 18.csv.gz 19.csv.gz 20.csv.gz  21.csv.gz 22.csv.gz 23.csv.gz

Daily CDRs will be stored in the /home_directory/year/month/ with a filename 00.csv.gz through 31.csv.gz.   

For example, the directory /cdr/2022/08/  would contain these files:

• 00.csv.gz  01.csv.gz 02.csv.gz … 31.csv.gz  (if 31 days in the month)

The retention period for CDRs on the SFTP is 30 days. Any CDR file older than 30 days is automatically purged.

This SFTP server will be configured to support a single SFTP user account. The username will be the customer's name or the customer's short name.

The password for this account must be at least 16 characters with at least 1 lowercase character, 1 uppercase character, 1 numeric character, and 1 special character.

Typically, this SFTP server will be assigned a unique Internet-accessible IP address. If the customer has private connectivity to the 46 Labs Cloud, such as 46 Labs Voice Firewalls then a non-Internet routing IP address can be assigned to the SFTP server.

46 Labs will provide the following information to the customer:

• IP Address of the SFTP server

• Username to access the SFTP server

• Password to access the SFTP server (via a separate communications method from the username)

Customer deployed SFTP server

46 Labs requires the following information for a customer-deployed SFTP server:

• The IP address of the server.

• This IP address is typically an Internet accessible IP address.  The must be network connectivity between the SFTP server and the customer’s Data Warehouse.

• The 46 Labs username to connect to the server. The recommended name is 46Labs.

• The password for the 46 Labs SFTP user. This should be provided in a separate communication.

• The frequency of transfer of CDRs from the Data Warehouse to the SFTP server: 1 hour or 24 hours

46 Labs will provide the IP address of our SFTP client. This IP address must be allowed to connect to the customer SFTP server. Typically a customer will need to update their firewall to allow inbound connections from the Internet to access their SFTP server.