Avatar of bobox00
bobox00
Flag for United States of America asked on

What's a good extraction tool for Goldmine version 9 (SQL back end)

I need to extract my Goldmine database and then later import that extracted data into Saleforce. What tool(s) would you recommend for the Goldmine extraction? The Goldmine database uses Microsoft SQL Server 2008 as back end. I used a Microsoft Windows 2003 server (hosts SQL server) and Vista, XP and Windows 7 client machines (Goldmine client).
Microsoft SQL Server 2008DatabasesMicrosoft Legacy OS

Avatar of undefined
Last Comment
jorgedeoliveiraborges

8/22/2022 - Mon
GMGenius

Goldmine has a built in export. Plus you can also perform SQL queries (selects only) with goldmine also
AwesomeMachine

I would output ascii text records, and excel has a function where you can place dividers to delineate the fields. After you have your record delineation template, excel will import the entire ascii table into a spreadsheet and then output to practically any format imaginable. But usually you just import each speadsheet as a table.  
GMGenius

With the SQL Queries, when you have the results you just right click and select "Output to>" and you can choose Clipboard or Excel or Word
Your help has saved me hundreds of hours of internet surfing.
fblack61
jorgedeoliveiraborges

Use bcp, it will work fine, you will have wide support, and it comes with Microsoft SQL Server 2008.
bobox00

ASKER
jorge please tell me more about bcp. How do I access it?
bobox00

ASKER
I need to get flat files like excel or CSV from the extract. Salesforce will only accept flat files for import.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
GMGenius

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.