![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/firebase-logo.png\"){kind=logo}
<\/a>Firebase is a popular cloud platform that provides real-time databases, cloud storage, and various backend services. Many organizations use Firebase to store application data and need to integrate it with their SQL Server databases for reporting, analytics, and business intelligence. Using Zappysys SSIS PowerPack, you can easily insert or extract data from Firebase Realtime Database or Firestore using REST APIs without writing custom code.<\/p>\nThis tutorial demonstrates how to connect SSIS to Firebase and load data into SQL Server tables using the Zappysys REST API Source component.<\/p>\n
<\/h3>\nPrerequisites<\/h2>\n\n- SQL Server Integration Services (SSIS) is installed.<\/li>\n
- Visual Studio with SSIS extension or SQL Server Data Tools (SSDT).<\/li>\n
- A Firebase project with Realtime Database or Firestore enabled.<\/li>\n
- Zappysys SSIS PowerPack<\/a> is installed on your system.<\/li>\n<\/ol>\n
Set Up Your Firebase Project<\/h3>\n\n- Go to the Firebase Console.<\/a><\/li>\n
- Select a project; if you do not have one, click on “Create a new project”.<\/li>\n
- Enter your project name and click “Continue.”<\/li>\n
- Enable Google Analytics if desired, and complete project creation.<\/li>\n
- Navigate to Security<\/strong> > Authentication<\/strong>.<\/li>\n
- In the Sign-in method<\/strong> tab, enable Email\/Password<\/strong> authentication.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Firebase-Enable-email-password-provider.png\")
<\/a>Firebase – Enable email-password provider<\/p><\/div><\/li>\n
- Go to the Users<\/strong> tab and create a new user, enter an email and a password.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Firebase-Enter-a-new-email.png\")
<\/a>Firebase – Enter a new email<\/p><\/div><\/li>\n
- Go to Settings<\/strong> > General<\/strong>.<\/li>\n
- Under the Your apps<\/strong> section, create a new app and select the Web<\/strong> option.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Firebase-Create-a-new-App.png\")
<\/a>Firebase – Create a new App<\/p><\/div><\/li>\n
- Enter the name for your app, and you will receive a configuration object with your app’s credentials:<\/li>\n
- Use this as the body:\n\n
const firebaseConfig = {\r\n\u00a0 apiKey: \"AIzaSyC2EYUliXXXXXXXXXXXXX\",\r\n\u00a0 authDomain: \"my-project.firebaseapp.com\",\r\n\u00a0 databaseURL: \"https:\/\/my-project.firebaseio.com\",\r\n\u00a0 projectId: \"my-project\",\r\n\u00a0 storageBucket: \"my-project.firebasestorage.app\",\r\n\u00a0 messagingSenderId: \"5750XXXXXXXXX\",\r\n\u00a0 appId: \"1:5750171XXXXXXXX:web:4404eca49b20XXXXXXXX\"\r\n};<\/pre>\n<\/div>\n<\/li>\n- In the Firebase Console, navigate to Realtime Database<\/strong> or Firestore Database<\/strong>.<\/li>\n
- Click Create Database<\/strong> and select your region.<\/li>\n
- Set security rules. For development and testing, use “auth!=null”<\/span> for read and write access.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Firebase-change-rules.png\")
<\/a>Firebase – change rules<\/p><\/div><\/li>\n
- From the Database tab, copy your database URL (e.g., https:\/\/my-project.firebaseio.com)<\/li>\n<\/ol>\n
Configure the token for Firebase<\/h3>\n\n- In your SSIS package, navigate to the Variables section and create the following variables:\n
\n- Api_Key<\/b> (String) \u2014 Enter the API key from Step 1.<\/li>\n
- Token<\/strong> (String) \u2014 Stores the authentication token generated by Firebase.<\/li>\n<\/ol>\n<\/li>\n
- Drag and drop the REST API Task<\/a> component onto your SSIS package canvas and double-click to open it.\n
![\"Add](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/07\/RestAPITask.jpg\")
<\/a>Add a REST API Task in SSIS<\/p><\/div><\/li>\n
- Navigate to the Response Settings<\/strong> tab and set Response Content Type<\/strong> to JSON<\/strong>.<\/li>\n
- In the JSONPath field, enter:
$.idToken<\/code>\u00a0to extract the session token from the API response.<\/li>\n- Enable Save Response Content<\/strong>,<\/strong>\u00a0select the\u00a0Variable<\/strong> option, and choose your Token variable.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Firebase-save-token-in-a-variable.png\")
<\/a>Firebase – save token in a variable<\/p><\/div><\/li>\n
- Go back to the Request<\/strong> tab and enter the following URL. For testing, use:\n
https:\/\/identitytoolkit.googleapis.com\/v1\/accounts:signInWithPassword?key={{User::api_key}}<\/pre>\n<\/li>\n- Set the HTTP Request Method<\/strong> to POST<\/strong>.<\/li>\n
- Use the following JSON in the body with your credentials:\n\n
{\r\n\u00a0 \"email\": \"test@gmail.com\",\r\n\u00a0 \"password\": \"testpassword\",\r\n\u00a0 \"returnSecureToken\": true\r\n}<\/pre>\n<\/div>\n<\/li>\n- Use JSON (application\/json)<\/strong> as Body Content Type<\/strong><\/li>\n
- Test the connection. If successful, you will see the generated token in the response.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Firebase-generate-token.png\")
<\/a>Firebase – generate token<\/p><\/div>\n
<\/div>\n<\/li>\n<\/ol>\nCreate and Configure the JSON Source<\/h3>\n\n- Add a new Data Flow Task to your SSIS package. Connect it downstream from the REST API task you created before.<\/li>\n
- Double-click the Data Flow Task to enter the Data Flow design surface.<\/li>\n
- Drag a ZappySys JSON Source<\/a> component from the toolbox onto the canvas.\n
![\"SSIS](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png\")
<\/a>SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Double-click the ZappySys JSON Source<\/strong><\/a> to open its editor.<\/li>\n
- Enter the following URL to the Firebase endpoint. Replace “users” with the database path where you want to send data:\n
https:\/\/zappysys-bigquery.firebaseio.com\/users.json?auth={{User::token}}<\/pre>\n<\/li>\n - Set the HTTP Request Method<\/strong> to POST<\/strong>.<\/li>\n
- Configure the JSON payload to insert your data. Since Firebase is a NoSQL database, structure the JSON according to your data schema:\n
{\r\n\"user001\": { \"nombre\": \"Ana Garc\u00eda\", \"email\": \"ana@test.com\" },\r\n\"user002\": { \"nombre\": \"Luis P\u00e9rez\", \"email\": \"luis@test.com\" }\r\n}<\/pre>\n![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Firebase-send-data.png\")
<\/a>Firebase – send data<\/p><\/div><\/li>\n
- Click Preview Data<\/strong>,\u00a0<\/strong>using a valid token in the variable, to test the connection and verify the data.<\/li>\n
- You can change the method to GET<\/strong> to check the data from the database\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Firebase-get-data-from-database.png\")
<\/a>Firebase – get data from the database<\/p><\/div><\/li>\n
- Click OK<\/strong> to save the configuration.<\/li>\n<\/ol>\n
Configure the Data Destination<\/h3>\n\n- Drag and drop a destination component (such as OLE DB Destination<\/strong>, Flat File Destination<\/strong>, or Trash Destination<\/strong>) into the Data Flow.<\/li>\n
- Connect the output arrow from the JSON Source component to the destination component.<\/li>\n
- Double-click the destination component to open its configuration dialog.<\/li>\n
- Configure the destination to point to your target table or file where Firebase data will be stored.<\/li>\n
- In the Mappings<\/strong> section, map the columns from the JSON response to the corresponding destination columns.<\/li>\n
- Click OK<\/strong> to save the destination configuration.<\/li>\n
- Execute the package and verify that the data extraction is working correctly.\n
- \n
- SQL Server Integration Services (SSIS) is installed.<\/li>\n
- Visual Studio with SSIS extension or SQL Server Data Tools (SSDT).<\/li>\n
- A Firebase project with Realtime Database or Firestore enabled.<\/li>\n
- Zappysys SSIS PowerPack<\/a> is installed on your system.<\/li>\n<\/ol>\n
Set Up Your Firebase Project<\/h3>\n
- \n
- Go to the Firebase Console.<\/a><\/li>\n
- Select a project; if you do not have one, click on “Create a new project”.<\/li>\n
- Enter your project name and click “Continue.”<\/li>\n
- Enable Google Analytics if desired, and complete project creation.<\/li>\n
- Navigate to Security<\/strong> > Authentication<\/strong>.<\/li>\n
- In the Sign-in method<\/strong> tab, enable Email\/Password<\/strong> authentication.\n
<\/a>Firebase – Enable email-password provider<\/p><\/div><\/li>\n
- Go to the Users<\/strong> tab and create a new user, enter an email and a password.\n
<\/a>Firebase – Enter a new email<\/p><\/div><\/li>\n
- Go to Settings<\/strong> > General<\/strong>.<\/li>\n
- Under the Your apps<\/strong> section, create a new app and select the Web<\/strong> option.\n
<\/a>Firebase – Create a new App<\/p><\/div><\/li>\n
- Enter the name for your app, and you will receive a configuration object with your app’s credentials:<\/li>\n
- Use this as the body:\n
\nconst firebaseConfig = {\r\n\u00a0 apiKey: \"AIzaSyC2EYUliXXXXXXXXXXXXX\",\r\n\u00a0 authDomain: \"my-project.firebaseapp.com\",\r\n\u00a0 databaseURL: \"https:\/\/my-project.firebaseio.com\",\r\n\u00a0 projectId: \"my-project\",\r\n\u00a0 storageBucket: \"my-project.firebasestorage.app\",\r\n\u00a0 messagingSenderId: \"5750XXXXXXXXX\",\r\n\u00a0 appId: \"1:5750171XXXXXXXX:web:4404eca49b20XXXXXXXX\"\r\n};<\/pre>\n<\/div>\n<\/li>\n- In the Firebase Console, navigate to Realtime Database<\/strong> or Firestore Database<\/strong>.<\/li>\n
- Click Create Database<\/strong> and select your region.<\/li>\n
- Set security rules. For development and testing, use “auth!=null”<\/span> for read and write access.\n
<\/a>Firebase – change rules<\/p><\/div><\/li>\n
- From the Database tab, copy your database URL (e.g., https:\/\/my-project.firebaseio.com)<\/li>\n<\/ol>\n
Configure the token for Firebase<\/h3>\n
- \n
- In your SSIS package, navigate to the Variables section and create the following variables:\n
- \n
- Api_Key<\/b> (String) \u2014 Enter the API key from Step 1.<\/li>\n
- Token<\/strong> (String) \u2014 Stores the authentication token generated by Firebase.<\/li>\n<\/ol>\n<\/li>\n
- Drag and drop the REST API Task<\/a> component onto your SSIS package canvas and double-click to open it.\n
<\/a>Add a REST API Task in SSIS<\/p><\/div><\/li>\n
- Navigate to the Response Settings<\/strong> tab and set Response Content Type<\/strong> to JSON<\/strong>.<\/li>\n
- In the JSONPath field, enter:
$.idToken<\/code>\u00a0to extract the session token from the API response.<\/li>\n- Enable Save Response Content<\/strong>,<\/strong>\u00a0select the\u00a0Variable<\/strong> option, and choose your Token variable.\n
<\/a>Firebase – save token in a variable<\/p><\/div><\/li>\n
- Go back to the Request<\/strong> tab and enter the following URL. For testing, use:\n
https:\/\/identitytoolkit.googleapis.com\/v1\/accounts:signInWithPassword?key={{User::api_key}}<\/pre>\n<\/li>\n- Set the HTTP Request Method<\/strong> to POST<\/strong>.<\/li>\n
- Use the following JSON in the body with your credentials:\n
\n{\r\n\u00a0 \"email\": \"test@gmail.com\",\r\n\u00a0 \"password\": \"testpassword\",\r\n\u00a0 \"returnSecureToken\": true\r\n}<\/pre>\n<\/div>\n<\/li>\n- Use JSON (application\/json)<\/strong> as Body Content Type<\/strong><\/li>\n
- Test the connection. If successful, you will see the generated token in the response.\n
<\/a>Firebase – generate token<\/p><\/div>\n
<\/div>\n<\/li>\n<\/ol>\nCreate and Configure the JSON Source<\/h3>\n
- \n
- Add a new Data Flow Task to your SSIS package. Connect it downstream from the REST API task you created before.<\/li>\n
- Double-click the Data Flow Task to enter the Data Flow design surface.<\/li>\n
- Drag a ZappySys JSON Source<\/a> component from the toolbox onto the canvas.\n<\/a>
SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Double-click the ZappySys JSON Source<\/strong><\/a> to open its editor.<\/li>\n
- Enter the following URL to the Firebase endpoint. Replace “users” with the database path where you want to send data:\n
https:\/\/zappysys-bigquery.firebaseio.com\/users.json?auth={{User::token}}<\/pre>\n<\/li>\n- Set the HTTP Request Method<\/strong> to POST<\/strong>.<\/li>\n
- Configure the JSON payload to insert your data. Since Firebase is a NoSQL database, structure the JSON according to your data schema:\n
{\r\n\"user001\": { \"nombre\": \"Ana Garc\u00eda\", \"email\": \"ana@test.com\" },\r\n\"user002\": { \"nombre\": \"Luis P\u00e9rez\", \"email\": \"luis@test.com\" }\r\n}<\/pre>\n<\/a>Firebase – send data<\/p><\/div><\/li>\n
- Click Preview Data<\/strong>,\u00a0<\/strong>using a valid token in the variable, to test the connection and verify the data.<\/li>\n
- You can change the method to GET<\/strong> to check the data from the database\n
<\/a>Firebase – get data from the database<\/p><\/div><\/li>\n
- Click OK<\/strong> to save the configuration.<\/li>\n<\/ol>\n
Configure the Data Destination<\/h3>\n
- \n
- Drag and drop a destination component (such as OLE DB Destination<\/strong>, Flat File Destination<\/strong>, or Trash Destination<\/strong>) into the Data Flow.<\/li>\n
- Connect the output arrow from the JSON Source component to the destination component.<\/li>\n
- Double-click the destination component to open its configuration dialog.<\/li>\n
- Configure the destination to point to your target table or file where Firebase data will be stored.<\/li>\n
- In the Mappings<\/strong> section, map the columns from the JSON response to the corresponding destination columns.<\/li>\n
- Click OK<\/strong> to save the destination configuration.<\/li>\n
- Execute the package and verify that the data extraction is working correctly.\n
- Double-click the ZappySys JSON Source<\/strong><\/a> to open its editor.<\/li>\n
- Token<\/strong> (String) \u2014 Stores the authentication token generated by Firebase.<\/li>\n<\/ol>\n<\/li>\n
- Api_Key<\/b> (String) \u2014 Enter the API key from Step 1.<\/li>\n
- Go to the Firebase Console.<\/a><\/li>\n