Contents x
    Detailed information about your plan
      • Print
      • PDF
      Contents

      Detailed information about your plan

        • Print
        • PDF
        Article summary

        summary

        This page describes various detailed information about rate plans.

        Rate Plans

        TROCCO offers the following fee plans

        • Free Plan
        • Starter Plan
        • Essential Plan
        • Advanced Plan
        • Professional Plan

        There are differences in the Connectors and features available in each plan. For details, please refer to the fee plan.
        For more information on the Professional Plan, please refer to the detailed information on the Professional Plan.

        Change in restrictions on use of each function due to revision of fee plans

        The rate plan was changed in 04/2024.
        Restrictions on the use of some functions have been changed in accordance with the change in the fee plan.

        * SSO using SAML authentication was bundled with the Team Features option in the previous plans.
        The new plan will be offered separately from the team functionality option.

        More information about pricing

        Connector Type

        Available Connector types vary depending on the plan you are subscribed to.

        Connector type Each planFreeStarterEssentialAdvancedProfessional
        Basic Connector✓✓✓✓✓
        Enterprise DB Connector✓-✓✓✓
        Connector for log data output✓-✓✓✓
        Reverse ETL Connector✓--✓✓
        Custom Connectors✓--✓✓

        The following is a list of Connectors belonging to each Connector type.

        Basic Connector

        Data Source - DWH system
        Data Source - Application-based
        Data Source - Cloud Application System
        Data Source - Database-based (excluding Enterprise DB Connector)
        Data Source - File/Storage Service System
        Data Source - Advertising
        Data Source - Local Files
        Data Destination - DWH system
        Data Destination - Database-based (excluding Enterprise DB Connector)
        Data Destination - File/Storage Service System

        Enterprise DB Connector

        Connector for log data output

        Reverse ETL Connector

        Data Destination - Cloud Application System
        Data Destination - Advertising System

        Custom Connectors

        optional feature

        The following are features not bundled with regular plans
        Available by signing up as an additional paid option.
        Please note that there are restrictions regarding plans for signing up for paid options.

        Optional FeaturesContractable Planssupplement
        Team FunctionsEssential PlanAvailable at no extra charge for the Professional plan
        TROCCO Web Activity LogEssential Plan and above-
        AWS PrivateLinkAdvanced plan and above-

        Job concurrency limit

        Concurrency limit specification

        TROCCO limits the number of jobs that can run simultaneously within an account.
        Normally, when a job is executed in TROCCO, the job is queued (waiting to be executed) and then the job begins execution.
        At this time, if the maximum number of running jobs has been reached, the queued (waiting for execution) state is maintained until any job that was running earlier finishes.

        Maximum value per contract plan

        The value of the maximum number of jobs to be executed concurrently varies depending on the plan you are subscribed to.

        FreeStarterEssentialAdvancedProfessional
        5102050100*

        * Professional plans can relax the limit on the number of concurrent executions.

        Countable jobs and job status

        The total number of jobs that meet the following conditions is counted as the number of simultaneous executions.

        • Job Type
          • ETL Job
          • data mart job
        • job status
          • SETTING UP: Job start-up status
          • EXECUTING: Job running status

        Note that once an ETL Job or Data Mart Job with the above Job status is terminated in some way, the Job will no longer be counted in the concurrent execution count.

        supplementary information

        Old plan specifications

        The maximum number of the same execution of a job has been partially specified following the change in the rate plan in April 2024.
        The specifications of the old plan are as follows

        • Upper limit: 100 (no difference by contract plan)
        • Countable Jobs: ETL Jobs only

        Job processing timeframe

        What is processing time and processing timeframe?

        TROCCO defines processing****time (*1) as "the total job execution time at any given point in a month" and processing time quota as "the maximum amount of execution time that can be used without being charged additionally (*2).

        *1 Processing time returns to 0 hour as of midnight (UTC+9) on the first day of each month.
        *2 There is no additional charge for the Free plan; instead, job execution is restricted.

        Processing timeframe per contracted plan

        Processing timeframes vary depending on the plan you have signed up for.

        FreeStarterEssentialAdvancedProfessional
        4 hours/month30 hours/month250 hours/month600 hours/month(Please inquire)

        When the processing time exceeds the processing timeframe

        Behavior when processing time exceeds the processing timeframe varies from plan to plan.

        • If you are using the Free plan
          • No additional charges will be incurred if processing time exceeds the processing time frame.
          • However, once the number is exceeded, job execution during the month will be restricted.
        • If you are using one of the paid plans
          • Excess will be billed in additional 20-hour increments.
          • Formula for calculating the amount of additional billing: Number of Blocks x Unit Price per Block
          • Formula for calculating the number of blocks: "(processing time - processing time frame + 19) / 20" (unit is time, division is rounded down)
        Regarding unit price per block

        Please contact your sales representative or Customer Success.

        Example of exceeding the processing timeframe in a paid plan and deferral of the calculation formula

        For example, suppose that the Essential plan (250-hour processing timeframe) has a processing time of 300 hours.
        In this case, (300-250+19)/20=3 (division rounded down), resulting in an additional bill for 3 blocks.

        Note that a one-hour grace period exists for the calculation of the number of blocks. (In the formula, +19 is used instead of +20.)
        This means, for example, that on the Essential plan, the processing time is 270 hours, 59 minutes, and 59 seconds.
        In this case, an additional charge for two blocks would normally be incurred.
        However, since there is a one-hour grace period in the formula, (270.99-250+19)/20 = 1 (division is rounded down), which results in an additional charge for one block.

        How to check processing time

        This information can be viewed from the TROCCO dashboard screen.
        The dashboard screen also shows daily processing time totals and other information.
        The processing time is aggregated several times a day at irregular intervals, and the aggregate results are reflected sequentially on the dashboard screen.

        Conditions under which processing time is measured

        The time from the start date and time to the end date and time of a job that meets the following conditions is credited to the processing time in seconds.

        • job status
          • Jobs that have been SUCCEEDED``(SUCCESS )
        • Job Type
          • ETL Job
          • data mart job
          • dbt job
          • Workflow Job (*)
        more on Workflow Job

        The following tasks in Workflow Jobs are not eligible for posting to prevent double counting

        • transfer job task
        • Managed ETL Job Tasks
        • Data Mart Job Tasks
        • dbt job task
        Was this article helpful?
        What's Next