<turbo-stream action="update" target="wiki_card"><template>

<h1>Build a Reporting Database and Dashboard with Rapidi MyData</h1>
<div class="trix-content"><h2>What MyData is</h2><p>MyData lets you keep a copy of your system data inside Rapidi and report on it, in five steps. Every Rapidi service can have its own small, Rapidi-hosted database called MyData. You can use it to store data from any connected system (Salesforce, HubSpot, Business Central and so on) and build reports or dashboards on top of it, without touching the source system or setting up anything outside Rapidi. The MYDATA connection reads its tables directly, so there is no Read Design step.<br><br></p><h2>Two ways to do it</h2><p>You can set up the tables and transfers in plain language with an AI assistant, or manually in the Rapidi portal.</p><ul><li><strong>With an AI assistant:</strong> Claude or any other AI assistant that supports MCP (Model Context Protocol) can do steps 1 and 3 once the Rapidi MCP connector is added. You describe the tables or transfers you want, and the assistant creates them in your service. Each step below includes an example prompt you can adapt.</li><li><strong>In the Rapidi portal:</strong> you can create the same tables and transfers yourself.</li></ul><p>Creating tables and transfers changes your service, so the assistant will usually ask for your approval before each action.<br><br></p><h2>Step 1: Create the tables</h2><p>Create one MyData table per object you want to report on, for example Accounts and Contacts.</p><ol><li>Add a column for each field you need.</li><li>Add a column for the source record ID, for example <code>sf_id</code>, and put a unique index on it. This lets the transfer update existing rows instead of creating duplicates.</li><li>For child tables such as Contacts, also add and index the parent ID, for example <code>account_sf_id</code>, so you can link contacts to their accounts.</li></ol><p>An <code>id</code> column is added to every table automatically.</p><p><strong>Example prompt:</strong> "In my MyData database, create a table called accounts with the columns sf_id, name, type, industry, billing_country and annual_revenue, and a unique index on sf_id."</p><h2>Step 2: Check the connection sees the tables</h2><p>Click on Read Design so you can see MYDATA connection's layout. Your new tables should appear straight away with the columns you created.</p><h2>Step 3: Create the transfers</h2><p>Create one transfer per table, from your source connection into MYDATA, for example Salesforce Account to <code>accounts</code>.</p><ul><li>Match on the source ID, for example <code>Id</code> to <code>sf_id</code>.</li><li>Map the remaining fields one to one.</li></ul><p><strong>Example prompt:</strong> "Create a transfer SF_MYDATA_ACCOUNTS from my Salesforce connection's Account table to the MyData accounts table, matching Id to sf_id, and map these fields: Name to name, Type to type, Industry to industry, BillingCountry to billing_country, AnnualRevenue to annual_revenue."<br><br></p><h2>Step 4: Run the transfers</h2><p>Run the parent transfer first (Accounts), then the child transfer (Contacts), so every contact has an account to link to. The first run is a full load and can take a few minutes. Later runs only update what changed.</p><h2>Step 5: Build the dashboard</h2><p>Once the data is in MyData, ask your AI assistant to read the tables and build a dashboard. It pulls the rows, calculates the statistics and presents the result.</p><p>Reading the data works the same way in any MCP-capable assistant. What you get back depends on the assistant: in Claude it is a dashboard you can keep, share and refresh, while other tools may return a chart or a file instead.</p><p><strong>Example prompt:</strong> "Read the accounts and contacts tables from my MyData database and build a dashboard showing accounts by industry, type and country, total annual revenue, and contacts per account."<br><br></p><h2>Example: comparing customers in Salesforce and Business Central</h2><p>The same five steps, with one extra table, give you a dashboard that shows which customers exist in both systems. We built this on a Rapidi test service with demo data.</p><ol><li><strong>Tables:</strong> <code>accounts</code> and <code>contacts</code> for Salesforce, plus <code>bc_customers</code> modelled on the Business Central Customer Card (No, Name, Phone, Email, Address, City, Country, Currency, Salesperson, Posting Group, Blocked, Balance, Credit Limit, Last Date Modified). <code>bc_customers</code> has a unique index on <code>no</code>, and <code>accounts</code> has an index on <code>account_number</code> to speed up the match.</li><li><strong>Transfers:</strong> Salesforce Accounts and Contacts into MyData as described above, and the Business Central Customer Card into <code>bc_customers</code>, matching <code>No</code> to <code>no</code>.</li><li><strong>Run:</strong> 452 Business Central customers loaded in about 6 seconds, with 0 errors.</li><li><strong>Dashboard:</strong> customers are matched on Business Central <code>No</code> = Salesforce <code>AccountNumber</code>.&nbsp;</li></ol><p><br></p><p></p><figure class="attachment attachment--content attachment--png"><div class="trix-media-container size-medium">
        <img src="/rails/active_storage/blobs/proxy/eyJfcmFpbHMiOnsiZGF0YSI6MzI1OSwicHVyIjoiYmxvYl9pZCJ9fQ==--317a9d2813b9b93a9499e43e797c6d847b172dfb/image.png" width="1616" height="519" title="Salesforce vs. Business Central Dashboard" alt="Salesforce vs. Business Central Dashboard">
      </div><figcaption class="attachment__caption"></figcaption></figure><br><br><br><strong>Example prompt:</strong> "Add a section to my dashboard that compares the bc_customers table with the accounts table, matching BC No to Salesforce AccountNumber. Show how many customers are in both systems, only in BC, only in Salesforce, have no AccountNumber, or match but have different names, plus a customer-by-customer table with a status filter."<br><br><br><p></p></div>
</template></turbo-stream>

