Top Panel
Browse by Category Search the Knowledge Base
Can I make custom reports or access the database outside of inFlow?

Last Updated
June 20th, 2008

User Opinions (0 votes)
No users have voted.

How would you rate this answer?
Helpful
Not helpful

We don’t officially support this, but you can do this if you have the appropriate skills with databases and/or reports, or can find somebody to help you.  Some more technical information is below.

inFlow uses a Microsoft SQL Server database as a back-end database.  You can connect to this using Crystal Reports or some other reporting tool to create custom reports.  It creates an SQL Server instance named INFLOWSQL on the server machine.  You can log into this using the sa account.  The password for the sa account is the Server Password, which you can find by switching inFlow to multi-user mode and selecting Change Connection from the File menu.  You can also connect to this database using an ODBC connection.  In fact, there may have been an ODBC connection called local-sql­ created for you after installing inFlow.

Some warnings about this - we don’t officially support connecting to the database outside of inFlow, although we’ll informally be glad to help you get started.  Making changes to the database outside of inFlow may lead to unexpected problems.  Also, many of the update patches for inFlow will update the database, so if you create some tools that rely on a particular database structure, you should be careful when choosing to update inFlow.

Visitor Comments
  1. Comment #1 (Posted by Terry )
    any chance you'd share the database entity diagram (or data dictionary) so I can be sure to extract the correct data for our custom reports?
  2. Comment #2 (Posted by admin )
    Hi Terry, can you send an email to support@inflowinventory.com to let us know what specific details you need for your custom reports? We can assist you from there. Thanks, -Amy
Post a comment for "Can I make custom reports or access the database outside of inFlow?"
   Your Name:
   Email Address:
*
 Your Comment:
*
 Enter the code below:
 
Related Articles
Attachments
No attachments were found.

Continue
Bottom Panel