HiveSQL
  • Introduction
  • Register your HiveSQL account
  • Support
  • Technical informations
    • Database Diagram
    • Operations
      • TxAccountClaims
      • TxAccountCreates
      • TxAccountRecoveryChanges
      • TxAccountRecoveryRequests
      • TxAccountRecoveryConfirms
      • TxAccountUpdates
      • TxAccountUpdates2
      • TxAccountWitnessProxies
      • TxAccountWitnessVotes
      • TxClaimRewardBalances
      • TxCollateralizedConverts
      • TxComments
      • TxCommentsOptions
      • TxConverts
      • TxCustoms
      • TxDeclineVotingRights
      • TxDelegateVestingShares
      • TxDeleteComments
      • TxEscrowApproves
      • TxEscrowDisputes
      • TxEscrowReleases
      • TxEscrowTransfers
      • TxFeeds
      • TxLimitOrdersCancels
      • TxLimitOrdersCreates
      • TxPows
      • TxProposalCreates
      • TxProposalRemoves
      • TxProposalUpdates
      • TxProposalVoteUpdates
      • TxRecurrentTransfers
      • TxTransfers
      • TxVotes
      • TxWithdraws
      • TxWithdrawVestingRoutes
      • TxWitnessSetProperties
      • TxWitnessUpdates
    • Virtual Operations
      • VOAccountCreateds
      • VOAuthorRewards
      • VOChangedRecoveryAccounts
      • VOClearNullAccountBalances
      • VOCollateralizedConvertImmediateConversions
      • VOCommentBenefactorRewards
      • VOCommentPayoutUpdates
      • VOCommentRewards
      • VOCommentsVotes
      • VOConsolidateTreasuryBalances
      • VOCurationRewards
      • VODelayedVotings
      • VODHFConversions
      • VODHFFundings
      • VOExpiredAccountNotifications
      • VOFailedRecurrentTransfers
      • VOFillCollateralizedConvertRequests
      • VOFillConvertRequests
      • VOFillOrders
      • VOFillRecurrentTransfers
      • VOFillTransferFromSavings
      • VOFillVestingWithdraws
      • VOHardforkHiveRestores
      • VOHardforkHives
      • VOHardforks
      • VOInterests
      • VOLimitOrderCancelleds
      • VOLiquidityRewards
      • VOPowRewards
      • VOProducerMisseds
      • VOProducerRewards
      • VOProposalFees
      • VOProposalPays
      • VOReturnVestingDelegations
      • VOShutdownWitnesses
      • VOSPSConverts
      • VOSPSFunds
      • VOTransferToVestingCompleteds
    • State tables
      • DynamicGlobalProperties
      • Accounts
      • Blacklists
      • BlacklistsFollows
      • Comments
      • Communities
      • CommunitiesRoles
      • CommunitiesSubscribers
      • Delegations
      • Followers
      • Mutes
      • MutesFollows
      • Proposals
      • ProposalsApprovals
      • RCDelegations
      • Reblogs
      • Tags
      • Witnesses
    • Full Text Search
    • Language detection
  • Tutorials
    • HiveSQL for Python developers
    • HiveSQL for PHP developers
    • HiveSQL for Ruby developers
    • HiveSQL for Microsoft Excel
  • HiveSQL Status
  • Resources
Powered by GitBook
On this page
  1. Tutorials

HiveSQL for Microsoft Excel

PreviousHiveSQL for Ruby developersNextResources

Last updated 4 years ago

This step-by-step tutorial will show how to use Microsoft Excel to retrieve data from the HiveSQL database and present your result in a simple but nice pivot chart.

Writing a SQL query

Let’s say for example you want to see how many transactions have been issued each month on the blockchain. The SQL query to get such information will be:

SELECT
    YEAR(Blocks.timestamp) AS [Year],
    MONTH(Blocks.timestamp) AS [Month],
    COUNT(*) AS [Transactions]
FROM
    Transactions
    INNER JOIN Blocks ON Transactions.block_num = Blocks.block_num
GROUP BY
    YEAR(Blocks.timestamp),
    MONTH(Blocks.timestamp)

Retrieving data with Excel

Start Excel, go to the Data tab and select SQL Server as your data source

The Data Connection Wizard will be displayed

Enter the connection information in the wizard dialog box as shown and click "Next"

Select any table (it doesn’t matter at this stage) and click '"Finish" to close the wizard

Click on "Properties"

Select the "Definition" tab and check the "Save Password" checkbox to avoid Excel asking you for credentials each time you connect to the database.

You can safely ignore the warning if your computer is secure

Open the "Command type" dropdown control and select "SQL"

Paste your SQL query and click OK

Finalizing the presentation

Now that you got all your data, make a nice chart.

Organize your data fields in the pivot properties

You now have created your report using the blockchain data.

Use your HiveSQL account login and password (see )

Select the type of data presentation you want in Excel.

Register your HiveSQL account